SEO

I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
pretty much in Sybase specially in UNix env. Please give me some
initial things that I have to check, for example

Check ENV vatiables
where is the Server logs?
Ps - ef | grep ???
Server status , health check??
select @@version
crontab -l
backup? they run sqlbacktrack also!
?
?



Please give me some better guideline, some more commands to check and
if you have an organized doc for a new dba env I greatly appreciate
your help.

Check out the The Boss Sybase DBA page at
http://www.bossconsulting.com/sybase_dba/
Rob Verschoor's site at http://www.sypron.nl/download.html
Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
"Frank" <soal6570@yahoo.com> wrote in message
news:42601b2.0404131900.27a8c76@posting.google.com ...
> I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> pretty much in Sybase specially in UNix env. Please give me some
> initial things that I have to check, for example
>
> Check ENV vatiables
> where is the Server logs?
> Ps - ef | grep ???
> Server status , health check??
> select @@version
> crontab -l
> backup? they run sqlbacktrack also!
> ?
> ?
>
>
>
> Please give me some better guideline, some more commands to check and
> if you have an organized doc for a new dba env I greatly appreciate
> your help.

Thanks Willie, That's a good one but doesn't over all. Seems there is
not too many good Sybase web sites there. Any other suggestion?
What's the best advanced technical dba bood for 12.5?

"Willie Kraatz" <wkraatz@csc.com> wrote in message news:<c5jc4p$l7j$1@lore.csc.com>...
> Check out the The Boss Sybase DBA page at
> http://www.bossconsulting.com/sybase_dba/
> Rob Verschoor's site at http://www.sypron.nl/download.html
> Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
> "Frank" <soal6570@yahoo.com> wrote in message
> news:42601b2.0404131900.27a8c76@posting.google.com ...
> > I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> > pretty much in Sybase specially in UNix env. Please give me some
> > initial things that I have to check, for example
> >
> > Check ENV vatiables
> > where is the Server logs?
> > Ps - ef | grep ???
> > Server status , health check??
> > select @@version
> > crontab -l
> > backup? they run sqlbacktrack also!
> > ?
> > ?
> >
> >
> >
> > Please give me some better guideline, some more commands to check and
> > if you have an organized doc for a new dba env I greatly appreciate
> > your help.

"Frank" <soal6570@yahoo.com> wrote in message
news:42601b2.0404150321.71ffdac9@posting.google.co m...
> Thanks Willie, That's a good one but doesn't over all. Seems there is
> not too many good Sybase web sites there. Any other suggestion?
> What's the best advanced technical dba bood for 12.5?
>


Pick up a copy of the System Admin Guide from sybooks.sybase.com/as.html (in
PDF format, and free). I think that'll answer many of your questions.
Otherwise, see www.sypron.nl/sybbooks.html .

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

To answer part of your original post, below are the routine tasks that I
follow. Others administrators will have different tasks and priorities. It
depends on your business requirements. I have 22 ASE servers (versions
11.03, 11.9.2, 12.0, 12.5) all run almost identical scripts and procedures.
A number of the scripts and procedures to accomplish these tasks can be
found via the previously posted links.



Daily - backup each database

Daily (and as needed via threshold processing) - dump transaction log

Daily - check success of nightly backups

Daily - check available of space in each database segment (watch trends)

Daily - check ASE server error log using egrep -f ${WORRIES} WORRIES is a
file containing key words to pull messages

Daily (twice) - run sp_sysmon and save to file



Hourly - Run and record elapsed time for a standardized set of DDL to
measure performance as seen by a user

Hourly - save current value of ( @@connections , @@cpu_busy , @@idle ,
@@io_busy , @@pack_received , @@pack_sent , @@packet_errors ,

@@timeticks , @@total_errors , @@total_read , @@total_write , @@trancount ,
@@servername )



Weekly - Print / plot max, min, avg response time from hourly checks to
monitor trends, etc.

Weekly - check high water mark for concurrent users in syblicenseslog

Weekly - extract DDL using DDLGEN and homegrown tools/procedures

Weekly - print chart showing daily/hourly changes of @@connections and
@@total_read (others available by special run)

Weekly - run dbcc checkstorage on all databases

Weekly - test each database backup for restoration (Using SQL BackTrack
dryrun facility)



Monthly - update index statistics on all tables



