Problems reported by DB2

Use this information to diagnose problems with DB2®.

Errors relating to DB2 authority

SQL error (SQLCODE = -204)

A configuration error occurred. The most likely cause is that the db2schema value in the batchcontainer-config.xml configuration file does not match the value that is given in the DB2SETUP configuration.

Ensure that the values in DB2SETUP and the batchcontainer-config.xml match.

SQL error (SQLCODE = -551) in the JVMError log.

When you start the batch container.

The DFLTUSER does not have permissions on the batch container DB2 tables or table spaces, check these permissions and rerun the CBCH transaction. (if no DFLTUSER is specified in the SIT parameters, CICSUSER is assumed)

SQL error (SQLCODE = -551) in the batch container log.

When you submit a job.

The user ID that is used to run inbound requests from the job scheduler does not have permissions for the batch container DB2 tables or table spaces. Check these permissions and restart the batch job.

SQL error (SQLCODE = -551) in the batch container log.

When an application uses the CICSJDBCReader or CICSJDBCWriter data streams to read or write to DB2.

The user ID that is used to run inbound requests from the job scheduler does not have permissions for the tables that are accessed by the batch job step. Check these permissions and restart the batch job.



probs_db2.html | Timestamp icon Last updated: Sunday, 4 June 2017