location of physical log/dbspaces

Hi all I have a situation here where the previous DBA leave the company and do not document any setting. Checking with onstat -d command does not give us any clue where the actual physical log location. I been using onmonitor -->Parameters-->Physical Log to check for actual location of physical dbspaces. Questions 1. Is that the only way to check for the dbspace for physical. 2. Knowing the fact the command onparam -p -d option can change location of the physical dbspace, is that a way (SQL/script) that I can check for the location/dbspace for physical log?

Hi Patrick, How about running oncheck -pe and looking for PHYSICAL LOG in the description. For example: DBspace Usage Report: plogdbs Owner: informix Created: 03/09/2012 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 2 /opt/informix/dbspaces3/plogdbs_1 2 25600 25053 547 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 plogdbs:'informix'.TBLSpace 3 50 PHYSICAL LOG 53 25000 FREE 25053 547 Total Used: 25053 Total Free: 547 Cheers, Stuart --- Ardenta Ltd is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LEY PATRICK Sent: 16 July 2012 11:43 To: ids@iiug.org Subject: location of physical log/dbspaces [27607] Hi all I have a situation here where the previous DBA leave the company and do not document any setting. Checking with onstat -d command does not give us any clue where the actual physical log location. I been using onmonitor -->Parameters-->Physical Log to check for actual location of physical dbspaces. Questions 1. Is that the only way to check for the dbspace for physical. 2. Knowing the fact the command onparam -p -d option can change location of the physical dbspace, is that a way (SQL/script) that I can check for the location/dbspace for physical log? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

The top section of the onstat -l report includes the location of the physical log as dbspace:offset. Also, IB that sysmaster.sysextents will show the log as tabname PHYSLOG. Art On Jul 16, 2012 6:43 AM, "LEY PATRICK" <patrickley@gmail.com> wrote: > Hi all > > I have a situation here where the previous DBA leave the company and do not > document any setting. > > Checking with onstat -d command does not give us any clue where the actual > physical log location. > > I been using onmonitor -->Parameters-->Physical Log to check for actual > location of physical dbspaces. > > Questions > 1. Is that the only way to check for the dbspace for physical. > 2. Knowing the fact the command onparam -p -d option can change location of > the physical dbspace, is that a way (SQL/script) that I can check for the > location/dbspace for physical log? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae934056393e3fc04c4f11d4e

Hi, You can check the location of the dbspace either thru: 1. oncheck -pe > oncheck_pe and look for Physical log in the resulting file oncheck_pe 2. Usually we look at the outout of onstat -l ex: IBM Informix Dynamic Server Version 11.70.FC4 -- On-Line (Prim) -- Up 2 days 18:42:04 -- 128132 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 32 7182 519 13.84 phybegin physize phypos phyused %used *1*:263 12288 2528 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 16 115449 9842 8305 11.7 1.2 Subsystem numrecs Log Space used OLDRSAM 115058 12010396 HA 391 18896 address number flags uniqid begin size used %used 203325c50 1 U-B---- 368 1:12551 500 500 100.00 203325cb8 2 U-B---- 369 1:13051 500 500 100.00 203325d20 3 U-B---- 370 1:13551 500 500 100.00 203325d88 8 U---C-L 371 1:24617 500 356 71.20 203325df0 4 U-B---- 364 1:14051 500 500 100.00 203325e58 5 U-B---- 365 1:14551 500 500 100.00 203325ec0 7 U-B---- 366 1:23941 500 500 100.00 203325f28 6 U-B---- 367 1:15051 500 500 100.00 8 active, 8 total The *phybegin* field on top in this example shows you the chunk # where the physical log is; however you have to also run onstat -d to locate the name of the chunk and the related dbspace. 3. Another way of doing it is to go thru the pseudo tables in the sysmaster database: Look in the sysplog table in sysmaster: ex: *select fname from sysmaster:sysplog, sysmaster:syschunks where pl_chunk=chknum* This query gives you the name of the chunk. You can even go further and join with with the sysdbspaces. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 16/07/12 12:43, LEY PATRICK a écrit : > Hi all > > I have a situation here where the previous DBA leave the company and do not > document any setting. > > Checking with onstat -d command does not give us any clue where the actual > physical log location. > > I been using onmonitor -->Parameters-->Physical Log to check for actual > location of physical dbspaces. > > Questions > 1. Is that the only way to check for the dbspace for physical. > 2. Knowing the fact the command onparam -p -d option can change location of > the physical dbspace, is that a way (SQL/script) that I can check for the > location/dbspace for physical log? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Hi Patrick, Isn't it listed in the file ? $INFORMIXDIR/etc/oncfg_<instance_name>.0 Jim Univ of Iowa -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Stuart Brooks Sent: Monday, July 16, 2012 5:49 AM To: ids@iiug.org Subject: RE: location of physical log/dbspaces [27608] Hi Patrick, How about running oncheck -pe and looking for PHYSICAL LOG in the description. For example: DBspace Usage Report: plogdbs Owner: informix Created: 03/09/2012 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 2 /opt/informix/dbspaces3/plogdbs_1 2 25600 25053 547 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 plogdbs:'informix'.TBLSpace 3 50 PHYSICAL LOG 53 25000 FREE 25053 547 Total Used: 25053 Total Free: 547 Cheers, Stuart --- Ardenta Ltd is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LEY PATRICK Sent: 16 July 2012 11:43 To: ids@iiug.org Subject: location of physical log/dbspaces [27607] Hi all I have a situation here where the previous DBA leave the company and do not document any setting. Checking with onstat -d command does not give us any clue where the actual physical log location. I been using onmonitor -->Parameters-->Physical Log to check for actual location of physical dbspaces. Questions 1. Is that the only way to check for the dbspace for physical. 2. Knowing the fact the command onparam -p -d option can change location of the physical dbspace, is that a way (SQL/script) that I can check for the location/dbspace for physical log? **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Running the following select statement should help. select P.pl_chunk Chunk, D.dbsnum dbspace_number, D.name name from sysmaster:sysplog as P, syschktab as C, sysdbstab D where P.pl_chunk =3D C.chknum and C.dbsnum =3D D.dbsnum It would be nice to know what version you are using, because if you are= using version 11 then I would suggest install OAT which will provide al= l of this information to you in a graphical gui interface. It can be insta= lled for free with the latest version of CSDK. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 07/16/2012 03:43:25 AM: > From: "LEY PATRICK" <patrickley@gmail.com> > To: ids@iiug.org, > Date: 07/16/2012 03:45 AM > Subject: location of physical log/dbspaces [27607] > Sent by: ids-bounces@iiug.org > > Hi all > > I have a situation here where the previous DBA leave the company and = do not > document any setting. > > Checking with onstat -d command does not give us any clue where the actual > physical log location. > > I been using onmonitor -->Parameters-->Physical Log to check for actu= al > location of physical dbspaces. > > Questions > 1. Is that the only way to check for the dbspace for physical. > 2. Knowing the fact the command onparam -p -d option can change locat= ion of > the physical dbspace, is that a way (SQL/script) that I can check for= the > location/dbspace for physical log? > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=