db2diag error - "oper system services sqloWaitInterru pt Probe:10 "

[WantedToBeDBA]

Hi Friends,
I am running a stored procedure in Windows 2000 box (version 8.1.0)
and i am getting following error in db2diag.log repeatly. The scenerio
is as follows. I am inserting 55000 records(getting it from a select
statement) into an temporary table which takes around 22.5 hours. When
i execute the query seprately, it talkes only 3 min to complete the
exection. The tablespace i am using for temporary table is DMS and it
has lots of free spaces on it. The error i am getting is as follows.

"2005-01-02-06.34.03.078000 Instance:DB2 Node:000
PID:2500(db2sys cs.exe) TID:2436 Appid:none
oper system services sqloWaitInterru pt Probe:10

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:2500 TID:2436 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid."

Needed help urgently,
Thiru,
WantedToBeDBA.

[Kiran]

Check out of the paths given for the tablespaces exists. try to stop
all other external porgrams running and try running the SP. Is your
rows inserted correctly ?.
Try giving absolute path ..if you have not given relative path in
creating table spaces.

[Thiru]

I have an exclusive control over that system and nobody is using that..
Then i haven't created the tablespace and so i don't know what path
they have given(relative or absolute).

I don't understand this sentence.. Where to give the absolute path??
"Try giving absolute path ..if you have not given relative path in
creating table spaces."
Bare me.. I am newbie to DB2...

Thanks.
Thiru,
WantedToBeDBA.

[Kiran]

Thiru ,
I guess you should create a temporary tablespace if want to use
temporary table ..and if you have given a DMS then you may need to
give the container name also .
I am also a newbie buddy ..lets look for other replies..

Kiran Nair

[dotyet]

for temporary tablespace as an SMS:
db2 "create user temporary tablespace tempspc1 pagesize xK managed by
system using ('<absolute path to the directory which will contain
temporary tablespace>') bufferpool xKbp"

for temporary tablespace as a DMS:
db2 "create user temporary tablespace tempspc1 pagesize xK managed by
database using (FILE '<absolute path to the file which will contain
temporary tablespace>' size_value|K|M| G) bufferpool xKbp"

however, I don't think 55000 are that many records to take 22 hours.
don't know, but maybe, taking a snapshot of the application | dynamic
sql may help.

regards,
dotyet