Re: using sysmaster in 9.x
thanks for the info - I guess I should have been more specific on what
versions - we are using 7.23.uc4 and 9.14. No 7.3 yet.... any other
ideas? maria
Carlson@WHSmith wrote:
> With 7.3 there is a configuration variable called TBLSPACE_STATS. If it
> is not set in $ONCONFIG (I use 1), then table stats will not be kept. I
> found that out when I upgraded from 7.2 to 7.3.
>
> John Carlson
> Informix DBA
> WHSmith USA
>
> Maria Wilson wrote:
> >
> > I am trying to use the same query in my 9x engines as I do in my 7x
> > engines to monitor users on the servers.....
> >
> > SELECT count(*) AS totals,
> > sid AS sid,
> > username AS user,
> > sqs_dbname[1,16] AS database,
> > $date AS date
> > FROM syssessions, syssqlstat
> > where sid = sqs_sessionid
> > GROUP BY sid,username,sqs_dbname;> >
> > for some reason this seems to work fine for 7x but returns 0 rows for
> > the 9x engines when I can clearly see that the query should be returning
> > something else..... Can anyone help?
> >
> > thanks, Maria
> > ----------------------------------------------------------------
> > Maria L. Wilson 757.766.8265 757.766.2571(fax)
> > Computer Sciences Corporation
> > NASA Langley Research Center m.l.wilson@larc.nasa.gov
> > Hampton, VA 23666 http://www.larc.nasa.gov
> > ----------------------------------------------------------------
--
----------------------------------------------------------------
Maria L. Wilson 757.766.8265 757.766.2571(fax)
Computer Sciences Corporation
NASA Langley Research Center m.l.wilson@larc.nasa.gov
Hampton, VA 23666 http://www.larc.nasa.gov
----------------------------------------------------------------
On the engine I get to play with, sqs_session_id and sid do not match for your join condition (I was the only connection, had sid of 1385, sqs_sessionid of 1386) Maria Wilson (m.l.wilson@larc.nasa.gov) wrote: : thanks for the info - I guess I should have been more specific on what : versions - we are using 7.23.uc4 and 9.14. No 7.3 yet.... any other : ideas? maria : Carlson@WHSmith wrote: : > With 7.3 there is a configuration variable called TBLSPACE_STATS. If it : > is not set in $ONCONFIG (I use 1), then table stats will not be kept. I : > found that out when I upgraded from 7.2 to 7.3. : > : > John Carlson : > Informix DBA : > WHSmith USA : > : > Maria Wilson wrote: : > > : > > I am trying to use the same query in my 9x engines as I do in my 7x : > > engines to monitor users on the servers..... : > > : > > SELECT count(*) AS totals, : > > sid AS sid, : > > username AS user, : > > sqs_dbname[1,16] AS database, : > > $date AS date : > > FROM syssessions, syssqlstat : > > where sid = sqs_sessionid : > > GROUP BY sid,username,sqs_dbname; : > > : > > for some reason this seems to work fine for 7x but returns 0 rows for : > > the 9x engines when I can clearly see that the query should be returning : > > something else..... Can anyone help? : > > : > > thanks, Maria : > > ---------------------------------------------------------------- : > > Maria L. Wilson 757.766.8265 757.766.2571(fax) : > > Computer Sciences Corporation : > > NASA Langley Research Center m.l.wilson@larc.nasa.gov : > > Hampton, VA 23666 http://www.larc.nasa.gov : > > ---------------------------------------------------------------- : -- : ---------------------------------------------------------------- : Maria L. Wilson 757.766.8265 757.766.2571(fax) : Computer Sciences Corporation : NASA Langley Research Center m.l.wilson@larc.nasa.gov : Hampton, VA 23666 http://www.larc.nasa.gov : ---------------------------------------------------------------- -- Rob Wilson rwilson@ntsource.com