IBM Support

IJ13295: THE DB2START COMMAND MAY FAIL WITH SQLCODE SQL1345N IN AN AUTOMATED HADR ENVIRONMENT

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

  • If this issue is encountered, then the following db2diag.log
    error messages will be seen during unsuccessful db2start
    processing:
    
    2019-01-29-17.05.28.992069-360 I59188709E1522        LEVEL:
    Warning
    PID     : 9726                 TID : 47021142566656  PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000
    HOSTNAME: host09
    EDUID   : 1                    EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, oper system services,
    sqloInitializeVendorProcess, probe:2500
    MESSAGE : ZRC=0x870F0044=-2029060028=SQLO_QUE_INVALID "Invalid
    queue name"
              DIA8560C An invalid message queue name was
    encountered.
    DATA #1 : String, 30 bytes
    Unable to open watchdog queue.
    DATA #2 : String, 68 bytes
    /opt/udb/home/db2inst1/sqllib/tmp/DB2VEND.STDIN.0.1.154880312656
    0945
    DATA #3 : String, 69 bytes
    /opt/udb/home/db2inst1/sqllib/tmp/DB2VEND.STDOUT.0.1.15488031265
    60945
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00002AC3E3BE4EB1 sqloInitializeVendorProcess + 0x1971
      [1] 0x00002AC3DE1345DE
    _Z29sqlhaInitVendorInfrastructureP18SQLO_VENDOR_HANDLEPcim +
    0x4DE
      [2] 0x00002AC3DE0F2357
    _Z26sqlhaSetupHAInfrastructurePP18SQLO_VENDOR_HANDLEPPciP27sqlha
    OpenDomainHandleStructPij + 0x1A7
      [3] 0x00002AC3DE0FD574
    _Z34sqlhaStartFastMonitoringOnResourceiP19SQLHA_CONTROL_BLOCK +
    0x284
      [4] 0x00002AC3E3D4CF60
    /opt/udb/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x72C6F60
      [5] 0x00002AC3E3D4BD78 sqloRunInstance + 0x928
      [6] 0x000000000040CEC6 DB2main + 0x1236
      [7] 0x00002AC3E3D5195B sqloEDUEntry + 0x11B
      [8] 0x00002AC3DC4ECDD5 /lib64/libpthread.so.0 + 0x7DD5
      [9] 0x00002AC3EC7F7B3D clone + 0x6D
    
    2019-01-29-17.05.29.007814-360 E59190948E407         LEVEL:
    Severe
    PID     : 9726                 TID : 47021142566656  PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000
    HOSTNAME: host09
    EDUID   : 1                    EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, oper system services,
    sqloSystemControllerMain, probe:3364
    MESSAGE : ZRC=0x827300AA=-2106392406=HA_ZRC_FAILED "SQLHA API
    call error"
    
    2019-01-29-17.05.29.011387-360 I59191764E504         LEVEL:
    Event
    PID     : 9704                 TID : 47059890064000  PROC :
    db2star2
    INSTANCE: db2inst1             NODE : 000
    HOSTNAME: host09
    FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:7653
    MESSAGE : ZRC=0xFFFFFABF=-1345
              SQL1345N  Execution failed due to a cluster manager
    error that will
              not affect the successful execution of subsequent SQL
    statements.
    
    DATA #1 : <preformatted>
    Db2StartMain:: sqlcode=0
    

Local fix

  • 1) Disable automation by running "db2haicu -disable"
    2) Re-run the db2start command
    3) Re-enable automation by running db2haicu and following
    command-line prompts
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ13295

  • Reported component name

    DB2 PURESCALE F

  • Reported component ID

    5724Y6900

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-05

  • Closed date

    2020-01-17

  • Last modified date

    2020-01-17

  • 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

    DB2 PURESCALE F

  • Fixed component ID

    5724Y6900

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 August 2020