Kbase 13689: 6.3 Gather script to gather promon information in batch mode
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
6.3 Gather script to gather promon information in batch mode
#!/bin/sh
# gather -- get statistics out of promon without user interaction
# gather takes two arguments, the database name and the name of a
# file to place the output.
#
# This version gathers the interesting sar data during the same
# interval output is placed in the file named in the third argument
# If this option is not available or you want to use vmstat instead
# please comment out the sar line and substitute the appropriate line.
#
# syntax: gather dbname mon.out sar.out
#
# where
# dbname is the name of the database
# mon.out is the name of the file to capture the promon output
# sar.out is the name of the file to capture the sar outputt
#
# gather reads the file gather.answers for input to promon
# gather.answers has the following fields:
#
# m /* this goes into the modify defaults screen */
# 1 /* change screen size */
# 50 /* the new screen size set large enough to handle all users */
# q /* return to main menu */
# 1 /* user control screen */
# q /* return to menu */
# R&D /* go to R&D section of promon */
# s /* get a 30 second sample */
# 10 /* misc counts */
# q
# 11 /* space allocation */
# q
# 12 /* i/o */
# q
# 13 /* queues */
# q
# 14 /* shared memory locks */
# q
# 15 /* shared memory */
# q
# 16 /* buffer pool */
# q
# 17 /* before image */
# q
# 18 /* after image */
# q
# 9 /* activity */
# q
# 3 /* block access */
# q
# q /* quit promon */
echo "gather statistics on database" $1 "into output file" $2
echo "sar data into" $3
echo "enter y to continue"
read ans
case $ans in
y) echo "this takes about 1 minute..."
sar -ucmd 5 10 > $3 &
promon $1 > $2 < gather.answers;;
*) echo "aborted"; exit 1;;
esac
# *** END of gather script ***
# gather.answers
# These answers could change depending on what version of progress
# progress you are running.
# include everything below this line:
m
1
50
q
1
1
q
R&D
s
10
q
11
q
12
q
13
q
14
q
15
q
16
q
17
q
18
q
9
q
3
q
q
# *** END of gather.answers
Progress Software Technical Support Note # 13689