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:
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\