Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: Sybase sp_poolconfig command

    I have problem which must be due to my idiotness. when i use the command...

    1> sp_poolconfig "default data cache", "20M", "16K"
    2> go
    Msg 18144, Level 16, State 1:
    Server 'DACS', Procedure 'sp_do_poolconfig', Line 580:
    Source pool (1p) and destination pool (16K) are the same pool. The source and
    destination pools must be different.
    (return status = 1)

    Now as i understand there is a 2k cache as default where the 16K pool should be supplied from ? Have I got this right ? Although when i use ...

    1> sp_cacheconfig "default data cache"
    2> go
    Cache Name Status Type Config Value Run Value
    ------------------ -------- -------- -------------- ------------
    default data cache Active Default 40.00 Mb 40.00 Mb

    (1 row affected)
    ------------ ------------
    Total 40.00 Mb 40.00 Mb
    ================================================== ========================
    Cache: default data cache, Status: Active, Type: Default
    Config Size: 40.00 Mb, Run Size: 40.00 Mb
    Config Replacement: strict LRU, Run Replacement: strict LRU
    Config Partition: 1, Run Partition: 1
    IO Size Wash Size Config Size Run Size APF Percent
    -------- ------------- ------------ ------------ -----------
    16 Kb 8192 Kb 40.00 Mb 40.00 Mb 10
    (return status = 0)


    I do not see the 2k pool .

    Could someone be kind enough to give me a few pointers as i am new to this type of dbase language.
    Many Thanks
    Steve

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    What is select @@maxpagesize
    The smallest pool will be equal to that size

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    I get the following so does this mean i have no 2k pool as default ? And does this mean i have to state a source of 16K .? If so how do i do that ? - tks

    1> select @@maxpagesize
    2> go

    -----------
    16384

    (1 row affected)

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by gollum View Post
    does this mean i have no 2k pool as default?
    Yes, your default is 16k
    So you can create a 128k pool for large I/O

    (2k page server) * (8 extents) = 16k pool
    (4k page server) * (8 extents) = 32k pool
    (8k page server) * (8 extents) = 64k pool
    (16k page server) * (8 extents) = 128k pool

Posting Permissions

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