|
Problem IC85791
|
Status: Closed |
ENOTSUP (OPERATION NOT SUPPORTED) OS ERROR RECEIVED DURING ALTER TABLESPACE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.08.2012
24.10.2012
24.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
