A fix is available
APAR status
Closed as program error.
Error description
ROLL-UP OF FOWARD FIT AND FIXES: APAR PI81548 FORWARD FIT PI81347(12.1 ONLY) FORWARD FIT PI82533 (11.1 AND 12.1 ONLY)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: 1 - A package name with mixed case * * characters needs to be enclosed * * in double quotes when referenced * * by an SQL statement. * * * * 2 - When certain primary commands are * * issued on panel ADBPZAT 'Display * * Accelerated Tables' involving a large * * number of tables, or when a batch job * * issues ACCELERATOR statements * * involving a large number of * * tables, an ONCODE=150 STRINGSIZE * * condition is encountered. * * * * 3 - The NUMPARTS keyword is * * generated instead of * * MAXPARTITIONS because * * SYSTABLESPACE.TYPE * * is specified in the ignore file. * * * * 4 - Analyzing a change ends with * * a ADBC002E / msgadbc002e * * error when the change contains * * an ADMIN ALTER INDEX * * statement with a quoted column * * name. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- On panel ADB21K 'Packages', when issuing line command 'GR' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB2GK 'Grant Package Privileges' with the package name in uppercase. Subsequently, the GRANT statement fails with a SQLCODE=-204 / SQLCODEN204 error: DSNT408I SQLCODE = -204, ERROR: MYCOLLID.MYPACKAGE IS AN UNDEFINED NAME a. On panel ADB2GK 'Grant Package Privileges', if you at first set the 'TO' field to your own USERID and press <Enter>, you receive error message ADB747E/msgadb747e: ADB747E an AUTH ID cannot grant a privilege to itself. But even after you change the 'TO' field to another USERID, the message is is still displayed. b. On panel ADB2AK 'Package Authorizations', when issuing line command 'R' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB2RK 'Grant Package Privileges' with the package name in uppercase. Subsequently, the REVOKE statement fails with a SQLCODE=-556 / SQLCODEN556 error: DSNT408I SQLCODE = -556, ERROR: USER1 CANNOT HAVE THE COPY PRIVILEGE ON MYCOLLID.MYPACKAGE REVOKED BY USER2 BECAUSE THE REVOKEE DOES NOT POSSESS THE PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT c. On panel ADB21K, when issuing line command 'RB' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB21KRN 'Grant Package Privileges' with the package name in uppercase. Subsequently, the REBIND statement fails with the following informational message: DSNT238I !SYS1 REBIND ERROR USING USERID1 AUTHORITY PACKAGE = MYCOLLID.MYPACKAGE.(V1) DOES NOT EXIST d. On panel ADB21K when issuing line command 'B' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB21KB 'Bind SQL Procedure Package' with the Deploy package name in uppercase. Subsequently, the BIND statement fails with the following informational message: DSNT238I !SYS1 BIND DEPLOY ERROR USING USERID1 AUTHORITY PACKAGE = MYCOLLID.MYPACKAGE.(V1) DOES NOT EXIST e. On panel ADB21K, when issuing line command 'BC' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB21KB 'Bind Copy Package' with the Copy package name in uppercase. Subsequently, the BIND statement fails with the following informational message: DSNT238I !SYS1 BIND COPY ERROR USING USERID1 AUTHORITY PACKAGE = MYCOLLID.MYPACKAGE.(V1) DOES NOT EXIST f. On panel ADB21K, when issuing line command 'F' on a row with a mixed case value in the 'Name' column and uppercase in the 'Collection' column, DB2 Admin Tool proceeds to panel ADB21KF 'Free Package' with the package name in uppercase. Subsequently, the FREE statement fails with the following informational message: DSNT238I !SYS1 FREE ERROR USING USERID1 AUTHORITY PACKAGE = MYCOLLID.MYPACKAGE.(V1) DOES NOT EXIST 2- When primary commands of LOAD or DET are issued for a large number (e.g., 1000) of tables on panel ADBPZAT 'Display Accelerated Tables', or wild cards are used in ADMIN ACCELERATOR batch statements that involve a large number of tables, an ONCODE=150 / ONCODE150 error is encountered: IBM0441W ONCODE=150 The STRINGSIZE condition was raised. From entry point _Concnvs at compile unit offset >offset< at entry offset >offset< at address >address< The current implementation supports a maximum string size of 32KB for internal processing of accelerator stored procedure parameters, and, whenever this limit is reached, the error above is encountered. This APAR adds an enhancement to support CLOB sizes of 2MB for LOAD tables operation in both online and batch modes and 256KB for DET (get tables details) operation. 3- When there are changes in the table that cause the Partition-By-Group (PBG) table space to be dropped and recreated, upon CREATE, the table space is being built with the NUMPARTS keyword instead of MAXPARTITIONS. 4- When a change contains an ADMIN ALTER INDEX statement with a quoted column name, upon performing an ALTER INDEX with column attribute operation, Merge fails to find the matching column name due to the quotes around the column name, and fails with the following error: ADBC002E severe error in merge, No object row found to match delta row - rowtype=KY
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI81548
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
2017-05-15
Closed date
2017-06-30
Last modified date
2017-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48497 UI48498 UI48499
Modules/Macros
ADBASP ADBASPR ADBCCMM ADBCDTS ADBD ADBDAT ADBGAJOB ADBTEP2 ADBXAT ADBXGTI ADB0 ADB2CME ADB2CMF ADB2CMO ADB2CMR ADB2CMS ADB2GK ADB2RK ADB2WVL ADB21KB ADB21KF ADB21KRN ADB27AC ADB8000
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI48497
UP17/07/07 P F707
RB20 PSY UI48498
UP17/07/07 P F707
RC10 PSY UI48499
UP17/07/07 P F707
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:
02 August 2017