VMWare Edition NW7 Java & Abap Stack on IBM DB2, how to add tablespace ?

40 Views

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 ??