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

ENOTSUP (OPERATION NOT SUPPORTED) OS ERROR RECEIVED DURING ALTER TABLESPACE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
User may received ENOTSUP (Operation not support) OS error 
during ALTER TABLESPACE operation. Operation may fail with the 
message "SQL0902C A system error (reason code = reason-code) 
occurred" or another SQL error code. Db2diag.log may contain the 
following entries: 
 
2011-09-25-04.10.45.492418-240 E34736A470         LEVEL: Warning 
(OS) 
PID     : 16311                TID  : 1           PROC : 
db2agent (xxxxx) 0 
INSTANCE: db2prod1             NODE : 000         DB   : xxxxx 
APPHDL  : 0-422                APPID: 
*LOCAL.db2prod1.110925080831 
AUTHID  : DB2PROD1 
FUNCTION: DB2 UDB, oper system services, sqloFileStats, 
probe:140 
MESSAGE : ZRC=0x83000030=-2097151952 
CALLED  : OS, -, ioctl 
OSERR   : ENOTSUP (48) "Operation not supported" 
 
2011-09-25-04.10.45.502221-240 I36025A390         LEVEL: Error 
PID     : 16311                TID  : 1           PROC : 
db2agent (xxxxx) 0 
INSTANCE: db2prod1             NODE : 000         DB   : xxxxx 
APPHDL  : 0-422                APPID: 
*LOCAL.db2prod1.110925080831 
AUTHID  : DB2PROD1 
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:40 
MESSAGE : ZRC=0x83000030=-2097151952 
 
2011-09-25-04.10.45.503396-240 E36416A470         LEVEL: Warning 
(OS) 
PID     : 16311                TID  : 1           PROC : 
db2agent (xxxxx) 0 
INSTANCE: db2prod1             NODE : 000         DB   : xxxxx 
APPHDL  : 0-422                APPID: 
*LOCAL.db2prod1.110925080831 
AUTHID  : DB2PROD1 
FUNCTION: DB2 UDB, oper system services, sqloFileStats, 
probe:140 
MESSAGE : ZRC=0x83000030=-2097151952 
CALLED  : OS, -, ioctl 
OSERR   : ENOTSUP (48) "Operation not supported"
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Solaris only.                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem is Solaris only . When containers are located on * 
* a disk volume larger then 1TB, on Solaris 9 the operation of * 
* altering tablespaces might fail. For Solaris 9 1TB of a disk * 
* volume is a known limitation . For Solaris 10 a fix for this * 
* APAR adds calls for Extended VTOC API and 1TB limitation is  * 
* not exist.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************
Local-Fix:
There is no known workaround at this time.
verfügbare FixPacks:
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
First fixed in DB2 Version 9.7 Fix Pack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.08.2012
24.10.2012
24.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList