A fix is available
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 number
PM31030
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-24
Closed date
2011-04-01
Last modified date
2011-05-02
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2011