PI81548: DB2 ADMIN TOOL - GRANT ON MIXED CASE PACKAGE NAMES FAILS. ROLL-UP OF OTHER FIXES.

Obtain the fix for this APAR.

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 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.