A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' install job template ADBSETUP shows a SQLCODEN646 / SQLCODE -646 as a result of the value of field 'SET CURRENT SCHEMA' on panel CCQPPRD 'Product Parameters' was not what the customer intended.
Local fix
Change the value for the field 'SET CURRENT SCHEMA' on panel CCQPPRD 'Product Parameters'.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS and IBM Tools Customizer for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following are fixed: * * * * 1. The DB2 Administration Tool for * * z/OS installation template job * * ADBSETUP shows a SQLCODE=-646/ * * SQLCODEN646 or SQLCODE=-204/ * * SQLCODEN204 for some objects. * * * * 2. When submitting job template * * ADBCFGPM 'Deploy settings for * * OCM integration' a SQLCODE=-204/ * * SQLCODEN204 is observed. * * * * 3. The DISCOVER process does not * * restore the Product Parameters and * * DB2 Parameters back to its original * * settings. * * * * 4. The DISCOVER process generates * * the following warning message * * CCQO057W. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following are fixed: 1. The DB2 Administration Tool for z/OS' installation template job ADBSETUP shows a SQLCODE=-646/ SQLCODEN646 or SQLCODE= -204/SQLCODEN204 for some objects because the value of the field 'SET CURRENT SCHEMA' on panel CCQPPRD 'Product Parameters' and/or panel CCQPDB2 'DB2 Parameters' is not what the customer intended or was left blank: DSNT408I SQLCODE = -646, ERROR: TABLE >tb-name< CANNOT BE CREATED IN SPECIFIED TABLE SPACE >ts-name< BECAUSE IT ALREADY CONTAINS A TABLE DSNT408I SQLCODE = -204, ERROR: >tb-schema<.>tb-name< IS AN UNDEFINED NAME 2. When submitting job template ADBCFGPM 'Deploy settings for OCM integration' a SQLCODE=-204/ SQLCODEN204 is observed because for an INSERT statement when specifying different values in the field 'Owner name' and 'SET CURRENT SCHEMA' when creating change management database objects because the SET CURRENT SCHEMA statement does not set the correct schema: DSNT408I SQLCODE = -204, ERROR: >tb-schema<.>tb-name< IS AN UNDEFINED NAME 3. The DISCOVER process does not restore the Product Parameters and DB2 Parameters back to its original settings when performing the following operations: a. Invoke the DISCOVER option to initialize parameter settings. b. Navigate to panel CCQPPRD 'Product Parameters' and specify values for the following parameters other than the default 'ADB': *Change Management database: Owner name . . . . . . . . . . . . . . . _____ SET CURRENT SCHEMA . . . . _____ *Checkpoint database: Owner name . . . . . . . . . . . . . . . _____ SET CURRENT SCHEMA . . . . . _____ *Catalog Copy database: Owner name . . . . . . .. . . . . . . . . _____ SET CURRENT SCHEMA . . . . . _____ *Profiles History database: Owner name . . . . . . . . . . . . . . . . _____ SET CURRENT SCHEMA . . . . . _____ *Reverse Engineering objects: Owner name . . . . . . . . . . . . . . . . _____ SET CURRENT SCHEMA . . . . . _____ *Stored Procedure ADB2RCP: Owner name . . . . . . . . . . . . . . . . _____ SET CURRENT SCHEMA . . . . . _____ c. Navigate to panel CCQPDB2 'DB2 Parameters' and specify override values. d. Navigate back to the DISCOVER option to initialize the parameter settings back to its original settings. e. Navigate back to panel CCQPPRD 'Product Parameters' and panel CCQPDB2 'DB2 Parameters' and note that the original settings have not been restored. 4. The DISCOVER process generates he following warning message CCQO057W if one of the values in the field STCNAME from table ADBTPARM is not blank. The field STCNAME indicates a Started task name for the DB2 MSTR services: CCQO057W The Discover EXEC could not find the CCQ_ADB_DB2_STRTTSK_MSTR parameter in the product metadata for the product to be customized. The record was not processed.
Problem conclusion
Problems have been resolved. 1. The SQLCODE=-646 / SQLCODEN646 will be tolerated in the ADBSETUP job template during the installation process of the DB2 Administration Tool and the following informational message ADB5179I / msgadb51791i will be displayed instead: ADB5179I An expected sqlcode -646 was encountered and can be ignored. No action needed. 2. Two new fields were added, 'Default owner of Admin objects' and 'Default schema of Admin objects' on panel CCQPPRD 'Product Parameters' to allow the user to specify a default owner and schema that are used by the SET CURRENT SQLID and SET CURRENT SCHEMA statements respectively for each category in the DB2 Admin setup task. Note these two fields must contain a value. 3. The field 'Owner name' both on panel CCQPPRD 'Product Parameters' and panel CCQPDB2 'DB2 Parameters' for each category in the DB2 Admin setup task is changed to 'Owner'. 4. The field 'SET CURRENT SCHEMA' both on panel CCQPPRD 'Product Parameters' and panel CCQPDB2 'DB2 Parameters' for category in the DB2 Admin setup task is changed to 'Schema'. 5. When the input field 'Owner' is blank both on panel CCQPPRD 'Product Parameters' and panel CCQPDB2 'DB2 Parameters' for each category in the DB2 Admin setup task, the value specified in the field 'Default owner of Admin objects' on panel CCQPPRD 'Product Parameters' will be used as the default value for owner used by the SET CURRENT SQLID statement in the ADBSETUP job template. 6. When the input field 'Schema' is blank both on panel CCQPPRD 'Product Parameters' and panel CCQPDB2 'DB2 Parameters' for each category in the DB2 Admin setup task, the value specified in the field 'Default schema of Admin objects' on panel CCQPPRD 'Product Parameters' will be used as the default value for the schema used by the SET CURRENT SCHEMA statement in ADBSETUP job template. 7. The following comments have been added into the job template ADBSETUP to provide the guidance for checking the SQLCODE=-204 / SQLCODEN204: IF AN SQLCODE = -204 IS ENCOUNTERED, PLEASE CHECK TO ENSURE ALL OCCURRENCES OF INPUT FIELD "SCHEMA" AND THE INPUT FIELD "DEFAULT SCHEMA OF ADMIN OBJECTS" ON TCZ PANEL CCQPPRD "PRODUCT PARAMETERS" AND CCQPDB2 "DB2 PARAMETERS" ARE PROPERLY SET TO THE CORRECT SITE-SPECIFIC VALUES. NOTE IF ONE INPUT FIELD "SCHEMA" IS BLANK, THE VALUE SPECIFIED IN THE FIELD "DEFAULT SCHEMA OF ADMIN OBJECTS" WILL BE USED AS THE DEFAULT VALUE BY SET CURRENT SCHEMA STATEMENT TO ESTABLISH AN IMPLICIT QUALIFIER FOR CREATING THE REQUIRED OBJECTS. 8. The SET CURRENT SCHEMA statement is generated with the correct schema name in the template job ADBCFGPM to resolve the SQLCODE=-204 / SQLCODEN204 issue when specifying different values in the field 'Owner' and 'Schema'when creating change management database objects. 9. The DISCOVER process is corrected to properly migrate Product Parameters and DB2 Parameters. 10. The DISCOVER process is corrected to resolve warning message CCQO057W.
Temporary fix
Comments
×**** PE16/06/24 PTF IN ERROR. SEE APAR PI51516 FOR DESCRIPTION ×**** PE16/06/24 PTF IN ERROR. SEE APAR PI51516 FOR DESCRIPTION ×**** PE16/06/24 PTF IN ERROR. SEE APAR PI51516 FOR DESCRIPTION ×**** PE16/06/24 PTF IN ERROR. SEE APAR PI51516 FOR DESCRIPTION ×**** PE16/06/14 FIX IN ERROR. SEE APAR PI64197 FOR DESCRIPTION
APAR Information
APAR number
PI51516
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-10-29
Closed date
2016-04-04
Last modified date
2016-09-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI36743 UI36744
Modules/Macros
ADB$$PRM ADBCFGPM ADBCUST ADBR ADBSETUP ADBUPGRD ADB2CUST
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 September 2016