Temp space
Hi,
I'd like to add more temp space to my db environment and just want to
confirm the necessary steps. Is there a limit on the amount of temp space
for allocation?
I'm using Informix 9.4.
1-use onspaces to enable new temp spaces
E.g. onspaces -c -d temp_014 -t -p /dev/links/sysvg_tmp0014 -o 0 -s 2097000
2-run fake backup using ontape
ontape -s -L 0 > /dev/null
3-update DBSPACETEMP in onconfig file with new temp spaces
4-bounce the engine
Thank you,
____________________________________________
Tony
Database Administrator
--0__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B
Content-type: multipart/alternative;
Boundary="1__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B"
--1__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
No, there's no limit as such ..it is governed by the overall limit of 3=
2767
chunks/dbspaces for 9.40. If u r within that limit, it should be fine.
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
From his neck down a man is worth a couple of dollars a day, from his n=
eck
up he is worth anything that his brain can produce. -- T. Edison
=
"Demeis, Tony" =
<Tony.Demeis@moh. =
gov.on.ca> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Temp space [4843] =
04/28/2005 08:36 =
AM =
=
=
=
=
Hi,
I'd like to add more temp space to my db environment and just want to
confirm the necessary steps. Is there a limit on the amount of temp sp=
ace
for allocation?
I'm using Informix 9.4.
1-use onspaces to enable new temp spaces
E.g. onspaces -c -d temp_014 -t -p /dev/links/sysvg_tmp0014 -o 0 -s 209=
7000
2-run fake backup using ontape
ontape -s -L 0 > /dev/null
3-update DBSPACETEMP in onconfig file with new temp spaces
4-bounce the engine
Thank you,
____________________________________________
Tony
Database Administrator
=
--1__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>No, there's no limit as such ..it is governed by the overall limit o=
f 32767 chunks/dbspaces for 9.40. If u r within that limit, it should b=
e fine.<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
From his neck down a man is worth a couple of dollars a day, from his n=
eck up he is worth anything that his brain can produce. -- T. Edison<br=
>
<br>
<img src=3D"cid:10__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Demeis, Tony&=
quot; <Tony.Demeis@moh.gov.on.ca>">"Demeis, Tony" <T=
ony.Demeis@moh.gov.on.ca><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE56=
2DFF1A65B8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Demeis, Tony" <Tony.Demeis@moh.go=
v.on.ca></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">04/28/2005 08:36 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE562DFF1A65B8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Temp space [4843]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE562DFF1=
A65B8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE562DFF1A65B8f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi,<br>
I'd like to add more temp space to my db environment and just want to<b=
r>
confirm the necessary steps. Is there a limit on the amount of te=
mp space<br>
for allocation?<br>
I'm using Informix 9.4. <br>
<br>
1-use onspaces to enable new temp spaces<br>
E.g. onspaces -c -d temp_014 -t -p /dev/links/sysvg_tmp0014 -o 0 -s 209=
7000<br>
<br>
2-run fake backup using ontape<br>
ontape -s -L 0 > /dev/null<br>
<br>3-update DBSPACETEMP in onconfig file with new temp spaces<br>
<br>
4-bounce the engine<br>
<br>
<br>
Thank you,<br>
____________________________________________<br>
Tony<br>
Database Administrator<br>
<br>
<br>
<br>
</tt><br>
</body></html>=
--1__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B--
--0__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE562DFF1A65B8f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=88BBE562DFF1A65B8f9e8a93df938690918c88BBE562DFF1A65B
Content-type: image/gif;
name="pic28633.gif"
Content-Disposition: inline; filename="pic28633.gif"
Content-ID: <20__=88BBE562DFF1A65B8f9e8a93df938@us
Hi,
You can use onmonitor to do so.
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On
Behalf Of Demeis, Tony
Sent: Thursday, April 28, 2005 11:37 AM
To: ids@iiug.org
Subject: Temp space [4843]
Hi,
I'd like to add more temp space to my db environment and just want to
confirm the necessary steps. Is there a limit on the amount of temp
space for allocation?
I'm using Informix 9.4.
1-use onspaces to enable new temp spaces E.g. onspaces -c -d temp_014 -t
-p /dev/links/sysvg_tmp0014 -o 0 -s 2097000
2-run fake backup using ontape
ontape -s -L 0 > /dev/null
3-update DBSPACETEMP in onconfig file with new temp spaces
4-bounce the engine
Thank you,
____________________________________________
Tony
Database Administrator