PM31030: NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
  SQLCODEN551 occurs when using ALT, the "Run SQLID" field on
  panel ADBP7P was not used and the SET CURRENT SQLID statement
  was missing in the WSL.
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS that use the ADB26CT 'Create Table'     *
  *                 panel.                                       *
  *                                                              *
  *                 Users of the DB2 Administration Tool for     *
  *                 z/OS, that use the CREATE and ALTER          *
  *                 functions.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADB26CT has been enhanced to      *
  *                      support adding hash clause, XML type    *
  *                      modifiers, inline LOBs with additional  *
  *                      default capability and EXCLUDING XML    *
  *                      TYPE MODIFIERS clause to the create     *
  *                      table statement.                        *
  *                                                              *
  *                      CREATE and ALTER function panels        *
  *                      need support for DB2 10 enhancements,   *
  *                      related to currently committed data     *
  *                      access, row/column level access         *
  *                      control, XML type, greater timestamp    *
  *                      precision, timestamp with time zone     *
  *                      and SQL routine body edit for SQL       *
  *                      scalar/table functions.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Panel ADB26CT was enhanced to support hash indexes, inline LOBs
  and XML type modifiers.
  
  CREATE and ALTER function panels were enhanced to support new
  DB2 10 enhancements.
  

Problem conclusion

Temporary fix

Comments

• The Create Table enhancements have been delivered.
  
  CREATE and ALTER function enhancements have been delivered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK66442 UK66443

Modules/Macros

•    ADBA1TC  ADBA1TG  ADBA1TH  ADBA1TM  ADBA1TP
  ADBA1TV  ADBA1TX  ADBBIND  ADBCCMM  ADBCDTS  ADBCP    ADBCRCM
  ADBCVCT  ADBEALT  ADBECP   ADBEPDCC ADBE6CF  ADBE6CFU ADBE6CTF
  ADBE6CTH ADBGAJOB ADBHCP   ADBHMES  ADBHMEX  ADBHMSPI ADBHUSC
  ADBHUSK  ADBHUSO  ADBHUSU  ADBHUTC  ADBHUXC  ADBHUXO  ADBH5L
  ADBH5TU1 ADBH6CF  ADBH6CFN ADBH6CFP ADBH6CFR ADBH6CFS ADBH6CFT
  ADBH6CFU ADBH6CFV ADBH6CFW ADBH6CFX ADBH6CFZ ADBH6CT  ADBH6CTF
  ADBH6CTH ADBH6CUU ADBH7P   ADBMAIN  ADBNSPB  ADBPAXM  ADBPCP
  ADBPMSPI ADBPPDC  ADBPPDCC ADBPPDC0 ADBP1PMA ADBP6CCM ADBP6CFA
  ADBP6CFN ADBP6CFQ ADBP6CFR ADBP6CFZ ADBP6CPM ADBP6CTH ADBSCP
  ADBTEPU  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMRG ADB2CMS  ADB2CMT
  ADB2CRO  ADB2C11A ADB2E    ADB2FMT  ADB2GEN  ADB2ISQ  ADB2LNH2
  ADB2MES  ADB2MEX  ADB2MSK  ADB2M1S  ADB2PA   ADB2PA5  ADB2PA6
  ADB2PSTM ADB2REG  ADB2RER  ADB2REY  ADB2U    ADB2UOPS ADB2USC
  ADB2USCO ADB2USK  ADB2USKO ADB2USO  ADB2USOP ADB2USU  ADB2UTC
  ADB2UTCO ADB2UUOP ADB2UXB  ADB2UXBO ADB2UXC  ADB2UXCO ADB2UXO
  ADB2UXOO ADB21    ADB21DS  ADB21F   ADB21KR  ADB21O   ADB21PM
  ADB21S   ADB21SA  ADB21T   ADB21TC  ADB21TSE ADB21TSR ADB21TUP
  ADB21VV  ADB21VV0 ADB21X   ADB21XA  ADB25    ADB25LD  ADB25LE
  ADB25LEA ADB25T   ADB25TL1 ADB25TL2 ADB25TU  ADB25TU3 ADB25TU4
  ADB26    ADB26CF  ADB26CFO ADB26CFP ADB26CFR ADB26CFS ADB26CFT
  ADB26CFU ADB26CFV ADB26CFW ADB26CFX ADB26CFY ADB26COQ ADB26CPC
  ADB26CRT ADB26CS  ADB26CT  ADB26CTF ADB26CTU ADB26CUU ADB26DT
  ADB26PAR ADB26PTR ADB26RT  ADB26TOP ADB27AC  ADB27AP  ADB27C
  ADB27CF  ADB27CFU ADB27CMR ADB27CR  ADB278C1 ADB28MC  ADB28S
  ADB28UL1 ADB31    ADB34    ADB39    ADB57    ADB60    ADB6000
  ADB7000  ADB75    ADB76
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66442

     UP11/04/08 P F104

• R720 PSY UK66443

     UP11/04/08 P F104

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.