Engine not using DBSPACETEMP in onconfig.pro
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01BDF608.9F827460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am running Informix OnLine Version 7.24.FC5 and having a problem with =
it using the root space as the temp space. I have the following line in =
my onconfig.pro:
DBSPACETEMP tempspc # dEFAULT temp dbspace
However, I have noticed that temp tables are being produced in the root =
space, which is specified here:
ROOTNAME rootspc # Root dbspace name
My platform is Digital Unix 4.0, DEC Alpha 1200 with 1GB memory.
Here is a breakdown of the DB Spaces:
DbSpace Name Total Size Total Used Percent Used Total =
Free
------------ ---------- ---------- ------------ =
----------
blobspc 128,000 120,004 93.75% =
7,996
bmsgenspc 2,048,000 19,702 .96% =
2,028,298
busigenspc 1,024,000 464,268 45.34% =
559,732
compdatspc 1,024,000 945,106 92.30% =
78,894
cscgenspc 2,112,000 1,477,758 69.97% =
634,242
daccdatspc 256,000 180,298 70.43% =
75,702
entdatspc 2,512,000 1,650,112 65.69% =
861,888
faredatspc 128,000 106 .08% =
127,894
logspc 1,152,000 1,150,106 99.84% =
1,894
miscgenspc 1,024,000 170,784 16.68% =
853,216
notedatspc 1,024,000 400,106 39.07% =
623,894
physspc 512,000 500,106 97.68% =
11,894
ppayspc 3,072,000 1,374,046 44.73% =
1,697,954
rootspc 320,000 33,142 10.36% =
286,858
servgenspc 1,024,000 527,514 51.52% =
496,486
tempspc 1,152,000 3,734 .32% =
1,148,266
toladatspc 3,072,000 2,070,156 67.39% =
1,001,844
tzdatspc 2,768,000 2,500,112 90.32% =
267,888
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Instance Totals (Gb): 23.22 12.96 55.79% =
10.27
------=_NextPart_000_001C_01BDF608.9F827460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.2106.6"' name=3DGENERATOR>
</HEAD>
<BODY>
<DIV>I am running Informix OnLine Version 7.24.FC5 and having a problem =
with it=20
using the root space as the temp space. I have the following line in my=20
onconfig.pro:</DIV>
<DIV> </DIV>
<DIV>DBSPACETEMP =20
tempspc # dEFAULT temp=20
dbspace<BR></DIV>
<DIV>However, I have noticed that temp tables are being produced in the =
root=20
space, which is specified here:</DIV>
<DIV> </DIV>
<DIV>ROOTNAME =20
rootspc # Root dbspace=20
name</DIV>
<DIV> </DIV>
<DIV>My platform is Digital Unix 4.0, DEC Alpha 1200 with 1GB =
memory.</DIV>
<DIV> </DIV>
<DIV>Here is a breakdown of the DB Spaces:</DIV>
<DIV><FONT face=3DCourier></FONT> </DIV>
<DIV><FONT face=3DCourier> DbSpace=20
Name Total Size Total=20
Used Percent Used Total=20
Free<BR> =20
------------ ---------- =20
---------- ------------ =20
----------<BR> =20
blobspc =
=20
128,000 =20
120,004 =20
93.75% =20
7,996<BR> =20
bmsgenspc =20
2,048,000 =20
19,702 =20
.96% =
2,028,298<BR> =20
busigenspc =20
1,024,000 =20
464,268 =20
45.34% =20
559,732<BR> =20
compdatspc =20
1,024,000 =20
945,106 =20
92.30% =20
78,894<BR> =20
cscgenspc =20
2,112,000 =20
1,477,758 =20
69.97% =20
634,242<BR> =20
daccdatspc =20
256,000 =20
180,298 =20
70.43% =20
75,702<BR> =20
entdatspc =20
2,512,000 =20
1,650,112 =20
65.69% =20
861,888<BR> =20
faredatspc =20
128,000 =20
106 =20
.08% =20
127,894<BR> =20
logspc &=
nbsp;=20
1,152,000 =20
1,150,106 =20
99.84% =20
1,894<BR> =20
miscgenspc =20
1,024,000 =20
170,784 =20
16.68% =20
853,216<BR> =20
notedatspc =20
1,024,000 =20
400,106 &