Coming from Oracle background:

How do you carry thiese admin tasks in Sybase Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions


Thanks for help.

soal6570 (AT) yahoo (DOT) com (Frank) wrote in message news:<42601b2.0404230147.2a014f5f (AT) posting (DOT) google.com>...
Hi, it's a long time ago I used Oracle, but I remember some of the
differences.

If I remember, instances and listerner are separate processes in
Oracle, Sybase includes all of them in a single multithread process,
so the kernel and network listeners are included in the single Sybase
service.

The errorlog of Sybase is usualy located under
$SYBASE\ASE-12_5\install\errorlog and it's a ascii file that can be
scanned for errors or warnings

1. ALL page, Data page, Row locking (at create or alter table)
2. Update statistics , sp_modifystats, optdiag (to help query
optimizer)
3. sp_object_stats (contention, deadlock .. stats on objects)
4. sp_showplan (to understand the usage of the indexes)
this is not an exhaustive list

database it self, the extends are automatic, you don't have to handle
them
sp_spaceused gives you an idea of the size of a table (and his
indexes)


Hope this small resume helps,

sorry for
I don't know what you mean about that.

Cheers, from belgium