PM74577: REPAIR DBD DIAGNOSE GOT SQLCODE -104 DUE TO CORRUPTED CHECKCONDITION AND ENDED WITH RC08.

APAR status

• Closed as suggestion for future release.

Error description

• REPAIR DBD DIAGNOSE got SQOCODE -104 due to corrupted
  CHECKCONDITION and ended with RC08. If we can have REPAIR DBD
  return more meaningful message, it should be helpful for them to
  find out the problem.
  REPAIR DIAGNOSE DBD sample message:
  DSNU778I  -D02V 261 08:38:41.03 DSNUEXDL - ERROR PROCESSING SQL
                STATEMENT -
                SQL CODE IS: -104
                SQLERRP: DSNHPARS
                SQLERRD: 00000003 00000000 00000000 FFFFFFFF
                         000001B0 000001F6
                SQL MESSAGE TEXT: ILLEGAL SYMBOL ".". SOME SYMBOLS
                THAT MIGHT BE LEGAL ARE: <IDENTIFIER
   XMLSERIALIZE TRIM CAST XMLCAST NOT (.
                SQL STATEMENT:
  ALTER TABLE "UUDVIT  " ."BDTABLES" ADD
  CONSTRAINT "DSNTAB_AVGROWLEN"
  
  CHECK (    .&#65509;......  ... ..D ...SYSIBM )..
  SYSIBM )
  DSNU017I    261 08:38:42.26 DSNUGBAC - UTILITY DATA BASE
  SERVICES
  MEMORY EXECUTION ABENDED, REASON=X'00E40601' CAUSE=X'20EB3B9A'
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• When catalog contains broken data, i.e., SYSCHECKS has bad
  CHECKCONDITION, REPAIR DBD hits ABEND04E RC00E40601 at DSNUEXDL
  +14EE and returns SQLCODE104 with incomplete message.
  
  The SYSTEM PROGRAMMERS RESPONSE for 00E40601 should be updated
  with the following information,
  
  If this reason code is issued as the result of running the
  REPAIR DBD job Contact IBM  Software Support for assistance.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels