PI62908: SUPPORT LONG AND MIXED CASE PACKAGE NAMES.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SUPPORT LONG AND MIXED CASE PACKAGE NAMES.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 11 who use mixed            *
  *                 case package names on a BIND                 *
  *                 statement.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Packages created with mixed case        *
  *                      names are not supported on              *
  *                      various DB2 Admin Tool panels.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a B, BC, F, or RB line command is issued on panel ADB21K
  'Packages' for a collection with a mixed case name, the panel
  that processes the line command will incorrectly display the
  collection name in uppercase, and when the 'Enter' key is
  pressed, the user will receive message DSNT238I, for example:
  
  DSNT238I  #DSNB- REBIND ERROR
              USING IBMUSER AUTHORITY
              PACKAGE =
  SSID.TESTONEA1AAAAAAAAA2BBBBBBBBB3CCCC
  FFFF7GGGGGGGGG8.ADBTEP2.(V11.2.0.00000)
              DOES NOT EXIST
  

Problem conclusion

Temporary fix

Comments

• This apar has the following changes:
  
  - DB2 Admin supports a 'CAPS ON' or 'CAPS OFF' primary command
    on panels listed below.  When CAPS OFF is in effect, it
    allows text to remain in mixed text after the 'Enter' key is
    pressed.
  
  - The filter line allows the list of objects to be reduced
    to only show the objects matching the filter.
  
    The following panels support the use of mixed case names in
    the 'Collection' field of the filter line, when CAPS OFF
    is in effect:
  
    * ADB21K, 'Packages'
    * ADB21L, 'Collections'
    * ADB2AK, 'Package Authorization'
    * ADB2AL, 'Collection Authorizations'
  
  - DB2 Admin supports a 'CAPS ON' or 'CAPS OFF' command in the
    following panels:
  
    * ADB21KB, 'Bind Package'
    * ADB21KF, 'Free Package'
    * ADB21KR, 'Rebind Package'
    * ADB2Gk, 'Grant Package Privileges'
    * ADB2GL, 'Grant Collection Privileges'
    * ADB2RL, 'Revoke Collection Privileges'
    * ADB2RK, 'Revoke Package Privileges'
  
    In these panels, the default is CAPS ON if the collection
    name consists of all capital letters and the default is
    CAPS OFF if the collection name contains any lower case
    characters.
  
  - Packages for Functions, Procedures, and Triggers are not
    supported.
  
  - There are three new messages:
  
    Number . . . : ADB820I
    Text . . . . : An object name contains mixed case characters.
    Explanation  : The collection id for this object is in mixed
                   case.  The input field for collection id is
                   changed to avoid capitalization.  Any changes
                   made to the collection id have to be made in
                   the desired case.
    System Action: The system continues.
    User Response: This message is for user awareness.  No
                   response is necessary.
  
    Number . . . : ADB821I
    Text . . . . : Some data fields are changed to CAPS OFF.
                   Some data fields are changed to CAPS ON.
    Explanation  : This message is in response to the user issuing
                   a CAPS command.
  
                   CAPS ON translates certain fields to upper case
                   case.  The user cannot save values in
                   mixed case.
                   CAPS OFF allows certain fields to allow mixed
                   case values. The user must type in the case
                   that is desired.
    System Action: The system continues.
    User Response: This message is for user awareness.
                   For CAPS ON, the user cannot save values in
                   mixed case.  For CAPS OFF, the user must
                   type in the case that is desired.
  
    Number . . . : ADB822W CAPS not allowed
    Text . . . . : The CAPS command is not allowed on this panel.
    Explanation  : This message is shown for panels that do not
                   have fields that support mixed case values.
    System Action: The system continues.
    User Response: This message is for user awareness.  No
                   response is necessary.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI39313 UI39314

Modules/Macros

•    ADBHAK   ADBHAL   ADBHP2   ADBH016  ADBH017
  ADBH1K   ADBH1L   ADBMAIN  ADBTEPR  ADB2AK   ADB2AL   ADB2GK
  ADB2GL   ADB2RK   ADB2RL   ADB21K   ADB21KB  ADB21KF  ADB21KR
  ADB21KRN ADB21L   ADB82
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI39313

     UP16/07/15 P F607

• RB20 PSY UI39314

     UP16/07/16 P F607

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.