"Frank" <soal6570@yahoo.com> wrote in message
news:42601b2.0404150321.71ffdac9@posting.google.co m...
> Thanks Willie, That's a good one but doesn't over all. Seems there is
> not too many good Sybase web sites there. Any other suggestion?
> What's the best advanced technical dba bood for 12.5?
>
> "Willie Kraatz" <wkraatz@csc.com> wrote in message
news:<c5jc4p$l7j$1@lore.csc.com>...
> > Check out the The Boss Sybase DBA page at
> > http://www.bossconsulting.com/sybase_dba/
> > Rob Verschoor's site at http://www.sypron.nl/download.html
> > Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
> > "Frank" <soal6570@yahoo.com> wrote in message
> > news:42601b2.0404131900.27a8c76@posting.google.com ...
> > > I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> > > pretty much in Sybase specially in UNix env. Please give me some
> > > initial things that I have to check, for example
> > >
> > > Check ENV vatiables
> > > where is the Server logs?
> > > Ps - ef | grep ???
> > > Server status , health check??
> > > select @@version
> > > crontab -l
> > > backup? they run sqlbacktrack also!
> > > ?
> > > ?
> > >
> > >
> > >
> > > Please give me some better guideline, some more commands to check and
> > > if you have an organized doc for a new dba env I greatly appreciate
> > > your help.

Thanks VERY much Willie, you are a good expert.

Just one thing you mentioned is interesting but I like to know how I
implement that : you said u use egrep -f ${WORRIES) to grab all
errors, can you show me how do you build the WoRRIES file and how does
it work?

Regards
Frank


"Willie Kraatz" <wkraatz@csc.com> wrote in message news:<c5mikl$os7$1@lore.csc.com>...
> To answer part of your original post, below are the routine tasks that I
> follow. Others administrators will have different tasks and priorities. It
> depends on your business requirements. I have 22 ASE servers (versions
> 11.03, 11.9.2, 12.0, 12.5) all run almost identical scripts and procedures.
> A number of the scripts and procedures to accomplish these tasks can be
> found via the previously posted links.
>
>
>
> Daily - backup each database
>
> Daily (and as needed via threshold processing) - dump transaction log
>
> Daily - check success of nightly backups
>
> Daily - check available of space in each database segment (watch trends)
>
> Daily - check ASE server error log using egrep -f ${WORRIES} WORRIES is a
> file containing key words to pull messages
>
> Daily (twice) - run sp_sysmon and save to file
>
>
>
> Hourly - Run and record elapsed time for a standardized set of DDL to
> measure performance as seen by a user
>
> Hourly - save current value of ( @@connections , @@cpu_busy , @@idle ,
> @@io_busy , @@pack_received , @@pack_sent , @@packet_errors ,
>
> @@timeticks , @@total_errors , @@total_read , @@total_write , @@trancount ,
> @@servername )
>
>
>
> Weekly - Print / plot max, min, avg response time from hourly checks to
> monitor trends, etc.
>
> Weekly - check high water mark for concurrent users in syblicenseslog
>
> Weekly - extract DDL using DDLGEN and homegrown tools/procedures
>
> Weekly - print chart showing daily/hourly changes of @@connections and
> @@total_read (others available by special run)
>
> Weekly - run dbcc checkstorage on all databases
>
> Weekly - test each database backup for restoration (Using SQL BackTrack
> dryrun facility)
>
>
>
> Monthly - update index statistics on all tables
>
>
>
> "Frank" <soal6570@yahoo.com> wrote in message
> news:42601b2.0404150321.71ffdac9@posting.google.co m...
> > Thanks Willie, That's a good one but doesn't over all. Seems there is
> > not too many good Sybase web sites there. Any other suggestion?
> > What's the best advanced technical dba bood for 12.5?
> >
> > "Willie Kraatz" <wkraatz@csc.com> wrote in message
> news:<c5jc4p$l7j$1@lore.csc.com>...
> > > Check out the The Boss Sybase DBA page at
> > > http://www.bossconsulting.com/sybase_dba/
> > > Rob Verschoor's site at http://www.sypron.nl/download.html
> > > Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
> > > "Frank" <soal6570@yahoo.com> wrote in message
> > > news:42601b2.0404131900.27a8c76@posting.google.com ...
> > > > I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> > > > pretty much in Sybase specially in UNix env. Please give me some
> > > > initial things that I have to check, for example
> > > >
> > > > Check ENV vatiables
> > > > where is the Server logs?
> > > > Ps - ef | grep ???
> > > > Server status , health check??
> > > > select @@version
> > > > crontab -l
> > > > backup? they run sqlbacktrack also!
> > > > ?
> > > > ?
> > > >
> > > >
> > > >
> > > > Please give me some better guideline, some more commands to check and
> > > > if you have an organized doc for a new dba env I greatly appreciate
> > > > your help.

