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.