Very Computer

by **John Rei** » Sat, 01 Feb 2003 19:49:38

Is there a way to query what % of physical log is full.
i want to know in advance when 75% mark will be reached
soon to trigger checkpoint.

thanks.

by **blackguar** » Sat, 01 Feb 2003 23:27:21

onstat -l

--
Posted via http://dbforums.com

by **blackguar** » Sat, 01 Feb 2003 23:27:52

onstat -l

--
Posted via http://dbforums.com

by **Bill Reid** » Sun, 02 Feb 2003 02:21:22

> Is there a way to query what % of physical log is full.
> i want to know in advance when 75% mark will be reached
> soon to trigger checkpoint.

> thanks.

======================================================

Informix handles to checkpoints through the Buffer settings.
You can monitor the % Full of Physical Log with the following query:

database sysmaster;
select pl_physize pl_size,
pl_phyused pl_used,
round ((pl_phyused * 100.0)/pl_physize,2) pl_pct
from sysplog;

This will match the value displayed in the Physical Logging section
of the onstat -l command.

Bill

by **Link, David A** » Sat, 01 Feb 2003 23:08:24

Onstat -l will give it to you.

-----Original Message-----

Sent: Friday, January 31, 2003 4:50 AM

Subject: How to find what % of physical log is full

Is there a way to query what % of physical log is full.
i want to know in advance when 75% mark will be reached
soon to trigger checkpoint.

thanks.

by **Brice Avi** » Sun, 02 Feb 2003 04:20:41

onstat -l

Brice Avila
Minneapolis, Minnesota

> Is there a way to query what % of physical log is full.
> i want to know in advance when 75% mark will be reached
> soon to trigger checkpoint.

> thanks.

by **calyan..** » Sun, 02 Feb 2003 14:29:09

> Onstat -l will give it to you.

> -----Original Message-----

> Sent: Friday, January 31, 2003 4:50 AM

> Subject: How to find what % of physical log is full

> Is there a way to query what % of physical log is full.
> i want to know in advance when 75% mark will be reached
> soon to trigger checkpoint.

> thanks.

Hi john

Read this query:-
database sysmaster;
select pl_physize pl_size,
pl_phyused pl_used,
round ((pl_phyused * 100.0)/pl_physize,2) pl_pct
from sysplog;
example
By using this query

pl_size pl_used pl_pct

1000 0 0.00

look at Pl-pct is the % used it shows 0.00
after inserting some rows
pl_size pl_used pl_pct

1000 6 0.60

Like wise you have to monitor the percentage and use
onmode -c if it reaches 74%

regards
calyanarm