IY95034: CREATE DECLARE GLOBAL TEMP TABLE STATEMENT CAUSES DATABASE CRASH

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2a - interim special build 2a
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Declaring/creating a global temp table causes database crash at
  fixpak 7a or db2_v82. At this code level we inadvertently try to
  create DGTT in IBMDEFAULTGROUP tablespace if it exists. This
  tablespace was default tablespace for permanent tables
  in pre-v7 versions. Due to the fact that IBMDEFAULTGROUP
  is permanent tablespace, an attempt to create a temp table in it
  leads to database crash. It is not the default tablespce
  anymore, therefore problem only
  happens on databases that were migrated from previous versions.
  

Local fix

• Drop or rename IBMDEFAULTGROUP tablespace.
  

Problem summary

• CREATE DECLARE GLOBAL TEMP TABLE STATEMENT CAUSES DATABASE CRASH
  

Problem conclusion

• LOCAL FIX:
  Drop or rename IBMDEFAULTGROUP tablespace.
  
  fixed in v9.1 fp2a
  

Temporary fix

Comments

APAR Information

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

  IY65029

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

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R910 PSY

     UP