A fix is available
APAR status
Closed as new function.
Error description
SUPPORT FOR DB2 V12 FUNCTION LEVELS 502 (key labels) and 503 (Db2ZAI).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool for * * z/OS and Object Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements to * * support Db2 function levels 502 * * (key labels) and 503 (Db2ZAI). * * * * Changes are in the following * * areas: * * * * 1. Catalog navigation * * 2. Create and alter (AL/ALT) * * 3. GEN * * 4. DDL reader/merge * * 5. Compare * * 6. Masking * * 7. WSL cloning * * 8. Change Management (CM) import * * 9. Formatter * * 10. System administration (FL 503) * **************************************************************** The following enhancements support Db2 function levels 502 and 503: 1. Catalog navigation The KEYLABEL column is displayed on catalog panels and interpretation panels for table, table space, stogroup and index. Panel ADB21G 'Storage Groups' is scrollable so it can display all catalog column values. 2. Create and Alter (AL/ALT) A key label value can be specified during the following operations: - CREATE stogroup (on panel ADB26CG 'Create Storage Group') - ALTER stogroup (on panel ADB21GA 'Alter Storage Group') - CREATE table (on panel ADB26TOP 'Create Table Options') - ALTER table (AL) (on panel ADB21TA 'Alter Table') - ALTER table (ALT) (on panel ADBP7TOP 'Alter - Table Options'). 3. GEN When you generate SQL to re-create a table or storage group, Db2 Admin Tool can generate CREATE or ALTER statements that include the pending changes to the KEY LABEL clause. 4. DDL reader/merge DDL reader and merge can parse and process (tokenize) the KEY LABEL clause in CREATE and ALTER statements. 5. Compare Compare supports key label changes for storage groups and tables: - A key label change for a storage group is applied to the Db2 catalog only. The encryption status of the physical data set for a storage group is not changed until REORG is manually run on the table space. - A key label change for a table is applied to the Db2 catalog. The encryption status of the physical data set for the table is updated when the 'Run REORG/REBUILD' field is set to 'A' (All relevant) on the GOC5 panel. 6. Masking New masking overwrites SGKEYLABL and TBKEYLABL are provided to overwrite the key labels for storage groups and tables. 7. WSL cloning WSL cloning supports the new masking overwrites for key labels. 8. Change Management (CM) import CM import supports the new masking overwrites for key labels. 9. Formatter Db2 Admin Tool can format the KEY LABEL clause of CREATE and ALTER TABLE statements during WSL cloning and change management (CM) import with masking. 10. System administration (FL 503) A new option '2M - Display/manage machine learning' is added on panel ADB2Z 'System Administration." This option allows you to issue the Db2 commands DISPLAY ML, START ML, and STOP ML.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH22698
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
2020-02-27
Closed date
2020-05-26
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69677
Modules/Macros
ADB0 ADB21G ADB21GA ADB21GI1 ADB21S ADB21SI1 ADB21T ADB21TA ADB21TI1 ADB21X ADB21XI1 ADB26CG ADB26CTF ADB26TOP ADB27AC ADB27C ADB27C0 ADB27CA ADB27CAA ADB27CMR ADB27CX ADB27DUP ADB28MC ADB28MM ADB2C21 ADB2C2L ADB2CDC ADB2CID ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMM ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2FMT ADB2IGN ADB2MASK ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2RE ADB2REC ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RPT ADB2WCL ADB2WIN ADB2WVL ADB2Z ADB2Z2M ADB2ZP ADB2ZPV ADB2ZZ ADB2ZZMN ADB2ZZUT ADB2ZZV9 ADB2ZZVA ADB2ZZVB ADB2ZZVC ADB7000 ADBASW ADBCCM ADBCCMM ADBCDTS ADBCEST ADBCEXP ADBCHST ADBCP ADBCRCM ADBCRCR ADBCRSP ADBCSPG ADBCVCT ADBCVEY ADBCVOC ADBDAT ADBDK ADBDT ADBH017 ADBH018 ADBH1G ADBH1TA ADBH6TOP ADBH7TOP ADBHC2L ADBHZ2M ADBLI ADBMAIN ADBNSPB ADBP7TOP ADBPA ADBPA1 ADBPX 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 UI69677
UP20/05/28 P F005
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021