Oninit cdi / Archive
Talk to an expert →

Issue about Physical Log Info

Posted in 2009

Topics: Storage & Space Management, Server Administration, Logging & Checkpoints, Platform-Specific Issues, Third-Party Tools & Monitoring

Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello, friends. We have a recommendation here to increase our physical log, oun our 11.50.FC4 instance running on Linux 64 bits. Our OAT Info page brings that informations about it: Physical Log Info Physical Log Size 19.0 GB Amount Used 2.99 GB Location 4_28 Start Offset 6.13 GB Buffer Size 512 KB What OAT means with "Start Offset" ??? It´s similar to a dbspace offset ??? It really means that IDS is "ignoring" 6.13Gb on the begin of the dbspace??? Best regards !!! -- Alexandre Marini Analista de Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix

↪ replying to Alexandre Marini
Nilesh Ozarkar — — source: IIUG Forums & Mailing Lists

> > Issue about Physical Log Info [16407] > > Alexandre Marini > > to: > > ids > > 07/15/2009 10:16 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hello, friends. > We have a recommendation here to increase our physical log, oun our > 11.50.FC4 instance running on Linux 64 bits. > > Our OAT Info page brings that informations about it: > Physical Log Info > Physical Log Size 19.0 GB > Amount Used 2.99 GB > Location 4_28 > Start Offset 6.13 GB > Buffer Size 512 KB > > What OAT means with "Start Offset" ??? It=B4s similar to a dbspace offset ??? > It really means that IDS is "ignoring" 6.13Gb on the begin of the dbspace??? No, 'Start Offset' refers to the current position in the physical log w= here next buffer write will occur. If you refresh the physical log info in OAT after a checkpoint, you wil= l notice the change in Start Offset. > > Best regards !!! > -- > > Alexandre Marini > > Analista de Tecnologia da Informa=E7=E3o - DBA > > SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

↪ replying to Nilesh Ozarkar
Cesar Inacio Martins — — source: IIUG Forums & Mailing Lists

I not checked, but , probably the same information on the "physpos" in the "onstat -l " --- Em qua, 15/7/09, Nilesh Ozarkar <nilesho@us.ibm.com> escreveu: De: Nilesh Ozarkar <nilesho@us.ibm.com> Assunto: Re: Issue about Physical Log Info [16411] Para: ids@iiug.org Data: Quarta-feira, 15 de Julho de 2009, 17:15 > > Issue about Physical Log Info [16407] > > Alexandre Marini > > to: > > ids > > 07/15/2009 10:16 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hello, friends. > We have a recommendation here to increase our physical log, oun our > 11.50.FC4 instance running on Linux 64 bits. > > Our OAT Info page brings that informations about it: > Physical Log Info > Physical Log Size 19.0 GB > Amount Used 2.99 GB > Location 4_28 > Start Offset 6.13 GB > Buffer Size 512 KB > > What OAT means with "Start Offset" ??? It=B4s similar to a dbspace offset ??? > It really means that IDS is "ignoring" 6.13Gb on the begin of the dbspace??? No, 'Start Offset' refers to the current position in the physical log w= here next buffer write will occur. If you refresh the physical log info in OAT after a checkpoint, you wil= l notice the change in Start Offset. > > Best regards !!! > -- > > Alexandre Marini > > Analista de Tecnologia da Informa=E7=E3o - DBA > > SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >= ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

Related threads

Glossary