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 IC87775 Status: Geschlossen

DB2LOOK GENERATES DDL FOR DMS TABLESPACE WITH MAXSIZE ROUNDED DOWN.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When the create tablespace command is issued for a DMS talespace 
with the MAXSIZE not a multiple of GB or MB then db2look 
generates the DDL statement with MAXSIZE rounded down.  This can 
cause confusion especially if the DMS tablespaces are very large 
in 
Giga bytes and not an exact multiple of GB. 
 
e.g. 
 
$ db2 "create tablespace xxxxx pagesize 4096 managed by database 
using (FILE '/xxxx/xxxx/xxxx/xxxxx/tbs2'  1024k) BUFFERPOOL bp4k 
AUTORESIZE YES  MAXSIZE 1536k" 
DB20000I  The SQL command completed successfully. 
 
and corresponding db2look output 
 
CREATE LARGE TABLESPACE "xxxxx" IN DATABASE PARTITION GROUP 
IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE 
         USING (FILE '/xxxx/xxxx/xxxx/xxxxx/tbs2' 256) 
         EXTENTSIZE 32 
         PREFETCHSIZE AUTOMATIC 
         BUFFERPOOL BP4K 
         OVERHEAD 7.500000 
         TRANSFERRATE 0.060000 
         AUTORESIZE YES 
         MAXSIZE 1 M 
         NO FILE SYSTEM CACHING 
         DROPPED TABLE RECOVERY ON; 
 
This defect will address this issue by providing the MAXSIZE in 
terms of actual KB when MAXSIZE is not an exact multiple 
of GB or MB.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V9.7 Fix Pack 8 or Later.             * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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
First Fixed in DB2 Version V9.7 Fix Pack 8
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.11.2012
30.09.2013
30.09.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList