Backup Central

Hi,

On one of my tsm server Activity Log Size: 3,742 M so it is very
difficult to get information from actlog - response time for 24 hour is
too high and if we query for more then 24 hr then not sure on output...

Could you please suggest the solution without touching retention period
?.. TSM server version - 5.5 .4.3 on AIX


Regards,
Ajay Patel

Upgrade to 6.2.3. Much faster

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Ajay Patel
Sent: Thursday, November 17, 2011 1:35 PM
To: ADSM-L < at > VM.MARIST.EDU
Subject: [ADSM-L] TSM 5.5 actlog size..

Hi,

On one of my tsm server Activity Log Size: 3,742 M so it is very
difficult to get information from actlog - response time for 24 hour is
too high and if we query for more then 24 hr then not sure on output...

Could you please suggest the solution without touching retention period
?.. TSM server version - 5.5 .4.3 on AIX


Regards,
Ajay Patel

i copy records daily to a MySQL database, where i keep a year's worth of
data. i can then keep the retention period low on the TSM database.

MySQL is running on a salvaged box from the trash pile (it actually took
several boxes to make up one good one), running CentOS Linux. reporting
is done using Perl and Apache, with no impact on the TSM server and zero
cost.

On 11/17/2011 03:35 PM, Ajay Patel wrote:
Hi,

On one of my tsm server Activity Log Size: 3,742 M so it is very
difficult to get information from actlog - response time for 24 hour is
too high and if we query for more then 24 hr then not sure on output...

Could you please suggest the solution without touching retention period
?.. TSM server version - 5.5 .4.3 on AIX


Regards,
Ajay Patel

-----------------------------------------
NOTICE: This communication is intended only for the person or
entity to whom it is addressed and may contain confidential,
proprietary, and/or privileged material. Unless you are the
intended addressee, any review, reliance, dissemination,
distribution, copying or use whatsoever of this communication is
strictly prohibited. If you received this in error, please reply
immediately and delete the material from all computers. Email sent
through the Internet is not secure. Do not use email to send us
confidential information such as credit card numbers, PIN numbers,
passwords, Social Security Numbers, Account numbers, or other
important and confidential information.