Creating chunk files?

i'm all confused after reading the guides.. and after trying, i still couldnt get it right.. 1. how do i change the default size of rootsdbs file? without adding another chunk file? I've tried changing the onconfig file, but upon restarting its still the old size. 2. And if i do a "onspaces -a abcdb \\\\\\\\.\\\\d:\\\\db\\\\abcdb_dat.000 -s 550000 -o 0" and when i do a "onstat -d", i see 2 chunk files and the abcdb_dat.000 size changes to 550000KB but how do i add physical chunk files instead? Meaning if i add a chunk file, it actually creates another abcdb_dat.001 file? 3. if i create "DBSPACETEMP tempdbs " in my onconfig file, does it mean i have to physically create the dbspace tempdbs using ONSPACES ? Thanks! Michael

Hi bro, 1) I'm affraid you cannot change ROOTDBS size on the fly (or even worse, without regenerating the instance). those are some of most basic steps - export your data - change rootdbs on onconfig file - onmode -ky ; oninit -i :-) - import your data 2) Not at all (altough what you ask is not clear) Physical chunk??? there is no such... chunks are just chunks (another layer in the DB) If the chunk already exists, onspaces complains. Also, onspaces will NOT auto-rename your chunks. 3) you ALWAYS MUST create temporary dbspace(s). ALWAYS. After that, set the variable to that temp dbs (although i think its not necessary...) Greetz

On IDS version 9.3 you can add additional chunks to the rootdbs. I am not sure about the Informix 7 versions. Here is an example : $ onspaces -a rootdbs -p /dev/i/0/vol01 -o 500000 -s 100000Verifying physical disk space, please wait ... Chunk successfully added. $ onstat - IBM Informix Dynamic Server Version 9.30.FC7 -- On-Line -- Up 14 days 08:54:13 -- 1234944 Kbytes Hope this helps. ESTEBAN RIEZNIK <erieznikr@repsolypf.com> wrote: Hi bro, 1) I'm affraid you cannot change ROOTDBS size on the fly (or even worse, without regenerating the instance). those are some of most basic steps - export your data - change rootdbs on onconfig file - onmode -ky ; oninit -i :-) - import your data 2) Not at all (altough what you ask is not clear) Physical chunk??? there is no such... chunks are just chunks (another layer in the DB) If the chunk already exists, onspaces complains. Also, onspaces will NOT auto-rename your chunks. 3) you ALWAYS MUST create temporary dbspace(s). ALWAYS. After that, set the variable to that temp dbs (although i think its not necessary...) Greetz ( --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today

--0__=08BBE4FCDF98D93F8f9e8a93df938690918c08BBE4FCDF98D93F Content-type: multipart/alternative; Boundary="1__=08BBE4FCDF98D93F8f9e8a93df938690918c08BBE4FCDF98D93F" --1__=08BBE4FCDF98D93F8f9e8a93df938690918c08BBE4FCDF98D93F Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable You can always add chunks to the rootdbs, regardless of version. Mark. Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com = "Ravi T " = <ravit29@yahoo.co = m> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Re: Creating chunk files? = 04/06/2004 04:48 [2794] = PM = = = = = = On IDS version 9.3 you can add additional chunks to the rootdbs. I am = not sure about the Informix 7 versions. Here is an example : $ onspaces -a rootdbs -p /dev/i/0/vol01 -o 500000 -s 100000Verifying physical disk space, please wait ... Chunk successfully added. $ onstat - IBM Informix Dynamic Server Version 9.30.FC7 -- On-Line -- Up 14 da=ys 08:54:13 -- 1234944 Kbytes Hope this helps. ESTEBAN RIEZNIK <erieznikr@repsolypf.com> wrote: Hi bro, 1) I'm affraid you cannot change ROOTDBS size on the fly (or even worse= , without regenerating the instance). those are some of most basic steps - export your data - change rootdbs on onconfig file - onmode -ky ; oninit -i :-) - import your data 2) Not at all (altough what you ask is not clear) Physical chunk??? there is no such... chunks are just chunks (another l= ayer in the DB) If the chunk already exists, onspaces complains. Also, onspa= ces will NOT auto-rename your chunks. 3) you ALWAYS MUST create temporary dbspace(s). ALWAYS. After that, set= the variable to that temp dbs (although i think its not necessary...) Greetz ( --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today = --1__=08BBE4FCDF98D93F8f9e8a93df938690918c08BBE4FCDF98D93F Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>You can always add chunks to the rootdbs, regardless of version. <br= > <br> Mark. <br> <br> Mark Scranton<br> Principal Consultant/Teacher<br> IBM Denver<br> <br> IBM Software Group - Data Management<br> Office: 303-773-5067<br> Cell: 303-929-0914<br> email: mscranto@us.ibm.com<br> <br> <br> <img src=3D"cid:10__=3D08BBE4FCDF98D93F8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for &quot;Ravi T &quot;= &lt;ravit29@yahoo.com&gt;">&quot;Ravi T &quot; &lt;ravit29@yahoo.com&g= t;<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__=3D08BBE4F= CDF98D93F8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">&quot;Ravi T &quot; &lt;ravit29@yahoo.com&gt;</= 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/06/2004 04:48 PM</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__=3D08BBE4FCDF98D93F8f9e8a93df938@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__=3D08BBE4FCDF98D93F8f9e8a93df938@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__=3D08BBE4FCDF98D93F8f9e8a93df938@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__=3D08BBE4FCDF98D93F8f9e8a93df938@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__=3D08BBE4FCDF98D93F8f9e8a93df938@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__=3D08BBE4FCDF98D93F8f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Re: Creating chunk files? [2794]</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__=3D08BBE4FCDF98= D93F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE4FCDF98D93F8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>On IDS version 9.3 you can add additional chunks to the rootdbs. &n= bsp;I am not sure about the Informix 7 versions. &nbsp;Here is an examp= le :<br> <br> $ onspaces -a rootdbs -p /dev/i/0/vol01 -o 500000 -s 100000<br> Verifying physical disk space, please wait ...<br> Chunk successfully added.<br> $ onstat -<br> IBM Informix Dynamic Server Version 9.30.FC7 &nbsp; &nbsp; -- On-Line -= - Up 14 days 08:54:13 -- 1234944 Kbytes<br> <br> Hope this helps. &nbsp;<br> <br> <br> <br> ESTEBAN RIEZNIK &lt;erieznikr@repsolypf.com&gt; wrote:<br> Hi bro,<br> <br>1) I'm affraid you cannot change ROOTDBS size on the fly (or even worse= , without regenerating the instance). those are some of most basic step= s<br> - export your data<br> - change rootdbs on onconfig file<br> - onmode -ky ; oninit -i :-)<br> - import your data<br> <br> 2) Not at all (altough what you ask is not clear)<br> Physical chunk??? there is no such... chunks are just chunks (another l= ayer in the DB) If the chunk already exists, onspaces complains. Also, = onspaces will NOT auto-ren

Hi there buddies Mark and Ravi (and everyone else out there) I know you can add chunks to ROOTDBS What I wrote is in regard to growing the size of the rootdbs chunk itself. Example: If rootdbs chunk /dev/rraw_rootdbs has a size of 64 MB and ROOTDBS on it has same size, you could grow the raw device to whatever size you want, but Informix will still take up only the original 64 MB, even modifying ROOTSIZE value, unless we proceed as stated in previous post. hope it's clear now. thanks for the advice anyways