PM76478: PANEL ADB21S 'TABLE SPACES' 'DSN - DISPLAY TABLE SPACE DATA SET NAME(S)' LINE COMMAND SQLCODEN206 INSTANCE IS NOT A COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' DSN - Display table space
  data set name(s) line command issued on panel ADB21S 'Table
  Spaces' ends with a SQLCODEN206:
  
  ADB2E1 in --------------------- DB2 Error Display 1
  Command ===>
  Rollback done
     SQLCODE : -206                           DSNTIAR CODE :  0
  
  DSNT408I SQLCODE = -206, ERROR:  INSTANCE IS NOT A COLUMN OF AN
  INSERTED TABLE,
           UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM
  CLAUSE, OR IS NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER
  DSNT418I SQLSTATE   = 42703 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXORSO SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -100  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF9C'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  when running on a DB2 R810 subsystem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use line command 'DSN - Display     *
  *                 table space data set name(s)' on panels      *
  *                 ADB21S 'Table Spaces'/ADB21X 'Indexes'       *
  *                 to display data set name for a table space   *
  *                 and table space indexes.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool 'DSN -      *
  *                      Display table space data set name(s)'   *
  *                      line command issued on panels ADB21S    *
  *                      'Table Spaces' and ADB21X 'Indexes'     *
  *                      ends with a SQLCODEN206 /               *
  *                      SQLCODE=-206 error:                     *
  *                                                              *
  *                      DSNT408I SQLCODE = -206,                *
  *                      ERROR:  INSTANCE IS NOT A COLUMN OF     *
  *                      AN INSERTED TABLE, UPDATED TABLE,       *
  *                      OR ANY TABLE IDENTIFIED IN A FROM       *
  *                      CLAUSE, OR IS NOT A COLUMN OF THE       *
  *                      TRIGGERING TABLE OF A TRIGGER.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When DB2 is running on R810 subsystem, the program should use
  the general INSTANCE as 0001 and remove column CLONE to
  construct a VSAM data set name for a table space and index
  space.
  

Problem conclusion

• Problem has 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:

  UK91048

Modules/Macros

•    ADB2DSN0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91048

     UP13/01/22 P F301

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.