Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

high number of comm_waits for a TSM backup

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users high number of comm_waits for a TSM backup
# 1  
Old 07-27-2010
high number of comm_waits for a TSM backup
Hi Guys,

I wonder if someone has come accross an issue where basically our db2 backups are running very slow and one thing that we can see from the TSM report below is that the number of comm_waits has increased dramatically. We asked the question to IBM about what comm_waits would means but according to them even the meaning is quite vague which I found a bit surprising. Please if anyone has a good idea of what the comm_waits means and what sort of actions we should follow to find the root cause of the slow backup. We are running aix 5.3 and tsm tdp client for the database backups. Thanks.


Code:
ENTITY                   COMM_WAIT          ST_DT        ST_TM                   Unnamed[5]              GB
------------------     -----------     ----------     --------     ------------------------     -----------
P01SCVI1_DB2                 21348     2010-07-05     23:00:25            0 06:07:44.000000             144
P01SCVI1_DB2                 21280     2010-07-05     23:01:24            0 06:06:45.000000             143
P01SCVI1_DB2                 15600     2010-07-06     23:00:47            0 04:36:30.000000             143
P01SCVI1_DB2                 15603     2010-07-06     23:01:27            0 04:35:51.000000             144
P01SCVI1_DB2                 18361     2010-07-07     23:01:17            0 05:13:13.000000             144
P01SCVI1_DB2                 18346     2010-07-07     23:01:27            0 05:13:03.000000             144
P01SCVI1_DB2                 19833     2010-07-08     23:01:08            0 05:45:32.000000             143
P01SCVI1_DB2                 19864     2010-07-08     23:01:17            0 05:45:23.000000             144
P01SCVI1_DB2                 20185     2010-07-09     23:00:55            0 05:46:38.000000             138
P01SCVI1_DB2                 20170     2010-07-09     23:01:10            0 05:46:23.000000             138
P01SCVI1_DB2                 18658     2010-07-10     23:00:40            0 05:27:10.000000             144
P01SCVI1_DB2                 18639     2010-07-10     23:01:10            0 05:26:40.000000             144
P01SCVI1_DB2                 18791     2010-07-11     23:00:19            0 05:27:38.000000             144
P01SCVI1_DB2                 18786     2010-07-11     23:01:04            0 05:26:53.000000             144
P01SCVI1_DB2                 20263     2010-07-12     23:01:00            0 05:43:29.000000             106
P01SCVI1_DB2                 20245     2010-07-12     23:01:15            0 05:43:14.000000             107
P01SCVI1_DB2                  2890     2010-07-13     05:00:40            0 02:09:59.000000             144
P01SCVI1_DB2                  2882     2010-07-13     05:00:46            0 02:09:53.000000             144
P01SCVI1_DB2                 14114     2010-07-13     23:01:06            0 04:02:15.000000             144
P01SCVI1_DB2                 14104     2010-07-13     23:01:15            0 04:02:04.000000             144
P01SCVI1_DB2                 12541     2010-07-14     23:01:09            0 03:57:05.000000             146
P01SCVI1_DB2                 12331     2010-07-14     23:01:21            0 03:56:54.000000             142
P01SCVI1_DB2                 20685     2010-07-15     23:00:30            0 05:53:01.000000             148
P01SCVI1_DB2                 20680     2010-07-15     23:01:23            0 05:52:08.000000             148

Last edited by pludi; 07-27-2010 at 08:50 AM.. Reason: code tags, please...
# 2  
Old 07-27-2010
Do the box have bottlenecks on resources like CPU, RAM or disk and network I/O at that time (client and/or TSM server)? Is the db2 busy with something else at the time of the backups? Is there any noticeable network problem like increasing error counters on switches where those boxes are attached?

Maybe an additional post at myadsm.org might be helpful.
# 3  
Old 07-27-2010
nope the box is quiet at the time of the backup. There is a dedicated netwlork link between the database server and the tsm server and doesn't seems to reach more thatn 205 of its capacity.
# 4  
Old 07-28-2010
My knowledge about TSM reaches only back to version 5.2 - does the activity log show a bit more of evidence to the problem?
Way back in time I only had good experience with TSM support from IBM - maybe you try it again hopefully getting a support member that is a bit more tenacious in trying to solve the problem.

