469,291 Members | 1,765 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

db2adutl query logs showing logs every second

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

Apr 20 '07 #1
1 3795
On Apr 20, 8:58 am, bill.dour...@alstec.com wrote:
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
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

Apr 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by MX1 | last post: by
reply views Thread by hismail | last post: by
reply views Thread by hismail | last post: by
2 posts views Thread by beisens | last post: by
12 posts views Thread by Kevin Blount | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.