Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2006
    Posts
    19

    Unanswered: Command to determine the Pagesize

    During the installation of sybase i selected one pagesize, and i dont remeber it now.

    Is there any command from which we can know the pagesize used during setting up the server ?

    Regards,
    Tahir

  2. #2
    Join Date
    Mar 2007
    Posts
    167

    Use Global Variable... @@maxpagesize

    Use Global Variable... @@maxpagesize


    1> select @@maxpagesize
    2> go

    -----------
    4096

    (1 row affected)

  3. #3
    Join Date
    Mar 2007
    Posts
    167

    grep the ASE log file...

    Another way is to use the UNIX grep command against the ASE log file (located in... $SYBASE/$SYBASE_ASE/install/<servername>.log).

    For example...

    -bash-3.00$ grep "pagesize" REG_TEST.log
    00:00000:00001:2006/07/20 19:49:01.39 server The logical pagesize of the server is 4 Kb.

  4. #4
    Join Date
    Dec 2006
    Posts
    19
    Thanks a lot for taking time for my query.......i also got one other command for future refrences i am posting it

    select pagesize ("master..sysobjects")

  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Another alternative which will also work on ASE pre 12.5
    (useful in cross ASE version scripts)
    select v.low as 'pagesize'
    from master.dbo.spt_values v
    where v.number = 1
    and v.type = "E"

  6. #6
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2

    Can get it in RUN_SERVER file

    Also you can get page size info in your RUN_Server file.

  7. #7
    Join Date
    Dec 2013
    Posts
    14
    Quote Originally Posted by yuvaraj.s View Post
    Also you can get page size info in your RUN_Server file.
    Perhaps as a comment, otherwise the page size is not a command line argument for the dataserver/sqlsrvr command.

Posting Permissions

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