Filter
Top Products
ReadiVoice Administration & Maintenance Guide
100 Proprietary & Confidential
Figure 4-3 Checking Informix users
6 Check logging by entering
onstat -l
.
Informix displays information about physical and logical logging of the
database. Figure 4-4 shows an example.
In the flags column, logical logs that have not been used (if any) are
marked
F------
. Logs that have been used and backed up, and therefore
are available for reuse, are marked
U-B----
. The log to which Informix is
currently writing is marked
U---C-L
. Logical logs that are full, but have
not been backed up are marked
U------
.
ragnar </rahome> cnow> onstat -u
Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 12 days 19:29:52 --
34960 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
ba94018 ---P--D 1 informix - 0 0 0 14 4209
ba944cc ---P--F 0 informix - 0 0 0 0 3577
ba94980 ---P--F 0 informix - 0 0 0 0 1619
ba94e34 ---P--F 0 informix - 0 0 0 0 0
ba973d4 Y--P--- 1172 web - bbddf18 0 1 0 0
ba97888 Y--P--- 1074 root 4 bb91e30 0 1 0 271
ba97d3c ---P--D 13 informix - 0 0 0 0 0
ba981f0 Y--P--- 1075 root 4 bca7b28 0 1 0 15
ba986a4 Y--P--- 1073 root 4 bb91760 0 1 0 0
ba98b58 Y--P--- 1183 patrol - bbad500 0 1 0 9
17 active, 128 total, 25 maximum concurrent
ragnar </rahome> cnow>
Caution!
If more than one entry is marked U------, the logical logs aren’t being backed up.
Once all the log files reach this condition, Informix stops! Reread “Logical Logs” on
page 94 if necessary and be sure you’re set up properly for logical log backup (or
are redirecting the log files to /dev/null). Then, restart logical log backup as
described in “Restarting Backup and Verifying Tape Drive Status” on page 102.