Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008
    Posts
    18

    Question Unanswered: Finding Pagesize through Qurey

    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
    Last edited by Blackprince; 03-24-09 at 03:13.

  2. #2
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    Depends what version of IDS you are using.
    For v<10 there is only one page size for all spaces:
    Code:
    select sh_pagesize from sysshmvals
    For v>=10 every single space can have its own page size:
    Code:
    select name, pagesize from  sysdbspaces
    HTH

  3. #3
    Join Date
    Nov 2008
    Posts
    18
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •