A fix is available
APAR status
Closed as program error.
Error description
This APAR will address three issues: Issue #1: COMMENT ON = Y and WSL = Y are mutually exclusive in MIG path, but not in GEN path. When specifying COMMENT ON = Y and WSL = Y in MIG path, the "Mutually Exclusive" error ADB902E will be displayed on panel ADB28M as below. However, there is no problem in GEN path for the same combination. ADB902E "Generate work stmt list" and GEN option "COMMENT ON" are mutually exclusive. To continue, enter NO for "Generate work stmt list" or enter GEN on the command line to disable the GEN option "COMMENT ON". Issue #2: Use Masking = Y and WSL = Y are mutually exclusive in MIG path, but not in GEN path. When specifying Use Masking = Y and WSL = Y in MIG path, the "Mutually Exclusive" error ADB532F will be displayed on panel ADB28M as below. However there is no problem in GEN path for the same combination. ADB532F Generate Work Statement List and the Masking GEN option are mutually exclusive. Issue #3: The option "Include SQL comments" is available on GEN panel, but not on MIG panel. The option "Include SQL comments" was added into both MIG and GEN in previous APAR PM83934 to include SQL comments that are within a native SQL procedure or a view statement. Currently in Admin v10.2 this option can be seen on MIG panel, but in Admin v11.1, this option can not be seen.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS who use the Migrate (MIG) * * function. * **************************************************************** * PROBLEM DESCRIPTION: There are three problems when using * * the MIG function: * * * * 1- When specifying 'COMMENT * * ON=Y on panel ADBP8MG * * 'Generate SQL from DB2 catalog' * * and 'Generate work stmt list' = * * YES on panel ADB28M 'Migrate * * Parameters', the 'Mutually * * Exclusive' error ADB902E / * * msgadb902e will be displayed on * * panel ADB28M incorrectly: * * * * ADB902E 'Generate work stmt list' * * and GEN option 'COMMENT ON' * * are mutually exclusive. To continue, * * enter NO for 'Generate work stmt * * list' or enter GEN on the command * * line to disable the GEN option * * 'COMMENT ON'. * * * * 2- When specifying 'Use Masking' * * = Y on panel ADBP8MG and * * 'Generate work stmt list' = YES * * on panel ADB28M, the * * 'Mutually Exclusive' error * * ADB532F / msgadb532f * * will be displayed on panel * * ADB28M incorrectly: * * * * ADB532F Generate Work * * Statement List and the Masking * * GEN option are mutually * * exclusive. * * * * 3- The option 'Include SQL * * comments' is not available * * on panel ADBP8MG to include * * SQL comments within a VIEW * * during migration. * **************************************************************** * RECOMMENDATION: * **************************************************************** There are three problems when using the MIG function: 1- When specifying 'COMMENT ON=Y on panel ADBP8MG 'Generate SQL from DB2 catalog' and 'Generate work stmt list' = YES on panel ADB28M 'Migrate Parameters', the 'Mutually Exclusive' error ADB902E / msgadb902e will be displayed on panel ADB28M incorrectly. 2- When specifying 'Use Masking' = Y on panel ADBP8MG and 'Generate work stmt list' = YES on panel ADB28M, the 'Mutually Exclusive' error ADB532F / msgadb532f will be displayed on panel ADB28M incorrectly. 3- The option 'Include SQL comments' is not available on panel ADBP8MG to include SQL comments within a VIEW during migration.
Problem conclusion
These three problems have been resolved: 1- 'COMMENT ON' = Y on panel ADBP8MG and 'Generate work stmt list' = YES on panel ADB28M can be used together and the error message ADB902E is no longer issued. Also, the help panel ADBH8MG ' HELP: Generate SQL from DB2 catalog' has been updated to correct the description for option 'COMMENT ON': Before: The COMMENT ON option controls whether or not SQL comments within a view are generated when the DDL is extracted. This option only applies for migrating VIEW objects. After: The COMMENT ON option generates COMMENT statements on the various objects. 2- 'Use Masking' = Y on panel ADBP8MG and 'Generate work stmt list' = YES on panel ADB28M can be used together and the error message ADB532F is no longer issued. 3- The option 'Include SQL comments' is added to panel ADBP8MG to include SQL comments within a view during migration. Please note the option 'Include SQL comments' can only be used for Batch, not Work Statement List (WSL), otherwise the message ADB902E will be issued, which has been changed by this APAR: Before: ADB902E "Generate work stmt list" and GEN option "COMMENT ON" are mutually exclusive. To continue, enter NO for "Generate work stmt list" or enter GEN on the command line to disable the GEN option "COMMENT ON".' After: ADB902E "Generate work stmt list" and GEN option "Include SQL comments" are mutually exclusive. To continue, enter NO for "Generate work stmt list" or enter GEN on the command line to disable the GEN option "Include SQL comments". Also, the help panel ADBH8MG has been updated to add the description for option "Include SQL comments": Include SQL comments Controls whether or not SQL comments within a view are generated when the DDL is extracted. This option is only for migrating a VIEW. This option is only available when the 'Generate work stmt list is set to NO. Specify: Y Include SQL comments that are within a view statement when the DDL is extracted. N Do not include SQL comments that are within a view statement when the DDL is extracted. This is the default value. Note: When Y is specified the DDL output is designed to be run using SPUFI or DSNTEP4. The DB2 Admin Tool's Batch Restart Program ADBTEP2 can also be used to run the DDL output if the SQLFORMAT = 'SQLCOMNT' option is manually specified in the ADBTEPIN DD. The ADBTEP2R sample job can be used to construct a job to run ADBTEP2.
Temporary fix
Comments
APAR Information
APAR number
PI49289
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-09-24
Closed date
2015-12-20
Last modified date
2016-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI33970 UI33971
Modules/Macros
ADBH8MG ADBH8MV ADBP8MG ADBP8MV ADB28M ADB90
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"11.1.0"}]
Document Information
Modified date:
31 March 2021