Bitte beachten: Dem Code auf den folgenden Pages können wichtige Format-Anweisungen (Tabulator, CR/LF etc) und Sonderzeichen (wie z.B. {[]}\~ usw) fehlen!

Datums-Format: MM/DD/YY, also Monat/Tag/Jahr.

Name

Kurzbeschreibung

db2bench.ksh

Executing db2batch Command

db2bench_prefix.awk

Executing db2batch Command

db2bench_prefix.ksh

Executing db2batch Command

db2look.ksh

Executing db2look Command

Epoch Seconds->Date

Umwandlung Epoch Seconds in ein Datum

iostat.awk

Executing iostat Command

iostat.ksh

Executing iostat Command

list_proc.ksh

Printing Application  and Process Information

lock.ksh

Display Lock Information

locks.awk

Display Lock Information

mon_start.ksh

Setting Event Monitor State

mon_stmt.awk

Reporting SQL Statements Information

mon_stmt.ksh

Report SQL Statements Information

sqlcache.awk

Display Statements in Dynamic Cache

sqlcache.ksh

Display Statements in Dynamic Cache

Timestamp

Timestamp-Formattierung in Perl

upd_cfg.awk

Executing GET DBM CFG or GET DB CFG

upd_cfg.ksh

Executing GET DBM CFG or GET DB CFG

xmpDB2Secure.pl

DB2 Security relevante Informationen anzeigen, Quelle ist der DB2 Catalog

xmpLog.pl

DBA Informationen über wichtige Vorgänge  in ein systemweites xmpdba.log schreiben

xmpMail.pl

Wichtige DBA Informationen via sendmail automatisch verschicken

xmpMonitor.pl

DB2 Monitoring Informationen auswerten und in einer speziellen Monitoring Datenbank speichern

xmpPerl.pm

Perl Modul Bibliothek

xmpRHFTool.pl

DB2 Recovery History File Auswertung

xmpTBSCCheck.pl

DB2 Tablespace und Container Check

xmpTBSCList.pl

Listet DB2 Tablespace un Container-Informationen

xmpTBSCStmt.pl

Generiert Redirected Restore und Create Tablespace Statements

xmpTBSCUsage.pl

Zeigt und prüft Auslastung der Tablespaces, generiert Mail bei Threshold-Überschreitung

xmpSetInstance.sh

Set DB2 Environment for one of more instances on a DB Server

xmpDB2Util.sh

Controlled execution of DB2 commands

xmpDB2ClearTable.sh

Shell script for mass delete on DB2 tables without logging

xmpDB2Cfg.pl

Extracts and compares DB2 Database and DB Manager Configurations with references or DB2 defaults

xmpDB2All.sh

Executes DB2 commands on every instance of a database server