Sybase sp_helpdb shows for 'data only' that 'free kbytes' is almost the same as the size, So, it seems that the database does not have any data. But we do know that it has data because many tables returned xxx rows. Sysusages also shows the unreservedpgs is the same as the size.
How can we correct this? This has been in this state for several days already and the backup that we have probably also has this and I prefer to just correct (if possible), instead of reloading backup.
We have ASE 12.5.2.
sp_spaceused did confirm that there is data in the database, and Sybase Central shows about 10GB free.
Since checkalloc requires single-user mode and as Joe said, I/O intensive and takes a long time (the database is a 24GB DB). this has to be scheduled during our Sunday maintenance window. Hopefully, 3 hours is enough.
Meanwhile, we tried 'dbcc usedextents'. After this, sp_helpdb seemed correct (at least it was not equal to the size). However, after Sybase is recycled (with -T7408), sp_helpdb reverted back to report free kb = size of the fragments. Did we miss something here?