PH09855: ADMIN TOOL SSID COMMAND NOT DISABLED "SSID SWITCHING" "NO" CCQPPRD CCQPDB2 TCZ SQLCODE -30080 DSNB260I REMOTE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  1.  The Db2 Administration Tool User's guide states that the
  SSID command can be enabled or disabled via the Tools Customizer
  Product or Db2 Parameter "SSID Switching".  However, even when
  this parameter is set to "NO", the SSID command is not
  disabled.
  2.  If a user connects to a remote subsystem using the CO line
  command on panel ADB2DDF, a COMMIT is not done once the user
  finishes their work.  As a result, if the user exits Admin Tool
  while still connected to the remote subsystem, they receive
  SQLCODE = -30080 / SQLCODEN30080 ERROR: COMMUNICATION ERROR 048,
  and the following appears on the Db2 log:
  DSNB260I  -ssid DSNB1PCK WARNING - A READER HAS BEEN
        RUNNING FOR <duration> MINUTES
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      The Db2 Admin Tool command SSID cannot  *
  *                      be disabled.                            *
  *                                                              *
  *                      Issue 2:                                *
  *                      The Db2 Admin Tool command              *
  *                      'CONNECT <location>' results in         *
  *                      SQLCODE=-30080 / SQLCODEN30080 and may  *
  *                      also see SQLCODE=-30081 / SQLCODEN30081 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Issue 1:
  When the IBM Tools Customizer for z/OS Product
  Parameters 'Allow SSID cmd to switch Db2 subsystems'
  is set to 'NO', the Db2 Admin Tool command SSID is
  not disabled.
  
  Issue 2:
  After issuing the Db2 Admin Tool command
  'CONNECT <location>', wait several minutes,
  and END/F3, the following error message occurs:
  
  SQLCODE = -30080 with Communication Error
            0048 (0000-08640000).
  Depending on environment, an SQLCODE = -30081
  can also occur.
  

Problem conclusion

• SSID, -30080, and -30081 incidents have been resolved.
  

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:

  UI64050 UI64051

Modules/Macros

•    ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI64050

     UP19/07/08 P F907

• RC10 PSY UI64051

     UP19/07/09 P F907

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.