A fix is available
APAR status
Closed as new function.
Error description
FL509 Object level Compression
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for * * z/OS and Object Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements to * * support Db2 12 function level 509. It * * also includes toleration and support * * for Db2 12 function level 510. * * * * Changes are in the following * * areas: * * * * 1. Catalog Navigation * * 2. Create/Alter * * 3. Parser and DDL reader * * 4. GEN * * 5. Compare * * 6. Masking * * 7. WSL cloning * * 8. Change management (CM) Import * * 9. Tools Customizer (TCz) * * * **************************************************************** The following enhancements support Db2 12 function level 509: 1. Catalog Navigation The column that displays the COMPRESS attribute (CO) is moved to the main display screen on the 'Table Spaces' panel (ADB21S). This display is consistent with its display on the 'Table Space Partitions' panel (ADB21SP). The Interpret panels for objects SYSTABLESPACE (ADB21SI1) and SYSTABLEPART (ADB21SPI) are also updated to describe the FIXEDLENGTH and HUFFMAN values of the COMPRESS column. 2. Create/Alter When creating or altering (AL/ALT) a table space, a user can select additional valid COMPRESS values of 'H' (HUFFMAN) and 'F' (FIXEDLENGTH) for partitions. A new COMPRESS field is also added on panels ADB21SAR (Create/Redefine Table Space) and ADB21SA (Alter Table Space) to allow specifying COMPRESS at the table space level. 3. Parser and DDL reader The Admin Tool SQL parser and DDL reader is enhanced to support the FIXEDLENGTH and HUFFMAN values of the table space COMPRESS attribute. 4. GEN GEN is enhanced to support the FIXEDLENGTH and HUFFMAN values of the table space COMPRESS attribute. 5. Compare Object Compare is enhanced to detect differences in the COMPRESS values FIXEDLENGTH and HUFFMAN on both the table space and partition level. 6. Masking The masking function has been enhanced to support the new values FIXEDLENGTH and HUFFMAN for the TSCOMPRES overwrite. 7. WSL cloning The WSL cloning function has been enhanced to support an overwrite of the COMPRESS attribute with the new values FIXEDLENGTH and HUFFMAN. 8. CM Import The CM import function has been enhanced to support an overwrite of the COMPRESS attribute with the new values FIXEDLENGTH and HUFFMAN. This APAR also adds the enhancement to tolerate and support Db2 12 function level 510. Tools Customizer (TCz) now allows V12R1M510 as a valid option for the APPLCOMPAT field.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH36485
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-20
Closed date
2021-05-21
Last modified date
2021-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI75519
Modules/Macros
ADB$$PRM ADB21S ADB21SA ADB21SAR ADB21SI1 ADB21SPI ADB21T ADB27AC ADB28MC ADB2C21 ADB2C2L ADB2CDC ADB2CID ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMM ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2FMT ADB2MASK ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RPT ADB2W1Q ADB2W1QB ADB2WCL ADB2WIN ADB2WVL ADB2Z ADB3000 ADB49 ADB7000 ADBALT ADBASW ADBCCM ADBCCME ADBCCMM ADBCDTS ADBCEST ADBCHST ADBCP ADBCRCR ADBCSPG ADBCVCT ADBCVEY ADBCVIC ADBCVOC ADBDAT ADBDK ADBGDDL ADBH1S ADBH1SA ADBH1SAR ADBH1SP ADBHC2L ADBLI ADBMAIN ADBNSPB ADBPA ADBPA1 ADBPZAPU ADBTEP2 ADBTEPI ADBTEPR ADBTEPU ADBV99 ADBVERS ADBVFC ADBVFCA ADBVFCF ADBVVFG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI75519
UP21/05/25 P F105
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
03 June 2021