In db2 environment,
there are two types of logs namely PRIMARY and SECONDARY
1q)i know secondary can allocated dynamically, then what is the need of primary??
2q) Apart from above point what is the difference between primary and secondary
3q) what is the specific need of primary and secondary
4q)what we have 2 types of logs
As per my knowledge,
primary + secondary = 256
(secondary =-1 <=> infinity , i dont have clear idea whether we can use this option in real time or not)
4q)in my environment,
Log file size (4KB) (LOGFILSIZ) = AUTOMATIC
Number of primary log files (LOGPRIMARY) = AUTOMATIC
Number of secondary log files (LOGSECOND) = AUTOMATIC
In this case,
if total of both primary and secondary exceeds 256 , what type of error we ca get, simple moving commited log files to another location will solve the issue??
(because in my log path, already 158 logs are there)
according the doc : this is not correct
logfilsiz can not be changed dynamically - deactivate - activate is needed for primary logs..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be