Hi all!

My problem:

I used ontape -c to backup my logical log on tape drive.
Now is that full. I made a big update an I think the IDS cannt commit the work:

My online log show the next:

08:36:53 Informix Dynamic Server Version 7.30.UC7
08:36:53 Who: Session(2877, mtssped@riba, 908, 0)
Thread(8384, sqlexec, 0, 3)
File: rstrans.c Line: 2117
08:36:53 Results: Log record (OLDRSAM:RDELETE) in log 40139, offset 0x4a190 was not rolled back
08:36:53 Action: Use 'onlog' to view the transaction and repair manually.
08:37:02 See Also: /tmp/af.20c0b814, shmem.20c0b814.0
08:38:16 Assert Failed: Rollback error 126
08:38:16 Informix Dynamic Server Version 7.30.UC7
08:38:16 Who: Session(2877, mtssped@riba, 908, 0)
Thread(8384, sqlexec, 0, 3)
File: rsextlog.c Line: 1414
08:38:16 Results: Log record (OLDRSAM:RDELETE) in log 40139, offset 0x4a190 was not rolled back
08:38:16 Action: Use 'onlog' to view the transaction and repair manually.
08:38:22 See Also: /tmp/af.20c0b814, shmem.20c0b814.1
08:39:33 Assert Failed: Dynamic Server must abort
08:39:33 Informix Dynamic Server Version 7.30.UC7
08:39:33 Who: Session(2877, mtssped@riba, 908, 0)
Thread(8384, sqlexec, 0, 3)
File: rslog.c Line: 3152
08:39:33 Results: Dynamic Server must abort
08:39:33 Action: Reinitialize shared memory
08:39:35 See Also: /tmp/af.20c0b814, shmem.20c0b814.2
08:40:34 rslog.c, line 3152, thread 8384, proc id 924, Dynamic Server must abort.
08:40:34 PANIC: Attempting to bring system down


The problem that I can't initialize the shared memory to delete the logs...



Pls help me becouse its very dangerous situation for me


Thanks a lot....

In ordet to Drop a log file:

onparams -d -l number -y or
onutil DROP LOG number command,
depending on the database server.