need tables name of sysmaster database
A user asked which sysmaster (SMI) tables hold information on shared memory, checkpoints and their duration, logical logs, database status, and HDR/RSS status, plus any documentation. John Miller supplied the table names: syssegments, syscheckpoints, syslogs, sysshmvals and sysha_nodes. Art Kagel noted the best documentation is the commented DDL in $INFORMIXDIR/etc/sysmaster.sql, since the manuals cover only some SMI tables, and also pointed to Lester Knutsen's SMI presentations on the IIUG/Advanced DataTools sites. The poster thanked the group.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, i need table name of sysmaster database for getting values of following items --Sheared memory --Check points and its duration --Logical log --Database status --HDR and RSS Status if there is any documentation of sysmaster database then also provide link of that document. Thanks
OMER KHAN wrote: > Hello, > > i need table name of sysmaster database for getting values of following items > > --Sheared memory > --Check points and its duration > --Logical log > --Database status > --HDR and RSS Status > > if there is any documentation of sysmaster database then also provide link of > that document. > Google is your friend -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm
Best documentation of the sysmaster tables is the DDL file that creates the database: $INFORMIXDIR/etc/sysmaster.sql Art On Mon, Mar 16, 2009 at 7:11 AM, OMER KHAN <oskhan@i2cinc.com> wrote: > Hello, > > i need table name of sysmaster database for getting values of following > items > > --Sheared memory > --Check points and its duration > --Logical log > --Database status > --HDR and RSS Status > > if there is any documentation of sysmaster database then also provide link > of > that document. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016360e3bd68601d204653c9d68
Hei buddy!!! Try this: http://publib.boulder.ibm.com/epubs/pdf/ct21nna.pdf []'s T··· Systems do Brasil Ltda Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle F: 55+11-4347-5475 / 2184-2751 email: alberto.pessonio@ts3.com.br Internet: www.t-systems.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: segunda-feira, 16 de Março de 2009 10:42 Para: ids@iiug.org Assunto: Re: need tables name of sysmaster database [15144] Best documentation of the sysmaster tables is the DDL file that creates the database: $INFORMIXDIR/etc/sysmaster.sql Art On Mon, Mar 16, 2009 at 7:11 AM, OMER KHAN <oskhan@i2cinc.com> wrote: > Hello, > > i need table name of sysmaster database for getting values of > following items > > --Sheared memory > --Check points and its duration > --Logical log > --Database status > --HDR and RSS Status > > if there is any documentation of sysmaster database then also provide > link of that document. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016360e3bd68601d204653c9d68 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
See table names below. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 03/16/2009 04:11:20 AM: > Hello, > > i need table name of sysmaster database for getting values of following items > > --Sheared memory syssegments > --Check points and its duration syscheckpoints > --Logical log syslogs > --Database status sysshmvals > --HDR and RSS Status sysha_nodes > > if there is any documentation of sysmaster database then also provide link of > that document. > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
That's the Guide to SQL Reference manual. It covers some of the system catalog tables but not the sysmaster database SMI tables. The Administrator's Reference actually covers SOME of the SMI tables but only a small number and not the most important and useful ones. You can also get some information from Lester Knutsen's presentations on the SMI tables which you can get from the IIUG web site from last year's conference or from Lester's company website at: http://www.advancedatatools.com/TechInfo/InformixInfo.html. However, as I said, the actual DDL file's comments are the best source of information. Art On Mon, Mar 16, 2009 at 10:45 AM, Alberto Pessonio < Alberto.Pessonio@ts3.com.br> wrote: > Hei buddy!!! > > Try this: > > http://publib.boulder.ibm.com/epubs/pdf/ct21nna.pdf > > []'s > > T··· Systems do Brasil Ltda > Alberto Romeu Pessonio Filho > IBM Informix Certified System Administrator V7 > IBM Certified Managing and Optimizing Informix Databases V7 > DBA Informix/DB2 UDB/SQLServer/Oracle > F: 55+11-4347-5475 / 2184-2751 > email: alberto.pessonio@ts3.com.br > Internet: www.t-systems.com.br > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art > Kagel > Enviada em: segunda-feira, 16 de Março de 2009 10:42 > Para: ids@iiug.org > Assunto: Re: need tables name of sysmaster database [15144] > > Best documentation of the sysmaster tables is the DDL file that creates the > database: $INFORMIXDIR/etc/sysmaster.sql > > Art > > On Mon, Mar 16, 2009 at 7:11 AM, OMER KHAN <oskhan@i2cinc.com> wrote: > > > Hello, > > > > i need table name of sysmaster database for getting values of > > following items > > > > --Sheared memory > > --Check points and its duration > > --Logical log > > --Database status > > --HDR and RSS Status > > > > if there is any documentation of sysmaster database then also provide > > link of that document. > > > > Thanks > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those > opinions reflect those of other individuals affiliated with any entity with > which I am affiliated nor those of the entities themselves. > > --0016360e3bd68601d204653c9d68 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016364272518bac3004653e44ff
Thanks for help