R Pidugu

DB2 Error: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-551;42501;SPILTODB2|SELECT|VAJ.CODES, DRIVER=3.53.95


Problem : DB2 Error: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-551;42501;SPILTODB2|SELECT|VAJ.CODES, DRIVER=3.53.95


Solution : The UserID which is trying access the table does not have proper previleges / credentials to access the table. So assign correct previleges to the UserId and try, it will work out.

Subscribe to this Blog via Email :

1 comments:

Write comments
Kosmas
AUTHOR
August 19, 2010 at 10:11 PM delete

If you're ever updated a column, you need to reorg the tables.

Reply
avatar