Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to disable automatic storage

Dear All,

I have DB2 9.1 fix pack 5 running on SUSE LINUX 10 with SAP ECC 5.0

db2 storage management is automatic storage.

I am unable to add a new container in DBA cockpit. when i try to add a new conatiner it showing an error as

SQL20318N  Table space "EC5#BTABD" of type "AUTOMATIC STORAGE" cannot be
altered using the "ADD" operation.  SQLSTATE=42858

Is there any possiblity that i can disable automatic storage and add new containers on my own.

If suppose I have to recreate the database/instance what should i do such that i can manage my storage manually

Please help me how to solve this problem. I am novice in db2 and just now started to work on it.

Suggestion of any level is warmly appreciated.



Former Member


using automatic storage or a manual tablespace setup is a selectable option within SAPINST. By default, automatic storage is enabled, so you'll have to disable it during installation with SAPINST.

In the following installation guide, see chapter 2.5.3 ff

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question