Need Info on tbtape/tbstat
I need to write a program to automatically know what level of
archive needs to be done. I am trying to read the
${INFORMIXDIR}/turbo.log to see the messages indicating when
the last archive completed.
The turbo.log and the tbmonitor status/archive does not really match.
Is there somewhere else I should be looking?
I would rather use system log information if it exists, rather
than maintain my own.
If turbo.log is where I look, what are the relevant log messages I
should be parsing and interpreting.
If I am doing an archive once a day, do I need to backup the
logs? If there is a system crash, will the logs be needed?
Once I do an archive, are the logs sync'd?
If I am doing the daily archives, can I backup the logs to /dev/null
to free them up.
I need to get this tool written in a couple of weeks, so all
information is greatly appreciated.
The status from tbmonmitor status Archive shows:
ARCHIVE INFORMATION
Level of Date and Time Logical Log Used
Archive of Archive at Time of Archive
0 Mon Nov 16 15:24:16 1992 139
1 Mon Nov 16 18:35:21 1992 139
2 0
The turbo.log shows:
Mon Nov 16 10:20:17 1992
10:20:17 Checkpoint Completed
10:25:36 Checkpoint Completed
12:01:36 Checkpoint Completed
13:32:18 Checkpoint Completed
13:37:37 Checkpoint Completed
13:42:57 Checkpoint Completed
14:04:17 Checkpoint Completed
14:14:57 Checkpoint Completed
14:20:16 Checkpoint Completed
14:25:37 Checkpoint Completed
14:30:02 Logical Log 138 Complete
14:30:57 Checkpoint Completed
14:36:16 Checkpoint Completed
14:41:37 Checkpoint Completed
14:46:57 Checkpoint Completed
14:52:16 Checkpoint Completed
14:57:37 Checkpoint Completed
15:02:57 Checkpoint Completed
15:08:16 Checkpoint Completed
15:18:57 Checkpoint Completed
15:24:17 Checkpoint Completed
18:26:54 Level 0 Archive Cancelled
18:27:13 Level 0 Archive Started
18:28:11 Checkpoint Completed
18:28:27 Checkpoint Completed
18:28:52 Checkpoint Completed
18:29:29 Checkpoint Completed
18:29:54 Checkpoint Completed
18:30:17 Checkpoint Completed
18:30:40 Checkpoint Completed
18:31:05 Checkpoint Completed
18:31:28 Checkpoint Completed
18:31:55 Checkpoint Completed
18:32:20 Checkpoint Completed
18:32:45 Checkpoint Completed
18:33:10 Checkpoint Completed
18:33:40 Checkpoint Completed
18:35:22 Checkpoint Completed
18:35:23 Level 0 Archive Completed
19:19:26 Level 0 Archive Cancelled
19:21:04 Process Aborted Abnormally: pid=12033 user=162 us=1012a4 flags=101
19:24:16 Process Aborted Abnormally: pid=12050 user=162 us=1012a4 flags=101
19:25:39 Level 1 Archive Started
19:28:21 Checkpoint Completed
19:28:22 Level 1 Archive Completed
19:31:55 Level 1 Archive Started
19:32:43 Level 1 Archive Cancelled
19:32:56 Logical Log 139 Complete
19:33:15 Logical Log 140 Complete
19:33:42 Logical Log 141 Complete
19:33:42 Checkpoint Completed
19:36:39 Level 0 Archive Cancelled
19:39:12 Checkpoint Completed
20:01:52 Shutdown Mode
20:02:33 Quiescent Mode
20:02:44 INFORMIX-OnLine Stopped
--
mikep@adaclabs.com (Michael Pechner) | Pizza Probably The Worlds Most
Adac Labs | Perfect Food.
Milpitas, Ca | Carbo, Meat, Dairy, And Veggie