A fix is available
APAR status
Closed as new function.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS. NEW FUNCTION FOR SPANNED RECORDS - CHANGE PROCESS
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: 1 - DB2 Admin did not support UNLOAD * * SPANNED * * * * 2 - DB2 Admin did not have the * * ability to overwrite attributes * * FREEPAGE, PCTFREE, LOCKMAX and * * ERASE using the Generate (GEN) * * function with masking for * * tablespace and index objects. * * * * 3 - DB2 Admin did not have the * * ability to overwrite attributes * * FREEPAGE, PCTFREE, LOCKMAX and * * ERASE using the Work Statement * * List (WSL) cloning function * * with masking for tablespace and * * index objects. * * * * 4 - DB2 Admin did not have the * * ability to overwrite attributes * * FREEPAGE, PCTFREE, LOCKMAX and * * ERASE using the IMPORT changes * * function with masking for * * tablespace and index objects. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1 - DB2 Admin did not support UNLOAD SPANNED 2 - DB2 Admin did not have the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the Generate (GEN) function with masking for tablespace and index objects. 3 - DB2 Admin did not have the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the Work Statement List (WSL) cloning function with masking for tablespace and index objects. 4 - DB2 Admin did not have the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the IMPORT changes function with masking for tablespace and index objects.
Problem conclusion
Temporary fix
Comments
The following enhancements are delivered: 1 - Support for UNLOAD SPANNED has been added to the DB2 Administration Tool for z/OS 'ALT Alter Table' (ALT) and Object Compare process when the skip conversion process is used. To utilize this support specify 'YES' for the ADBTEP2 "Spanned" option on panel ADB2UPA 'Batch Job Utility Parameters': ADB2UPA -- DSNB Batch Job Utility Parameters --- Command ===> Spanned . . . . . . . NO (Yes/No) Support for UNLOAD SPANNED has also been added to the DB2 Admin utility functions. UNLOAD SPANNED improves the performance of unloading tables with LOB and XML columns because these columns now can be unloaded to the unload data set and no longer requires the use of LOB files which is an I/O intensive process. 2 - DB2 Admin now has the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the Generate (GEN) function with masking for tablespace and index objects. Example to overwrite FREEPAGE attribute for tablespaces and indexes: FREEPG: ABC*.DEF*, 6 TSFREEPG:DBTEST1.TSTEST1,8 IXFREEPG:IXSCH1.IXNAME1,9 Example to overwrite PCTFREE attribute for tablespaces and indexes: PCTFREE: ABC*.DEF*, 6 TSPCTFREE:DBTEST1.TSTEST1,8 IXPCTFREE:IXSCH1.IXNAME1,9 Example to overwrite LOCKMAX attribute for tablespaces: LOCKMAX:DBTEST1.TSTEST1,20 Example to overwrite ERASE attribute for tablespaces and indexes: ERASE: ABC*.DEF*, YES TSERASE:DBTEST1.TSTEST1,NO IXERASE:IXSCH1.IXNAME1,YES 3 - DB2 Admin Tool now has the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the Work Statment List (WSL) cloning function with masking for tablespace and index objects. Example to overwrite FREEPAGE attribute for tablespaces and indexes: FREEPG: ABC*.DEF*, 6 TSFREEPG:DBTEST1.TSTEST1,8 IXFREEPG:IXSCH1.IXNAME1,9 Example to overwrite PCTFREE attribute for tablespaces and indexes: PCTFREE: ABC*.DEF*, 6 TSPCTFREE:DBTEST1.TSTEST1,8 IXPCTFREE:IXSCH1.IXNAME1,9 Example to overwrite LOCKMAX attribute for tablespaces: LOCKMAX:DBTEST1.TSTEST1,20 Example to overwrite ERASE attribute for tablespaces and indexes: ERASE: ABC*.DEF*, YES TSERASE:DBTEST1.TSTEST1,NO IXERASE:IXSCH1.IXNAME1,YES 4 - DB2 Admin Tool now has the ability to overwrite attributes FREEPAGE, PCTFREE, LOCKMAX and ERASE using the IMPORT changes changes function with masking for tablespace and index objects. Example to overwrite FREEPAGE attribute for tablespaces and indexes: FREEPG: ABC*.DEF*, 6 TSFREEPG:DBTEST1.TSTEST1,8 IXFREEPG:IXSCH1.IXNAME1,9 Example to overwrite PCTFREE attribute for tablespaces and indexes: PCTFREE: ABC*.DEF*, 6 TSPCTFREE:DBTEST1.TSTEST1,8 IXPCTFREE:IXSCH1.IXNAME1,9 Example to overwrite LOCKMAX attribute for tablespaces: LOCKMAX:DBTEST1.TSTEST1,20 Example to overwrite ERASE attribute for tablespaces and indexes: ERASE: ABC*.DEF*, YES TSERASE:DBTEST1.TSTEST1,NO IXERASE:IXSCH1.IXNAME1,YES
APAR Information
APAR number
PM95581
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-21
Closed date
2014-11-12
Last modified date
2014-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBASW ADBCCM ADBCCMM ADBCDTS ADBCEST ADBCRCA ADBCRCR ADBCSPG ADBC31 ADBDAT ADBDBSP ADBDK ADBEALT ADBEEXPL ADBEM610 ADBETRAP ADBGAJOB ADBHC2L ADBHUSU ADBHUTC ADBH1KSE ADBLI ADBNSPB ADBPA ADBPA1 ADBPM610 ADBPTHA ADBSUSU3 ADBTEPI ADBTEPR ADBTEPU ADBTEP2 ADBTUNL ADBU00 ADBU02 ADBV99 ADB0 ADB2CCU ADB2CCV ADB2CID ADB2CMF ADB2CMM ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2C11A ADB2C2L ADB2ELI ADB2FMT ADB2JCLI ADB2MASK ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2REG ADB2REH ADB2REM ADB2TBLD ADB2TEP ADB2U ADB2UPA ADB2US ADB2USU ADB2UT ADB2UTC ADB2UTCI ADB2UTCO ADB2UTLX ADB2UTUL ADB2UTU2 ADB2UUOP ADB2WCL ADB2WIN ADB2WVL ADB2000 ADB21K ADB21KSE ADB21KSQ ADB21KS0 ADB21L ADB21M ADB21P ADB21T ADB22SQL ADB25 ADB25L ADB25LE ADB25LU ADB25TL1 ADB25TL2 ADB25TU ADB27AC ADB27C0 ADB27SP ADB28M ADB28MC ADB28MM ADB28UL1 ADB3000 ADB5000 ADB58 H0IHB10J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI22966
UP14/11/18 P F411
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 December 2014