IBM Support

PH37874: SEARCH FOR LOWER CASE USERNAME PASSWORD PANEL ADB2Z55 RESULTS INMESSAGE 'NO ROWS MATCH'

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Even though a username is entered in lower case on panel ADB2Z55
    (('DISPLAY/UPDATE USERNAMES'), a search for that username,
    either by typing the username under the 'Auth ID' column of the
    panel, or by using the SARG primary command, translates the
    search argument to upper case.  As a result, the search ends
    with the message 'No rows match.'  The same result occurs when
    searching for a lower case password.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: On panel ADB2Z55, searching for         *
    *                      lowercase characters does not work,     *
    *                      even though two of the columns can      *
    *                      contain lowercase letters.              *
    ****************************************************************
    On the "Display/Update USERNAMES" panel (ADB2Z55),  an attempt
    to search for lowercase letters in columns AUTHID and PASSWORD
    fails to find the qualifying rows.  Searching for uppercase
    letters works correctly.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH37874

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-04

  • Closed date

    2021-08-26

  • Last modified date

    2021-09-01

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

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

    UI76934

Modules/Macros

  • ADB2Z55
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI76934

       UP21/08/28 P F108

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":"12.1.0"}]

Document Information

Modified date:
02 September 2021