Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: Fuzzy and Full checkpoint duration

Posted By: H.G
Date: Thursday, 9 August 2007, at 5:08 p.m.

In Response To: RE: Fuzzy and Full checkpoint duration (John Miller iii)

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.

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.