Received 'DBST002E 0308' Error Status while executing DB/REORG in the UPLINK step. What does this error mean and how to resolve it?

Document ID : KB000051362
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

During the execution of CA IDMS DB/REORG in the UPLINK step, the step failed with a

'DBST002E ERROR STATUS ................... 0308'.
'DBST008E CURRENT DBKEY.......B2FBB52B'   

What does this error mean and how to resolve it?

Answer:

While executing CA IDMS DB/REORG, in the UPLINK step, the step failed with a 0308 IDMS Minor Code Error.

The 0308 IDMS Minor Code error means that the object record is not in the specified subschema.

The DBST002E message will be followed by a DBST008E message containing the current dbkey. In this example if the current dbkey is hex B2FBB52B which is converted to decimal page 11729845 line index 43. Check what area the page 11729845 is in by executing the PRINT PAGE utility.

In similar cases of the 0308; we have noticed that the reason why the 0308 occurs is that a NOSWEEP statement is missing from area that contains page 11729845. Typically this dbkey may be getting picked up during a sweep of non-copy areas. With non-copy areas, DB/REORG just updates the pointers in the old area in the UPDLINK step.

To resolve this, add a NOSWEEP statement to this area(s).

The NOSWEEP syntax is

'NOSWEEP,AREA=area-name' 

and follows the PROCESS and COPY statements.

It is also recommended that an IDMSDBAN or DB/AUDIT is executed to verify the integrity of the database both before and after executing DB/REORG.

References:

CA IDMS Messages and Codes 11.1.2 Advantage CA-IDMS Minor Codes.

CA IDMS/DB Database Audit Option User Guide.

CA IDMS/DB Database Reorg Option User Guide - 2.2.3. NOSWEEP Statement Overview.
                                                                     - 6.4 Message Text - to find DBST002E

CA IDMS Utilities - 5.2 IDMSDBAN
                         - 6.3.21 PRINT PAGE