IBM Support

IZ03496: -4212: NO MEMBER OF SYSPLEX AVAILABLE FROM JCC DRIVER.

Fixes are available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • "-4212: No member of Sysplex available" is returned from the JCC
    (Java Universal) driver after several messages indicating that
    client reroute was successful. This APAR applies only to
    configurations in with the JCC driver connecting to DB2 for z/OS
    with SYSPLEX enabled.
    
    A JCC trace will show the following sequence of events:
    
    [ibm][db2][jcc][Thread:http-8080-Processor52][SQLException@e0765
    8] java.sql.SQLException
    [ibm][db2][jcc][Thread:http-8080-Processor52][SQLException@e0765
    8] SQL state  = 08506
    [ibm][db2][jcc][Thread:http-8080-Processor52][SQLException@e0765
    8] Error code = -30108
    [ibm][db2][jcc][Thread:http-8080-Processor52][SQLException@e0765
    8] Message    = A connection failed but has been re-established.
    The hostname or IP address is "test.ibm.com" and the
    service name or port number is 446 . Special registers may or
    may not be re-attempted (Reason code = 1
    DB2ConnectionCorrelator: G91234567.C624.C06D577E8985
    ...
    ...
    [ibm][db2][jcc][Thread:http-8080-Processor48][SQLException@57961
    5] java.sql.SQLException
    [ibm][db2][jcc][Thread:http-8080-Processor48][SQLException@57961
    5] SQL state  = null
    [ibm][db2][jcc][Thread:http-8080-Processor48][SQLException@57961
    5] Error code = -4212
    [ibm][db2][jcc][Thread:http-8080-Processor48][SQLException@57961
    5] Message    = No member of Sysplex available
    The current server list that returned from the z/os server(count
    = 8):
      node: /9.131.99.38port: 446 priority: 5
      node: /9.131.98.53port: 447 priority: 2
    

Local fix

Problem summary

  • See Error Description.
    

Problem conclusion

  • First fixed in v9.1 FixPak6.  At minimum the fix should be
    applied to the client side.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ03496

  • Reported component name

    DB2 CEE SOLARIS

  • Reported component ID

    5765F3002

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-08-22

  • Closed date

    2008-11-05

  • Last modified date

    2008-11-05

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

    IZ03494

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

Fix information

  • Fixed component name

    DB2 CEE SOLARIS

  • Fixed component ID

    5765F3002

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 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":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 January 2022