cancel
Showing results for 
Search instead for 
Did you mean: 

sp_spaceused negative count display

jmtorres
Active Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

jmtorres
Active Participant
0 Kudos

Mark,

Thank you. Where can I get sp_spaceused_syslogs..?

Regards

Jose

,

Thanks Mark,

but where do I get sp_spaceused_syslosgs ?

Jose