IBM Support

IT36095: ZRC=0xFFFFFFFF=-1 error in db2diag.log when using purescale withSSL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 3257115 data DB2 UDB base sys utilities sqlePopulateSrvlstEntry
    fnc (3.3.5.1830.0.20)
    pid 21971 tid 139802959668992 cpid 22099 node 1 probe 20
    bytes 360
    
    Data1   (PD_TYPE_DIAG_LOG_REC,352) Diagnostic log record:
    
    2021-04-05-18.50.49.941245-240 I73468E351            LEVEL:
    Error
    PID     : 21971                TID : 139802959668992 PROC :
    db2sysc 1
    INSTANCE:                      NODE : 001
    HOSTNAME:
    EDUID   : 22                   EDUNAME: db2pdbc 1
    FUNCTION: DB2 UDB, base sys utilities, sqlePopulateSrvlstEntry,
    probe:20
    RETCODE : ZRC=0xFFFFFFFF=-1
    
    This error is caused because sqlccGenerateSynclog is the
    function to see the error. The condition for the error in this
    function is that "SVCENAME is not set". Customer is using SSL,
    so they did not set SVCENAME. A temporary work-around is to set
    SVCENAME same as SSL_SVCENAME. There is no need to add TCPIP to
    DB2COMM.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * set SVCENAME same as SSL_SVCENAME or apply fix               *
    ****************************************************************
    

Problem conclusion

  • first fix in v11.1.4.7
    

Temporary fix

  • set SVCENAME same as SSL_SVCENAME
    

Comments

APAR Information

  • APAR number

    IT36095

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-03-02

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT36628

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
03 May 2022