How to disable automatic storage
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.
Hans-Juergen Zeltwanger replied
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