Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: Strange value in sp_helpsegment

    i use sp_helpsegment to get the result of free pages
    but i found that the value is negative

    what is that means

    I use the dump/load method to get the image from other database
    that with exactly size

    What is it implied?

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    What version of Sybase you are using. I recall a bug in 11.5 long time ago. Here's a copy of the case with Sybase.

    Case Description:
    Stored procedures sp_helpsegment and sp_helpdb return negative free space values.

    Tip or Workaround:
    The negative space values occur because a value in the dbtable structure is incorrect. Sp_helpsegment and sp_helpdb both use a system function curunreservedpgs() which accesses the databases internal memory structure - the DBTABLE - and reads the value for dbt_unrsvd for each database fragment, if this value is negative then the value returned by the procedure will also be negative.

    The fact that the dbt_unrsvd value is incorrect should not in any way effect the space usage in the database. When pages need to be allocated ASE uses the allocation pages and GAM pages, not the value stored in the dbtable, to determine if there is space available. The dbt_unrsvd value should however be regularly updated on extent allocations and deallocations. Currently there are no open bugs logged for these negative dbt_unrsvd values.


    Resolution:
    Currently no bugfix available - reboot the Server as a workaround.

Posting Permissions

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