online question
does anyone know how to interpret the online logfile flags. the following
if from todays log right after the system died (ungracefully):
11:19:02 Logical Log 6459 Complete
11:25:19 Checkpoint Completed
11:38:29 Checkpoint Completed
11:42:19 Logical Log 6460 Complete
11:53:17 Checkpoint Completed
12:08:56 Checkpoint Completed
12:13:05 Process Aborted Abnormally: pid=19554 user=1026 us=10002698 flags=101
12:13:05 Process Aborted Abnormally (critical section): pid=19554 user=1026 flags=101
12:13:05 INFORMIX-OnLine entering ABORT mode!!!
12:13:05 -- Online Aborting -- us=10001ba8, pid=6702, uid=0
12:13:19 INFORMIX-OnLine Stopped
Wed Feb 10 12:15:37 1993
12:15:37 INFORMIX-OnLine Initialized -- Shared Memory Initialized
12:15:37 Physical Recovery Started
12:17:22 Checkpoint Completed
12:17:22 Physical Recovery Complete: 6055 Pages Restored
12:17:25 Checkpoint Completed
12:17:25 Logical Recovery Complete 9 Committed, 5 Rolled Back, 0 Open, 0 Bad Locks
12:17:25 Checkpoint Completed
12:17:29 Dropping temporary tblspace 10004f0, recovering 1742 pages.
12:17:36 On-Line Mode
the user 1026 was logged in to the database using both wingz and isql from a
remote mac.
------------------------------------------------------------------------------
| . .
Bob Baskett | ... ...
Software Engineer, DBA | ..... .....
Business Systems Integration Group | .. ... ..
Semiconductor Products Sector | . . .
Mesa, AZ |
| Motorola, Inc
------------------------------------------------------------------------------
Informix Versions:
Online - 5.00.UC2
ISQL - 4.10.UD1
4GL-RDS- 4.10.UC1
------------------------------------------------------------------------------