IBM Support

IT02243: DB2CKUPGRADE FAILS WITH PASSWORD NOT RECOGNIZED DUE TO '&' (AMPERSAND) SPECIAL CHARACTER CONTAINED IN THE PASSWORD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Tivoli Storage Manager server V7 installation can fail at step
    db2ckupgrade if the db2 instance user id uses a password with
    '&' (ampersand) special character in it
    
    ERROR: Error during "pre-install configure" phase:
    
      ERROR: Error
        ANRI1061E: The       failed for database TSMDB1 in instance
    SERVER1.
    
        Explanation:
    
    STDOUT
    ====================
    SQL1403N  The username and/or password supplied is incorrect.
    
    STDERR
    ====================
    'XXXXXXXXXX' is not recognized as an internal or external
    command,
    operable program or batch file.
    
    
    The issue is in the way the db2ckupgrade command is run to check
    for upgrade prerequisites.
    
    db2ckupgrade TSMDB1 ?u tsminst1 ?p &XXXXXXXXXX
    
    Where XXXXXXXXXX is part of the password without '&' resulting
    in operating system trying to execute the part of the password
    after '&' since ampersand special character is used to separate
    multiple commands on one command line.
    
    The db2ckupgrade is not  enclosing provided password in
    parenthesis to escape special characters properly.
    
    TSM Versions Affected:
    Tivoli Storage Manager server 7.1 on all platforms
    
    Initial Impact:
    Low
    
    Additional Keywords:
    TSM zz71 db2ckupgrade SQL1403N not recognized internal external
    command operable program batch file
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users upgrading to V7.1.   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in level 7.1.1. Note that this is      *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02243

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-06

  • Closed date

    2014-08-11

  • Last modified date

    2014-08-11

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

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

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"71W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
11 August 2014