home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC69901 Status: Geschlossen

db2look does not generates tablespace container information if option
"-ct" issued

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2look does not generates tablespace information if option 
"-ct" isused 
 
               db2look -d mpp1 -l -ct 
 
CREATE LARGE TABLESPACE "TS_PD_DATA_001" IN DATABASE PARTITION 
GROUP PDPG PAGESIZE 4096 MANAGED BY DATABASE 
         EXTENTSIZE 32 
         PREFETCHSIZE AUTOMATIC 
         BUFFERPOOL IBMDEFAULTBP 
         OVERHEAD 3.630000 
         TRANSFERRATE 0.070000 
         AUTORESIZE YES 
         MAXSIZE 2 G 
         NO FILE SYSTEM CACHING 
         DROPPED TABLE RECOVERY ON ; 
 
See the Tablespace's containers path are missing 
 
Problem is due to the internal default temporary directory used 
by db2look when generating the DDL code.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* System running DB2 v9.70 FP3 or lower                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2look does not generates tablespace container information  * 
* if option "-ct" issued                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP4 or higher                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 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

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC69957 IC69977 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.07.2010
28.04.2011
28.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList