db2/progs/db_printlog/txn.awk


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

# @(#)txn.awk	10.1 (Sleepycat) 11/1/98
#
# Print out all the records for a comma-separated list of transaction ids.
{
	if (NR == 1) {
		ntxns = 0
		while ((ndx = index(TXN, ",")) != 0) {
			txn[ntxns] = substr(TXN, 1, ndx - 1);
			TXN = substr(TXN, ndx + 1, length(TXN) - ndx);
			ntxns++
		}
		txn[ntxns] = TXN;
	}
}
/^\[/{
	if (printme == 1) {
		printf("%s\n", rec);
		printme = 0
	}
	rec = "";

	for (i = 0; i <= ntxns; i++)
		if (txn[i] == $5) {
			rec = $0
			printme = 1
		}
}
/^	/{
	rec = sprintf("%s\n%s", rec, $0);
}