Skip to content

Reviewing the last few lines of the db2diag.log

September 24, 2015

For those of us used to using the tail command in UNIX to tail the end of a file or the number of lines of interest, there is a little known option on the db2diag command to enable you to do the same thing. By using the lastlines option you can do this with the db2diag command. See below example:

C:\Users\Administrator>db2diag -lastlines 20
2015-09-24-01.39.36.909000-240 E114014F431        LEVEL: Info
PID     : 2424                 TID  : 11528       PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : GTS_PROD
APPHDL  : 0-7834               APPID: *LOCAL.DB2.150924053010
AUTHID  : DB2ADMIN
EDUID   : 11528                EDUNAME: db2agent (GTS_PROD)
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:906
MESSAGE : Backup complete.

2015-09-24-02.00.31.707000-240 I114447F308        LEVEL: Error
PID     : 13484                TID  : 3784        PROC : db2dasstm.exe
INSTANCE: DB2                  NODE : 000
EDUID   : 3784
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : signed integer, 4 bytes
-204

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: