Oninit cdi / Archive
Talk to an expert →

ontape -r idle

Posted in 2009

Summary

A user on IDS 7.31.UD6 ran 'ontape -r' from a disk-based level-0 archive; the restore appeared to finish without errors but the server sat in Fast Recovery (CKPT REQ), Blocked:CKPT, with almost no I/O. Advice was to check I/O progress (iostat, onstat -u/-D) to confirm nothing was still moving. Art Kagel said this is expected after a physical restore: the engine is waiting for 'onmode -m' to finish recovery and go online, and shutting down first can wreck the instance. Kern Doe doubted onmode -m works while blocked on CKPT; Fernando Nunes noted you can restart with 'oninit -r', force logical recovery, then onmode -m. The original poster never confirmed the outcome.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Backup & Restore, Storage & Space Management

CHEE KHUAN LEONG — — source: IIUG Forums & Mailing Lists

Hi, When i run ontape -r to restore database, it didn't return any abnormallies, but it remain hangs/idle. Server remain at Fast recovery mode and i am able to run onstat command. Please help. I have paste the output and error log information below. Kindly review. Thanks # ontape -r Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: Informix Dynamic Server Version 7.31.UD6 Archive date: Thu Mar 5 02:30:08 2009 User id: informix Terminal id: ? Archive level: 0 Tape device: /ifmx_bkup/uk/lvl0/lvl_zero Tape blocksize (in k): 1024 Tape size (in k): 2000000 Tape number in series: 1 Continue restore? (y/n)y Do you want to back up the logs? (y/n)n ======================================================================== Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- Up 00:21:07 -- 65984 Kbytes Blocked:CKPT ========================================================================== Fri Mar 6 01:46:13 2009 01:46:13 Event alarms enabled. ALARMPROG = '/shared/informix/live/etc/log_full_null.sh' 01:46:19 DR: DRAUTO is 0 (Off) 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB 01:46:19 Dynamically allocated new message shared memory segment (size 608KB) 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number AAD#J345056 01:46:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. 01:46:21 Dataskip is now OFF for all dbspaces 01:46:21 Restartable Restore has been DISABLED 01:46:21 Recovery Mode

↪ replying to CHEE KHUAN LEONG
jak aka — — source: IIUG Forums & Mailing Lists

