IDMS DB/REORG fails with DB002300 DBIO Error:3001 and DBST002E ERROR STATUS 09DD. What does Error Status 09DD mean?
search cancel

IDMS DB/REORG fails with DB002300 DBIO Error:3001 and DBST002E ERROR STATUS 09DD. What does Error Status 09DD mean?

book

Article ID: 29482

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

The IDMS DB/REORG messages DB002300 DBIO Error:3001 and DBST002E ERROR STATUS 09DD tend to occur together.                                     

Typically 09DD status code in IDMS DB/Reorg is issued as a result of either a #RDPAGE or #WRITPAGE failure in the DBIO routines which access the database. Meaning a DMCL mismatch problem has occurred.

For all steps before the STORE step, the //SYSIDMS DD statement needs to point to the 'OLDDMCL'; whereas in the STORE step //SYSIDMS DD must point to the 'NEWDMCL'.

 

This error normally occurs when the STORE step's SYSIDMS file is missing the new DMCL.

Specify DCML=newdmcl in SYSIDMS where newdmcl is the dmcl the describes the newly modified area.                                                       

If the IDMS DB/REORG batch utility is being executed in Step Mode, verify that the second job step OPTALLOC does not contain warning message:                                               

                                                                            

OPTX023W THE DATABASE CONTAINS n OCCURRENCES OF RECORD ID nnnn, WHICH IS NOT DEFINED IN THE OLD SUBSCHEMA                                               

                                                                           

This would cause the third step to start with UPDLINK instead of the STORE Step, and the UPDLINK would not run because the intermediate steps (OPTALLOC through  IIXSDBK) have not completed.                           

                                                                           

Here are the OPTX023W msg from the DB/REORG User Guide, Chapter 7 Messages:  

                                                                           

"OPTX023W THE DATABASE CONTAINS nnn OCCURRENCES OF RECORD ID id, WHICH IS NOT DEFINED IN THE OLD SUBSCHEMA                                           

                                                                           

Reason:  While performing an area sweep, these records were encountered on the old database.

                                                                           

Action:  Proceed with the reorganization and these records will be eliminated from the new database, or begin the job again, providing an OLD SUBSCHEMA that defines these records.

                                                                           

If the record is a member of the CALC set, nnn will be twice as large as the actual number of record occurrences on the database. "

The 09DD message is documented in IDMS Problem 5005:

PROBLEM DESCRIPTION:                                                    

If an attempt to read or write a database page fails in the DBIO routines due to a possible DMCL mismatch, the likely status that results is an 09DD.  The minor code 'DD' is not documented.

                                                                        

             *****   Product Documentation Change   *****               

                                                                        

CA IDMS DB Reorg User Guide Release 18.5.00                             

    Chapter 7: Messages                                                  

        Message Text                                                    

            DBIO Error Codes:                                           

<after:>                                                                

DA = DBNAME not valid or segment name cannot be used as DBNAME          

                                                                        

<add:>                                                                  

DD = Attempt to read/write a page failed; possible DMCL mismatch.       

                                                                        

PRODUCT(S) AFFECTED: CA IDMS                                Release 18.5

                                                                                               Release 18.0

 

 

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: