onstat -g arc x systable

need to know which table stores the information displayed in osntat-g arc, must know the date of execution of the last backup

versão em questão é 10.00 e 11.5

Sysmaster:sysdbspaces On Feb 23, 2011 8:36 PM, "ELIEL FERRAZ" <elielmferraz.dba@gmail.com> wrote: > need to know which table stores the information displayed in osntat-g arc, > must know the date of execution of the last backup > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001517503b08ab5301049cfd662e

The following select should provide what you need: select dbsnum, name, decode(level0,0,"NEVER",DBINFO("utc_to_datetime",level0)::char(40)) as level0, decode(level1,0,"NEVER",DBINFO("utc_to_datetime",level1)::char(40)) as level1, decode(level2,0,"NEVER",DBINFO("utc_to_datetime",level2)::char(40)) as level2 from sysmaster:sysdbstab; 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 02/23/2011 05:35:49 PM: > [image removed] > > onstat -g arc x systable [22891]> > ELIEL FERRAZ > > to: > > ids > > 02/23/2011 05:40 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > need to know which table stores the information displayed in osntat-g arc, > must know the date of execution of the last backup > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hello, my friends. There are excelent "ready to go" queries on two articles, check it out!!!! https://www.ibm.com/developerworks/mydeveloperworks/blogs/informix_admins_blog/e ntry/logical_logfile_monitoring_using_smi_tables_part_ii5?lang=en Best regards! Em 23/02/2011 22:18, John Miller iii escreveu: > The following select should provide what you need: > > select > dbsnum, name, > decode(level0,0,"NEVER",DBINFO("utc_to_datetime",level0)::char(40)) as > level0, > decode(level1,0,"NEVER",DBINFO("utc_to_datetime",level1)::char(40)) as > level1, > decode(level2,0,"NEVER",DBINFO("utc_to_datetime",level2)::char(40)) as > level2 > from sysmaster:sysdbstab; > > 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 02/23/2011 05:35:49 PM: > >> [image removed] >> >> onstat -g arc x systable [22891]>> >> ELIEL FERRAZ >> >> to: >> >> ids >> >> 02/23/2011 05:40 PM >> >> Sent by: >> >> ids-bounces@iiug.org >> >> Please respond to ids >> >> need to know which table stores the information displayed in osntat-g > arc, >> must know the date of execution of the last backup >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 <http://www.iiug.org/conf/2011/iiug/>;