Temp Space Problem

[craig322]

I am running IDS 7.31FD5. I have 3 temp different temp spaces defined. If someone runs a large job and runs 1 temp space out of space, I am getting error messages. I have checked and the other two spaces are relatively untouched. In this version, is it better to define one large temp space instead of 3 smaller temp spaces?

TIA

 

[rmutyapu]

What value you have for DBSPACETEMP?

Check to see if all of your temp dbspaces are listed for this parameter or not? If not do it to over come the problem in future.

 

[craig322]

I do have all 3 listed in DBSPACETEMP

 

[mberni]

Check your online.log if there are any errors concerning DBSPACETEMP at server startup.

your onconfig-File-entry must look like:

DBSPACETEMP tmpdbs1,tmpdbs2,tmpdbs3

not

DBSPACETEMP tmpdbs1 tmpdbs2 tmpdbs3

Furthermore check if all of your temp-dbspaces are flagged as such. You can check that by issueing the command:

onstat -d

In the column "flags" there must be listed the letter T for TEMP for all of your TEMP-dbspaces. Otherwise your server wont use them.

Hope that will help you further.