Fuzzy and Full checkpoint duration
A DBA on IDS 9.4 on HP-UX wanted fuzzy/full checkpoint durations but couldn't read online.log (mode 660 informix:informix), and onstat -m only shows the last 20 lines. Replies: chmod 664 on online.log (and $ONCONFIG) is safe and needs no engine restart; alternatively run something like 'su informix -c "view online.log"'. Art Kagel noted checkpoint duration is recorded only in the online log (inferable from chkpt begin/end logical log records), not in reserved pages. John Miller added that the then-upcoming Cheetah release exposes syscheckpoint (last 20 checkpoints, with flush/cp times) and sysonlinelog via SQL, and explained dskflush_per_sec shows buffer count when flush time is under a second.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuzzy &
full checkpoint duration. Therefore, did not get any response. Let me try
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. There is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online logs. My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permission on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I do
that myself and it has never presented any issues as far as I can tell.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuzzy &
full checkpoint duration. Therefore, did not get any response. Let me try
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. There
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online logs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permission
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks Clifton. Apprecaited prompt response. Since, permission is not going to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I do
that myself and it has never presented any issues as far as I can tell.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuzzy &
full checkpoint duration. Therefore, did not get any response. Let me try
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. There
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online logs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permission
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
That question I was leaving for some of the real tech wizards reading this
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if this is
one of them) I believe you would need to perform a "tail -xxxx logfile" and
parse that information to get what you need ... but that would require read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not going
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I do
that myself and it has never presented any issues as far as I can tell.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuzzy &
full checkpoint duration. Therefore, did not get any response. Let me try
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. There
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online logs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permission
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
The checkpoint duration is not recorded anywhere except in the online log. You
can infer it from the chkpt begin and chkpt end records in the logical logs,
but that's it. On the checkpoint reserved pages, pages 2 & 3, only the start
time and the logical log unique id and offset of the check point log record for
the most recent two checkpoints are recorded, but no duration.
Art S. Kagel
----- Original Message -----
From: Clifton Bean <ids@iiug.org>
At: 8/08 14:17:42
That question I was leaving for some of the real tech wizards reading this
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if this is
one of them) I believe you would need to perform a "tail -xxxx logfile" and
parse that information to get what you need ... but that would require read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not going
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I do
that myself and it has never presented any issues as far as I can tell.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H.G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuzzy &
full checkpoint duration. Therefore, did not get any response. Let me try
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. There
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online logs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permission
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=
"Clifton Bean" =
<cbean@ctm.com> =
Sent by: =
To
ids-bounces@iiug. ids@iiug.org =
org =
cc
=
Subj=
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =
AM duration [9731] =
=
=
Please respond to =
ids@iiug.org =
=
=
That question I was leaving for some of the real tech wizards reading t=
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
and
parse that information to get what you need ... but that would require =
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
.G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
do
that myself and it has never presented any issues as far as I can tell.=
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
.G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
!
TV.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
H.G
> Sent: Wednesday, August 08, 2007 1:05 PM
> To: ids@iiug.org
> Subject: RE: Fuzzy and Full checkpoint duration [9730]
>
> Thanks Clifton. Apprecaited prompt response. Since, permission is not
> going to
> change soon (for some reason), any comments on my question 1?
You could create a script like this:
su informix -c 'view /usr/informix/online.log'
When you execute it, you would have to type the informix password. This
should be pretty safe since it only executes the one command and view is
read only.
--EEM
>
> Thanks.
>
> Clifton Bean <cbean@ctm.com> wrote:
> chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I
do
> that myself and it has never presented any issues as far as I can
tell.
>
> Take care.
>
> Clifton M. Bean
> Informix DBA / AIX System Admin
> Currency Technics & Metrics
>
> Phone: (972) 812-1411 x244
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
H.G
> Sent: Wednesday, August 08, 2007 12:51 PM
> To: ids@iiug.org
> Subject: Fuzzy and Full checkpoint duration [9727]
>
> IDS 9.4.FC4/HP-UX 11
>
> It appears that my question was incorrectly phrased, in relation to
fuzzy
> &
> full checkpoint duration. Therefore, did not get any response. Let me
try
> again by rephasing my question:
>
> OnLine logs have got info. about fuzzy and full checkpoints duration.
> There
> is
> a permission issue with online log file at our site (permission 660
> informix:informix). onstat -m can show only last 20 lines from online
> logs.
> My
> questions are:
>
> 1. How can I find fuzzy & full checkpoint duration since no read
> permission
> on
> online log file?
> 2. I am hoping changing permissions on online log file (say 664
> informix:informix) is safe and does not require bouncing the engine.
Is
> this
>
> correct ?
>
> Thanks.
>
> ---------------------------------
> Got a little couch potato?
> Check out fun summer activities for kids.
>
>
************************************************************************
**
> **
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
************************************************************************
**
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---------------------------------
> Ready for the edge of your seat? Check out tonight's top picks on
Yahoo!
> TV.
>
>
>
************************************************************************
**
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
John, I would expect to see the dskflush_per_sec to be calculated as:
n_dirty_buffs / flush_time = 6 / 0.021177158516 = 283.324129413623
Not 6! ??
Art S. Kagel
----- Original Message -----
From: John Miller iii <ids@iiug.org>
At: 8/08 14:39:32
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=
"Clifton Bean" =
<cbean@ctm.com> =
Sent by: =
To
ids-bounces@iiug. ids@iiug.org =
org =
cc
=
Subj=
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =
AM duration [9731] =
=
=
Please respond to =
ids@iiug.org =
=
=
That question I was leaving for some of the real tech wizards reading t=
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
and
parse that information to get what you need ... but that would require =
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
..G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
do
that myself and it has never presented any issues as far as I can tell.=
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
..G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
!
TV.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Art:
Your expectation would be met if the flush time is greater than 1 secon=
d.
If the flush time
is less than one second we take the number of buffers flushed. This =
is
to protect the
numbers.
John
=
"ART KAGEL, =
BLOOMBERG/ 731 =
LEXIN" =
To
<kagel@bloomberg. ids@iiug.org =
net> =
cc
Sent by: =
ids-bounces@iiug. Subj=
ect
org RE: Fuzzy and Full checkpoint =
duration [9735] =
=
08/08/2007 11:47 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
John, I would expect to see the dskflush_per_sec to be calculated as:
n_dirty_buffs / flush_time =3D 6 / 0.021177158516 =3D 283.324129413623
Not 6! ??
Art S. Kagel
----- Original Message -----
From: John Miller iii <ids@iiug.org>
At: 8/08 14:39:32
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
=3D
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=3D
"Clifton Bean" =3D
<cbean@ctm.com> =3D
Sent by: =3D
To
ids-bounces@iiug. ids@iiug.org =3D
org =3D
cc
=3D
Subj=3D
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =3D
AM duration [9731] =3D
=3D
=3D
Please respond to =3D
ids@iiug.org =3D
=3D
=3D
That question I was leaving for some of the real tech wizards reading t=
=3D
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
=3D
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
=3D
and
parse that information to get what you need ... but that would require =
=3D
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
...G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
=3D
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
=3D
do
that myself and it has never presented any issues as far as I can tell.=
=3D
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
...G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
=3D
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
=3D
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
=3D
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
=3D
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
=3D
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
=3D
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
=3D
!
TV.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=3D
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Wow.. What an excellent piece of work in Cheetah. Well done team. I am sure,
this type of info. would certainly helpful and handy to DBAs.
Thanks everyone for helping me.
Cheers.
John Miller iii <miller3@us.ibm.com> wrote:
Art:
Your expectation would be met if the flush time is greater than 1 secon=
d.
If the flush time
is less than one second we take the number of buffers flushed. This =
is
to protect the
numbers.
John
=
"ART KAGEL, =
BLOOMBERG/ 731 =
LEXIN" =
To
net> =
cc
Sent by: =
ids-bounces@iiug. Subj=
ect
org RE: Fuzzy and Full checkpoint =
duration [9735] =
=
08/08/2007 11:47 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
John, I would expect to see the dskflush_per_sec to be calculated as:
n_dirty_buffs / flush_time =3D 6 / 0.021177158516 =3D 283.324129413623
Not 6! ??
Art S. Kagel
----- Original Message -----
From: John Miller iii
At: 8/08 14:39:32
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
=3D
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=3D
"Clifton Bean" =3D
=3D
Sent by: =3D
To
ids-bounces@iiug. ids@iiug.org =3D
org =3D
cc
=3D
Subj=3D
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =3D
AM duration [9731] =3D
=3D
=3D
Please respond to =3D
ids@iiug.org =3D
=3D
=3D
That question I was leaving for some of the real tech wizards reading t=
=3D
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
=3D
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
=3D
and
parse that information to get what you need ... but that would require =
=3D
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
....G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
=3D
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
=3D
do
that myself and it has never presented any issues as far as I can tell.=
=3D
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
....G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
=3D
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
=3D
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
=3D
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
=3D
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
=3D
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
=3D
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
=3D
!
TV.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=3D
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us.
Hi John,
Where can we find the table syscheckpoints?
I can neither find it in sysmaster nor in application databases (Informix
Dynamic Server 10.00.FC4W3)..
Truly yours,
Long N
==========================================================
"John Miller iii"
<miller3@us.ibm.c To: ids@iiug.org
om> cc:
Sent by: Subject: RE: Fuzzy and Full checkpoint duration [9733]
ids-bounces@iiug.
org
09/08/2007 04:39
AM
Please respond to
ids
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=
"Clifton Bean" =
<cbean@ctm.com> =
Sent by: =
To
ids-bounces@iiug. ids@iiug.org =
org =
cc
=
Subj=
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =
AM duration [9731] =
=
=
Please respond to =
ids@iiug.org =
=
=
That question I was leaving for some of the real tech wizards reading t=
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
and
parse that information to get what you need ... but that would require =
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
..G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
do
that myself and it has never presented any issues as far as I can tell.=
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
..G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
!
TV.
***********************************************************************=
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
It is in version 11, not in version 10.
John
=
"Long Nguyen" =
<lnguyen@ruralco. =
com.au> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
RE: Fuzzy and Full checkpoint =
08/15/2007 07:36 duration [9795] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi John,
Where can we find the table syscheckpoints?
I can neither find it in sysmaster nor in application databases (Inform=
ix
Dynamic Server 10.00.FC4W3)..
Truly yours,
Long N
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"John Miller iii"
<miller3@us.ibm.c To: ids@iiug.org
om> cc:
Sent by: Subject: RE: Fuzzy and Full checkpoint duration [9733]
ids-bounces@iiug.
org
09/08/2007 04:39
AM
Please respond to
ids
There is allot more information in cheetah about checkpoints. The
most common information is in a table called syscheckpoints which
records information about the last 20 checkpoints.
In addition if you still want to get information out of the online log =
=3D
you
now can query sysonlinelog using matches and other SQL functions
to get want you want.
select first 1 * from syscheckpoint
intvl 200
type Non-Blocking
caller CKPTINTVL
clock_time 1186594954
crit_time 3.06655214e-05
flush_time 0.021177158516
cp_time 0.046485315566
n_dirty_buffs 6
plogs_per_sec 0
llogs_per_sec 0
dskflush_per_sec 6
ckpt_logid 10
ckpt_logpos 1688356
physused 5
logused 1
n_crit_waits 0
tot_crit_wait 0.00
longest_crit_wait 0.00
block_time 0.00
hope this helps,
John F. Miller III
=3D
"Clifton Bean" =3D
<cbean@ctm.com> =3D
Sent by: =3D
To
ids-bounces@iiug. ids@iiug.org =3D
org =3D
cc
=3D
Subj=3D
ect
08/08/2007 11:17 RE: Fuzzy and Full checkpoint =3D
AM duration [9731] =3D
=3D
=3D
Please respond to =3D
ids@iiug.org =3D
=3D
=3D
That question I was leaving for some of the real tech wizards reading t=
=3D
his
group. :)
Until Cheetah comes out (it gathers some metrics but I don't know if th=
=3D
is
is
one of them) I believe you would need to perform a "tail -xxxx logfile"=
=3D
and
parse that information to get what you need ... but that would require =
=3D
read
access of the log file.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
...G
Sent: Wednesday, August 08, 2007 1:05 PM
To: ids@iiug.org
Subject: RE: Fuzzy and Full checkpoint duration [9730]
Thanks Clifton. Apprecaited prompt response. Since, permission is not g=
=3D
oing
to
change soon (for some reason), any comments on my question 1?
Thanks.
Clifton Bean <cbean@ctm.com> wrote:
chmod 664 is okay for the online.log ... and for the $ONCONFIG file. I =
=3D
do
that myself and it has never presented any issues as far as I can tell.=
=3D
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of H=
=3D
...G
Sent: Wednesday, August 08, 2007 12:51 PM
To: ids@iiug.org
Subject: Fuzzy and Full checkpoint duration [9727]
IDS 9.4.FC4/HP-UX 11
It appears that my question was incorrectly phrased, in relation to fuz=
=3D
zy &
full checkpoint duration. Therefore, did not get any response. Let me t=
=3D
ry
again by rephasing my question:
OnLine logs have got info. about fuzzy and full checkpoints duration. T=
=3D
here
is
a permission issue with online log file at our site (permission 660
informix:informix). onstat -m can show only last 20 lines from online l=
=3D
ogs.
My
questions are:
1. How can I find fuzzy & full checkpoint duration since no read permis=
=3D
sion
on
online log file?
2. I am hoping changing permissions on online log file (say 664
informix:informix) is safe and does not require bouncing the engine. Is=
=3D
this
correct ?
Thanks.
---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo=
=3D
!
TV.
***********************************************************************=
=3D
*****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=3D
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=