PM65177: DB2 ADMIN TOOL PANEL ADB2E OPTION CT CREATES WRONG DDL FOR PLAN_TABLE WHILE UNDER DB2 FOR Z/OS V8 NFM AND V10 CM8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admininistration Tool for z/OS V10.1
  Panel ADB2E Option CT creates wrong DDL for PLAN_TABLE
  while under DB2 for z/Os V8 NFM and V10 CM8
  Additional symptoms:
  DSNTXTB while running under DB2 for z/OS V8 NFM receives:
  DSNT095I DSNTXTB REQUEST CANCELLED BECAUSE TABLE
  authid.PLAN_TABLE
           IS NOT IN THE REQUIRED FORMAT AT COLUMN NUMBER 29:
  - EXPECTED: VERSION VARCHAR(64)
  - FOUND   : VERSION VARCHAR(122)
   Aborting due to unexpected table format.
   *** End   RC=8
  .........................................................
  DSNTXTAunder DB2 for z/OS V10 CM8 receives following message:
  DSNT092I: DSNTXTA DID NOT COMPLETE PROCESSING OF
  authid.PLAN_TABLE
  BECAUSE OF AN UNEXPECTED NAME OR TYPE FOR COLUMN NUMBER 59.
  - EXPECTED: PARENT_PLANNO SMALLINT
  - FOUND   : BIND_EXPLAIN_ONLY CHAR(1)
  *** End   RC=8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use panel ADB2EC 'Create Plan       *
  *                 Table' to create PLAN_TABLE.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS        *
  *                      Version 10.1 panel ADB2E 'Explain'      *
  *                      Option 'CT - Create a table used by     *
  *                      EXPLAIN' creates the wrong DDL for      *
  *                      PLAN_TABLE when using DB2 for z/OS      *
  *                      R810 New Function Mode (NFM) and        *
  *                      DB2 10 Compatibility Mode 8 (CM8).      *
  *                                                              *
  *                      Additional symptoms:                    *
  *                      DSNTXTB while running under             *
  *                      DB2 for z/OS R810 NFM receives          *
  *                      the following message:                  *
  *                                                              *
  *                      DSNT095I DSNTXTB REQUEST                *
  *                      CANCELLED BECAUSE TABLE                 *
  *                      authid.PLAN_TABLE IS NOT IN             *
  *                      THE REQUIRED FORMAT AT                  *
  *                      COLUMN NUMBER                           *
  *                      column_number:                          *
  *                                                              *
  *                      - EXPECTED: VERSION VARCHAR(64)         *
  *                      - FOUND   : VERSION VARCHAR(122)        *
  *                      Aborting due to unexpected table        *
  *                      format                                  *
  *                      End   RC=8 rc8 rc08                     *
  *                      ....................................    *
  *                      DSNTXTA under DB2 for z/OS 10 CM8       *
  *                      receives the following message:         *
  *                                                              *
  *                      DSNT092I: DSNTXTA DID NOT COMPLETE      *
  *                      PROCESSING OF authid.PLAN_TABLE         *
  *                      BECAUSE OF AN UNEXPECTED NAME           *
  *                      OR TYPE FOR COLUMN NUMBER               *
  *                      column_number.                          *
  *                      - EXPECTED: PARENT_PLANNO SMALLINT      *
  *                      - FOUND   : BIND_EXPLAIN_ONLY CHAR(1)   *
  *                      End   RC=8 rc8 rc08                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool panel ADB2EC should detect the DB2
  release/mode before defining the DDL to create PLAN_TABLE.
  

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:

  UK81008

Modules/Macros

•    ADB2EC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81008

     UP12/08/15 P F208

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.