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