Hi all,
i am running the Testdrive for Linux with IBM DB2. How can i add more DB table spaces ? If i start transaction DBACOCKPIT and try to add new storage paths the following error occurs:
Exception CX_DBA_ADBC in class CL_DB6_ADBC_CMD method EXEC_SQL line 20
Kernel Error ID:
SYSID: N4S
SY-SUBRC: 0
SQL statement: ALTER DATABASE ADD STORAGE ON '/db2/N4S/sapdata5'
Database:
caused by Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Kernel Error ID:
DB Error: Yes
SQL Code: 552-
SQL Message: SQL0552N "SAPN4S" does not have the privilege to perform operation "ALTER DATABASE". SQLSTATE=42502
DB Object Exists: No
Duplicated Key: No
Internal Error: 1
Invalid Cursor: No
Unknown Connection: No
I found a hint saying that "usermod -g dbn4sadm sapn4s" will fix this but same error occurs...
Any ideas ??