Hi all,

I am getting these errors almost everyday. They generally occur after a scheduled bulk update that happens every night.

here's the error:

2006-06-06-01.16.29.345017-300 E452459A664 LEVEL: Error
PID : 4268212 TID : 1 PROC : db2pfchr 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePageToDisk, probe:20
MESSAGE : ADM6017E The table space "TEMP16K" (ID "4") is full. Detected on
container "/prod1/sms/tmp/tmp16k" (ID "0"). The underlying
file system is full or the maximum allowed space usage for the file
system has been reached. It is also possible that there are user
limits in place with respect to maximum file size and these limits
have been reached.

2006-06-06-01.16.29.345327-300 I453124A292 LEVEL: Error
PID : 4268212 TID : 1 PROC : db2pfchr 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePageToDisk, probe:20
MESSAGE : Cont page = 82816 ObjID=5 ObjType=128

2006-06-06-01.16.29.345518-300 E453417A666 LEVEL: Error
PID : 4268212 TID : 1 PROC : db2pfchr 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloseekwrite64, probe:100
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
0x0FFFFFFFFFFFD310 : 0000 000E 0000 0000 ........
DATA #2 : unsigned integer, 8 bytes
16384
DATA #3 : signed integer, 8 bytes
1353777152
DATA #4 : unsigned integer, 8 bytes
40
DATA #5 : Hex integer, 4 bytes
0x0000001C
DATA #6 : signed integer, 8 bytes
-1
----------------------------------------------------------

Now the thing is that the location for container mentioned in the error is not full, its just using 2-3% of the space allocated to it.

So I am not understanding where the problem resides. I hope I can get some advice from here.

Also I would like to know the impact of these errors??

Anks

I am sorry I forgot to mention the version and OS info


DB2 UDB v8.2, FP 7, AIX

Anks

Is the table space "TEMP16K" system-managed or database-managed?
And if it's DMS, is there a size limit specified?

What is the current file size of /prod1/sms/tmp/tmp16k ?
Does the disk have accounting or other user-based space limitations switched on?

Thanks Peter

Its System Managed Tablespace

After doing a ulimit, here's what I see

ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 245760
stack(kbytes) 16384
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited

I don't know if the data and stack should also be kept as unlimited.

The size of the filesystem is this

df -k /prod1/sms/tmp
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/fslv03 4194304 4178404 1% 316 1% /prod1/sms/tmp


du -k /prod1/sms/tmp/xyz

1308 /prod1/sms/tmp/xyz/tmp16k
1948 /prod1/sms/tmp/xyz/tmp32k
8 /prod1/sms/tmp/xyz/tmp4k
3264 /prod1/sms/tmp/xyz

Don't know if all this information will help

Let me if you need more information

Anks

The "data" limit looks fine; quoting from http://publib.boulder.ibm.com/infoce...perftune25.htm
"It is recommended that the process data size and virtual memory size be set to unlimited. Setting to unlimited can be done by modifying the following lines in the /etc/security/limits file:

default:
data = -1
rss = -1

At minimum, set these size limits to 256 MB, which is the value of 256000 in the /etc/security/limits file."

Only 2 MB is being used up.
Are you sure that those limits apply to DB2?

SMS temporary space is allocated is needed. I'm sure that if you monitor the space utilization during the "bulk update" process you'll see that it approaches 100% just before the process failure.

I have set the data limits to "unlimited" and i'll monitor the utilization at the time of the bulk update to see what happens.

Thanks for all your help!!