IBM Support

JR62835: DOC - NOTE TO ENSURE THE READ_COMMITTED_SNAPSHOT FLAG IS ALWAYS SET FOR SQL SERVER DATABASES AFTER UPGRADING IS MISSING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • "Creating SQL Server databases"
    
    (https://www.ibm.com/support/knowledgecenter/SS8JB4_20.x/com.ibm
    .wbpm.imuc.doc/topics/db_typ_nd_lin_sql.html) mentions that you
    must enable the READ_COMMITTED_SNAPSHOT database flag when
    creating IBM Business Automation Workflow databases for
    Microsoft SQL Server, but it doesn't state that you should
    enable this flag after you upgrade if it wasn't enabled in a
    previous version.
    

Local fix

  • Enable READ_COMMITTED_SNAPSHOT on SQL SERVER databases
    

Problem summary

  • No additional information is available.
    

Problem conclusion

  • The content will be updated the next time the documentation is
    refreshed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR62835

  • Reported component name

    BUS AUTO WORKFL

  • Reported component ID

    5737H4100

  • Reported release

    J00

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-22

  • Closed date

    2020-10-06

  • Last modified date

    2020-10-06

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

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0.0.1"}]

Document Information

Modified date:
07 October 2020