dbTalk Databases Forums  

Determine Dbspace Pagesize

comp.databases.informix comp.databases.informix


Discuss Determine Dbspace Pagesize in the comp.databases.informix forum.



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

Default Determine Dbspace Pagesize - 08-25-2011 , 07:39 AM






What query can I run vs. sysmaster or system catalog tables to
determine the pagesize for a given dbspace?

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

Default Re: Determine Dbspace Pagesize - 08-25-2011 , 07:46 AM






select name, pagesize from sysmaster:sysdbspaces where name = 'mydbspace';

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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, Aug 25, 2011 at 8:39 AM, red_valsen <red_valsen (AT) yahoo (DOT) com> wrote:

Quote:
What query can I run vs. sysmaster or system catalog tables to
determine the pagesize for a given dbspace?
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

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.