Re: Log info from sysmaster
Steve Romankiw wrote:
>
> How can I retrieve which dbspace a log resides in? I would like to
> retrieve this information thru the SMI.
>
> I would like to be able to generate the following dynamically:
> <snip>
> onparams -a -d log1 -s 5000
> onparams -a -d log2 -s 5000
> onparams -a -d log1 -s 5000
> <snip>>
> Any thoughts?
Well, here's a start:
SELECT number log_no, name dbspace
FROM sysmaster:syslogfil, sysmaster:syschunks c,
sysmaster:sysdbspaces d
WHERE sysmaster:physchunk(physloc) = chknum
AND c.dbsnum = d.dbsnum
Just something I prepared earlier, I'm sure you can work out the rest.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+