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
1  3954 
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jason |
last post by:
I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that...
|
by: shenanwei |
last post by:
I have DB2 backed up to TSM from the production system.
How can I use db2adutl to view the backup info from other server
instead of production.
|
by: Dom |
last post by:
I need to run a query based on a query in Access. The second query has
a number of conditions which all work well, but there is one more
contition I need to set to make it run properly.
the...
|
by: MX1 |
last post by:
Here's a type of query I'm always having trouble with. There are 4 fields
in a web access log table.
User | Date | Time | Destination
I want to show all the instances of a user hitting a...
|
by: hismail |
last post by:
I am creating a vb.net service that will run AS SERVICE. There is
actually a timer; so the timer will run every 2 minutes and see if
there are any new ERROR type logs in the APPLICATION logs. And...
|
by: hismail |
last post by:
1. hism...@dot-solution.net Aug 16, 2:51 pm show options
Newsgroups: microsoft.public.vb.general.discussion
From: hism...@dot-solution.net - Find messages by this author
Date: 16 Aug 2005...
|
by: Wired Hosting News |
last post by:
I tried to be breif and give a scenario so as not to be overlooked because
it was soooo long. Let me give you real world.
I am a manufacturer of goods and produce 11 items that are distributed...
|
by: beisens |
last post by:
Our DB2 V8 FP14 application cleans up backups over 8 days old using
the "db2adutl delete full older than 8 days" command. However our user
has asked that we keep one backup for a year. Is there any...
|
by: Kevin Blount |
last post by:
I'm having a very odd issue, that arose this morning after working
fine yesterday...
here's a very simple script:
1: <?php
2: $test = $_GET;
3: echo "Hello" . $test . "<p>";
4: ?>
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
