SQL Anywhere database - sa_table_fragmentation and sa_index

Author

sa_table_fragmentation and sa_index_density not returning any rows

2005-05-26, 7:23 am

Using ASA 9.0.2.3044 on WinXP sp1 (logged in as DBA).
DB-file size is 2GB - around 200 tables.

In ISQL I've tried
call sa_table_fragmentati
on ();
and
call sa_index_density();

They take a couple of minutes to finish, but none of them return any rows?!

Is there a prerequisite I'm missing?

regards/Peter Simonsen

Chris Keating \(iAnywhere Solutions\)

2005-05-26, 9:23 am

This is a known issue with DBISQL and is addressed ih the 3124 EBF which is
currently available. You will need to rebuild or upgrade the database using
that fix to address the issue.

A workaround is to uncheck the "commit after each statement" option.

<Peter Simonsen> wrote in message news:4295b067@forums
-2-dub...
> Using ASA 9.0.2.3044 on WinXP sp1 (logged in as DBA).
> DB-file size is 2GB - around 200 tables.
>
> In ISQL I've tried
> call sa_table_fragmentati
on ();
> and
> call sa_index_density();
>
> They take a couple of minutes to finish, but none of them return any
> rows?!
>
> Is there a prerequisite I'm missing?
>
> regards/Peter Simonsen
>
>
>

Sponsored Links