IBM Support

IT43606: CERTAIN SETDBPARMS ARE NOT WORKING ON WINDOWS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • On Windows,  the credentials set using mqsisetdbparms command
    may never be used if the following conditions are met
    
    1. The user runs mqsisetdbparms where the resource type is a
    known credential type (https://www.ibm.com/docs/en/app-connect/
    12.0?topic=commands-mqsicredentials-command)
    
    2.  One or more characters of the resource type are in upper
    case.
    
    In the reported issue, the customer had created the dbparms as
    below
    
    mqsisetdbparms NODE -n 'TrustStore::truststorePass' -u 'ignore'
    -p 'password'
    
    
    The prefix TrustStore is a known credential type but T&S are
    in upper case,
    
    
    When the TrustStore::truststorePass is set as truststorePass
    under ComIbmJVMManager, it caused a failure in loading the trust
    store as the password was never retrieved correctly.  The same
    configuration worked on Linux.
    

Local fix

  • Use the resource type as an unknown credential type(eg:
    ESB::truststorePass) while creating the dbparms on windows or
    use everything in lowercase.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of IBM App Connect Enterprise v11 and v12 using
    mqsisetdbparams command on Windows platform.
    
    
    Platforms affected:
    Windows on x86 platform, Windows on x86-64 platform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    On Windows,  the credentials that are set using mqsisetdbparms
    command may never be used if the following conditions are met
    
    1. The user runs mqsisetdbparms where the resource type is a
    known credential type
    (https://www.ibm.com/docs/en/app-connect/12.0?topic=commands-mqs
    icredentials-command)
    
    2.  One or more characters of the resource type are in upper
    case.
    
    Example : The prefix TrustStore is a known credential type but
    T&S are in upper case. Hence, when 'TrustStore::truststorePass'
    is set as truststorePass under ComIbmJVMManager, it would cause
    a failure in loading the truststore as the password may never be
    retrieved correctly. The same configuration would work on Linux.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT43606

  • Reported component name

    APP CONNECT ENT

  • Reported component ID

    5724J0550

  • Reported release

    B00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-04-21

  • Closed date

    2023-07-27

  • Last modified date

    2023-07-27

  • 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

    APP CONNECT ENT

  • Fixed component ID

    5724J0550

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDR5J","label":"IBM App Connect Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B00","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 July 2023