A fix is available
APAR status
Closed as new function.
Error description
Db2 v12 FL 508
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements to * * support Db2 12 function level 508. * * * * Changes are in the following * * areas: * * * * 1. ALTER (Move Table) * * 2. GEN * **************************************************************** The following enhancements support Db2 12 function level 508: 1. ALTER (Move Table): The new primary and line command MOVETB is available on panels ADB21D 'Databases' and ADB21S 'Table spaces'. MOVETB allows moving tables from multi-table table spaces to partition-by-growth (PBG) table spaces. This operation is implemented by using the following Db2 statement: ALTER TABLESPACE <multi-tb TS> MOVE TABLE <table> TO TABLESPACE <PBG TS> The new panel ADB2MVT1 'Move Table Options' allows specifying the following table space options: Buffer pool, Storage group, Lock size, Tables per REORG, REBINDs for affected packages The subsequent new panel ADB2MVT2 'Move Tables to PBGs' displays attributes of the new tables. This panel allows navigating to related objects, checking for the existence of selected new table spaces, and checking for pending changes on selected multi-table table spaces. From this panel, the batch job is generated with the selected user options to execute the MOVE TABLE operation. 2. GEN: When Db2 MOVE TABLE pending changes exist, the GEN command generates the ALTER statements for the pending changes based on the option of 'Include DB2 pending chgs' on the ADB2GEN panel. If the option is set to YES or ALTER, the same set of statements are generated. The ALTER statements for MOVE TABLE pending changes are listed at the end. An additional change is delivered to remove trailing spaces in the value of the SET CURRENT APPLICATION COMPATIBILITY statement when issuing GEN on a deprecated table space. An additional change is delivered to remove trailing spaces in the value of the SET CURRENT APPLICATION COMPATIBILITY statement when issuing GEN on a deprecated table space.
Problem conclusion
Temporary fix
Comments
×**** PE21/04/30 PTF IN ERROR. SEE APAR PH34739 FOR DESCRIPTION
APAR Information
APAR number
PH31554
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-11-11
Closed date
2021-01-15
Last modified date
2021-04-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73496
Modules/Macros
ADB21D ADB21S ADB27AC ADB28MC ADB2CID ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2FMT ADB2MSK ADB2MSQ ADB2MVT1 ADB2MVT2 ADB2MVT3 ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PSQL ADB2REG ADB2REH ADB2REM ADB2UOPS ADB2WCL ADB2WIN ADB2WVL ADBASW ADBCCM ADBCCMM ADBCDTS ADBCEST ADBCHST ADBCRCR ADBCSPG ADBDAT ADBDK ADBEMVT2 ADBEMVT3 ADBEMVTC ADBH1D ADBH1S ADBHMVT1 ADBHMVT2 ADBHMVT3 ADBLI ADBM30 ADBMAIN ADBNSPB ADBPA ADBPA1 ADBSMVT3 ADBSMVTO ADBTEP2 ADBTEPI ADBTEPR ADBTEPU ADBV99 ADBVERS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI73496
UP21/01/20 P F101
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:
01 May 2021