Any I/O progress ? you can use iostat ,vmpstat, mpstat and onstat -u to see if any I/O perform progress. You can see the log of Tape manager buf if your tape is disk, you can see I/O from iostat. If no movement , ontape might waiting for something. Check chunk or tape or config. (; Jakkrit A. ________________________________ From: CHEE KHUAN LEONG <cloudlck@hotmail.com> To: ids@iiug.org Sent: Friday, March 6, 2009 9:15:00 AM Subject: ontape -r idle [15055] Hi, When i run ontape -r to restore database, it didn't return any abnormallies, but it remain hangs/idle. Server remain at Fast recovery mode and i am able to run onstat command. Please help. I have paste the output and error log information below. Kindly review. Thanks # ontape -r Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: Informix Dynamic Server Version 7.31.UD6 Archive date: Thu Mar 5 02:30:08 2009 User id: informix Terminal id: ? Archive level: 0 Tape device: /ifmx_bkup/uk/lvl0/lvl_zero Tape blocksize (in k): 1024 Tape size (in k): 2000000 Tape number in series: 1 Continue restore? (y/n)y Do you want to back up the logs? (y/n)n ======================================================================== Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- Up 00:21:07 -- 65984 Kbytes Blocked:CKPT ========================================================================== Fri Mar 6 01:46:13 2009 01:46:13 Event alarms enabled. ALARMPROG = '/shared/informix/live/etc/log_full_null.sh' 01:46:19 DR: DRAUTO is 0 (Off) 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB 01:46:19 Dynamically allocated new message shared memory segment (size 608KB) 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number AAD#J345056 01:46:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. 01:46:21 Dataskip is now OFF for all dbspaces 01:46:21 Restartable Restore has been DISABLED 01:46:21 Recovery Mode ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to jak aka
CHEE KHUAN LEONG — — source: IIUG Forums & Mailing Lists

Hi, Look like the ontape is idle. Only slight i/o happen on rootdbs. Will it be caused by tape copy? onstat -u =========Userthreads address flags sessid user tty wait tout locks nreads nwrites c056018 ---P--D 1 informix - 0 0 0 14 5 c056514 ---P--F 0 informix - 0 0 0 0 0 c056a10 ---P--F 0 informix - 0 0 0 0 0 c056f0c ---P--F 0 informix - 0 0 0 0 0 c057408 ---P--F 0 informix - 0 0 0 0 0 c057904 ---P--F 0 informix - 0 0 0 0 0 c057e00 ---P--F 0 informix - 0 0 0 0 0 c0582fc ---P--F 0 informix - 0 0 0 0 0 c0587f8 ---P--F 0 informix - 0 0 0 0 0 c058cf4 ---P--F 0 informix - 0 0 0 0 0 c0591f0 ---P--F 0 informix - 0 0 0 0 0 c0596ec ---P--F 0 informix - 0 0 0 0 0 c059be8 ---P--F 0 informix - 0 0 0 0 0 c05a0e4 ---P--F 0 informix - 0 0 0 0 0 c05a5e0 ---P--F 0 informix - 0 0 0 0 0 c05aadc ---P--F 0 informix - 0 0 0 0 0 c05afd8 ---P--F 0 informix - 0 0 0 0 0 c05b4d4 ---P--F 0 informix - 0 0 0 0 0 c05b9d0 ---P--F 0 informix - 0 0 0 0 0 c05becc ---P--F 0 informix - 0 0 0 0 0 c05c3c8 ---P--F 0 informix - 0 0 0 0 0 c05c8c4 ---P--F 0 informix - 0 0 0 0 0 c05cdc0 ---P--F 0 informix - 0 0 0 0 0 c05d2bc ---P--F 0 informix - 0 0 0 0 0 c05d7b8 ---P--F 0 informix - 0 0 0 0 0 c05dcb4 ---P--F 0 informix - 0 0 0 0 0 c05e1b0 ---P--F 0 informix - 0 0 0 0 0 c05e6ac ---P--F 0 informix - 0 0 0 0 0 c05eba8 ---P--F 0 informix - 0 0 0 0 0 c05f0a4 ---P--F 0 informix - 0 0 0 0 0 c05f5a0 ---P--F 0 informix - 0 0 0 0 0 c05fa9c ---P--F 0 informix - 0 0 0 0 0 c05ff98 ---P--F 0 informix - 0 0 0 0 1 c060494 ---P--- 15 informix - 0 0 0 0 0 c060990 ---P--B 16 informix - 0 0 0 0 0 c060e8c ---P--D 17 informix - 0 0 0 0 0 ============================================================================ onstat -D ========= c054210 1 1 0 14 6 /cerb/opt/ifx/cerberus/chnks/uk_rootdbs c055210 2 2 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_llog_dbs c055310 3 3 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_plog_dbs c055410 4 4 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_tmp_dbs1 c055510 5 5 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_tmp_dbs2 c055610 6 6 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_tmp_dbs3 c055710 7 7 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_sendq c055810 8 8 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_recvq c055910 9 9 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_db_dbs c055a10 10 10 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs1 c055b10 11 11 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs2 c055c10 12 12 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs3 c055d10 13 13 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs4 c055e10 14 14 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs5 c055f10 15 15 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs6 c07de30 16 16 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs7 c089630 17 17 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs8 c089730 18 18 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs9 c089830 19 19 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_audit_dbs1 c089930 20 20 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs10 c089a30 21 10 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs1_2 c089b30 22 11 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs2_2 c089c30 23 12 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs3_2 c089d30 24 13 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs4_2 c089e30 25 14 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs5_2 c842018 26 15 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs6_2 c842118 27 16 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs7_2 c842218 28 17 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs8_2 c842318 29 18 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs9_2 c842418 30 20 0 0 0 /cerb/opt/ifx/cerberus/chnks/uk_data_dbs10_2

↪ replying to CHEE KHUAN LEONG
Art Kagel — — source: IIUG Forums & Mailing Lists

Good, now run: omnode -m To complete fast recovery and bring the server to full online mode. Art On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG <cloudlck@hotmail.com>wrote: > Hi, > When i run ontape -r to restore database, it didn't return any > abnormallies, > but it remain hangs/idle. Server remain at Fast recovery mode and i am able > to > run onstat command. Please help. I have paste the output and error log > information below. Kindly review. Thanks > > # ontape -r> > Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue > ... > > Archive Tape Information > > Tape type: Archive Backup Tape > Online version: Informix Dynamic Server Version 7.31.UD6 > Archive date: Thu Mar 5 02:30:08 2009 > User id: informix > Terminal id: ? > Archive level: 0 > Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > Tape blocksize (in k): 1024 > Tape size (in k): 2000000 > Tape number in series: 1 > > Continue restore? (y/n)y > Do you want to back up the logs? (y/n)n > > ======================================================================== > Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- Up > 00:21:07 -- 65984 Kbytes > Blocked:CKPT > ========================================================================== > Fri Mar 6 01:46:13 2009 > > 01:46:13 Event alarms enabled. ALARMPROG = > '/shared/informix/live/etc/log_full_null.sh' > 01:46:19 DR: DRAUTO is 0 (Off) > 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB > 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB > 01:46:19 Dynamically allocated new message shared memory segment (size > 608KB) > 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number > AAD#J345056 > 01:46:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. > 01:46:21 Dataskip is now OFF for all dbspaces > 01:46:21 Restartable Restore has been DISABLED > 01:46:21 Recovery Mode > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016364eca9eb461cd04647515a5

↪ replying to CHEE KHUAN LEONG
Art Kagel — — source: IIUG Forums & Mailing Lists

Ooops typo. That should be: onmode -m Art On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > Good, now run: > > omnode -m > > To complete fast recovery and bring the server to full online mode. > > Art > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG <cloudlck@hotmail.com>wrote: > >> Hi, >> When i run ontape -r to restore database, it didn't return any >> abnormallies, >> but it remain hangs/idle. Server remain at Fast recovery mode and i am >> able to >> run onstat command. Please help. I have paste the output and error log >> information below. Kindly review. Thanks >> >> # ontape -r>> >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue >> ... >> >> Archive Tape Information >> >> Tape type: Archive Backup Tape >> Online version: Informix Dynamic Server Version 7.31.UD6 >> Archive date: Thu Mar 5 02:30:08 2009 >> User id: informix >> Terminal id: ? >> Archive level: 0 >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero >> Tape blocksize (in k): 1024 >> Tape size (in k): 2000000 >> Tape number in series: 1 >> >> Continue restore? (y/n)y >> Do you want to back up the logs? (y/n)n >> >> ======================================================================== >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- Up >> 00:21:07 -- 65984 Kbytes >> Blocked:CKPT >> ========================================================================== >> Fri Mar 6 01:46:13 2009 >> >> 01:46:13 Event alarms enabled. ALARMPROG = >> '/shared/informix/live/etc/log_full_null.sh' >> 01:46:19 DR: DRAUTO is 0 (Off) >> 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB >> 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB >> 01:46:19 Dynamically allocated new message shared memory segment (size >> 608KB) >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number >> AAD#J345056 >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. >> 01:46:21 Dataskip is now OFF for all dbspaces >> 01:46:21 Restartable Restore has been DISABLED >> 01:46:21 Recovery Mode >> >> >> >> ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016361e813458c774046475183a

↪ replying to Art Kagel
Kern Doe — — source: IIUG Forums & Mailing Lists

Is this problem resolved, I'm just curious to know? correct me if I'm wrong Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you cannot run "onmode -m" yet, it will not work. you will have to wait for this "Fast Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it may never be finished for some reasons, perhaps, not having the right tapes, etc... ________________________________ From: Art Kagel <art.kagel@gmail.com> To: ids@iiug.org Sent: Friday, March 6, 2009 10:39:57 AM Subject: Re: ontape -r idle [15059] Ooops typo. That should be: onmode -m Art On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > Good, now run: > > omnode -m > > To complete fast recovery and bring the server to full online mode. > > Art > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG <cloudlck@hotmail.com>wrote: > >> Hi, >> When i run ontape -r to restore database, it didn't return any >> abnormallies, >> but it remain hangs/idle. Server remain at Fast recovery mode and i am >> able to >> run onstat command. Please help. I have paste the output and error log >> information below. Kindly review. Thanks >> >> # ontape -r>> >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue >> ... >> >> Archive Tape Information >> >> Tape type: Archive Backup Tape >> Online version: Informix Dynamic Server Version 7.31.UD6 >> Archive date: Thu Mar 5 02:30:08 2009 >> User id: informix >> Terminal id: ? >> Archive level: 0 >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero >> Tape blocksize (in k): 1024 >> Tape size (in k): 2000000 >> Tape number in series: 1 >> >> Continue restore? (y/n)y >> Do you want to back up the logs? (y/n)n >> >> ======================================================================== >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- Up >> 00:21:07 -- 65984 Kbytes >> Blocked:CKPT >> ========================================================================== >> Fri Mar 6 01:46:13 2009 >> >> 01:46:13 Event alarms enabled. ALARMPROG = >> '/shared/informix/live/etc/log_full_null.sh' >> 01:46:19 DR: DRAUTO is 0 (Off) >> 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB >> 01:46:19 Requested shared memory segment size rounded from 600KB to 608KB >> 01:46:19 Dynamically allocated new message shared memory segment (size >> 608KB) >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number >> AAD#J345056 >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. >> 01:46:21 Dataskip is now OFF for all dbspaces >> 01:46:21 Restartable Restore has been DISABLED >> 01:46:21 Recovery Mode >> >> >> >> ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016361e813458c774046475183a ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Kern Doe
Art Kagel — — source: IIUG Forums & Mailing Lists

It depends on the reason for the block. In the case of the fast recovery after a restore, the engine is actually waiting for you to run onmode -m. If you shutdown before doing that the engine is hosed. Art On Fri, Mar 6, 2009 at 10:03 PM, Kern Doe <kern_doe@yahoo.com> wrote: > Is this problem resolved, I'm just curious to know? correct me if I'm wrong > Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you > cannot > run "onmode -m" yet, it will not work. you will have to wait for this "Fast > Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it > may > never be finished for some reasons, perhaps, not having the right tapes, > etc... > > ________________________________ > From: Art Kagel <art.kagel@gmail.com> > To: ids@iiug.org > Sent: Friday, March 6, 2009 10:39:57 AM > Subject: Re: ontape -r idle [15059] > > Ooops typo. That should be: > > onmode -m> > Art > > On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > Good, now run: > > > > omnode -m > > > > To complete fast recovery and bring the server to full online mode. > > > > Art > > > > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG > <cloudlck@hotmail.com>wrote: > > > >> Hi, > >> When i run ontape -r to restore database, it didn't return any > >> abnormallies, > >> but it remain hangs/idle. Server remain at Fast recovery mode and i am > >> able to > >> run onstat command. Please help. I have paste the output and error log > >> information below. Kindly review. Thanks > >> > >> # ontape -r> >> > >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue > >> ... > >> > >> Archive Tape Information > >> > >> Tape type: Archive Backup Tape > >> Online version: Informix Dynamic Server Version 7.31.UD6 > >> Archive date: Thu Mar 5 02:30:08 2009 > >> User id: informix > >> Terminal id: ? > >> Archive level: 0 > >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > >> Tape blocksize (in k): 1024 > >> Tape size (in k): 2000000 > >> Tape number in series: 1 > >> > >> Continue restore? (y/n)y > >> Do you want to back up the logs? (y/n)n > >> > >> ======================================================================== > >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) -- > Up > >> 00:21:07 -- 65984 Kbytes > >> Blocked:CKPT > >> > ========================================================================== > >> Fri Mar 6 01:46:13 2009 > >> > >> 01:46:13 Event alarms enabled. ALARMPROG = > >> '/shared/informix/live/etc/log_full_null.sh' > >> 01:46:19 DR: DRAUTO is 0 (Off) > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > 608KB > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > 608KB > >> 01:46:19 Dynamically allocated new message shared memory segment (size > >> 608KB) > >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial Number > >> AAD#J345056 > >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory > Initialized. > >> 01:46:21 Dataskip is now OFF for all dbspaces > >> 01:46:21 Restartable Restore has been DISABLED > >> 01:46:21 Recovery Mode > >> > >> > >> > >> > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > organization with which I am associated either explicitly or implicitly. > > Neither do those opinions reflect those of other individuals affiliated > > with any entity with which I am affiliated nor those of the entities > > themselves. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > --0016361e813458c774046475183a > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --001636426b391b9c900464950278

↪ replying to Art Kagel
Fernando Nunes — — source: IIUG Forums & Mailing Lists

Not necessarily. You can bring it up with "oninit -r". After that it's possible to force logical revovery, and then "onmode -m" Regards. On Sun, Mar 8, 2009 at 5:44 AM, Art Kagel <art.kagel@gmail.com> wrote: > It depends on the reason for the block. In the case of the fast recovery > after a restore, the engine is actually waiting for you to run onmode -m. > If you shutdown before doing that the engine is hosed. > > Art > > On Fri, Mar 6, 2009 at 10:03 PM, Kern Doe <kern_doe@yahoo.com> wrote: > > > Is this problem resolved, I'm just curious to know? correct me if I'm > wrong > > Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you > > cannot > > run "onmode -m" yet, it will not work. you will have to wait for this > "Fast > > Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it > > may > > never be finished for some reasons, perhaps, not having the right tapes, > > etc... > > > > ________________________________ > > From: Art Kagel <art.kagel@gmail.com> > > To: ids@iiug.org > > Sent: Friday, March 6, 2009 10:39:57 AM > > Subject: Re: ontape -r idle [15059] > > > > Ooops typo. That should be: > > > > onmode -m> > > > Art > > > > On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > Good, now run: > > > > > > omnode -m > > > > > > To complete fast recovery and bring the server to full online mode. > > > > > > Art > > > > > > > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG > > <cloudlck@hotmail.com>wrote: > > > > > >> Hi, > > >> When i run ontape -r to restore database, it didn't return any > > >> abnormallies, > > >> but it remain hangs/idle. Server remain at Fast recovery mode and i am > > >> able to > > >> run onstat command. Please help. I have paste the output and error log > > >> information below. Kindly review. Thanks > > >> > > >> # ontape -r> > >> > > >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to > continue > > >> ... > > >> > > >> Archive Tape Information > > >> > > >> Tape type: Archive Backup Tape > > >> Online version: Informix Dynamic Server Version 7.31.UD6 > > >> Archive date: Thu Mar 5 02:30:08 2009 > > >> User id: informix > > >> Terminal id: ? > > >> Archive level: 0 > > >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > > >> Tape blocksize (in k): 1024 > > >> Tape size (in k): 2000000 > > >> Tape number in series: 1 > > >> > > >> Continue restore? (y/n)y > > >> Do you want to back up the logs? (y/n)n > > >> > > >> > ======================================================================== > > >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) > -- > > Up > > >> 00:21:07 -- 65984 Kbytes > > >> Blocked:CKPT > > >> > > > ========================================================================== > > >> Fri Mar 6 01:46:13 2009 > > >> > > >> 01:46:13 Event alarms enabled. ALARMPROG = > > >> '/shared/informix/live/etc/log_full_null.sh' > > >> 01:46:19 DR: DRAUTO is 0 (Off) > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Dynamically allocated new message shared memory segment (size > > >> 608KB) > > >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial > Number > > >> AAD#J345056 > > >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory > > Initialized. > > >> 01:46:21 Dataskip is now OFF for all dbspaces > > >> 01:46:21 Restartable Restore has been DISABLED > > >> 01:46:21 Recovery Mode > > >> > > >> > > >> > > >> > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > >> > > > > > > > > > -- > > > Art S. Kagel > > > Oninit (www.oninit.com) > > > IIUG Board of Directors (art@iiug.org) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > > organization with which I am associated either explicitly or > implicitly. > > > Neither do those opinions reflect those of other individuals affiliated > > > with any entity with which I am affiliated nor those of the entities > > > themselves. > > > > > > > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity > > with which I am affiliated nor those of the entities themselves. > > > > --0016361e813458c774046475183a > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > --001636426b391b9c900464950278 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00221532c7583c463804649ebdf3

↪ replying to Fernando Nunes
jak aka — — source: IIUG Forums & Mailing Lists

Hi , I wonder : How do you know restoring is completed ? I have not seen any log of restoring in the onstat -m. Anyway , I not familiar w ________________________________ From: Fernando Nunes <domusonline@gmail.com> To: ids@iiug.org Sent: Monday, March 9, 2009 12:20:56 AM Subject: Re: ontape -r idle [15063] Not necessarily. You can bring it up with "oninit -r". After that it's possible to force logical revovery, and then "onmode -m" Regards. On Sun, Mar 8, 2009 at 5:44 AM, Art Kagel <art.kagel@gmail.com> wrote: > It depends on the reason for the block. In the case of the fast recovery > after a restore, the engine is actually waiting for you to run onmode -m. > If you shutdown before doing that the engine is hosed. > > Art > > On Fri, Mar 6, 2009 at 10:03 PM, Kern Doe <kern_doe@yahoo.com> wrote: > > > Is this problem resolved, I'm just curious to know? correct me if I'm > wrong > > Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you > > cannot > > run "onmode -m" yet, it will not work. you will have to wait for this > "Fast > > Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it > > may > > never be finished for some reasons, perhaps, not having the right tapes, > > etc... > > > > ________________________________ > > From: Art Kagel <art.kagel@gmail.com> > > To: ids@iiug.org > > Sent: Friday, March 6, 2009 10:39:57 AM > > Subject: Re: ontape -r idle [15059] > > > > Ooops typo. That should be: > > > > onmode -m> > > > Art > > > > On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > Good, now run: > > > > > > omnode -m > > > > > > To complete fast recovery and bring the server to full online mode. > > > > > > Art > > > > > > > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG > > <cloudlck@hotmail.com>wrote: > > > > > >> Hi, > > >> When i run ontape -r to restore database, it didn't return any > > >> abnormallies, > > >> but it remain hangs/idle. Server remain at Fast recovery mode and i am > > >> able to > > >> run onstat command. Please help. I have paste the output and error log > > >> information below. Kindly review. Thanks > > >> > > >> # ontape -r> > >> > > >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to > continue > > >> ... > > >> > > >> Archive Tape Information > > >> > > >> Tape type: Archive Backup Tape > > >> Online version: Informix Dynamic Server Version 7.31.UD6 > > >> Archive date: Thu Mar 5 02:30:08 2009 > > >> User id: informix > > >> Terminal id: ? > > >> Archive level: 0 > > >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > > >> Tape blocksize (in k): 1024 > > >> Tape size (in k): 2000000 > > >> Tape number in series: 1 > > >> > > >> Continue restore? (y/n)y > > >> Do you want to back up the logs? (y/n)n > > >> > > >> > ======================================================================== > > >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) > -- > > Up > > >> 00:21:07 -- 65984 Kbytes > > >> Blocked:CKPT > > >> > > > ========================================================================== > > >> Fri Mar 6 01:46:13 2009 > > >> > > >> 01:46:13 Event alarms enabled. ALARMPROG = > > >> '/shared/informix/live/etc/log_full_null.sh' > > >> 01:46:19 DR: DRAUTO is 0 (Off) > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Dynamically allocated new message shared memory segment (size > > >> 608KB) > > >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial > Number > > >> AAD#J345056 > > >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory > > Initialized. > > >> 01:46:21 Dataskip is now OFF for all dbspaces > > >> 01:46:21 Restartable Restore has been DISABLED > > >> 01:46:21 Recovery Mode > > >> > > >> > > >> > > >> > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > >> > > > > > > > > > -- > > > Art S. Kagel > > > Oninit (www.oninit.com) > > > IIUG Board of Directors (art@iiug.org) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > > organization with which I am associated either explicitly or > implicitly. > > > Neither do those opinions reflect those of other individuals affiliated > > > with any entity with which I am affiliated nor those of the entities > > > themselves. > > > > > > > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity > > with which I am affiliated nor those of the entities themselves. > > > > --0016361e813458c774046475183a > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > --001636426b391b9c900464950278 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00221532c7583c463804649ebdf3 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Fernando Nunes
jak aka — — source: IIUG Forums & Mailing Lists

Hi , I wonder : How do you know restoring is completed ? I have not seen any log of restoring in the onstat -m. Anyway , I not familiar with IDS.7.31 so I 'm not sure after ontape -r finish, IDS should be in on-line mode. ________________________________ From: Fernando Nunes <domusonline@gmail.com> To: ids@iiug.org Sent: Monday, March 9, 2009 12:20:56 AM Subject: Re: ontape -r idle [15063] Not necessarily. You can bring it up with "oninit -r". After that it's possible to force logical revovery, and then "onmode -m" Regards. On Sun, Mar 8, 2009 at 5:44 AM, Art Kagel <art.kagel@gmail.com> wrote: > It depends on the reason for the block. In the case of the fast recovery > after a restore, the engine is actually waiting for you to run onmode -m. > If you shutdown before doing that the engine is hosed. > > Art > > On Fri, Mar 6, 2009 at 10:03 PM, Kern Doe <kern_doe@yahoo.com> wrote: > > > Is this problem resolved, I'm just curious to know? correct me if I'm > wrong > > Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you > > cannot > > run "onmode -m" yet, it will not work. you will have to wait for this > "Fast > > Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it > > may > > never be finished for some reasons, perhaps, not having the right tapes, > > etc... > > > > ________________________________ > > From: Art Kagel <art.kagel@gmail.com> > > To: ids@iiug.org > > Sent: Friday, March 6, 2009 10:39:57 AM > > Subject: Re: ontape -r idle [15059] > > > > Ooops typo. That should be: > > > > onmode -m> > > > Art > > > > On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > Good, now run: > > > > > > omnode -m > > > > > > To complete fast recovery and bring the server to full online mode. > > > > > > Art > > > > > > > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG > > <cloudlck@hotmail.com>wrote: > > > > > >> Hi, > > >> When i run ontape -r to restore database, it didn't return any > > >> abnormallies, > > >> but it remain hangs/idle. Server remain at Fast recovery mode and i am > > >> able to > > >> run onstat command. Please help. I have paste the output and error log > > >> information below. Kindly review. Thanks > > >> > > >> # ontape -r> > >> > > >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to > continue > > >> ... > > >> > > >> Archive Tape Information > > >> > > >> Tape type: Archive Backup Tape > > >> Online version: Informix Dynamic Server Version 7.31.UD6 > > >> Archive date: Thu Mar 5 02:30:08 2009 > > >> User id: informix > > >> Terminal id: ? > > >> Archive level: 0 > > >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > > >> Tape blocksize (in k): 1024 > > >> Tape size (in k): 2000000 > > >> Tape number in series: 1 > > >> > > >> Continue restore? (y/n)y > > >> Do you want to back up the logs? (y/n)n > > >> > > >> > ======================================================================== > > >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) > -- > > Up > > >> 00:21:07 -- 65984 Kbytes > > >> Blocked:CKPT > > >> > > > ========================================================================== > > >> Fri Mar 6 01:46:13 2009 > > >> > > >> 01:46:13 Event alarms enabled. ALARMPROG = > > >> '/shared/informix/live/etc/log_full_null.sh' > > >> 01:46:19 DR: DRAUTO is 0 (Off) > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > 608KB > > >> 01:46:19 Dynamically allocated new message shared memory segment (size > > >> 608KB) > > >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial > Number > > >> AAD#J345056 > > >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory > > Initialized. > > >> 01:46:21 Dataskip is now OFF for all dbspaces > > >> 01:46:21 Restartable Restore has been DISABLED > > >> 01:46:21 Recovery Mode > > >> > > >> > > >> > > >> > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > >> > > > > > > > > > -- > > > Art S. Kagel > > > Oninit (www.oninit.com) > > > IIUG Board of Directors (art@iiug.org) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > > organization with which I am associated either explicitly or > implicitly. > > > Neither do those opinions reflect those of other individuals affiliated > > > with any entity with which I am affiliated nor those of the entities > > > themselves. > > > > > > > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity > > with which I am affiliated nor those of the entities themselves. > > > > --0016361e813458c774046475183a > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > --001636426b391b9c900464950278 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00221532c7583c463804649ebdf3 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to jak aka
R Fo — — source: IIUG Forums & Mailing Lists

Jak When you issue the command: ontape -r it show you a list of dbspaces and chunks in the beggining ? AFTER: Please mount tape 1 on /scratch/uk/lvl_zero and press Return to continue ... and BEFORE: Continue restore? (y/n)y Do you want to back up the logs? (y/n)n it should show you a list of dbspaces and chunks ... IF NOT , maybe you're using the wrong tape. If it is showed , the list of chunks should show you the total pages for each chunk and total pages USED for each chunk. As restore is running, in other session , you can issue the command: onstat -D to see the number of restored pages for each chunk. Please, let me know the Operational system ... Best regards R Ferronato > To: ids@iiug.org > From: jakkritakeng@yahoo.com > Subject: Re: ontape -r idle [15065] > Date: Mon, 9 Mar 2009 01:43:10 -0400 > > Hi , > I wonder : > How do you know restoring is completed ? > I have not seen any log of restoring in the onstat -m. > > Anyway , I not familiar with IDS.7.31 so I 'm not sure after ontape -r finish, > IDS should be in on-line mode. > > ________________________________ > From: Fernando Nunes <domusonline@gmail.com> > To: ids@iiug.org > Sent: Monday, March 9, 2009 12:20:56 AM > Subject: Re: ontape -r idle [15063] > > Not necessarily. You can bring it up with "oninit -r". > After that it's possible to force logical revovery, and then "onmode -m" > > Regards. > > On Sun, Mar 8, 2009 at 5:44 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > It depends on the reason for the block. In the case of the fast recovery > > after a restore, the engine is actually waiting for you to run onmode -m. > > If you shutdown before doing that the engine is hosed. > > > > Art > > > > On Fri, Mar 6, 2009 at 10:03 PM, Kern Doe <kern_doe@yahoo.com> wrote: > > > > > Is this problem resolved, I'm just curious to know? correct me if I'm > > wrong > > > Art, when the engine is in "Fast Recovery" with "Blocked" on CKPT you > > > cannot > > > run "onmode -m" yet, it will not work. you will have to wait for this > > "Fast > > > Recovery (CKPT REQ)" (or should we say "slow recovery") is finished or it > > > may > > > never be finished for some reasons, perhaps, not having the right tapes, > > > etc... > > > > > > ________________________________ > > > From: Art Kagel <art.kagel@gmail.com> > > > To: ids@iiug.org > > > Sent: Friday, March 6, 2009 10:39:57 AM > > > Subject: Re: ontape -r idle [15059] > > > > > > Ooops typo. That should be: > > > > > > onmode -m> > > > > > Art > > > > > > On Fri, Mar 6, 2009 at 10:39 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > > > Good, now run: > > > > > > > > omnode -m > > > > > > > > To complete fast recovery and bring the server to full online mode. > > > > > > > > Art > > > > > > > > > > > > On Thu, Mar 5, 2009 at 9:15 PM, CHEE KHUAN LEONG > > > <cloudlck@hotmail.com>wrote: > > > > > > > >> Hi, > > > >> When i run ontape -r to restore database, it didn't return any > > > >> abnormallies, > > > >> but it remain hangs/idle. Server remain at Fast recovery mode and i am > > > >> able to > > > >> run onstat command. Please help. I have paste the output and error log > > > >> information below. Kindly review. Thanks > > > >> > > > >> # ontape -r> > > >> > > > >> Please mount tape 1 on /scratch/uk/lvl_zero and press Return to > > continue > > > >> ... > > > >> > > > >> Archive Tape Information > > > >> > > > >> Tape type: Archive Backup Tape > > > >> Online version: Informix Dynamic Server Version 7.31.UD6 > > > >> Archive date: Thu Mar 5 02:30:08 2009 > > > >> User id: informix > > > >> Terminal id: ? > > > >> Archive level: 0 > > > >> Tape device: /ifmx_bkup/uk/lvl0/lvl_zero > > > >> Tape blocksize (in k): 1024 > > > >> Tape size (in k): 2000000 > > > >> Tape number in series: 1 > > > >> > > > >> Continue restore? (y/n)y > > > >> Do you want to back up the logs? (y/n)n > > > >> > > > >> > > ======================================================================== > > > >> Informix Dynamic Server Version 7.31.UD6 -- Fast Recovery (CKPT REQ) > > -- > > > Up > > > >> 00:21:07 -- 65984 Kbytes > > > >> Blocked:CKPT > > > >> > > > > > ========================================================================== > > > >> Fri Mar 6 01:46:13 2009 > > > >> > > > >> 01:46:13 Event alarms enabled. ALARMPROG = > > > >> '/shared/informix/live/etc/log_full_null.sh' > > > >> 01:46:19 DR: DRAUTO is 0 (Off) > > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > > 608KB > > > >> 01:46:19 Requested shared memory segment size rounded from 600KB to > > > 608KB > > > >> 01:46:19 Dynamically allocated new message shared memory segment (size > > > >> 608KB) > > > >> 01:46:20 Informix Dynamic Server Version 7.31.UD6 Software Serial > > Number > > > >> AAD#J345056 > > > >> 01:46:20 Informix Dynamic Server Initialized -- Shared Memory > > > Initialized. > > > >> 01:46:21 Dataskip is now OFF for all dbspaces > > > >> 01:46:21 Restartable Restore has been DISABLED > > > >> 01:46:21 Recovery Mode > > > >> > > > >> > > > >> > > > >> > > > > > > > > > > > > > > > ******************************************************************************* > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > >> > > > >> > > > > > > > > > > > > -- > > > > Art S. Kagel > > > > Oninit (www.oninit.com) > > > > IIUG Board of Directors (art@iiug.org) > > > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > > opinions > > > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > > > organization with which I am associated either explicitly or > > implicitly. > > > > Neither do those opinions reflect those of other individuals affiliated > > > > with any entity with which I am affiliated nor those of the entities > > > > themselves. > > > > > > > > > > > > > > -- > > > Art S. Kagel > > > Oninit (www.oninit.com) > > > IIUG Board of Directors (art@iiug.org) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > > and > > > do not reflect on my employer, Oninit, the IIUG, nor any other > > organization > > > with which I am associated either explicitly or implicitly. Neither do > > > those opinions reflect those of other individuals affiliated with any > > > entity > > > with which I am affiliated nor those of the entities themselves. > > > > > > --0016361e813458c774046475183a > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > *****************************************

Related threads

Glossary