RE: What???
Someone (posting as Obnoxio The Clown) questioned odd read-ahead statistics on an IDS instance, where the "RA-pgsused" counter looked wildly out of line with the ixda-RA/idx-RA/da-RA counters. Suggestions included comparing against sysmaster:sysprofile, a counter rolling over negative, or stats simply not having been reset for a long time. The poster later reported being told it may be a bug in the Time Series DataBlade, which increments RA-pgsused but not the other counters; this was never confirmed. A follow-up post asked unanswered questions about TimeSeries/Real Time Loader manuals, container free space and why IDS must be bounced on schema changes.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I doubt it, I have much larger numbers on the same IDS and O/S they would need to be a loonngg way out of kilter to go negative. ixda-RA idx-RA da-RA RA-pgsused 20203943 4236345 29774913 53943308 Keith -> -----Original Message----- -> From: Roy Mercer [mailto:roy.mercer@gmail.com] -> Sent: Tuesday, March 07, 2006 2:25 PM -> To: informix-list@iiug.org -> Subject: Re: What??? -> -> -> Compare these to -> select * from sysmaster:sysprofile. -> -> Maybe one of the numbers rolled over to a (-) negative -> -> FYI -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************
Or maybe stats have not been reset in a long time. Since the Clown is so vague, we will never know. How long is that piece of string?
Roy Mercer said: > Or maybe stats have not been reset in a long time. > > Since the Clown is so vague, we will never know. > > How long is that piece of string? It's green and made of cotton. Does that help? :op I've just spoken to a wise man. It turns out that it MIGHT be a bug in the Time Series DataBlade, which increments the counter "RA-pgsused" but NOT the other counters. So there! -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo
Now if you had mentioned timeseries in the first place ............ Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 North America Conference. Tampa, Florida, USA. 7-11 May 2006. Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] > Posted At: Tuesday, March 07, 2006 9:29 AM > Posted To: comp.databases.informix > Conversation: What??? > Subject: Re: What??? > > > > Roy Mercer said: > > Or maybe stats have not been reset in a long time. > > > > Since the Clown is so vague, we will never know. > > > > How long is that piece of string? > > It's green and made of cotton. Does that help? :op > > I've just spoken to a wise man. It turns out that it MIGHT be > a bug in the > Time Series DataBlade, which increments the counter > "RA-pgsused" but NOT > the other counters. > > So there! > > -- > Bye now, > Obnoxio > > "It's easier with pictures." > -- Cosmo > >
Paul Watson said: > Now if you had mentioned timeseries in the first place ............ ... you would have been none the wiser? -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.45.1141752500.18205.informix-list@iiug.org... > > Paul Watson said: >> Now if you had mentioned timeseries in the first place ............ > > ... you would have been none the wiser? To paraphrase Lord Birkenhead, he may indeed have been none the wiser, but he *would* have been better informed!
Captain Pedantic said: > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:mailman.45.1141752500.18205.informix-list@iiug.org... >> >> Paul Watson said: >>> Now if you had mentioned timeseries in the first place ............ >> >> ... you would have been none the wiser? > > > To paraphrase Lord Birkenhead, he may indeed have been none the wiser, but > he *would* have been better informed! And it still wouldn't have helped! -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, it gets worse." -- Cosmo "Run, don't walk, for the nearest exit." -- Cosmo
1. Does anyone here use Timeseries and real time loader apart from that
clown?
2. Where are the manuals?
3. Why does IDS need to be bounced when using Real Time Loader when the
table schema changes or the table storage gets moved
(sbspace/dbspace??).
4. I understand Timeseries uses dbspaces (up to 32Gb max) and
'containers'
inside sbspaces. How do I see the free space in a container since
onstat -d showsthe dbspace/sbspace (can't remember which) as full?
David.
Obnoxio The Clown wrote:
> I've just spoken to a wise man. It turns out that it MIGHT be a bug in the
> Time Series DataBlade, which increments the counter "RA-pgsused" but NOT
> the other counters.
>
> So there!
>
> --
> Bye now,
> Obnoxio
>
> "It's easier with pictures."
> -- Cosmo
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape