DB2 FOR LUW / DB2FORLUW / 970 - DB2

An MQT that was created via a Windows utility may prepend extra 
characters (^M or <NL> characters) in the MQT DDL text. This can 
lead to an SQL0901N error or possible trap when trying to 
collect the DDL via db2look or when the DROP TABLE RECOVERY 
feature attempts to collect the DDL when the MQT is being 
dropped. This also applies to any MQT DDL statement that does 
not begin with 'CREATE' or 'ALTER' (case insensitive). 
 
You can verify the DDL text used to create the MQT with the 
below query: 
 
select text from syscat.views

Users affected: Any using a 3rd party client tool to create 
tables 
Problem Description: Extra characters in the table name can 
cause db2 to trap during DROP table or db2look. 
Problem Summary: See above.

For the drop table case, you can temporarily turn off DROP TABLE 
RECOVERY for that tablespace (e.g. ALTER TABLESPACE <tbspname> 
DROPPED TABLE RECOVERY OFF) to allow the drop to complete and 
then re-enable it.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 FixPak 3

For the drop table case, you can temporarily turn off DROP TABLE 
 
RECOVERY for that tablespace (e.g. ALTER TABLESPACE <tbspname> 
DROPPED TABLE RECOVERY OFF) to allow the drop to complete and 
then re-enable it.

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

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

27.05.2010
07.10.2010
07.10.2010

9.7.