simple awk problem

Shell Programming and Scripting
1

Hello;

I have the following log file:

10/11/11  10:42:02  LOCK Q Userid:284 Username=root UserPID:23158 Device:marlin batch
10/11/11  10:42:02         TableNr:226 TableName:iatkn RecId:116290398 Flags:X    Q H
10/11/11  10:42:02     LOCK CONTENTION X
10/11/11  10:42:02                  Userid:320 Username:root UserPID:19808 Device:marlin batch
10/11/11  10:42:03                  Table:iatkn RecId:116290398 Flags:X
10/11/11  10:42:03  /uscripts/dsl/com/snmpalert.sh "MESSAGE:1040" "deva Q_LOCK: Userid:284 Username:root UserPID:23158 Device:marlin batch TableNr:226 TableName:iatkn RecId:116290398 Flags:X    Q H WAITING FOR X_LOCK: Userid:320 Username:root UserPID:19808 Device:marlin batch Flags:X       "

I want to select the lines so that I get the following output:

10/11/11  10:42:02  LOCK Q Userid:284 Username=root UserPID:23158 Device:marlin batch
10/11/11  10:42:02     LOCK CONTENTION X
10/11/11  10:42:02                  Userid:320 Username:root UserPID:19808 Device:marlin batch

I tried the following but obviously it is not working.

awk '/LOCK Q/ || /LOCK CONTENTION X/ {getline;print}' deva.db_locks_exc2.status
10/11/11  10:42:02         TableNr:226 TableName:iatkn RecId:116290398 Flags:X    Q H
10/11/11  10:42:02                  Userid:320 Username:root UserPID:19808 Device:marlin batch

Thank you for any help

2

Hi delphys,

Try:

$ cat infile
10/11/11 10:42:02 LOCK Q Userid:284 Username=root UserPID:23158 Device:marlin batch
10/11/11 10:42:02 TableNr:226 TableName:iatkn RecId:116290398 Flags:X Q H
10/11/11 10:42:02 LOCK CONTENTION X
10/11/11 10:42:02 Userid:320 Username:root UserPID:19808 Device:marlin batch
10/11/11 10:42:03 Table:iatkn RecId:116290398 Flags:X
10/11/11 10:42:03 /uscripts/dsl/com/snmpalert.sh "MESSAGE:1040" "deva Q_LOCK: Userid:284 Username:root UserPID:23158 Device:marlin batch TableNr:226 TableName:iatkn RecId:116290398 Flags:X Q H WAITING FOR X_LOCK: Userid:320 Username:root UserPID:19808 Device:marlin batch Flags:X "
$ awk 'BEGIN { IGNORECASE = 1 } $3 ~ /(lock|userid)/' infile
10/11/11 10:42:02 LOCK Q Userid:284 Username=root UserPID:23158 Device:marlin batch
10/11/11 10:42:02 LOCK CONTENTION X
10/11/11 10:42:02 Userid:320 Username:root UserPID:19808 Device:marlin batch

Regards,
Birei

3

Try

awk '/LOCK Q/ {print} /LOCK CONTENTION X/ {print;getline;print}' deva.db_locks_exc2.status
4

Thank you .. the extra print was what I was missing