db2adutl query logs showing logs every second

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill.dourado@alstec.com - 20 Apr 2007 14:58 GMT

Using DB2:-

Product identifier SQL08027
Level identifier 03080106
Level DB2 v8.1.14.292
Build level s061108
PTF WR21377

Using the db2adutl query logs showing archived logs every second even
though the Task Center schedule is set to run every hour. (archiving
is done via TSM fron DB2 Task Center.

Sample:-

Log file: S0267687.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.57.38
Log file: S0267688.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.57.57
Log file: S0267689.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.58.12
Log file: S0267690.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.58.27
Log file: S0267691.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.58.37
Log file: S0267692.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.58.49
Log file: S0267693.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.59.01
Log file: S0267694.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.59.13
Log file: S0267695.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.59.25
Log file: S0267696.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.59.34
Log file: S0267697.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-08.59.48
Log file: S0267698.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.00.00
Log file: S0267699.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.00.17
Log file: S0267700.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.00.32
Log file: S0267701.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.00.46
Log file: S0267702.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.01.05
Log file: S0267703.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.01.22
Log file: S0267704.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.01.35
Log file: S0267705.LOG, Chain Num: 4, DB Partition Number: 0, Taken
at: 2007-04-20-09.01.54

Any advice would be appreciated.

Thanks

Fred

Reply to this Message

arunrocks@gmail.com - 20 Apr 2007 18:34 GMT

> Using DB2:-
>
[quoted text clipped - 54 lines]
>
> Fred

Instead of doing it in the task center, I think you have also pointed
the logarchmeth2(archive
method 2) to TSM, and hence when the active logs become full, the
archival sends them to directly to tsm, do check the logprimary and
logsecond parameters on how many active logs you want to have, you may
consider increasing them, so that archival is not done so frequently.
Also check out the size of the log files, and increase them if needed.

Bye
Arun

Reply to this Message