Re: help needed with ISM/onBar/IDS7.3 on NT

From: Dave Crane <ulunum@bigfoot.com> > >I'm trying to set up IDS7.3 on NT. I'm using command-line in the DOS window >hanging off the Start Menu | Programs | Informix menu (the one that sets >all the environment variables). I don't have IECC or the ISM gui manager >tools. > >After running a standard install, the DB logical logs are all full, and the >DB is locked. I'm using JDBC to talk to it, and can connect to the data >server fine, and query the sys table, but I can't do anything until I flush >the logs. > >onstat -l reports >--------------------------- >Informix Dynamic Server Version 7.31.TC7 -- On-Line (CKPT REQ) -- Up >17:42:3 > -- 9536 Kbytes>Blocked:CKPT > >Physical Logging >Buffer bufused bufsize numpages numwrits pages/io > P-2 0 8 0 0 0.00 > phybegin physize phypos phyused %used > 10003f 500 395 0 0.00 > >Logical Logging >Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-1 1 8 1 1 1 1.0 1.0 > Subsystem numrecs Log Space used > OLDRSAM 1 32 > >Buffer Waiting >Buffer ioproc flags > L-1 c19e018 0x1 0 > >address number flags uniqid begin size used %used >c038c08 1 U------ 1 100233 125 125 100.00 >c038c24 2 U------ 2 1002b0 125 125 100.00 >c038c40 3 U------ 3 10032d 125 125 100.00 >c038c5c 4 U------ 4 1003aa 125 125 100.00 >c038c78 5 U------ 5 100427 125 125 100.00 >c038c94 6 U------ 6 1004a4 125 125 100.00 >c038cb0 7 U------ 7 100521 125 125 100.00 >c038ccc 8 U-----L 8 10059e 125 125 100.00 >c038ce8 9 U------ 9 10061b 125 125 100.00 >c038d04 10 U---C-- 10 100698 125 125 100.00 >--------------------------- >(I haven't altered log size, number etc. These are the settings provided by >install. Oddly, I've noticed that the ONCONFIG file states: > ># Logical Log Configuration > >LOGFILES 10 # Number of logical log files >LOGSIZE 500 # Logical log size (Kbytes)> >so why does onstat report log size as 125??) onstat gives the size in pages, and a page on NT is 4K. >I need to back up to the file system rather than to tape. Looks like I need >to use onBar and ISM to do this. I've gone through the pdf's on the Answers >CD and done the following to configure these two: > >1] made a couple of directories >d:\\informix\\archive\\em_sys for data backup >d:\\informix\\archive\\em_logs for log backup > > >2] in ONCONFIG file: > ># System Archive Tape Device > >TAPEDEV d:\\informix\\archive\\em_sys # Tape device path >LTAPEDEV d:\\informix\\archive\\em_logs # Tape device path > >to tell onbar which devices to mount. I stop and start the IDS service, and >the messages file notes the change in TAPEDEV & LTAPEDEV No it doesn't -- these parameters are for ontape, not onbar. >3] configured the directories as devices in ism as follows > >ism_add -device d:\\informix\\archive\\em_sys -type file >ism_op -label -device d:\\informix\\archive\\em_sys -volume datbak -pool >ISMData >ism_op -mount d:\\informix\\archive\\em_sys > >and similarly for the em_sys (labelled as llbak) > >ism_show -devices now reports: >----------------------------------------------- >(nothing) mounted on 4mm tape \\\\.\\Tape0 >file disk llbak mounted on d:\\informix\\archive\\em_logs, write enabled >file disk datbak mounted on d:\\informix\\archive\\em_sys, write enabled >----------------------------------------------- > >4] When I run onbar -l it returns very quickly with no output, but the >onstat -l still reports all logs as full. So does messages file when I stop >and restart the server, i.e.> >'10:32:07 Logical Log Files are Full -- Backup is Needed' > > > >I've managed to free it up temporarily by setting TAPEDEV and LTAPEDEV to >NUL (a.k.a. /dev/null on Unix/Linux) - this has released one log and >allowed me to run the stores7 demo script successfully, but once I put some >real data into the thing, I'd like to be able to back it up (and the docs >say don't use that /dev/null trick with ONBAR :o{ ) No, but you can use onbar -b -F for "null archives" >Have I omitted any crucial steps? Can anyone help me?? What happens if you run ontape -s -L 0 ? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.