Explore Sysmaster
Hi, how can we explore sysmaster database ? Is there any graphical representation available (in ERD form) for sysmaster db ? Also, how can we know that update statistics required for any particular table ? When we run update statistics, is there any way that we can calculate/identify the remaining time (for update statistics) ? We are using IDS 11.FC5-W1 for Solaris Sparc. Thanks.
Hello. I suppose you are using 11.50.FC5W1, so here´s the tip: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id s_adr_0268.htm?resultof=%22%73%6d%69%22%20%22%74%61%62%6c%65%73%22%20 The sysmaster is called SMI tables on oficial docs, ok? Hope it helps. Regarding the needs of running update statistics, this topic has already been discussed here this week, I think! (check on the search pages, Mr Art Kagel answered it ok?) Best regards! Em 15/10/2010 11:11, SHAHZAD SALAM KASI escreveu: > Hi, > how can we explore sysmaster database ? Is there any graphical representation > available (in ERD form) for sysmaster db ? > > Also, how can we know that update statistics required for any particular table > ? > When we run update statistics, is there any way that we can calculate/identify > the remaining time (for update statistics) ? > > We are using IDS 11.FC5-W1 for Solaris Sparc. > > Thanks. > > > ******************************************************************************* > 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 IBM Informix Dynamic Server Certified Professional V10 / V11
Go to the IIUG website (www.iiug.org) and look in the download section of the members only pages for conference downloads. In there you will find Lester Knutsen's presentation materials on the SMI tables in the sysmaster database. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 15, 2010 at 11:11 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote: > Hi, > how can we explore sysmaster database ? Is there any graphical > representation > available (in ERD form) for sysmaster db ? > > Also, how can we know that update statistics required for any particular > table > ? > When we run update statistics, is there any way that we can > calculate/identify > the remaining time (for update statistics) ? > > We are using IDS 11.FC5-W1 for Solaris Sparc. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016364eecfe579fbd0492ab9ab3