Reorg Rebuild - Sybase 11.9.2.1

[rche...@my-deja.com]

Hai,

We have Adaptive Server Enterprise 11.9.2.1 Version running on Sun
Solaris. There is a utility called "Reorg Rebuild" available in this
version which helps to rebuild the indexes and updates the system
tables.

Though Sybase Online Manual gives an overview on when to use Reorg
Rebuild command (ie., to check optdiag output and system tables), there
is no specific example or any parameters that have to be checked in the
optdiag output to find the need to run this command.

Can anybody help me on this ?

Thanks,

Raj

Sent via Deja.com http://www.deja.com/
Before you buy.

[rche...@my-deja.com]

[Petehernan]

Raj, I am unclear as to what you are really asking here,,,are you looking for
a way to determine when you need to run REORG?

Here a few suggestions
1. you can query systabstats for object_name(id) and forwrowcnt to determine
how many forwarded rows OR
2. run optdiag at database level and grep out the table names and Cluster
Ratios to determine fragmentation.

Note, if you have finite periods for system maintenance , then you should keep
track of which tables appear to experiencing fragmentation problems. In which
case you should look into the space management attributes 'exp_row_size' ,
'reserve_page_gap' and fillfactor to alleviate problems.

Hope it helps.
Peter N. Hernandez, CSPDBA
Peter N. Hernandez
CSPDBA - Columbus, OH

[raj...@hotmail.com]

Hai,

Let me be clear now. If sp_object_stats stored procedure is executed
and if the total contention on the table exceeds 15%, Sybase recommends
us to go for next level of locking.

Similarly, for running reorg rebuild on a user table, is there any
concrete value that we can check on. For example, assume that a user
table contains 100,000 rows. If the number of forwarded rows is 100 in
systabstats table for that object, does it mean that we have to run
reorg rebuild on this table ???

Can you please give me a concrete example as to when reorg rebuild has
to be run ?

Thanks in advance.

Raj

In article <19991115185835...@ng-ft1.aol.com>,