Personal tools
You are here: Home DB2 How To's Where to find information about transactions Logs
Navigation
Log in


Forgot your password?
 
Document Actions

Where to find information about transactions Logs

Total of log file size, What is the First active log file , What is the Path to log files


Issue the following command below to extract information about transactions log.

Where "sample" is the database name.


db2 get db cfg for sample
....

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 2
 Changed path to log files                  (NEWLOGPATH) =
 Path to log files                                       = C:\DB2\NODE0000\SQL00
002\SQLOGDIR\
 Overflow log path                     (OVERFLOWLOGPATH) =
 Mirror log path                         (MIRRORLOGPATH) =
 First active log file                                   = S0000002.LOG
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Percent of max active log space by transaction(MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

...

With the output above you can extract a lot of information about transactions logs:

Total of log file size:


You have to sum the two variables below:

 Number of primary log files                 (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 2

________________________________________________________
                                                                                 5


Now, you have to multiple the followings values:

Log file size (4KB)                         (LOGFILSIZ) = 1000


4KB*1000 = 4000 KB


Finally, multiply the sum of LOGPRIMARY and LOGSECOND variables by 4000KB, you will have:

4000KB*5=20000KB or 20MB


So, the space reserved for transactions log file is 20MB



What is the First active log file  ?


In the output above you can find the following parameter:

First active log file                           = S0000002.LOG

So, the first active log file is S0000002.LOG




What is the Path to log files  ?


In the output above you can find the following parameter:

Path to log files                                       = C:\DB2\NODE0000\SQL00
002\SQLOGDIR\


So, the path to log file is C:\DB2\NODE0000\SQL00002\SQLOGDIR\

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls