Determine Dbspace Pagesize

Posted in 2011

red_valsen — Thu, 25 Aug 2011 05:39:28 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to red_valsen

Art Kagel — Thu, 25 Aug 2011 08:46:12 -0400 — source: Usenet: comp.databases.informix

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@yahoo.com> wrote: > 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@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

Glossary

dbspace