IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

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

Document Information

Modified date:
02 September 2021