IBM Support

IZ43731: $ IN DB2 USER PW / WAREHOUSE USER PW CAUSES CONNECT FAILURE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment:
    TEPS, Install, Configuration
      DB2 or Oracle database
      AIX, Linux
      Customer found problem in ITM 6.2 FP1 and in ITM 6.2.1
      Latest patches did not cause this problem.
    
    Problem Description:
      Since passwords are encrypted in the configuration files and
    are masked in the RAS1 trace los and also in the install and
    configure trace logs, the problem is difficult to diagnose.
    The issue shows as a connection failure to the WAREHOUSE
    database. The problem is not specific to either DB2 or Oracle.
    When the password for the Warehouse user contains a $, the
    parsing of thecq.ini file has an error which causes a bad
    datasource string to be generated.  A bad datasource string for
    the TEPS database can also occur if the DB2 user password
    contains a $.   Enter a password which contains a $ while
    configuring the TEPS will cause this problem.
    
    Detailed Recreation Procedure:
      1) Make sure that there are two different IDs that can be used
         to access the Warehouse DB.
      2) Change the login password of the first ID (WH1) to
         abc$:.123
      3) Change the login password of the first ID (WH2) to abc:.123
      4) Install the TEPS and Warehouse Proxy Agent
    
      5) Configure the TEPS and specify WH2 and the password with no
         $ as the Warehouse user id and password.
      6) Configure the WPA and specify WH2 and the password with no
         $ as the Warehouse user id and password.
      7) Start the TEPS and WPA and generate some history.
      8) Wait a day ( or use an existing Warehouse DB with history
         older than one day)
      9) Verify that you can access the history from the Warehouse
         DB which is older than one day.
     10) Stop the TEPS and WPA
     11) Configure the TEPS and specify WH1 and the password with a
         $ as the Warehouse user id and password.
     12) Start the TEPS and WPA and generate some history.
     14) Verify that you can NOT access the history from the
         Warehouse DB which is older than one day.
         which is older than one day.
    
    NOTE: You can run these test with the following tracing set if
    you wish
    to verify that have entered the correct ID and PW for each case.
    
    This can be confirmed by adding at least "ERROR (UNIT:ctsql
    IN,ER,DET)"
    tracing, so that you can see the decrypted user / password from
    the data
    sources referenced within the TEPS RAS1 log.  For example, for
    the TEPS
    datasource, you normally see something like this:
    
    (494D7073.0006-9:ctsqlconnectionodbc.cpp,426,"CTSQLEvaluatorODBC
    _i::Conn
    ection::establishConnection")   connectionString:
    DSN=TEPS;UID=itmuser;PWD=ibmdb2;CONNECTION_TYPE=DB2;CONNECTION_L
    IMIT=100
    

Local fix

  • remove $ from password
    

Problem summary

  • When the password for the warehouse database user ID contains a
    dollar symbol($), the parsing of the cq.ini file causes a bad
    datasource string to be generated.  A bad datasource string for
    the portal server database can also occur if the DB2 user
    password contains a dollar symbol.
    

Problem conclusion

  • The code was changed to handle the dollar symbol in a database
    user ID password.
    
    
    The fix for this APAR is contained in the following maintenance
    packages:
    
       | interim fix | 6.2.0.3-TIV-ITM-IF0001
    

Temporary fix

  • If possible, avoid using the dollar symbol for database user ID
    passwords.
    

Comments

APAR Information

  • APAR number

    IZ43731

  • Reported component name

    OMEG DIST INSTA

  • Reported component ID

    5608A41CI

  • Reported release

    620

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-12

  • Closed date

    2009-06-30

  • Last modified date

    2009-07-21

  • 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

    OMEG DIST INSTA

  • Fixed component ID

    5608A41CI

Applicable component levels

  • R620 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTFXA","label":"Tivoli Monitoring"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"620","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 November 2022