Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Prather, Wanda
Well, should have mentioned this DS3512 is running DDP firmware, so it's spiffier than average. Sounds like you are looking in all the right places. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Kevin Kettner Sent: Wednesday, March 26, 2014 1

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Kevin Kettner
Thanks, I will investigate that a bit. Sounds plausible. On 3/26/2014 13:04, Colwell, William F. wrote: When I had TSM databases on Netapp - both v5 & v6 - I had to do frequent netapp 'reallocate' commands to get the physical order in the netapp to match the logical order of db2. The db2 backu

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Colwell, William F.
When I had TSM databases on Netapp - both v5 & v6 - I had to do frequent netapp 'reallocate' commands to get the physical order in the netapp to match the logical order of db2. The db2 backup is reading the database sequentially, but within the netapp it is completely out of order. Try doing '

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Gee, Norman
This is when we need a product to gather 24X7 SAN performance data and report on every connections. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Kevin Kettner Sent: Wednesday, March 26, 2014 10:24 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Mov

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Kevin Kettner
That is what I'm leaning towards as well. I've got NetApp looking at the disk end to see if its getting hit hard. I also want to find out if the work load is heavier on reads or write (I'm guessing read) to know what sort of hardware fix is best for this, cache, flash, or more spindles, etc. From

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Kevin Kettner
They are E06 (TS1130) drives. I don't think it's the drives but anything is possible. On 3/26/2014 10:43, Gee, Norman wrote: Are these the original 3592-J1A? They max out at 40 MB per second transfer rate with 2 gig fiber channel. 200 GB backup on LTO4 takes about 20 minutes. I have both a

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Ehresman,David E.
Kevin, My gut reaction is that your disk drives can't feed the data fast enough. If it were me, I would open up a PMR to find out what the real bottleneck is. David Ehresman University of Louisville. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Be

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Gee, Norman
Are these the original 3592-J1A? They max out at 40 MB per second transfer rate with 2 gig fiber channel. 200 GB backup on LTO4 takes about 20 minutes. I have both and could not take the thru put of 3592 on really big items. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM

Re: Moving the TSM DB2 database (AIX)

2014-03-26 Thread Kevin Kettner
On the original question, I have moved DBs on AIX with LVM several times with good success. The only real concern is the performance impact. The benefit over mirroring is you can do it with no outage at all. I have 3 servers with similar sized DBs on AIX with NetApp SAS disk on the back end, back