dbtugetss.sh

This is a small script that captures all possible snapshot data for the given database into a file and displays it.

>>--- dbtugetss.sh --- ALIAS ---><

Syntax diagram

After calling the script with the database alias (ALIAS - normally the same as the database name), all monitor switches are activated. Then the outputfile is cleaned up and filled by the data from the two snapshots.

db2 GET SNAPSHOT FOR DBM
db2 GET SNAPSHOT ALL ON DB <ALIAS>

Sample commands

The outputfile is shown via the less command/tool. (If it hasn't been installed in your environment, then a) install it, b) create an alias pointing to the more command/tool or c) change the script.) When you leave less by pressing "q", the script ends also. Please note, the output file will not be removed, so you can have a second look at the outputfile later on.