IDS 7.31 resize drop and recreate new logical logs

Hi All, I am having problem on our OLD IDS 7.31. I would like to drop the smaller logical logs and create new bigger logical logs. Here are my inquiries: 1. I read a book "Informix Survival Guide" and it says that resizing the logical logs in 7.31, the DB needs to be re-initialized? is it true? Does this mean, i need to rebuild the DB from scratch again? 2. Does 7.31 IDS, needs to be in "Quiescent" mode in order to add/remove logical logs? in IDS 9.4 up, i didn't set the DB instance in Quiescent mode. I need your help badly.. thanks,

I don't remember having to bring the engine to quiescent just to add logical logs in 7.31 and earlier and as far as I remember you could always just add new logs of a different size then drop the old ones. There was a point before which you had to take an archive to activate new logs, but IB that was earlier than 7.31. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Apr 12, 2013 at 4:53 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > I am having problem on our OLD IDS 7.31. I would like to drop the smaller > logical logs and create new bigger logical logs. > > Here are my inquiries: > > 1. I read a book "Informix Survival Guide" and it says that resizing the > logical logs in 7.31, the DB needs to be re-initialized? is it true? Does > this > mean, i need to rebuild the DB from scratch again? > > 2. Does 7.31 IDS, needs to be in "Quiescent" mode in order to add/remove > logical logs? > > in IDS 9.4 up, i didn't set the DB instance in Quiescent mode. > > I need your help badly.. > > thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04016b496e4a9004da27691e

Really? You would be very happy to upgrade to a newer version, mainly because of performance benefits, and also the new features you could use. Consider this, IDS 7.31 is tooooooooooooooo old. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: informix2009@gmail.com > Subject: IDS 7.31 resize drop and recreate new logical logs [30043] > Date: Fri, 12 Apr 2013 04:53:39 -0400 > > Hi All, > > I am having problem on our OLD IDS 7.31. I would like to drop the smaller > logical logs and create new bigger logical logs. > > Here are my inquiries: > > 1. I read a book "Informix Survival Guide" and it says that resizing the > logical logs in 7.31, the DB needs to be re-initialized? is it true? Does this > mean, i need to rebuild the DB from scratch again? > > 2. Does 7.31 IDS, needs to be in "Quiescent" mode in order to add/remove > logical logs? > > in IDS 9.4 up, i didn't set the DB instance in Quiescent mode. > > I need your help badly.. > > thanks, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thanks Art, Here's what i've got when i tried to add logical log: => onstat - IBM Informix Dynamic Server Version 7.31.FD8X5 -- On-Line => onstat -d|grep " 2 "700000050081f28 2 1 2 1 N informix logdbs01 700000050080f38 2 2 0 524287 24234 PO- /dev/logdbsl01 This is the error i've got: => onparams -a -d logdbs01 -s 10000 IBM Informix Dynamic Server must be in quiescent mode. I tried to drop log number 10, but getting the same error: address number flags uniqid begin size used %used 700000013d8b320 1 U-B---- 1099 200035 50000 50000 100.00 700000013d8b340 2 U-B---- 1100 20c385 50000 50000 100.00 700000013d8b360 3 U-B---- 1101 2186d5 50000 50000 100.00 700000013d8b380 4 U-B---- 1102 224a25 50000 50000 100.00 700000013d8b3a0 5 U-B---- 1103 230d75 50000 50000 100.00 700000013d8b3c0 6 U---C-L 1104 23d0c5 50000 36982 73.96 700000013d8b3e0 7 U-B---- 1095 249415 50000 50000 100.00 700000013d8b400 8 U-B---- 1096 255765 50000 50000 100.00 700000013d8b420 9 U-B---- 1097 261ab5 50000 50000 100.00 700000013d8b440 10 U-B---- 1098 26de05 50000 50000 100.00 => onparams -d -l 10 IBM Informix Dynamic Server must be in quiescent mode. Quiescent mode is all the users currently connected will be disconnected.