Did you open a thread on http://myadsm.org ? I really recommend this.
This User Gave Thanks to zaxxon For This Post:
arizah
# 5  
Old 07-28-2010
Hi,

Actually IBM came back saying there was a network congestion then we found that on our TSM server we have 4 ethernet adapter attach to it and 1 of them was off . We are planning to get that link back on and hopefully the congestion will go aaway. Thanks again for your reply.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tsm commands

hi all, In my shell script, they have used the bplist commands where backup team were using the bplist utility and right now they have changed the utility to TSM. Could you please help me out the revelant commands for TSM utility for the backup. Let me know if you have any idea on tis. (1 Reply)
Discussion started by: ramkumar15
1 Replies

2. Linux

Tsm

my backup team was using the bpclient utility which they are migrated to TSM client. I need to change the script running from bpclient to TSM . if anyone give some inputs that would be great. (2 Replies)
Discussion started by: ramkumar15
2 Replies

3. Red Hat

TSM service not found

Hello, I have some trouble checking the TSM ( Tivoli storage Mgr )service status in Linux box when i am doing service tsm status -bash: service command not found Above command is working fine in all other linux box ( Any idea how to look into this to resolve this, i am clueless from... (2 Replies)
Discussion started by: saurabh84g
2 Replies

4. Shell Programming and Scripting

rsync backup mode(--backup) Are there any options to remove backup folders on successful deployment?

Hi Everyone, we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment? Thanks in adv. (0 Replies)
Discussion started by: MVEERA
0 Replies

5. Red Hat

apache high cpu load on high traffic

i have a Intel Quad Core Xeon X3440 (4 x 2.53GHz, 8MB Cache, Hyper Threaded) with 16gig and 1tb harddrive with a 1gb port and my apache is causing my cpu to go up to 100% on all four cores heres my http.config <IfModule prefork.c> StartServers 10 MinSpareServers 10 MaxSpareServers 15... (4 Replies)
Discussion started by: awww
4 Replies

6. AIX

TSM capacity

Dears, The TSM storage that we have is already configured to backup some Application,directories & logs or let's say backup different path from 15 servers, I want to add more Items to be backuped by this storage, how to be confirmed if that possible or not? I mean how do we know the capacity of... (7 Replies)
Discussion started by: arm
7 Replies

7. AIX

TSM backup and recovery problem

When I use tsm command: archive -subdir=yes /dir1/ to backup file system: /dir1 After I delete the contents under /dir1 and recovery it from TSM backup, retrieve /dir1/ I found the link breaked. Such as: Before: ls -l lrwxrwxrwx 1 abc develop 8 Apr 28 16:04 bin... (1 Reply)
Discussion started by: rainbow_bean
1 Replies

8. AIX

Backup solutions / TSM alternative?

Hey all, I've just about had it with Tivoli Storage Manager. I won't go into the what's and why's. Do any of you have suggestions for an alternative? We have around 70 linux clients and 10 AIX lpars. We mostly do incremental filesystem backups each night and have a 3494 tape library with 3... (2 Replies)
Discussion started by: cruiser
2 Replies

9. UNIX for Dummies Questions & Answers

SCO Backup Problem (bad Sblock Magic Number)

Hi guys, First I have to say that I'm not Unix expert, I just have medium level experince in Unix scripting and some knowledge with a little of hands on experience of unix administration (Solaris only). I have my plans to move ahead in that field but this is a different story. I have a client... (0 Replies)
Discussion started by: SolarisProToBe
0 Replies

10. UNIX for Advanced & Expert Users

Sun: High kernel usage & very high load averages

Hi, I am seeing very high kernel usage and very high load averages on my system (Although we are not loading much data to our database). Here is the output of top...does anyone know what i should be looking at? Thanks, Lorraine last pid: 13144; load averages: 22.32, 19.81, 16.78 ... (4 Replies)
Discussion started by: lorrainenineill
4 Replies
Login or Register to Ask a Question