PI64387: SQL CODE -30080 USING DB2 ADMIN TOOL ACROSS LPARS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using option DD ('Distributed DB2 systems') to execute DB2
  Admin Tool functions across DB2 subsystems,  a timeout may be
  encountered, resulting in SQL code -30080:
  
  DSNT408I SQLCODE = -30080, ERROR:  COMMUNICATION ERROR 0048
  (0000-8640000)
  DSNT418I SQLSTATE   = 08001 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNLVRPL SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 9  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000009'  X'00000000'  X'00000000'
  X'FFFFFFFF' X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who connect to remote systems       *
  *                 using Virtual Telecommunications             *
  *                 Access Method (VTAM).                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using option DD ('Distributed      *
  *                      DB2 systems') to execute DB2 Admin      *
  *                      Tool functions across DB2 subsystems,   *
  *                      a timeout may be encountered and        *
  *                      SQLCODE=-30080 displayed.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using option DD ('Distributed DB2 systems') to execute DB2
  Admin Tool functions across DB2 subsystems, a timeout may be
  encountered and the following SQLCODE=-30080 / SQLCODEN30080
  error may be observed:
  
  DSNT408I SQLCODE = -30080, ERROR:  COMMUNICATION
  ERROR 0048 (0000-08640000)
  DSNT418I SQLSTATE   = 08001
  SQLSTATE RETURN CODE
  

Problem conclusion

• The problem has been fixed by resetting the connection when a
  SQLCODE=-30080 is received, and by attempting to connect again
  and run the SQL statement.
  

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:

  UI42796 UI42797

Modules/Macros

•    ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI42796

     UP16/11/24 P F611

• RB20 PSY UI42797

     UP16/11/24 P F611

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.