Using DB2 7.2, Win NT,

Create long tablespace (of DMS type) command is failing with DIA3612C Disk was full error in diag.log even when there is space on disk.
The total container files in create tablespace statement need less than 80GB of space. The file system has 150 GB of free space in it.

The command looks like -

CREATE LONG TABLESPACE tbspc1 IN NODEGROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (FILE 'D:\Data\cont1.DB' 2560000, FILE 'D:\Data\cont2.DB' 2560000, FILE 'D:\Data\cont3.DB' 2560000, FILE 'D:\Data\cont4.DB' 2560000, FILE 'D:\Data\cont5.DB' 2560000,FILE 'D:\Data\cont6.DB' 2560000 ) EXTENTSIZE 32 PREFETCHSIZE 32 BUFFERPOOL IBMDEFAULTBP OVERHEAD 11.670000 TRANSFERRATE 0.310000

Since the disk has space, can there be any other reason for this error? All the tablespaces are DMS, including catalog.

Following is from db2diag.log -

2004-10-07-18.52.54.765000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:1696 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -10740 IGNORED ... err loc 0
. Request follows...

2004-10-07-18.52.54.828000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:1696 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = ADDDMSCONTAINER

2004-10-07-18.52.55.265000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:1076 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -10740 IGNORED ... err loc 0
. Request follows...

2004-10-07-18.52.55.265001 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:1076 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = ADDDMSCONTAINER

2004-10-07-18.52.55.328000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
buffer_pool_services sqlbDMSCreatePool Probe:800 Database:T1DB
DIA3612C Disk was full.

ZRC=FFFFD60C

2004-10-07-18.52.55.343000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
buffer_pool_services sqlbDMSCreatePool Probe:800 Database:T1DB

Page=110

2004-10-07-18.52.55.343001 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
buffer_pool_services sqlbCreatePool Probe:920 Database:T1DB
DIA3612C Disk was full.

ZRC=FFFFD60C

2004-10-07-18.52.55.906000 InstanceB2 Node:000
PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
data_management sqldPoolCreate Probe:273 Database:T1DB
DIA3612C Disk was full.

ZRC=FFFFD60C

Thanks,
-Preeti

Long Tablespaces are for long or LOB table columns. It does not affect the total size of the tablespace. If you want a tablespace larger than 64 GB (but no more than 128 GB), use an 8K page size. If 128 GB is not enough, keep increasing the page size.

Refer to the SQL limits, Appendix A, of the SQL Reference, where it has: Table 36. Database Manager Page Size Specific Limits.

We do have LOB columns in the table which will be connected to this long tablespace.

If you are going over 64GB, you need a page size larger than 4K.