A fix is available
APAR status
Closed as new function.
Error description
NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
Local fix
APPLY PTF.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the ALT (Alter Table) function * * to change tables, and users of the DB2 * * Administration Tool for z/OS who use the * * CM IMPORT feature to import a changes * * (.CHG) file. * **************************************************************** * PROBLEM DESCRIPTION: The ALT function for altering a table * * has been enhanced to allow changes to * * more attributes of a table. * * * * Additionally, the ADBDELET job built * * by the ALT process now deletes the * * SVARS data set. * * * * New messages have been added to the * * ALT dialog when making changes that * * involve temporal table attributes. * * The new message numbers are: * * * * ADB460E * * 'A column named col_name cannot * * exist when defining a col_name * * period.' * * * * * * ADB461I * * 'The columns defined as ROW BEGIN * * and ROW END are chosen for the * * PERIOD SYSTEM_TIME clause.' * * * * ADB465E * * 'The chosen column contains an * * attribute that is not allowed for a * * BUSINESS_TIME period column.' * * * * ADB466W * * 'If the BUSINESS_TIME WITHOUT * * OVERLAPS is removed, the business * * period columns will become part of * * the primary key.' * * * * ADB467E * * 'A default value is not allowed for * * a column with any of the following * * attributes: AS ROW BEGIN, AS ROW * * END or AS TRANSACTION START ID.' * * * * ADB468E * * 'The BUSINESS_TIME columns must * * be of the same type and precision.' * * * * ADB469E * * 'A SYSTEM_TIME period cannot be * * specified for a table with a row * * permission or column mask.' * * * * ADB733E * * 'The target table space cannot be * * used, Reason reason_code' * * * * ADB736E * * 'The history table specification is * * not complete.' * * * * ADB736W * * 'Views exist that are dependent on * * the SYSTEM_TIME period and * * versioning. ' * * * * ADB741E * * 'A primary key must be specified * * in order to specify the BUSINESS_TIME * * WITHOUT OVERLAPS attribute.' * * * * ADB743E * * 'Business time period columns cannot * * be part of the index or primary key * * if BUSINESS_TIME WITHOUT OVERLAPS * * has been specified.' * * * * In Version 10.1 of the DB2 * * Administration Tool, panel ADB25 * * 'Utility generation using LISTDEFs', * * does not support the new parameters * * of the DB2 LISTDEF utility statement * * which were introduced by DB2 10. * * * * A new capability has been added to * * the IMPORT feature of the DB2 * * Administration Tool that allows * * importing the changes file generated * * by the DB2 Object Comparison Tool * * having a PREDROP prefixes. * **************************************************************** * RECOMMENDATION: * **************************************************************** A new command TBLOPTS has been added to panel ADB27C 'Alter Table' to allow changing certain attributes for a table. The attributes which can be changed using this command include these attributes: AUDIT, DATA CAPTURE, VALIDPROC, RESTRICT ON DROP, VOLATILE, APPEND, LABEL, COMMENT, BUSINESS_TIME and SYSTEM_TIME. The VOLATILE parameter has been moved from panel ADB27C to the new TBLOPTS panel ADBP7TOP 'ALTER - Table Options'. Panel ADB25 'Utility generation using LISTDEFs and TEMPLATEs' and associated parts are enhanced to support the new parameters of the LISTDEF utility statement. The enhancement in IMPORT supports the PREDROP prefix generated by DB2 Object Comparison Tool in the changes (.CHG) file.
Problem conclusion
Temporary fix
********* * HIPER * *********
Comments
The described capabilities and changes have been made. This enhancement allows users to specify the new LISTDEF parameters: CLONED, DEFINED, and HISTORY. The users of the DB2 Administration Tool for z/OS will need to use the option 'UL' on panel ADB25 'Utility generation using LISTDEFs and TEMPLATEs' to upgrade any existing LISTDEF definitions. ž**** PE11/11/09 PTF IN ERROR. SEE APAR PM51885 FOR DESCRIPTION ž**** PE11/11/23 PTF IN ERROR. SEE APAR PM52845 FOR DESCRIPTION
APAR Information
APAR number
PM44550
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-07-27
Closed date
2011-10-17
Last modified date
2011-12-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBALT ADBCCMM ADBCDTS ADBCP ADBCRCM ADBCRCR ADBCVC ADBCVCT ADBCVOC ADBEALT ADBEUSU ADBEZRPU ADBEZTW ADBE6CTH ADBE7TOP ADBGAJOB ADBHUSV ADBH5LE ADBH5LEA ADBH6CTU ADBH7C ADBH7CA ADBH7CR ADBH7C1 ADBH7TOC ADBH7TOP ADBPTAV ADBP7HA ADBP7TOC ADBP7TOP ADBSALT ADBTEPR ADBTEP2 ADBTRUN ADBTUNL ADBXF00 ADB2CID ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2DIP ADB2EC ADB2FMT ADB2IGN ADB2ISQ ADB2MSK ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2PTPL ADB2RE ADB2REE ADB2REG ADB2REH ADB2REP ADB2RER ADB2REU ADB2REY ADB2REZ ADB2SQL ADB2U ADB2USC ADB2USE ADB2USO ADB2USOO ADB2USQ ADB2USR ADB2USRA ADB2USR9 ADB2USU ADB2USUZ ADB2USV ADB2USVO ADB2USVX ADB2UTUL ADB2UXB ADB2UXK ADB2UXO ADB2UXR ADB2WCL ADB2WIN ADB2WVL ADB21SAR ADB21TA ADB21TAF ADB21TAN ADB21X ADB21XAR ADB21XP ADB25 ADB25C ADB25L ADB25LA ADB25LD ADB25LDP ADB25LD1 ADB25LE ADB25LEA ADB25LU ADB25LUV ADB25LUZ ADB25TL1 ADB25TUP ADB26CT ADB26CTP ADB26CTU ADB27AC ADB27C ADB27CA ADB27CAA ADB27CMR ADB27CPV ADB27CR ADB27CU ADB27CX ADB27C0 ADB27DUP ADB27IFF ADB27PC ADB27RDR ADB28M ADB28MC ADB28MM ADB3000 ADB46 ADB52 ADB73 ADB74 ADB77
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK72995
UP11/10/21 P F110
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:
22 December 2011