Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Unanswered: Sybase devices and segments

    I'm a MS SQL guy that has to admin a very old Sybase database, upgraded to ASE 15.02. I rely some what on Sybase Central. My current confusion is
    unix on salaris

    1. Sybase Central reports a segment has 3 gig free, yet an object on that segment fails on insert, sybase reporting only .5 meg free.

    2. This old database is composed of many 2 gig devices. I started making my devices 5 gig +, but when I assign them to the database, it never takes more than 2 gigs. I can't find a config setting that limits device size.

    Sybase central reports the device (say 5 gig) as 5 gigs, 3 gigs unused

    but querying the database returns 5 gigs, 0 unused.

    Any info would be greatly appreciated!

    PS. I don't believe any ordinary maintenance has been done to this database over time. It has tables with excess of 1 billion rows
    Last edited by Manodak; 07-16-09 at 15:47.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    What version of Sybase Central & plug-in version are you using?
    The link between sysusages and sysdevices changed in ASE 15
    How was the upgrade done?
    Is it now using a different page size?
    How did you query the database to determine free space?

  3. #3
    Join Date
    Jan 2009
    Posts
    4
    Sybase Central 4.3.0.2437

    Servers were upgraded by first moving them to 12.5, then to 15.02.

    I just got here at the end of the conversion (product of consultant)

    Currently still use 2k pages.

    These databases are 14 years old and never had a DBA managing them, so I know basic stuff like reorg, shrink, rebuild indexes, etc. were never done.

    Some of my confusion is Sybase Central reports (Table view)

    that a particular table has 90,000 89,750 used 250 free.

    But the table is assigned to a segment, and the segment says it has 2.5 gigs free.

    With those numbers, it then fails on insert; reporting to SQL that were was on .5 megs free space.

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    OK so the version is not a problem.
    Free space on a table does not include all the free space on the segment
    Space is allocated in extents and the free space is the space remaining on the extent before allocating the next extent. (It can also indicate wasted space from deletes/updates)
    You might have to update statistics to get proper space usage info on tables
    What is the exact error message you get?

Posting Permissions

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