I have the following problem that is occurring more frequently. Trying to

determine what buffer/pool/userspace1 to increase
any help would be appreciated on how to resolve
Partition still has alot of free space
regards
doug gisselsman

Tablespace ID = 2.
Name = USERSPACE1.
Type = System managed space.
Contents = Any data.
State = 0x0008.
Detailed explanation:.
Load pending.
Total pages = 332476.
Useable pages = 332476.
Used pages = 332476.
Free pages = Not applicable.
High water mark (pages) = Not applicable.
Page size (bytes) = 4096.
Extent size (pages) = 32.
Prefetch size (pages) = 16.
Number of containers = 1.
State change tablespace ID = 2.
State change object ID = 133.

Starting LOAD phase at 11-24-2005 02:28:05.780056. Table NPOS
.GLOBAL_DEBIT_BIN

2005-11-24-02.28.03.880000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
database_utilities sqlulPrintPhaseMsg Probe:0


Completed LOAD phase at 11-24-2005 02:28:10.269278.

2005-11-24-02.28.04.120000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
database_utilities sqlulPrintPhaseMsg Probe:0


Starting BUILD phase at 11-24-2005 02:28:10.535189.

2005-11-24-02.28.04.520000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
buffer_pool_services sqlbSMSTruncateObject Probe:820
DIA3612C Disk was full.

ZRC=0xFFFFD60C

2005-11-24-02.28.04.840000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
buffer_pool_services sqlbSMSTruncateObject Probe:820

Obj={pool:2;obj:133;type:1} State=x27 Page=3 Cont=0

Data Title:SQLB_OBJECT_DESC PID:130 TID:21 Node:000
0200 8500 0200 8500 0100 0000 0006 8ace ................
02b8 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0100 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 8501 .... ...........
f835 2302 3000 0702 .5#.0...


2005-11-24-02.28.06.060000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
database_utilities DIAG_ERROR Probe:0

Error!!! Trunc -10740, 1, Detected in file:
d:\db2bld\engn\SQU\sqlulinx.c, line 3009

2005-11-24-02.28.06.230000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:21 Appid:none
database_utilities DIAG_ERROR Probe:0

Error!!! -10740, 0, Detected in file: d:\db2bld\engn\SQU\sqlulinx.c,
line 602

2005-11-24-02.28.06.490000 Instance:DB2 Node:000
PID:130(DB2SYSC.EXE) TID:9 Appid:*LOCAL.DB2.051124050335
database_utilities call_sqluvload Probe:40 Database:SMG0001

Load Error: Load failed for table NPOS .GLOBAL_DEBIT_BIN in tablespace
2.


I


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Doug Gisselman
IBM Global Services
Sears Retail Development Team
Telephone - 630-568-7653
Pager - 1-800-SKYTEL2 PIN 1894745

DB2 & UDB email list listserv db2-l LazyDBA home page