IDMSDBAN messages 599702 and 599703 not necessarily mean broken chain.

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

Description:

When an IDMSDBAN report issues 599702 and 599703 messages, this typically means that there are broken chains on the database. This is a form of corruption that UNLOAD/RELOAD will either abend on or not function correctly. But there is one exception.

Solution:

When IDMSDBAN issues 599702 and 599703 messages, it normally means there is a broken chain.

However, if the SET identified in the messages is CALC and the line index is 0, then that is an indication that the set is not really broken. For example, consider these messages:

599702 - NEXT LINK NOT FOUND                                                
  SET=CALC              START OF LINK  38858467:1   OWNER IS AT   38855467:0
  CHAIN LENGTH  1      LINK POINTS TO  38858467:0   PRIOR IN PFX  38858467:0
                                                                            
599703 - PRIOR LINK NOT FOUND                                               
  SET=CALC              START OF LINK  38858467:1   OWNER IS AT   38855467:0
  CHAIN LENGTH  1      LINK POINTS TO  38858467:0   PRIOR IN PFX  38858467:0

These messages indicate problems with CALC set chains. It means that a record which is in the CALC chain of page 38858467 should be in the CALC chain of page 38855467.

IDMSDBAN calculates the target CALC page of CALC records, and if the result is not the same as the page on whose CALC chain the record resides, then it issues the above message. Neither CALC set chain is really "broken".

In this case, if OPT00093 is in use, an UNLOAD/RELOAD should be able to handle the corruption and fix the database.