A fix is available
APAR status
Closed as new function.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS, MISCELLANEOUS ENHANCEMENTS.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for z/OS * * and IBM Tools Customizer for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following enhancements are * * delivered: * * * * - The following input fields are * * now supported/enabled on the LOAD * * Utility Options panel ADB2UTC * * 'Specify Utility Options - LOAD': * * * * ERRDDN . . (DD name for error * * processing) * * DISCARDDN (DD name for * * discarded records) * * DISCARDS . (0 to * * 2147483647) * * * * - DB2 Administration Tool now has the * * ability to override attributes * * TRACKMOD and DATA CAPTURE using the * * Generate (GEN), Work Statement List * * (WSL) , Multi-target changes, Export * * changes, and Change Management (CM) * * Import functions with masking for * * objects tablespaces and tables. * * * * - The DB2 Administration Tool GEN * * function now has the ability to * * include new schema SYSIBMADM in the * * CURRENT PATH when generating DDL for * * objects Views, Triggers, Masks, * * Permissions, Procedures and Functions. * * * * - A change with no change statements * * is currently considered an Incomplete * * change which is set to INITIAL status * * when registered. Such a change can * * not be analyzed, run or recovered. * * * * - The Change management function * * is enhanced to add the ability to * * REGISTER, ANALYZE, RUN and RECOVER * * an empty change. * * * * - The DDL converter does not have * * the newly introduced schema name * * SYSIBMADM as a default path. * * * * - The UPGRADE option for the Change * * Management Database task has been * * enhanced to generate a job template * * ADBMCMA that will upgrade back-level * * DB2 Administration Tool objects to * * the current maintenance level. * * * * The UPGRADE job template ADBMCMA * * also has provisions to tolerate * * possible SQLCODE = -601 / * * SQLCODEN601, SQLCODE = -612 / * * SQLCODEN612, or SQLCODE = 562 / * * SQLCODE562 errors and not fail with * * RC=8 / RC8 when these SQLCODEs are * * encountered. Instead, a brief/simple * * informational message ADB51791I / * * msgadb51791i will be displayed in the * * * * For example, if SQLCODE = -612 is * * encountered, the following message * * will appear in the job output: * * * * ADB5179I An expected sqlcode -612 * * was encountered and can be ignored. * * No action needed. * * * * Due to this enhancement, the following * * SADBSAMP jobs are no longer required * * and have been disabled: * * * * DB2 Administration Tool for z/OS * * Version 10, Release 2: * * SADBSAMP(ADBCHANU) * * SADBSAMP(ADBCHG01) * * SADBSAMP(ADBCHG02) * * SADBSAMP(ADBCHG03) * * SADBSAMP(ADBCHG04) * * SADBSAMP(ADBCHG05) * * SADBSAMP(ADBCHG06) * * * * DB2 Administration Tool for z/OS * * Version 11, Release 1: * * SADBSAMP(ADBCHG01) * * SADBSAMP(ADBCHG02) * * SADBSAMP(ADBCHG03) * * * * - MERGE module uses hard coded * * message without error numbers. * * * * - Change Management processing * * does not allow a user to modify * * REORG INDEX parameters when * * using Change Management. * * * * - DB2 Admin does not allow a user * * to user to modify REORG INDEX * * parameters when issuing the ALT * * command. * * * * - CM Batch does not allow users to * * control data set attributes for the * * IFF, CHG, DELTA, DDL, SRCVF, * * TGTVF, and MTC file. * * * * - The special registers CURRENT * * TEMPORAL BUSINESS_TIME and * * CURRENT TEMPORAL * * SYSTEM_TIME are now being saved * * when set in a DB2 Admin session * * and restored when a DB2 Admin * * session is started again. * * * * - Support added for new FUNCTION * * and PROCEDURE options * * BUSINESS_TIME SENSITIVE and * * SYSTEM_TIME SENSITIVE. * * * * The following has been fixed: * * * * - Using the 'ALT Alter Table' (ALT) * * command to change objects, will * * sometimes produce duplicate REBIND * * statements. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following enhancements are delivered: - The following input fields are now supported/enabled on the panel ADB2UTC: ERRDDN . . . . . . ________ (DD name for error processing) DISCARDDN . . . . ________ (DD name for discarded records) DISCARDS . . . . . ________ (0 to 2147483647) - DB2 Administration Tool now has the ability to override attributes TRACKMOD and DATA CAPTURE using the Generate (GEN), Work Statement List (WSL), Multi-target changes, Export changes, and Change Management (CM) Import functions with masking for objects tablespaces and tables. - DB2 Administration Tool GEN function now has the ability to include new schema SYSIBMADM in CURRENT PATH when generating DDL for objects Views, Triggers, Masks, Permissions, Procedures and Functions. - The Change management function is enhanced to add the ability to register, analyze, run and recover an empty change. - The DDL converter now has the newly introduced schema SYSIBMADM as a default path. The absence of the schema SYSIBMADM from the default path can result in failures. - The UPGRADE option for the Change Management Database task has been enhanced to generate a job template ADBMCMA that will upgrade back-level DB2 Administration Tool objects (including Change Management) to the current maintenance level. The UPGRADE job template ADBMCMA also has provisions to tolerate possible SQLCODE = -601 / SQLCODEN601, SQLCODE = -612 / SQLCODEN612, or SQLCODE = 562 / SQLCODE562 errors and not fail with RC=8 / RC8 when these SQLCODEs are encountered. Instead, a brief/simple informational message ADB51791I / msgadb51791i will be displayed in the job output. - The MERGE module uses hard coded messages without error numbers. It does not assist users with troubleshooting. - Users are allowed to go to the utility parameter option panel but are not allowed to modify REORG INDEX parameters during Change Management processing. - Users are allowed to go to the utility parameter option panel but are not allowed to modify REORG INDEX parameters during ALT command processing. - Users can not control data set attributes during CM Batch processing for the IFF, CHG, DELTA, DDL, SRCVF, TGTVF, and MTC file. - The special registers CURRENT TEMPORAL BUSINESS_TIME and CURRENT TEMPORAL SYSTEM_TIME are now being saved when set in a DB2 Admin session and restored when a DB2 Admin session is started again. - Changes to FUNCTION and PROCEDURE options BUSINESS_TIME SENSITIVE and SYSTEM_TIME SENSITIVE were not supported by the DB2 Object Comparison Tool. The following has been fixed: - Using ALT command or using Compare will sometimes produce duplicate REBIND statements.
Problem conclusion
Temporary fix
Comments
Problems have been resolved. Duplicate REBIND statements will no longer occur. Enhancements delivered: - Error range ADB8001E to ADB8032E are converted from hard-coded messages. - Enhancement delivered to allow users to control data set attributes for the IFF, CHG, DELTA, DDL, SRCVF, TGTVF, and MTC file. The attribute name from the TSO ALLOCATE statement syntax is used below to list the attributes enabled: DATACLAS MGMTCLAS STORCLAS EXPDT RETPD VOLUME MAXVOL DSNTYPE DIR BUFNO Updates to the DB2 Administration Tool for z/OS Version 11, Release 1, User's Guide and Reference can be found in the following techdoc: http://www-01.ibm.com/support/docview.wss?uid=swg27041314 ž**** PE14/12/03 FIX IN ERROR. SEE APAR PI24731 FOR DESCRIPTION
APAR Information
APAR number
PI19740
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-11
Closed date
2014-07-16
Last modified date
2014-12-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB$$PRM ADB$$SEQ ADBASW ADBCCM ADBCCME ADBCCMM ADBCDCH ADBCDTS ADBCDTW ADBCEST ADBCFGPM ADBCHANG ADBCHG01 ADBCHG02 ADBCHG03 ADBCHKPT ADBCKP02 ADBCMBAT ADBCMBIV ADBCMBSS ADBCMPDB ADBCP ADBCRCM ADBCRCR ADBCRSM ADBCRSP ADBCRSU ADBCSPG ADBCSRV ADBCUPC ADBCUST ADBCVCP ADBCVCT ADBDAT ADBDK ADBEALT ADBEAPI0 ADBEC7E ADBEC7L ADBEDDL ADBE7TOP ADBFB2VB ADBGAJOB ADBHCRG ADBHCRS ADBHC2L ADBHC7AT ADBHC7L ADBHTRC ADBHUSU ADBHUTC ADBH1TAL ADBH7TOP ADBIREO ADBLI ADBLIM ADBMAIN ADBMCMA ADBMCMB ADBNSPB ADBPA ADBPARM ADBPA1 ADBPCRG ADBPCRS ADBPC15 ADBPC15A ADBPC7AT ADBPC7L ADBPC71 ADBPTRC ADBPWLB ADBP1TAL ADBP7TOP ADBP9000 ADBRIP9 ADBS27AC ADBTCHK ADBTEPA ADBTEPI ADBTEPR ADBTEPU ADBTEP2 ADBTEP2R ADBUPGRD ADBV99 ADB1000 ADB2CID ADB2CIMP ADB2CLUP ADB2CMF ADB2CMM ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CRO ADB2CR0 ADB2C11 ADB2C11A ADB2C12 ADB2C14 ADB2C2L ADB2C44 ADB2DEP ADB2FMT ADB2GEN ADB2GEN2 ADB2GET ADB2GO ADB2ISQ ADB2MASK ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RIP ADB2TEP ADB2UCUU ADB2UCU6 ADB2UOPS ADB2USOO ADB2USU ADB2UT ADB2UTC ADB2UTCO ADB2UTLX ADB2UXO ADB2VERD ADB2WCL ADB2WIN ADB2WLDA ADB2WVL ADB2W1 ADB2W1B1 ADB2W10 ADB2Z2BU ADB2000 ADB21 ADB21TA ADB21XA0 ADB2314 ADB2314T ADB25LU ADB26CO ADB26COQ ADB26RT ADB27AC ADB27C ADB27CA ADB27CAA ADB27CMR ADB27CX ADB27C0 ADB27DUP ADB28M ADB28MC ADB3000 ADB5000 ADB51 ADB7000 ADB8000 ADB9000 H0IHB10J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI19669
UP14/07/23 P F407
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 December 2014