IBM Support

LI74684: Engine can CRASH IF CIRCULAR CATALOGING of a database using tpcip loopback NODE is used.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you have a circular reference between database alias and
    database name such as below, the engine might crash:
    
    Database 1 entry:
    
    Database alias = C14
    Database name = C14L
    Node name = NODEC14
    Database release level = c.00
    ...
    Directory entry type = Remote
    ...
    
    
    Database 2 entry:
    
    Database alias = C14L
    Database name = C14
    Local database directory = /db2/C14
    ...
    Directory entry type = Indirect
    ...
    
    The circular calatoging above is Entry 1 alias C14 that refers
    to Entry 1 database name C14L which in turn reference Entry 2
    alias C14L that reference name C14 (same as entry 1 alias)
    

Local fix

  • Undo the circular cataloging by changing the name database
    aliases per example:
    
    Database 1 entry:
    
    Database alias = C14_REM
    Database name = C14
    Node name = NODEC14
    Database release level = c.00
    Comment =
    Directory entry type = Remote
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =
    
    Database 2 entry:
    
    Database alias = C14
    Database name = C14
    Local database directory = /db2/C14
    Database release level = c.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =
    

Problem summary

  • If you have a circular reference between database alias and
    
    database name such as below, the engine might crash:
    
    Database 1 entry:
    
    Database alias = C14
    Database name = C14L
    Node name = NODEC14
    Database release level = c.00
    ...
    Directory entry type = Remote
    ...
    
    
    Database 2 entry:
    
    Database alias = C14L
    Database name = C14
    Local database directory = /db2/C14
    ...
    Directory entry type = Indirect
    ...
    
    The circular calatoging above is Entry 1 alias C14 that refers
    to Entry 1 database name C14L which in turn reference Entry 2
    alias C14L that reference name C14 (same as entry 1 alias)
    

Problem conclusion

  • First fixed in version 9.5 fixpak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74684

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-19

  • Closed date

    2009-12-15

  • Last modified date

    2009-12-15

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

    LI74660

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 December 2009