Can't free logical logs
Hi Diane,
Try the following steps -
1. Login as 'informix' and Set proper TBCONFIG.
2. tbstat -u
take all 'PID' for all users other than root and informix users.
3. tbmode -z PID
use this individually for all the PIDs.
4. Login as 'root' and kill and PIDs with -15 option.
kill -15 PIDs
5. Login as informix , set your TBCONFIG and increase the 'Logical
Log number' with some handful number from 'tbmonitor' for time
being.
6. tbtape -a
take logical log backup.
7. tbmode -ky
stop your informix
8. tbinit
restart informix
9. Change the logical log number to the previous status.
Bye,
Sanjit.
20/05/1998.
************************ START OF FORWARDED MESSAGE **********************
>From : mail>diane.houston@bbc.co.uk
To : informix-list@iiug.org
Subject : Can't free logical logs
Date : 19/05/98 23:44
I am running OnLine 5.01 UDS on HP-UX 9.04.
I had a problem with all logical logs full due to long transaction. I
was unable to resolve problem by methods from manual and unable take
off-line so I rebooted the system. OnLine now stuck in Recovery mode
although log shows:
Tue May 19 17:43:17 1998
17:43:17 INFORMIX-OnLine Initialized -- Shared Memory Initialized
17:43:18 Physical Recovery Started
17:43:18 Checkpoint Completed
17:43:18 Physical Recovery Complete: 0 Pages Restored
17:43:18 Logical Log Files are Full -- Backup is Needed
17:43:19 Logical Log Files are Full -- Backup is Needed
17:43:20 Logical Log Files are Full -- Backup is Needed
17:43:21 Logical Log Files are Full -- Backup is Needed
OnLine seems to think user dianeh still logged in
USER INFORMATION
Locks Disk Disk User
PID User Held Reads Writes
Status
383 root 0 6
2 ------D
0 root 0 0 0
------D
0 dianeh 0 0 0
--T----
595 root 0 0 0
------M
571 root 0 0 0
------M
I have tried tbmode -c since status of log was U-B-L.
Any other suggestions before I restore.
Thanks in Advance
Regards
Diane Houston
MedAS
OASIS Application Support
Villiers House, Room 135
Tel: 19575