Re: Checking dbspace for Logs

Posted in 2000

Mark D. Stock — Sat, 30 Sep 2000 00:44:37 +0100 — source: Informix-list mailing list archive (1991-1998)

Jinu.Joseph@citicorp.com wrote: > > Hi, > Can anybody tell me how to check as to in which dbspace is the logical > logs residing in. Something like: 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 Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+