Aqua Data Studio 14.0.0-rc-13
Database version: DB2-LUW 10.1
Goto ADS menubar-> DBA tools-> Storage Manager
1.Create a Tablespace named "Test1" Managed by Database.
2.Alter the "Test1" tablespace and add more than one container to the tablespace.
After clicking on Create icon ADS gives message "Neither container operations nor a REBALANCE can be performed while a rebalance of the table space is pending or in progress."
But when we executed the script that was generated in Preview SQL in Query analyzer the script was successfully executed and multiple containers were added successfully. In Preview SQL the script generated contains two alter statements for two containers
3.When a Single alter statement was executed
ALTER TABLESPACE "Test1"
ADD (FILE 'C:\DB2\NODE0000\SAMPLE\T0000000\t1' 2000, FILE 'C:\DB2\NODE0000\SAMPLE\T0000000\t2' 2000)
ADD (FILE 'C:\DB2\NODE0000\SAMPLE\T0000000\t3' 2000)
go
It was executed successfully with no error message.
This is returned by the IBM DB2 Server and not a ADS error. Please look into the SQLCODE in IBM documentation and make the changes so that it works.
SQL0258N
Neither container operations nor a REBALANCE can be performed while a rebalance of the table space is pending or in progress.
Explanation
One of the following conditions is true:
User response
Perform the response that is appropriate to the condition: