Unix Code - Detail View


Date

Name

Plattform

Language

Kurzbeschreibung

Owner

Link

19.10.2001

db2bench_prefix.awk

Unix

Shell

Executing db2batch Command

IBM Copr. 2000

ftp://www.redbooks.ibm.com/redbooks/sg246012

DB2 ist ein Produkt der
IBM Corporation. Bitte
Copyright-  und Trademark-Hinweise beachten!

BEGIN{
TOP        = 1;
PREFIX     = ENVIRON[ "PREFIX" ];
}
{
PUT_PREFIX = 0 ;
}
#/Statement number: /{ TOP=0 }
#TOP{ PUT_PREFIX=1 }
(NR <= TOP){ PUT_PREFIX=1 }
/            \*\*\* Database Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Bufferpool Snapshot \*\*\*/{ PUT_PREFIX=1 }
/Bufferpool Name  .* = /{ PUT_PREFIX=1 }
/            \*\*\* Bufferpool Info Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Application Info Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Application Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Statement Details  \*\*\*/{ PUT_PREFIX=1 }
/Statement operation  .* = /{ PUT_PREFIX=1 }
/        \*\*\* List of Associated Agents \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Tablespace Header Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Tablespace Snapshot \*\*\*/{ PUT_PREFIX=1 }
/Tablespace Name .* = /{ PUT_PREFIX=1 }
/            \*\*\* Table Header Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* Table Snapshot \*\*\*/{ PUT_PREFIX=1 }
/Table Name .* = /{ PUT_PREFIX=1;TAB=$NF}
/Table File ID .* = / && (TAB == "="){ PUT_PREFIX=1 }
/            \*\*\* Database manager Snapshot \*\*\*/{ PUT_PREFIX=1 }
/            \*\*\* FCM Snapshot \*\*\*/{ PUT_PREFIX=1 }

{sub( /^\[.*\]: /, "") }# Strip existing prefix
PUT_PREFIX{printf "[%-15.15s]: ", PREFIX }# Prefix
{print }

© Gernot Ruban