Hi all,

After execute 'sp_helpdb test_db', the following result returned:

device_fragments size usage free
kbytes
------------------------------ ------------- -------------------- ----------
------
test_data1 2047.0 MB data only
70
test_data2 2047.0 MB data
-202
test_data3 2047.0 MB data only
1935234
test_log1 511.0 MB log only not
applicable

Is it normal for "test_data2" as it shown "-202" in free kbytes column??
Anyone know?

Thanks a lot!

"jerke szabo" <jerkeszabo (AT) hotmail (DOT) com> wrote

Never encountered it myself but from Sybase:

"The negative space values occur because a value in the dbtable structure is
incorrect. Sp_helpsegment and sp_helpdb both use a system function
curunreservedpgs() which accesses the databases internal memory structure -
the DBTABLE - and reads the value for dbt_unrsvd for each database fragment,
if this value is negative then the value returned by the procedure will also
be negative.

The fact that the dbt_unrsvd value is incorrect should not in any way effect
the space usage in the database. When pages need to be allocated ASE uses
the allocation pages and GAM pages, not the value stored in the dbtable, to
determine if there is space available. The dbt_unrsvd value should however
be regularly updated on extent allocations and deallocations. Currently
there are no open bugs logged for these negative dbt_unrsvd values.

Resolution:
Currently no bugfix available - reboot the Server as a workaround."

What version are you on?

Martin

Thanks for your information.

The version is: Adaptive Server Enterprise/12.0.0.3/P/SWR 9643 ESD 2


"Martin Hanna" <postmaster (AT) SPAMIGNOREmovillaIGNOREplus (DOT) com> ¼¶¼g©ó¶l¥ó
news:9KFcc.30612$Y%6.3766858 (AT) wards (DOT) force9.net...

"jerke szabo" <jerkeszabo (AT) hotmail (DOT) com> wrote

Well..for Sybase 12.0 on Solaris they say:

Tip or Workaround:
Run dbcc usedextents(0, 1, 1) and reboot ASE to correct. Boot ASE with trace
7412 in the run file to scan allocation pages and update free space.

Resolution:
CRs 256318, 254794, 236517 are all fixed by 12.0.0.4IR