on 11-17-2016 1:54 PM
Hello,
Running ASE 15.7 SP60 on HP.UX. When executing sp_spaceused, we get a negative count displayed in "reserved" and "data" columns:
1> sp_spaceused
2> go
database_name database_size
------------- -------------
comex 111680.0 MB
(1 row affected)
reserved data index_size unused
------------- ------------- ----------- ---------
-817604568 KB -835007160 KB 16632312 KB 749720 KB
(return status = 0)
I recall that there were some dbcc's (which I don't have now) to update sysusages.
Which would be the correct steps to fix this situation?
note: sp_helpdb reports space OK
Thank you
Jose
Mark,
Thank you. Where can I get sp_spaceused_syslogs..?
Regards
Jose
,Thanks Mark,
but where do I get sp_spaceused_syslosgs ?
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.