IDS Forum

RE: logical log problem

Posted By: Jarrod Teale
Date: Thursday, 21 January 2010, at 10:58 p.m.

In Response To: logical log problem (YAN CHING TAN)

Hi,
Please post the platform and version of your issue. It is very difficult
to diagnose something with out this detail.

The logical logs are not designed to hold a whole days activity with no
backup. Each log must be backed up individually, so maybe you need to
make the individual logs bigger?

That being said, try "onstat -l " to list the logical logs, then run
"onlog -n xxx" where xxx is the uniqid of the current log

This will show you the transactions running through the logs, who the
user was, what the session id was (691033 below for example) and what
was happening.
In my example there are a number of insert statements and index
additions happening.

E.g.
onstat -l
=========
address number flags uniqid begin size used
%used
504abfb8 11 U-B---- 32381 6:53 1500 1500
100.00
506d5fb8 12 U-B---- 32382 6:1553 1500 1500
100.00
508fffb8 13 U-B---- 32383 6:3053 1500 1500
100.00
50b31ab8 14 U---C-L 32384 6:4553 1500 1098
73.20
50b31b00 15 U-B---- 32375 6:6053 1500 1500
100.00
50b31b48 16 U-B---- 32376 6:7553 1500 1500
100.00

onlog -n 32384
==============

IBM Informix Dynamic Server Logical Log display
Software Serial Number AAA#B000000
Copyright IBM Corporation 1996, 2004 All rights reserved.

log uniqid: 32384.

addr len type xid id link
18 52 BEGIN 142 32384 0 01/22/2010 16:37:24
691033 sdev
4c 396 HINSERT 142 0 18 5000a0 31f00c03 332
1d8 72 ADDITEM 142 0 4c 5000a1 31f00c03 344363 1
12
220 72 ADDITEM 142 0 1d8 5000a2 31f00c03 402690 1
12
268 48 COMMIT 142 0 220 01/22/2010 16:37:24
1018 52 BEGIN 165 32384 0 01/22/2010 16:37:24
691036 sdev
104c 396 HINSERT 165 0 1018 5000a0 31f00c04 332
11d8 72 ADDITEM 165 0 104c 5000a1 31f00c04 344363 1
12
1220 72 ADDITEM 165 0 11d8 5000a2 31f00c04 402695 1
12
1268 48 COMMIT 165 0 1220 01/22/2010 16:37:24
2018 52 BEGIN 137 32384 0 01/22/2010 16:37:24
691034 sdev
204c 396 HINSERT 137 0 2018 5000a0 31f00c05 332
21d8 72 ADDITEM 137 0 204c 5000a1 31f00c05 344363 1
12
2220 72 ADDITEM 137 0 21d8 5000a2 31f00c05 402694 1
12
2268 48 COMMIT 137 0 2220 01/22/2010 16:37:24
3018 52 BEGIN 143 32384 0 01/22/2010 16:37:24
691035 sdev
304c 396 HINSERT 143 0 3018 5000a0 31f00c06 332
31d8 72 ADDITEM 143 0 304c 5000a1 31f00c06 344363 1
12

addr len type xid id link

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
YAN CHING TAN
Sent: Friday, 22 January 2010 4:43 p.m.
To: ids@iiug.org
Subject: logical log problem [18738]

Dear all,

Currently face one problem, one of the instance logical log keep full
even i try to backup everyday. But based on my understanding this
instance suppose not much activities.

Anywhere i can check what caused the logical log keep getting full?

Thanks in advance.

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

DISCLAIMER:
This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email.
You may not use, disclose or copy this email or its attachments in any way.
Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group.
http://www.fonterra.com/

Messages In This Thread

• logical log problem
  YAN CHING TAN -- Thursday, 21 January 2010, at 10:42 p.m.
  • RE: logical log problem
    Jarrod Teale -- Thursday, 21 January 2010, at 10:58 p.m.
  • AW: logical log problem
    Andreas.KUTSCHE@spar.at -- Friday, 22 January 2010, at 3:08 a.m.
  • Re: logical log problem
    Art Kagel -- Friday, 22 January 2010, at 8:01 a.m.
    • Re: logical log problem
      SCHIL ACHE -- Monday, 8 February 2010, at 12:22 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.