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

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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