Hi all,


I am strugling to find the pagesize of Informix Qurey,
I know ouside of Qurey onstat -b can give it , but if i could get it through qurey it would be realy flexible.

In IDS select value/1024 from sysshmhdr where (name='bufsize')
works

But For informix XPS name , value pair dont exsit , do any one have some other idea?

Thanks in Advance
With Regards
Stiju

Depends what version of IDS you are using.
For v<10 there is only one page size for all spaces:
For v>=10 every single space can have its own page size:
HTH

But both are not valid for XPS,
Is there some other table storing this information for XPS?
i forgot to mention about XPS in previous post