Getting old and forgetful I guess. I agree with Jack BTW past time to relicense and upgrade. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Apr 12, 2013 at 7:09 AM, JACK PAPA <informix2009@gmail.com> wrote: > Thanks Art, > > Here's what i've got when i tried to add logical log: > > => onstat - > > IBM Informix Dynamic Server Version 7.31.FD8X5 -- On-Line > > => onstat -d|grep " 2 "> 700000050081f28 2 1 2 1 N informix logdbs01 > 700000050080f38 2 2 0 524287 24234 PO- /dev/logdbsl01 > > This is the error i've got: > > => onparams -a -d logdbs01 -s 10000 > IBM Informix Dynamic Server must be in quiescent mode. > > I tried to drop log number 10, but getting the same error: > > address number flags uniqid begin size used %used > 700000013d8b320 1 U-B---- 1099 200035 50000 50000 100.00 > 700000013d8b340 2 U-B---- 1100 20c385 50000 50000 100.00 > 700000013d8b360 3 U-B---- 1101 2186d5 50000 50000 100.00 > 700000013d8b380 4 U-B---- 1102 224a25 50000 50000 100.00 > 700000013d8b3a0 5 U-B---- 1103 230d75 50000 50000 100.00 > 700000013d8b3c0 6 U---C-L 1104 23d0c5 50000 36982 73.96 > 700000013d8b3e0 7 U-B---- 1095 249415 50000 50000 100.00 > 700000013d8b400 8 U-B---- 1096 255765 50000 50000 100.00 > 700000013d8b420 9 U-B---- 1097 261ab5 50000 50000 100.00 > 700000013d8b440 10 U-B---- 1098 26de05 50000 50000 100.00 > > => onparams -d -l 10 > IBM Informix Dynamic Server must be in quiescent mode. > > Quiescent mode is all the users currently connected will be disconnected. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160b90629e2c004da28249b

Hi Art, Thank you for your reply. Here's what i've got when trying to add/drop logfile. => onstat - Informix Dynamic Server Version 7.31.FD1XC -- On-Line -- => onparams -a -d logdbs01 -s 10000 Informix Dynamic Server must be in quiescent mode. [informix]:/appl/informix => onstat -l ............................... address number flags uniqid begin size used %used 7000000006d3138 1 U-B---- 529 200035 50000 23 0.05 7000000006d3158 2 U-B---- 530 20c385 50000 549 1.10 7000000006d3178 3 U-B---- 531 2186d5 50000 746 1.49 7000000006d3198 4 U---C-L 532 224a25 50000 51 0.10 7000000006d31b8 5 U-B---- 523 230d75 50000 15 0.03 7000000006d31d8 6 U-B---- 524 23d0c5 50000 557 1.11 7000000006d31f8 7 U-B---- 525 249415 50000 729 1.46 7000000006d3218 8 U-B---- 526 255765 50000 20 0.04 7000000006d3238 9 U-B---- 527 261ab5 50000 556 1.11 7000000006d3258 10 U-B---- 528 26de05 50000 729 1.46 ---- dropping logical log number 10 => onparams -d -l 10 Informix Dynamic Server must be in quiescent mode.

Thanks Art. I really appreciate your time and effort replying to multiple inquiries here in iiug. I'll check all the options from the business side. Best Regards, Jack

On 12 Apr 2013, at 09:53, JACK PAPA <informix2009@gmail.com> wrote: > > I am having problem on our OLD IDS 7.31. I would like to drop the smaller > logical logs and create new bigger logical logs. > > Here are my inquiries: > > 1. I read a book "Informix Survival Guide" and it says that resizing the > logical logs in 7.31, the DB needs to be re-initialized? is it true? Does this > mean, i need to rebuild the DB from scratch again? No. You can add the new logs, do a backup, drop the old logs. > > 2. Does 7.31 IDS, needs to be in "Quiescent" mode in order to add/remove > logical logs? > No. > in IDS 9.4 up, i didn't set the DB instance in Quiescent mode. > > I need your help badly.. > > thanks, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Yes you can add logical logs of different sizes thru onparams not onmonitor that onlu allows you do that based on the initial log size; you have to do a backup (ontape or onbar) to make the new logs available for use. However, you need to be in Quiescent mode to do that in IDS 7.31. In newer versions, adding a logical log can be done online without needing to be in quiescent mode. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 13/04/13 02:13, Spokey Wheeler Gmail a écrit : > On 12 Apr 2013, at 09:53, JACK PAPA<informix2009@gmail.com> wrote: > >> I am having problem on our OLD IDS 7.31. I would like to drop the smaller >> logical logs and create new bigger logical logs. >> >> Here are my inquiries: >> >> 1. I read a book "Informix Survival Guide" and it says that resizing the >> logical logs in 7.31, the DB needs to be re-initialized? is it true? Does > this >> mean, i need to rebuild the DB from scratch again? > No. You can add the new logs, do a backup, drop the old logs. > >> 2. Does 7.31 IDS, needs to be in "Quiescent" mode in order to add/remove >> logical logs? >> > No. > >> in IDS 9.4 up, i didn't set the DB instance in Quiescent mode. >> >> I need your help badly.. >> >> thanks, >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >