13 Verifying DB2 installation

After creating all required databases and application plans, and after granting authorization for the entire OAM system (OSR, LCS, and OSMC), do the following verification process:

13a Verify that all application plans have been created.

You must perform this step both for migration and at initial installation.

Perform the following verification step if your OAM installation uses optical or tape devices, or if you intend to start the OAM address space for object processing.

Use SPUFI to enter the following command:

       SELECT * FROM SYSIBM.SYSPLAN
         WHERE NAME = 'xxxxxxxx';

Substitute each of the following plan names for the xxxxxxxx on the WHERE clause:

CBROAM        CBRHSVOL      CBRHDUPD      CBRISMF
CBRHSMSI      CBRHSBKV      CBRHSBCC      CBRUTIL
CBRHOBJP      CBRHRDAS      CBRHSPCC      CBRHORCL
CBRHSOBP      CBRHWDAS      CBRIDBS       CBRHCNTL

You must perform this step if you are going to use only DB2 sublevel storage (no file system, optical volumes, or tape devices), and do not start the OAM address space for processing objects.

Use SPUFI to enter the following command:

       SELECT * FROM SYSIBM.SYSPLAN
         WHERE NAME = 'xxxxxxxx';

Substitute each of the following plan names for the xxxxxxxx on the WHERE clause:

CBRHSMSI
CBRIDBS

Execute the SELECT statement once for each plan. After each execution, one row of information should be returned. See the SYSIBM.SYSPLAN table in IBM Information Management Software for z/OS Solutions Information Center for a detailed description of the information that should be returned.

13b Verify that all application plans have been authorized.

You must perform this step both for migration and at initial installation.

Perform the following verification step if your OAM installation uses optical or tape devices, or if you intend to start the OAM address space for object processing.

Use SPUFI to enter the following command:

       SELECT * FROM SYSIBM.SYSPLANAUTH
         WHERE NAME = 'xxxxxxxx';

Substitute each of the following plan names for the xxxxxxxx on the WHERE clause:

CBROAM        CBRHSVOL      CBRHDUPD      CBRISMF
CBRHSMSI      CBRHSBKV      CBRHSBCC      CBRUTIL
CBRHOBJP      CBRHRDAS      CBRHSPCC      CBRHORCL
CBRHSOBP      CBRHWDAS      CBRIDBS       CBRHCNTL

13c Verify that all application plans have been created.

You must perform this step if you are going to use only DB2 sublevel storage (no file system, optical volumes, or tape devices), and do not start the OAM address space for processing objects

Use SPUFI to enter the following command:

       SELECT * FROM SYSIBM.SYSPLANAUTH
         WHERE NAME = 'xxxxxxxx';

Substitute each of the following plan names for the xxxxxxxx on the WHERE clause:

CBRHSMSI
CBRIDBS

Execute the SELECT statement once for each plan. After each execution, one row of information should be returned.

If no information is returned, access authority to the application plan specified on the SELECT statement has not been successfully granted.

Related reading: For more information, see “OAM Diagnostic Aids” in the z/OS DFSMSdfp Diagnosis and the SYSIBM.SYSPLANAUTH table in IBM Information Management Software for z/OS Solutions Information Center.