DB2 Database Error - SQL0551N - SAPDEV does not have the authorization

700 Views

Hi gurus, The sap server running on DB2 9.7 FP2 & windows server 2008 64 bit. I have upgrade to EHP4 and it's running successfully. When i try to run the SGEN, after completing 10% it said the tablespace is full. I am aware that during the ECC installation it suppose to be Auto extend mode and i didnt change any setting . now i have this error. Even in St22 abap dump got many error due to this sgen generation (DDIC TYPE INCONSISTENCIES). Then when i check in the DBACOCKPIT, i saw this error message.

@8O\QError message@ DEV SQL0551N "SAPDEV" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SYSPROC.WLM_G

I presume this could be the problem all this issue. However how can i fix this above error message first. can someone guide me through pls. i am just a beginner in DB2 database. Pls provide the steps and solution . Appreciate your help. Thanks.