PM81372: DB2 ABENDS04E REASON CODE=00C50102 NAME=DSNECP10 DSNE004E PROBABLE SUBSYSTEM ERROR DETECTED IN CSECT DSNECP10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management handling
  of a REBIND statement causes an ABEND in DB2:
  
  IEA995I SYMPTOM DUMP OUTPUT  649
  SYSTEM COMPLETION CODE=04E  REASON CODE=00C50102
   TIME=14.13.42  SEQ=20987  CPU=0000  ASID=00EE
   PSW AT TIME OF ERROR  078D0000   8008D01A  ILC 2  INTC 0D
     ACTIVE LOAD MODULE           ADDRESS=0006D228
  OFFSET=0001FDF2
     NAME=DSNECP10
     DATA AT PSW  0008D014 - 5810C219  0A0DD203  61CBC195
     GR 0: 00000000   1: 8404E000
        2: 0000004E   3: 00000008
        4: 000455A0   5: 00000000
        6: 00043A48   7: 00000008
        8: 00000001   9: 0000000C
        A: 0003EA40   B: 8008C310
        C: 0008D30F   D: 0003EA40
        E: 8008D008   F: 00C50102
   END OF SYMPTOM DUMP
  and a message:
   DSNE004E PROBABLE SUBSYSTEM ERROR DETECTED IN CSECT DSNECP10,
  SUBSYSTEM
  FUNCTION IDENTIFY, RETCODE X'0000004E', REASON CODE X'00C5
  0102'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Change Management Batch     *
  *                 (CM Batch) interface to perform REBIND       *
  *                 statements.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Change Management Batch (CM Batch)      *
  *                      handling of a REBIND statement causes   *
  *                      an ABENDS04E/ abend04e in DB2:          *
  *                                                              *
  *                      IEA995I SYMPTOM DUMP                    *
  *                      OUTPUT  649                             *
  *                      SYSTEM COMPLETION                       *
  *                      CODE=04E  REASON                        *
  *                      CODE=00C50102                           *
  *                       TIME=14.13.42  SEQ=20987               *
  *                      CPU=0000  ASID=00EE                     *
  *                       PSW AT TIME OF ERROR                   *
  *                      078D0000   8008D01A  ILC 2  INTC 0D     *
  *                         ACTIVE LOAD MODULE                   *
  *                      ADDRESS=0006D228                        *
  *                      OFFSET=0001FDF2                         *
  *                         NAME=DSNECP10                        *
  *                         DATA AT PSW                          *
  *                       0008D014 - 5810C219                    *
  *                      0A0DD203  61CBC195                      *
  *                         GR 0: 00000000                       *
  *                      1: 8404E000                             *
  *                            2: 0000004E   3: 00000008         *
  *                            4: 000455A0   5: 00000000         *
  *                            6: 00043A48   7: 00000008         *
  *                            8: 00000001   9: 0000000C         *
  *                            A: 0003EA40   B: 8008C310         *
  *                            C: 0008D30F   D: 0003EA40         *
  *                            E: 8008D008   F: 00C50102         *
  *                       END OF SYMPTOM DUMP                    *
  *                                                              *
  *                      and a message:                          *
  *                                                              *
  *                      DSNE004E PROBABLE                       *
  *                      SUBSYSTEM ERROR                         *
  *                      DETECTED IN CSECT                       *
  *                      DSNECP10,                               *
  *                      SUBSYSTEM                               *
  *                      FUNCTION IDENTIFY,                      *
  *                      RETCODE X'0000004E',                    *
  *                      REASON CODE                             *
  *                      X'00C50102'  /                          *
  *                      rc00C50102 and                          *
  *                      rsn00C50102                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Change Management Batch
  (CM Batch) handling of a REBIND statement causes an ABEND04E /
  abend04e in DB2.
  

Problem conclusion

• Problem has been resolved.  The resolution will call the DB2
  stored procedure SYSPROC.ADMIN_COMMAND_DSN to issue the REBIND
  statements.
  
  The customer must ensure that the DB2 stored procedure
  SYSPROC.ADMIN_COMMAND_DSN is installed and functional.  If
  the SYSPROC.ADMIN_COMMAND_DSN is not installed a
  SQLCODE=-440 / SQLCODEN440 error will occur:
  
  DSNT408I SQLCODE = -440, ERROR:  NO AUTHORIZED
  PROCEDURE NAMED SYSPROC.ADMIN_COMMAND_DSN
  HAVING COMPATIBLE ARGUMENTS WAS FOUND
  DSNT418I SQLSTATE   = 42884 SQLSTATE RETURN CODE
  

Temporary fix

Comments

APAR Information

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

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

  UK91915 UK91916

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91915

     UP13/02/26 P F302

• RA20 PSY UK91916

     UP13/02/26 P F302

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.