IDS Forum

Re: IDS suddenly generates 4 times more logical lo

Posted By: John Miller iii
Date: Sunday, 23 January 2011, at 12:55 p.m.

In Response To: Re: IDS suddenly generates 4 times more logical lo (JIMMY JONSSON)

sql_logspace is stored in bytes and is closely related to
sysmaster:sysrstcb.upf_logspused
column.

Here is some more information that might help you along with a demo program
that helps
explains the usage of some of the columns in the sysmaster:sysrstcb

1. upf_iscommit The number of implicit or explicit commit works
that session has done
2. upf_longtxs The number of long transactions generated by this
users
3. upf_logspuse The amount of log space consumed in bytes by the
current transaction

Reset to 0 after transaction completes.
4. upf_logspmax The largest transaction in byte consumed by this user
5 upf_lgrecs The number of logical log records generated by this
user

=======================PROGRAM==================================
database sysmaster;
select "SYSMASTER"::char(12), upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
create database d1 with log;
select "CREATE DBS"::char(12), upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
create table t1 (c1 serial, c2 char(250));
select "CREATE TABLE"::char(12), upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
begin;
insert into t1 values (0,"JOHN");
select "INSERT"::char(12),upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
commit;
select "COMMIT"::char(12),upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
begin;
delete from t1 where c1=1;
select "DELETE"::char(12), upf_iscommit, upf_longtxs, upf_logspuse,
upf_logspmax, upf_lgrecs

from sysmaster:sysrstcb where sid = dbinfo('sessionid');
commit;

=======================OUTPUT==================================
(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

SYSMASTER 0 0 0 0 0

(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

CREATE DBS 1 0 0 2263472 15689

(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

CREATE TABLE 2 0 0 2263472 15718

(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

INSERT 2 0 424 2263472 15721

(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

COMMIT 3 0 0 2263472 15722

(constant) upf_iscommit upf_longtxs upf_logspuse upf_logspmax upf_lgrecs

DELETE 3 0 376 2263472 15724

John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)

ids-bounces@iiug.org wrote on 01/23/2011 05:46:40 AM:

> From:
>
> JIMMY JONSSON <>
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 01/23/2011 05:47 AM
>
> Subject:
>
> Re: IDS suddenly generates 4 times more logical lo [22534]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Does sql_logspace column show the log space used i bytes or blocks ?
>
>
>
*******************************************************************************

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

Messages In This Thread

• IDS suddenly generates 4 times more logical logs
  JIMMY JONSSON -- Tuesday, 18 January 2011, at 7:15 a.m.
  • RE: IDS suddenly generates 4 times more logical lo
    Dan Mueller -- Tuesday, 18 January 2011, at 7:21 a.m.
    • Re: IDS suddenly generates 4 times more logica....
      Art Kagel -- Tuesday, 18 January 2011, at 7:35 a.m.
  • Re: IDS suddenly generates 4 times more logical lo
    John Miller iii -- Tuesday, 18 January 2011, at 12:53 p.m.
    • Re: IDS suddenly generates 4 times more logical lo
      JIMMY JONSSON -- Wednesday, 19 January 2011, at 3:58 a.m.
      • Re: IDS suddenly generates 4 times more logical lo
        Mirav Kapadia -- Wednesday, 19 January 2011, at 10:18 a.m.
    • Re: IDS suddenly generates 4 times more logical lo
      JIMMY JONSSON -- Sunday, 23 January 2011, at 8:46 a.m.
      • Re: IDS suddenly generates 4 times more logical lo
        Art Kagel -- Sunday, 23 January 2011, at 11:21 a.m.
      • Re: IDS suddenly generates 4 times more logical lo
        John Miller iii -- Sunday, 23 January 2011, at 12:55 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.