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
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?
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?