PM55039: SQLCODEN206 ERROR: TS.MAXPARTITIONS IS NOT A COLUMN SPACE MANAGEMENT / SM FUNCTION PANEL ADB2M 11/12/27 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Space Management function
  panel ADB2M 'DB2 Space Manager' option 2 'Table space estimator'
  running against DB2 R810 ends with:
  DSNT408I SQLCODE = -206, ERROR:  TS.MAXPARTITIONS 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    = -600  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Space Manager (SM)          *
  *                 function when on DB2 subsystems prior        *
  *                 to DB2 9.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS'   *
  *                      Space Management function panel ADB2M   *
  *                      'DB2 Space Manager' Option 2 'Table     *
  *                      space estimator' running against DB2    *
  *                      R810 ends witha SQLCODEN206 /           *
  *                      SQLCODE=-206:                           *
  *                                                              *
  *                      DSNT408I SQLCODE = -206,                *
  *                      TS.MAXPARTITIONS 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           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  MAXPARTITIONS is not a valid column in table
  SYSIBM.SYSTABLESPACE on DB2 prior to DB2 9.
  

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:

  UK76134 UK76135

Modules/Macros

•    ADB2MES  ADB2MESG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK76134

     UP12/02/15 P F202

• R720 PSY UK76135

     UP12/02/15 P F202

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.