dbTalk Databases Forums  

When did the latest SMI tables show up?

comp.databases.informix comp.databases.informix


Discuss When did the latest SMI tables show up? in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Art Kagel
 
Posts: n/a

Default When did the latest SMI tables show up? - 12-16-2010 , 10:08 AM






Does anyone remember in which releases the following SMI tables first
appear:

sysbufpool
sysactptnhdr

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

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.

Reply With Quote
  #2  
Old   
Southwell Schuyler
 
Posts: n/a

Default RE: When did the latest SMI tables show up? - 12-16-2010 , 10:38 AM






Well, if this can be believed, sysbufpool appeared in 10.0: not sure aboutsysactptnhdr.
http://publib.boulder.ibm.com/infoce....doc/mig44.htm
Changes for Dynamic Server 10.0

The sysdirectives system catalog table was added.

The sysbufpool system-monitoring interface (SMI) table was added, and the following changes were made to other SMI tables:

* The sysfragments table contains a Partition column and the Flags column now tells you if the fragmentation scheme has partitions.
* ....


Schuyler Southwell u Information Technology Division u Maricopa County Attorney's Office u tel: 602.506.8107


________________________________

________________________________
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Art Kagel
Sent: Thursday, December 16, 2010 9:09 AM
To: ids (AT) iiug (DOT) org; IIUG Informix List
Subject: When did the latest SMI tables show up?

Does anyone remember in which releases the following SMI tables first appear:

sysbufpool
sysactptnhdr

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com<http://www.advancedatatools.com>)
IIUG Board of Directors (art (AT) iiug (DOT) org<mailto:art (AT) iiug (DOT) org>)
Blog: http://informix-myview.blogspot.com/

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, orby 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.

Reply With Quote
  #3  
Old   
Art Kagel
 
Posts: n/a

Default Re: When did the latest SMI tables show up? - 12-16-2010 , 11:06 AM



Thanks. Not sure I trust the Information Center since I have three pages of
notes on changes to the SMI database going from 11.50.xC7 to 11.70.xC1 and
none are listed in the Information Center <sigh>. But thanks for the link,
never dug deep enough into the Migration section there to find this before.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

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 Thu, Dec 16, 2010 at 11:38 AM, Southwell Schuyler <
southwel (AT) mcao (DOT) maricopa.gov> wrote:

Quote:
*Well, if this can be believed, sysbufpool appeared in 10.0: not sure
about sysactptnhdr.* *
http://publib.boulder.ibm.com/infoce....doc/mig44.htm
* *Changes for Dynamic Server 10.0*

The *sysdirectives* system catalog table was added.

The *sysbufpool* system-monitoring interface (SMI) table was added, and
the following changes were made to other SMI tables:

- The *sysfragments* table contains a *Partition *column and the *Flags
* column now tells you if the fragmentation scheme has partitions.
- ....





*Schuyler Southwell* u Information Technology Division u Maricopa
County Attorney's Office u tel: 602.506.8107


------------------------------


------------------------------

*From:* informix-list-bounces (AT) iiug (DOT) org [mailto:
informix-list-bounces (AT) iiug (DOT) org] *On Behalf Of *Art Kagel
*Sent:* Thursday, December 16, 2010 9:09 AM
*To:* ids (AT) iiug (DOT) org; IIUG Informix List
*Subject:* When did the latest SMI tables show up?



Does anyone remember in which releases the following SMI tables first
appear:

sysbufpool
sysactptnhdr

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

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.

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list


Reply With Quote
  #4  
Old   
Fernando Nunes
 
Posts: n/a

Default Re: When did the latest SMI tables show up? - 12-16-2010 , 01:47 PM



I believe sysfubpool is there since V10.
sysactptnhdr appeared in version 11 AFAIK. But be careful, because there was
a bug with it... Can't recall exactly, and I'm sure a formal bug was opened
and I'm almost sure it's now fixed.

If someone finds them in previous versions please correct me.
Regards.



On Thu, Dec 16, 2010 at 4:08 PM, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote:

Quote:
Does anyone remember in which releases the following SMI tables first
appear:

sysbufpool
sysactptnhdr

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

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.


_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list



--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.