A fix is available
APAR status
Closed as program error.
Error description
IBM INTERNAL
Local fix
APPLY PTF.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS and DB2 Object Comparison * * Tool for z/OS version 10. * **************************************************************** * PROBLEM DESCRIPTION: Several enhancements to the * * Explain table capability and * * visibility have been added. * * Such as: * * * * - The ability to go into the * * Explain list panel showing * * the index access information * * from the package panel when * * index access is required on * * those queries. * * * * - Adding a MIXOPSEQ column to * * the ORDER BY clause when * * selecting data from the explain * * table to achieve the correct * * ordering of explain data rows. * * * * - Run WSL has been enhanced * * to accommodate Authorization * * Switch ID and SECADM * * Authorization ID via the build of * * the ADBTEPA job. * * * * - The RUNSTATS panel ADB2USR * * has been enhanced to support * * new parameters in DB2 V10. * * Additional fields for Sample, * * Tablesample, Repeatable, Profile * * and From Existing has been added. * * The skeleton ADB2USRO is * * enhanced to support those changes. * * * * - The Migrate function has been * * enhanced to support DB2 V10 * * Versioned Tables. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** Several enhancements to the Explain table capability and visibility have been added. Such as: - The ability to go into the Explain list panel showing the index access information from the package panel when index access is required on those queries. - Adding a MIXOPSEQ column to the ORDER BY clause when selecting data from the explain table to achieve the correct ordering of explain data rows. - Run WSL has been enhanced to accommodate Authorization Switch ID and SECADM Authorization ID via the build of the ADBTEPA job. - The RUNSTATS panel ADB2USR has been enhanced to support new parameters in DB2 V10. Additional fields for Sample, Tablesample, Repeatable, Profile and From Existing has been added. The skeleton ADB2USRO is enhanced to support those changes. - The Migrate function has been enhanced to support DB2 V10 Versioned Tables.
Problem conclusion
The enhancements have been provided. The following Admin 720 APARs have been fixed in this APAR. PM02594 PM22125 PM18517 PM15370 PM11745 PM13392 PM25811 PK79758 PM17999 PM12069 PM19723 PM06669 PK97664 PM25811 PM11854 PM15062 PM23327 PM22426 PM21764 PM22033 PM22057 PM01936 PM16339 PM16790 PM19939 PM14625 PM07202 PM16857 PM22106 PM06879
Temporary fix
Comments
APAR Information
APAR number
PM24212
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-10-11
Closed date
2010-12-29
Last modified date
2011-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBBIND ADBBIND2 ADBCCMM ADBCDTS ADBCHKPT ADBCHU01 ADBCHU02 ADBCNBVF ADBCVIC ADBC12 ADBEALT ADBEEL ADBGAJOB ADBGRANT ADBHAZ ADBHPDCC ADBHP2 ADBHSQL ADBHUSR ADBHUSR9 ADBHW ADBHWLA ADBHW1 ADBHW1B1 ADBH1TAB ADBH1TC ADBH1XAR ADBH8M ADBH8S ADBH8T ADBMAIN ADBPAXM ADBPWLA ADBRIP9 ADBSALT ADBSEL ADBSWLA ADBSWLP ADBTEPR ADBTEP2 ADBTREO ADB2AUS2 ADB2A2WS ADB2CC ADB2CCI ADB2CIMP ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2C11 ADB2C11A ADB2C44 ADB2E ADB2EE ADB2EL ADB2EQ ADB2EUC ADB2GC ADB2GD ADB2GE ADB2GEN ADB2GF ADB2GG ADB2GGEN ADB2GH ADB2GK ADB2GL ADB2GO ADB2GP ADB2GQ ADB2GR ADB2GS ADB2GT ADB2GZ ADB2MSK ADB2MSP ADB2M1M ADB2M1R ADB2M1S ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PSTM ADB2RALL ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2REY ADB2REZ ADB2RGC ADB2RIP ADB2TEP ADB2U ADB2US ADB2USOP ADB2USR ADB2USRA ADB2USRO ADB2USR9 ADB2W ADB2WCL ADB2WHPU ADB2WLVD ADB2WVL ADB2W1 ADB2W1B1 ADB2W1Q ADB2W1S ADB2W1SI ADB2W10 ADB2Z2BU ADB2Z2B1 ADB21A ADB21CI1 ADB21D ADB21E ADB21F ADB21J ADB21K ADB21P ADB21PR ADB21S ADB21SAR ADB21SAT ADB21SA0 ADB21SGM ADB21T ADB21TA ADB21TAB ADB21TAU ADB21TSE ADB21X ADB21XA ADB21XAA ADB21XAR ADB21XAS ADB21XAV ADB21XA0 ADB21XP ADB26CRT ADB26CT ADB26CTF ADB26CUU ADB26CXU ADB27AC ADB27CA ADB27CAA ADB27CF ADB27CFU ADB27CMR ADB27CV ADB28ADD ADB28ASD ADB28AT ADB28ATD ADB28M ADB28MC ADB28S ADB28SHI ADB28T ADB28USK ADB3000 ADB48 ADB5000 ADB51 ADB53 ADB56 ADB74 EXC21DAJ H0IHA10J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK63573
UP11/02/06 P F102
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 March 2011