Category Archives: DB2 for z/OS

Common Error Codes in DB2 for Z/OS

Posted on March 24, 2013 by DB2 Administrator

When DB2 executes SQL statements, it returns the results of the operation into the SQLCODE and SQLSTATE fields in the SQLCA. SQLCODE provides key information about the success or failure of SQL statement execution.

DB2 for z/OS Common Rules

Posted on March 23, 2013 by DB2 Admin

Rule 1:  Don’t Grant any DB2 Object for PUBLIC, you don’t know who will use this authority and get access to your DB2 subsystem. Rule 2: Grant access to DB2 objects according to need to know concept, don’t give extra … Continue reading →