IBM Support

LO90497: CHANGING NTS_AUTO_SCHEMA PARAMETER WITH DB2 MAY CHANGE SCHEMA NAME.

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

  • Customer switched from NTS_AUTO_SCHEMA=false to
    NTS_AUTO_SCHEMA=true in production which isn't a problem.
    However they had been using the default schema name of LNT.
    Since the default value it didn't have to be set in notes.ini so
    when change AUTO_SCHEMA settings the schema name also changed
    unexpectedly.  This is only seen when using DB2 as the
    enterprise DB solution.
    
    The fix in this APAR will be to Auto generate the
    NTS_DB2_SCHEMA=LNT value into the notes.ini when it is detected
    that NTS_AUTO_SCHEMA is set to false and the customer is using
    the default schema value.  Then switching AUTO_SCHEMA values
    will work as expected.  Additionally the customer will still be
    able to change the NTS_DB2_SCHEMA value in notes.ini if desired.
    

Local fix

  • Set NTS_DB2_SCHEMA=<schema name> in notes.ini, in this case
    LNT is the schema name.
    

Problem summary

  • Updated the travelerUtil application and the product
    documentation to indicate that changing the database username
    could impact the schema and/or database name accessed by the IBM
    Traveler server.
    

Problem conclusion

  • The IBM Traveler server has been updated to improve the product
    usability in this scenario.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LO90497

  • Reported component name

    LOTUS NOTES TRA

  • Reported component ID

    5724E6204

  • Reported release

    901

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-11

  • Closed date

    2016-11-09

  • Last modified date

    2016-11-09

  • 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

    LOTUS NOTES TRA

  • Fixed component ID

    5724E6204

Applicable component levels

  • R901 PSY

       UP



Document information

More support for: IBM Traveler

Software version: 9.0.1

Reference #: LO90497

Modified date: 09 November 2016