A fix is available
APAR status
Closed as new function.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS 10.2 NEW FUNCTION.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * and IBM Tools Customizer (TCz) for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following enhancements are * * delivered: * * * * (1) When the ALTSHV or GOCSHVRS data * * set contents are modified to add, * * change or alter the release flag * * contents (i.e. adb111nf, adb111cm, * * adb101nf, adb101cm, adb091nf, * * adb091cm, adb081nf and adb081cm), * * the DB2 Administration Tool for z/OS * * does not automatically set missing * * flags. For example, if the user * * specifies only adb111nf of 'Y', * * the subordinate flags (i.e. all the * * other release flags) should be 'Y' * * as well. This change will now * * automatically set these subordinate * * release flags when they are not also * * provided. This will make it easier * * for users who want to manually * * modify and provide these switch * * settings. The flags are case * * sensitive. * * * * (2) ADBTEP2 will only run if the DB2 * * release fits into minimum and maximum * * boundaries. This change allows * * ADBTEP2 to run in DB2 environments * * between DB2 9 New Function Mode / NFM * * and DB2 11 Compatibility Mode / * * CM inclusive. * * * * (3) When a CM (Change Management) * * change that is created in earlier * * or later version of the product is * * analyzed, there may be mismatches * * in version record structures * * between the base and delta * * versions. Such changes are now * * allowed to be restarted so that * * the delta version can be * * reconstructed to match the current * * version of the product. * * * * (4) Adds the ability to use TCz to * * create and customize CM Batch JCL * * procedures, and an installation * * verification job to verify basic CM * * Batch customization was done * * correctly. The JCL PROCLIB * * parameter is a dataset that will be * * used to store DB2 Admin JCL * * procedures. This dataset will be * * created if it does not already exist. * * As a result, the following options * * have been added to the TCz CCQPPRD * * 'Product parameters' panel: * * * * (a) Generate customization: * * * * - JCL procedure library (PROCLIB) * * * * (b) Change management: * * - Use one CM Batch JCL procedure * * to support multiple SSIDs * * - CM Batch JCL procedure name * * - CM Batch local installation * * parameters * * * * (c) Installation verification * * jobs: * * * * - Generate a CM Batch verification * * job * * * * (5) On the CCQPLPR 'LPAR Parameters' * * panel, the following option has been * * added when Change management (CM) is * * selected on the TCz CCQPPRD 'Product * * 'Parameters' panel: * * * * (a) DB2 Object Comparison Tool * * customization HLQ * * * * (6) On the CCQPDB2 'DB2 * * Parameters' panel, the following * * option has been added: * * * * (a) Use one CM Batch JCL * * procedure to support multiple * * SSIDs * * * * The following has been fixed: * * * * (1) The DSSIZE value of DB2 9 * * tablespace is overwritten by * * the default DSSIZE. * * * * (2) When specifying option 'Generate * * base version before run . . AUTO' on * * panel ADB2CEX1 'CM - Run a change', * * and running the change, DB2 Object * * Comparison Tool for z/OS will fail at * * step GNSQL8 with the following error * * message MSGADB1031E / ADB1031E: * * * * ADB1031E DDL cannot be * * generated for DB2 release 910. * * Supported releases are 915 * * through 1110. * * * * (3) The COPY utility statement * * failed with "INVALID OPERAND * * '99999' FOR KEYWORD 'PARALLEL'", * * while on panel ADB2USC 'Specify * * Utility Options - COPY DATA FULL', * * when specifying '99999' for the * * PARALLEL option: * * * * For example: * * * * COPY TABLESPACE * * >dbname.tsname< * * DSNUM ALL * * FULL YES * * PARALLEL 99999 * * * * (4) The ALT line command * * produced a job that ended * * with return code 4 / RC4 and * * included message * * MSGDSNU047I / DSNU0471: * * * * DSNU047I >timestamp< * * DSNUBCKB * * - A REQUIRED DD CARD OR * * TEMPLATE IS MISSING. NAME= * * * * (5) When changing the buffer pool * * of a Partition-By-Growth (PBG) * * tablespace, then altering the table * * by changing the 'HASH SPACE' option * * on panel ADBP7HA 'Alter Table - Hash * * organization', the APPLY job fails * * with SQLCODE = -20385 / SQLCODEN20385: * * * * DSNT408I SQLCODE = -20385, * * ERROR: THE STATEMENT * * CANNOT BE PROCESSED * * BECAUSE THERE ARE PENDING * * DEFINITION CHANGES FOR * * OBJECT >dbname<.>tsname< * * OF TYPE TABLESPACE * * (REASON 2) * * DSNT418I SQLSTATE = 57007 * * SQLSTATE RETURN CODE. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following enhancements are delivered: (1) Logic has been added to determine the 'highest' DB2 release switch set and to set all subordinate switches that have not been provided. Since the user can enter these flags, adb111nf, adb111cm, adb101nf, adb101cm, adb091nf, adb091cm, adb081nf and manuallymanually, DB2 Admin Tool will now edit the flag values. All provided flags must be 'Y' or 'N'. If not provided, a flag will resolve as '' (nothing). The following error will be produced if any of these edits fails: Invalid value provided to >flag< = >value< If the user specifies 'N' for adb101nf, 'Y' for adb101cm, and does not specify a value for adb091nf, DB2 Admin Tool will produce the following error: 'adb091nf must be provided as Y or N when adb101nf is not provided and adb101cm is Y' This can be resolved by specifying 'Y' or 'N' for adb091nf. Since these flags can be entered by the user, DB2 Admin Tool will also allow the long values of YES and NO. This will not fail any edits. The flags are case sensitive. (2) ADBTEP2 will only run if the DB2 release fits into minimum and maximum boundaries. This change allows ADBTEP2 to run in DB2 environments between DB2 9 NFM and DB2 11 CM inclusive. (3) The line command 'RST - Restart a change in INITIAL, DEFINED or ANALYZED status' on panel ADB2C11 'CM - Changes' currently allows a change to be restarted when the status of the change is 'INITIAL'. With this enhancement, line command 'RST - Restart a change in INITIAL, DEFINED or ANALYZED status' can also be used to restart a change that is in Defined or Analyzed state. (4) The code for the DB2 Admin driver (ADBMAIN), Generate (GEN), Revoke Impact, 'Alter Table ALT' ALT function, and ZPARM has been modified so it allows a user to run on a DB2 11 system in Conversion Mode. (5) On the TCz CCQPPRD 'Product Parameters' panel, the following options have been added: (a) Generate customization: - JCL procedure library (PROCLIB) (b) Change management: - Use one CM Batch JCL procedure to support multiple SSIDs - CM Batch JCL procedure name - CM Batch local installation parameters (c) Installation verification jobs: - Generate a CM Batch verification job (6) On the TCz CCQPLPR 'LPAR Parameters' panel, the following option has been added when Change Management (CM) is selected on the TCz CCQPPRD 'Product Parameters' panel: (a) DB2 Object Comparison Tool customization HLQ (7) On the TCz CCQPDB2 'DB2 Parameters' panel, the following option has been added: (a) Use one CM Batch JCL procedure to support multiple SSIDs The following has been fixed: (1) The default DSSIZE 4G is used for DB2 9 tablespaces when a value other than the default is specified. (2) When specifying option 'Generate base version before run . . AUTO' on panel ADB2CEX1 'CM - Run a change', and running the change, DB2 Object Compare will fail at step GNSQL8 with the error message MSGADB1031E / ADB1031E: ADB1031E DDL cannot be generated for DB2 release 910. Supported releases are 915 through 1110. (3) The COPY utility statement failed with "INVALID OPERAND '99999' FOR KEYWORD 'PARALLEL'", while on panel ADB2USC 'Specify Utility Options - COPY DATA FULL', when specifying '99999' for the PARALLEL option. (4) When using the ALT line command for a LOB tablespace, and a REORG is required, the COPYDDN keyword will be provided starting with DB2 11 CM. (5) When changing the buffer pool of a Partition-By-Growth (PBG) tablespace, then altering the table by changing the 'HASH SPACE' option on panel ADBP7HA 'Alter Table Hash organization', the APPLY job fails with SQLCODE = -20385 / SQLCODEN20385: DSNT408I SQLCODE = -20385, ERROR: THE STATEMENT CANNOT BE PROCESSED BECAUSE THERE ARE PENDING DEFINITION CHANGES FOR OBJECT >dbname<.>tsname< OF TYPE TABLESPACE (REASON 2) DSNT418I SQLSTATE = 57007 SQLSTATE RETURN CODE.
Problem conclusion
Temporary fix
Comments
Problems have been resolved. Enhancements are delivered. ×**** PE13/05/08 FIX IN ERROR. SEE APAR PM88642 FOR DESCRIPTION
APAR Information
APAR number
PM81163
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-01-22
Closed date
2013-03-05
Last modified date
2013-06-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK92243
Modules/Macros
ADB$$PRM ADB$$SEQ ADBCCM ADBCCMM ADBCDTS ADBCMBAT ADBCMBIV ADBCMBSS ADBCRCM ADBCUST ADBCVC ADBCVCP ADBCVEY ADBCVOC ADBC02 ADBC06 ADBDK ADBDT ADBGAJOB ADBHUSV ADBH060E ADBMAIN ADBRIP9 ADBTEPA ADBTEPR ADBTEP2 ADBTREO ADBVERS ADB0001 ADB1000 ADB2CCR ADB2CCR0 ADB2CMF ADB2CMP ADB2CMR ADB2C11 ADB2E ADB2EC ADB2EU ADB2EUC ADB2EUF ADB2EUS ADB2RE ADB2REE ADB2REG ADB2REM ADB2REZ ADB2USC ADB2USV ADB2ZZ ADB2ZZAL ADB2ZZAP ADB2ZZDS ADB2ZZLG ADB2ZZLK ADB2ZZMN ADB2ZZOD ADB2ZZOT ADB2ZZPR ADB2ZZRS ADB2ZZSP ADB2ZZST ADB2ZZTL ADB2ZZTR ADB2ZZT2 ADB2ZZUT ADB2ZZVA ADB2ZZVB ADB2ZZV9 ADB2Z2Z ADB21TAU ADB41 ADB9000 H0IHA20J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA20 PSY UK92243
UP13/03/07 P F303
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":"10.2.0"}]
Document Information
Modified date:
31 March 2021