I have attached the scripts that I use to check the errorlog. They are
written to my environment that supports mulitple releases and multiple
databases on the same UNIX host. But you should be able to adjust them to
fit your needs. Error messages are reported for the last 2 days. This does
give duplicates on succeeding days, but I don't miss anything.



You may also wish to check Rob Verschoors's example at
http://www.sypron.nl/chklog.html

Crontab entry

/usr/local/sybtools/common/sybase_message.sh sybase-11 PSAIX1_SYBASE_2
/usr/local/sybase-11.0.3/install/PSAIX1_SYBASE_2_errorlog

"Frank" <soal6570@yahoo.com> wrote in message
news:42601b2.0404182044.3f19bdd0@posting.google.co m...
> Thanks VERY much Willie, you are a good expert.
>
> Just one thing you mentioned is interesting but I like to know how I
> implement that : you said u use egrep -f ${WORRIES) to grab all
> errors, can you show me how do you build the WoRRIES file and how does
> it work?
>
> Regards
> Frank
>
>
> "Willie Kraatz" <wkraatz@csc.com> wrote in message
news:<c5mikl$os7$1@lore.csc.com>...
> > To answer part of your original post, below are the routine tasks that I
> > follow. Others administrators will have different tasks and priorities.
It
> > depends on your business requirements. I have 22 ASE servers (versions
> > 11.03, 11.9.2, 12.0, 12.5) all run almost identical scripts and
procedures.
> > A number of the scripts and procedures to accomplish these tasks can be
> > found via the previously posted links.
> >
> >
> >
> > Daily - backup each database
> >
> > Daily (and as needed via threshold processing) - dump transaction log
> >
> > Daily - check success of nightly backups
> >
> > Daily - check available of space in each database segment (watch trends)
> >
> > Daily - check ASE server error log using egrep -f ${WORRIES} WORRIES is
a
> > file containing key words to pull messages
> >
> > Daily (twice) - run sp_sysmon and save to file
> >
> >
> >
> > Hourly - Run and record elapsed time for a standardized set of DDL to
> > measure performance as seen by a user
> >
> > Hourly - save current value of ( @@connections , @@cpu_busy , @@idle ,
> > @@io_busy , @@pack_received , @@pack_sent , @@packet_errors ,
> >
> > @@timeticks , @@total_errors , @@total_read , @@total_write ,
@@trancount ,
> > @@servername )
> >
> >
> >
> > Weekly - Print / plot max, min, avg response time from hourly checks to
> > monitor trends, etc.
> >
> > Weekly - check high water mark for concurrent users in syblicenseslog
> >
> > Weekly - extract DDL using DDLGEN and homegrown tools/procedures
> >
> > Weekly - print chart showing daily/hourly changes of @@connections and
> > @@total_read (others available by special run)
> >
> > Weekly - run dbcc checkstorage on all databases
> >
> > Weekly - test each database backup for restoration (Using SQL BackTrack
> > dryrun facility)
> >
> >
> >
> > Monthly - update index statistics on all tables
> >
> >
> >
> > "Frank" <soal6570@yahoo.com> wrote in message
> > news:42601b2.0404150321.71ffdac9@posting.google.co m...
> > > Thanks Willie, That's a good one but doesn't over all. Seems there is
> > > not too many good Sybase web sites there. Any other suggestion?
> > > What's the best advanced technical dba bood for 12.5?
> > >
> > > "Willie Kraatz" <wkraatz@csc.com> wrote in message
> > news:<c5jc4p$l7j$1@lore.csc.com>...
> > > > Check out the The Boss Sybase DBA page at
> > > > http://www.bossconsulting.com/sybase_dba/
> > > > Rob Verschoor's site at http://www.sypron.nl/download.html
> > > > Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
> > > > "Frank" <soal6570@yahoo.com> wrote in message
> > > > news:42601b2.0404131900.27a8c76@posting.google.com ...
> > > > > I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> > > > > pretty much in Sybase specially in UNix env. Please give me some
> > > > > initial things that I have to check, for example
> > > > >
> > > > > Check ENV vatiables
> > > > > where is the Server logs?
> > > > > Ps - ef | grep ???
> > > > > Server status , health check??
> > > > > select @@version
> > > > > crontab -l
> > > > > backup? they run sqlbacktrack also!
> > > > > ?
> > > > > ?
> > > > >
> > > > >
> > > > >
> > > > > Please give me some better guideline, some more commands to check
and
> > > > > if you have an organized doc for a new dba env I greatly
appreciate
> > > > > your help.