Archive for the ‘automation’ Category
Monday, October 1st, 2007
Commands below are for Linux, but the idea works everywhere 'sadc' is available.
1) Start
/usr/lib/sa/sadc
Example
machine1:~ # /usr/lib/sa/sadc 2 7200 sadc.outfile
this logs SAR data for 4 hours.
2) Stop logging, do
'killall sadc' or 'kill'
3) Usage of sar. Creating report with all options
sar -A -f
Example
machine1:~ # sar -A -f sadc.outfile > sar.outfile
machine1:~ # cat ...
Posted in performance monitoring, automation, linux | No Comments »
Thursday, June 14th, 2007
Like the Nissan Pathfinder's ad: "not that you would, but you could". In certain performance test conditions, you may have to drop the current DB2 V8 instance, install V9.1, and re-create a instance. Here is a short list of helpful commands - run as root unless specifically sudo'ed:
1. Drop ...
Posted in db tuning, automation, system admin, aix, ibm db2 | No Comments »
Tuesday, June 5th, 2007
Below shows simple steps in Oracle 9i and 10g to backup and restore Oracle databases; the goal is for the tasks to be called remotely so they can be automated as part of a performance test execution (i.e., always restores a known baseline before start a test!)1) Shuts down the ...
Posted in automation, backup and restore, windows, oracle | No Comments »