Diagnosing DB2 problems

These are some common DB2® problems that may occur during initialization and use of OAM.

When running CBRSAMPL to establish the Start of change

OAM

configuration database:

You must have SYSADM (system administrator) authority to create the required storage group. If the job fails because of a lack of authority, run it under a user ID having SYSADM authority.
Be sure references to a storage group have been changed to match the name chosen for the storage group created in the first step of CBRSAMPL.

When using DB2I:

If DSNE110E ("ssid NOT VALID SUBSYSTEM ID, COMMAND TERMINATED," where "ssid" is most often DSN, the default subsystem identifier (ssid)) is issued, set the subsystem name to the name of your DB2 subsystem.

During OAM initialization:

If OAM fails to initialize and message CBR0100I, CBR0120I, CBR0140I, CBR0160I, or CBR0180I is issued, consult the accompanying DSNT501I message for the corresponding reason and type codes. If the SQLCODE in CBR0xxxI is -904, and the type and reason codes in DSNT501I are 200 and 00C90081 respectively, the table space corresponding to the table in CBR0xxxI is probably not started. Use a -DISPLAY DATABASE command from DB2I option 7 to verify that this is the case, and then use a -START DATABASE command to correct the problem.
If OAM fails to initialize and message DSNE106E is issued, OAM does not have the proper authority to execute application plan CBROAM. Use SPUFI to execute an SQL GRANT command that gives execute authority on plan CBROAM to the public.
If OAM fails to initialize with SQLCODE of -818, the level of your DBRMs does not match the level of your object code. Run CBRABIND, the OAM bind job. After receiving message DSNT200I BIND FOR PLAN CBROAM SUCCESSFUL, try to start OAM again.

When using OAM:

If frequent resource contention problems occur, check the isolation level parameter used when each application plan was bound. For the OAM configuration database, it must be CS for cursor stability, except in the CBRHDUPD plan used by OSMC, which uses level RR for repeatable read.