Active Logs Full

Hiten

Unregistered / Unconfirmed
Joined
Sep 14, 2010
Messages
99
Reaction score
0
Points
0
Location
I am living in Mumbai.
PREDATAR Control23

Hi,
I am having server with TSM 6.4.x with 80gb database with Active & Archive logs with 30gb volumes. Now a days I observed that even after TSM DB full backup complete successfully Disk on which Activelog path given remains full & there will be no update in Archive logs disk. Active logs size is not getting reduced where I checked with other servers it's happening. Details for the disk size given below

H:\DB01 Size=40gb
H:\DB02 size=40gb

Active logs
J:\Activelogs Size=30gb
Archive Logs
I:\Archivelogs size=30gb
I also observed that my file server monthly backup which was previously taking 7hrs to complete gone up & running till 3 days. Also found daily incremental backup which was completing in 2hrs taking 11hrs to complete. I doubt on hardware front for which I consulted the vendor & verified the drivers & firmware for Tape library & TSM Server which was found ok.
Can someone guide for such performance changes.
 
PREDATAR Control23

The active log contains active transactions, so you will never see it getting reduced by doing a database backup (it will actually increase during). It will reduce as transactions are committed and logs are archived. Once archived, then the archive log can be reduced with a database backup.

If you are running out of active log space, you have 2 options:
- reduce the amount of concurrent activity, this will reduce the number of active transactions at any given time
- increase the size of the active log, your archive log is probably too small too, monitor it.

Two things about your performance:
- first, when the logs are getting near full, the TSM Server starts to delay transactions to avoid filling the logs, this slows down all activity
- second, I see you have H:\DB01 and H:\DB02, are those 2 mount points or 2 directories on the same disk. If the latter, that is a contributing factor.

I recommend you review the best practices for DB and log layout:
DB: http://www-01.ibm.com/support/knowl...com.ibm.itsm.perf.doc/r_chklist_srvdbdsk.html
Logs: http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.perf.doc/r_chklist_srvrlogdsk.html
Log sizing: http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.srv.install.doc/c_srv_inst_active_log_space-windows.html
 
PREDATAR Control23

Thanks Marclant. I migrated the Activelogs in bigger size disk but still the performance is same for the file server backup. Can you guide what parameters we can update which brings the good speed to the backup.
 
Top