help needed with ISM/onBar/IDS7.3 on NT
Posted in 2000
Topics: Backup & Restore, Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Server Administration, Logging & Checkpoints
Hi,
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 KbytesBlocked: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??)
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
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{ )
Have I omitted any crucial steps? Can anyone help me??
Thanks in advance,
Dave Crane - ulunum@bigfoot.com
_______________________________________________________________________
Free Unlimited Internet Access! Try it now!
http://www.zdnet.com/downloads/altavista/index.html
_______________________________________________________________________