Sponsored Content
Top Forums UNIX for Advanced & Expert Users high number of comm_waits for a TSM backup Post 302440422 by arizah on Tuesday 27th of July 2010 07:25:17 AM
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...
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
All times are GMT -4. The time now is 09:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy