ext File

Shell Programming and Scripting
1

I have a log file that I want to extract the field name and the field value
and write them to a text file for importation it a database table for reporting purposes.

How can I extract the desired data from this file .

Example: dbt_dbid=4

dbt_dbid is the field name
4 is the field value

1> use master
1> dbcc traceon(3604)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> dbcc dbtable("TestDB")
DBTABLES (ACTIVE):
DB Table at: 0x0000000021986BA0
 
dbt_dbid=4   dbt_stat=0x0 (0x0000)
dbt_extstat=0x0 (0x0000)
dbt_stat2=0x0 (0x0000)
dbt_stat3=0x20000 (0x00020000 (DBT3_SYSPARTITIONS_EXISTS))
dbt_stat4=0x0 (0x00000000)
dbt_runstat=0x0(0x0000)
dbt_state=0x2(0x0002 (DBST_ACTIVE))   dbt_keep=0  dbt_hdeskeep=0
dbt_next=0x000000002197DE80   dbt_systask_keep=0 dbt_detachxact_keep 0
 dbt_dcompver_default=1
dbt_lock=0  dbt_dbaid=1
dbt_verstimestamp= May 15 2012  3:37PM   dbt_dbname=TestDB
dbt_logrows=0
dbt_lastlogbp=0x0000000000000000
dbt_logsema=000000000099EE10 
dbt_nextseq=11  dbt_oldseq=11
dbt_dbinfobuf.dbi_logvers=7
dbt_dbinfobuf.dbi_upgdvers=35 ... .dbi_upgd_minor=1720
dbt_dbinfobuf.dbi_dbinfovers=5
dbt_dbinfobuf.dbi_sarg_vers=2  dbt_threshstat=0x0
dbt_thresholds=0x00000000219873B8  dbt_thresh_spin=0x000000002011E300
dbt_maxthresh=256
thc_segment   2 thc_level   664 thc_status 0xf <-- last chance threshold
dbt_nextid=560001995 dbt_nextidstat=0x0
dbt_dflinfo=0x0000000000000000  dbt_dflstat=0x0
dbt_dumpthreadlock=0
dbt_dbts=0x0000 0x00001492   dbt_xdesqueue   next=0x0000000021986C20
prev=0x0000000021986C20
dbt_xdesqueue_spin=0x000000002011E100
2

If I understood it correct:

awk -F"[= \t]+" '/dbt_dbid/ {print $1,$2}' infile > newfile
3

How would I go about retrieving all the fields that begin with
dbt_xxxxxxxx= in the file and generating a file with every field
listed.

4

Like this?

# awk -F"[= \t]+" '/^dbt_/ {print $2}' infile
4
0x0
0x0
0x20000
0x0
0x0(0x0000)
0x2(0x0002
0x000000002197DE80
0
May
0
0x0000000000000000
000000000099EE10
11
7
35
5
2
0x00000000219873B8
256
560001995
0x0000000000000000
0
0x0000
0x000000002011E100

If you want the name, add $1 to the print. If you want it redirected, use "> newfile" like in the example before.

5

This file is not formatted with one record(field) on each line
in some instances the more than one field is on the same line
Example: dbt_verstimestamp= May 15 2012 3:37PM dbt_dbname=TestDB

SO how would I grab the date 'May 15 2012 3:37PM' and grab the field dbt_dbname and it valur 'TestDB'

then read the next field.
with the file formated with more than one field on each line I think the delimiter for the next field would be
dbt_

SO how would I modify the script to account for that