Sybase Adaptive Server, Configuration Manual

Page: 61 / 150

CHAPTER 3 Configuring the Operating System
Configuration Guide
45
• The
ps
command gives you an accurate snapshot of accumulated CPU
time and usage for individual processes. This can be very helpful in
determining the dataserver-, engine-, and process-specific loading.
• The
time
command can be useful in determining the various user, system,
and real-time resources used over a complete run.
For details about these tools, see your operating system documentation.
A sample C shell maintenance script
Running
dbcc
checks and performing database backups protect the integrity
and recoverability of your Adaptive Server databases. The following sample C
shell script calls several
isql
scripts to help you do this:
#!/bin/csh -f
if ( -e dbcc_mail.out) then
rm dbcc_mail.out
endif
foreach i (*.dbcc)
isql -Usa -Ppassword < $i > dbcc_out
if ( ‘grep -c ‘Msg 25[0-9][0-9]’ dbcc_out’ ) then
echo "There are errors in" $i >> dbcc_mail.out
cat dbcc_out >> dbcc_mail.out
else
echo "Backing up " $i:r >> dbcc_mail.out
isql -Usa -Ppassword < $i:r.backup
endif
end
mail -s "Backup Report" jjones < dbcc_mail.out
The first set of scripts (one for each database with a file name appended with
.dbcc) runs
dbcc checkalloc
and
dbcc checkdb
for each database and sends the
messages to an output file called dbcc_out.
For example, the script
master.dbcc
runs
dbcc
to check the
master
database:
dbcc checkalloc (master)
go
dbcc checkdb (master)
go
The C shell script then runs the
grep
command to find 2500-level error
messages in the
dbcc
output. The results of the
grep
command go into an output
file called dbcc_mail.out.