PI54617: CHANGE MANAGEMENT MULTI TARGET CHANGE / MTC SQLCODEN900

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Change Management Multi
  Target Change / MTC jobs fail with a SQLCODE -900 / SQLCODEN900.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Multi-Target            *
  *                 Change (MTC) function and do not             *
  *                 have Distributed Relational Database         *
  *                 Architecture  (DRDA ) enabled.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS'   *
  *                      Change Management Multi-Target Change   *
  *                      job failed with a SQLCODE=-900 /        *
  *                      SQLCODEN900 or SQLCODE=-30081           *
  *                      SQLCODEN30081:                          *
  *                                                              *
  *                      DSNT408I SQLCODE = -900, ERROR:         *
  *                      THE SQL STATEMENT CANNOT                *
  *                      BE EXECUTED BECAUSE                     *
  *                      THE APPLICATION PROCESS                 *
  *                      IS NOT CONNECTED TO A SERVER            *
  *                      DSNT418I SQLSTATE   = 08003             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      DSNT408I SQLCODE = -30081,              *
  *                      ERROR:  TCP/IP COMMUNICATIONS           *
  *                      ERROR DETECTED.                         *
  *                      API=SOCKETS,                            *
  *                      LOCATION=::>location_IP<,               *
  *                      FUNCTION=CONNECT                        *
  *                      ERROR CODES=1128 76630291 0000          *
  *                      DSNT418I SQLSTATE   = 08001             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      when selecting communication method     *
  *                      Distributed Relational Database         *
  *                      Architecture  (DRDA ) even though       *
  *                      DRDA was not enabled.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS' Change Management
  Multi-Target change job failed with a SQLCODE=-900 /
  SQLCODEN900 or SQLCODE=-30081 / SQLCODEN30081
  when selecting communication method DRDA when DRDA
  was not enabled.
  

Problem conclusion

• Problem has been resolved.
  
  1 - When a SQLCODE=-30081 error is detected, a new message
  ADB9427E / msgadb9427e will be displayed:
  
  ADB9427E   Cannot connect to the DB2 subsystem. Restore
  the connection and rerun the job.
  Explanation
  The target change cannot be registered because there is
  a disconnection between the multi-target change program
  and the DB2 subsystem.
  System action
  Processing stops.
  User response
  Restore the connection and rerun the job.
  
  2 - When a SQLCODE=-900 error is detected, a new message
  ADB9428E / msgadb9428e will be displayed:
  
  ADB9428E   A multi-target change cannot be registered
  because the connection to DB2 system no longer exists.
  Explanation
  A failure has disconnected the application, so the application
  can not execute any SQL statement.
  System action
  Processing stops.
  User response
  Restore the connection and rerun the job.
  

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:

  UI35630

Modules/Macros

•    ADBCRCM  ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI35630

     UP16/02/26 P F602

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.