DB2 FOR LUW / DB2FORLUW / 970 - DB2

call CAPTURE_STORAGEMGMT_INFO returns error SQL0443N, "SQL0407 
Token:TBSPACEID=2, TABLEID=8, COLNO=3".  SQLSTATE=38553 
 
This issue occurs only when database is created in Oracle mode, 
where the empty string cannot be assigned to NOT NULL column. 
 
Test Case: 
 
$ db2set -all 
[i] DB2_COMPATIBILITY_VECTOR=ORA 
 
$ db2stop force 
db2sSQL1064N  DB2STOP processing was successful. 
 
$ db2start 
db2 create db oSQL1063N  DB2START processing was successful. 
 
$ db2 create db ordb 
DB20000I  The CREATE DATABASE command completed successfully. 
 
$ db2 connect to ordb 
 
   Database Connection Information 
 
 Database server        = DB2/LINUXX8664 9.7.6 
 SQL authorization ID   = LAPPANNA 
 Local database alias   = ORDB 
 
$ db2 "call drop_storagemgmt_tables(1)" 
  Return Status = 0 
 
$ db2 "call create_storagemgmt_tables('USERSPACE1')" 
  Return Status = 0 
 
$ db2 "call CAPTURE_STORAGEMGMT_INFO(0,'','ORDB')" 
SQL0443N  Routine "*GMT_INFO" (specific name "") has returned an 
error SQLSTATE with diagnostic text "SQL0407 Token:TBSPACEID=2, 
TABLEID=8, COLNO=3".  SQLSTATE=38553

**************************************************************** 
* USERS AFFECTED:                                              * 
* aLL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description Above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7  Fix Pack 6                       * 
****************************************************************

N/A

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

First Fixed in Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84244 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.11.2011
06.06.2012
06.06.2012

9.7.,
9.7.FP6