OnDemand User Group
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Search
Calendar
Login
Register
OnDemand User Group
»
Support Forums
»
MP Server
»
CMOD slow during online DB2 backup
« previous
next »
Print
Pages: [
1
]
Author
Topic: CMOD slow during online DB2 backup (Read 4362 times)
Michel de Kraker
Full Member
Posts: 164
CMOD slow during online DB2 backup
«
on:
April 19, 2012, 12:03:30 AM »
Hi all,
We are experiencing the following.
We start a online DB2 backup at 21:00. This backup runs until 00:00. During this backup retrieval of document is very slow , > 1 minute.
I can imagine that there is a performance penalty when you backup a db2 database while you are retrieving documents.
But clients are complaining about performance and are not happy with it.
Does this sound familiar to you? Or do you have advice for me?
System: AIX / POWER5 / 1 CPU / 2GB memory, all data on DS4300 disks.
thx.
Michel.
Logged
Justin Derrick
IBM Content Manager OnDemand Consultant
Administrator
Hero Member
Posts: 2231
CMOD Guru for hire...
Re: CMOD slow during online DB2 backup
«
Reply #1 on:
April 19, 2012, 03:46:55 AM »
You're obviously constrained somewhere -- CPU or IO or RAM. It's really up to your System Admin to find out.
If you ARE the System Admin, check on the CPU/IO stats with iostat / vmstat / topas.
It's probably time for a hardware upgrade though -- my personal development server (p510Q) is more powerful than your production server!
-JD.
Logged
IBM CMOD Professional Services:
http://TenaciousConsulting.com
Call: +1-866-533-7742 or eMail:
jd@justinderrick.com
IBM CMOD Wiki:
https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:
https://CMOD.Training/
Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR
Michel de Kraker
Full Member
Posts: 164
Re: CMOD slow during online DB2 backup
«
Reply #2 on:
April 20, 2012, 06:00:12 AM »
Thx JD.
After investigating this issue it is indeed IO related. We are transferring everything now to IBM Storwize V7000 luns.
And you are right. system is 5 years old. Within a few months we will migrate everything to POWER7 LPARs.
Brings me to another question.
The current cmod environment is a DR550 solution. In my opinion this is just a marketing term for a cmod black box.
I do not see any problems in migrating everything to POWER7 LPARs. Do you have an opinion on this?
Thanks once again.
Kind regards,
Michel.
Logged
Alessandro Perucchi
Global Moderator
Hero Member
Posts: 1002
Re: CMOD slow during online DB2 backup
«
Reply #3 on:
April 20, 2012, 08:47:55 AM »
Hello Michel,
DR 550 is more an Archiving Storage BlackBox (more a TSM Black Box), that CMOD can use.
And if you are moving CMOD to a new LPAR, then the connection to the DR550 won't change.
Sincerely yours,
Alessandro
Logged
Alessandro Perucchi
#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML
Michel de Kraker
Full Member
Posts: 164
Re: CMOD slow during online DB2 backup
«
Reply #4 on:
April 22, 2012, 11:27:22 AM »
Thx Allessandro,
That was my tought also.
Regards,
Michel.
Logged
demaya
Guest
Re: CMOD slow during online DB2 backup
«
Reply #5 on:
April 22, 2012, 11:54:42 PM »
A DR550 / TSM consultant said some years ago its just an switch "archiveretention = YES" what makes the DR550 so unique. Everything behind is a normal AIX with a TSM-Server... yes its pre configured
Cheers
Logged
dr_te_z
Guest
Re: CMOD slow during online DB2 backup
«
Reply #6 on:
April 23, 2012, 02:51:43 AM »
Which version of DB2 are you using? v9.5 or higher? You might want to look into this:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.dbobj.doc%2Fdoc%2Fc0052483.html
Logged
Michel de Kraker
Full Member
Posts: 164
Re: CMOD slow during online DB2 backup
«
Reply #7 on:
April 23, 2012, 03:12:36 AM »
@mayach
Yes , i know. Unfortunately, someone reinstalled TSM 5 years ago without setting the archiveretention=yes .........
Michel.
Logged
Print
Pages: [
1
]
« previous
next »
OnDemand User Group
»
Support Forums
»
MP Server
»
CMOD slow during online DB2 backup