Re: Fwd: [ADSM-L] Lun versus logical volume for DB volumes

2014-07-17 Thread Prather, Wanda
SM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Harris Sent: Wednesday, July 16, 2014 8:43 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Fwd: [ADSM-L] Lun versus logical volume for DB volumes Thanks Ron for the reply Its actually moot as the back end is XIV behind SVCs.

Re: Lun versus logical volume for DB volumes

2014-07-16 Thread Rhodes, Richard L.
ck -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Harris Sent: Wednesday, July 16, 2014 8:43 AM To: ADSM-L@VM.MARIST.EDU Subject: Fwd: [ADSM-L] Lun versus logical volume for DB volumes Thanks Ron for the reply Its actually moot as the b

Fwd: [ADSM-L] Lun versus logical volume for DB volumes

2014-07-16 Thread Steven Harris
s Advisor - Tivoli Storage > IBM Certified Deployment Professional > Butterfly Solutions Professional > 916-458-5726 (Office > 925-457-9221 (cell phone) > > email: *ron.delaw...@us.ibm.com* > > From:Steven Harris > To:ADSM-L@vm.marist.edu > Da

Re: Lun versus logical volume for DB volumes

2014-07-15 Thread Ron Delaware
torage Services Offerings From: Steven Harris To: ADSM-L@vm.marist.edu Date: 07/15/2014 06:55 PM Subject:[ADSM-L] Lun versus logical volume for DB volumes Sent by:"ADSM: Dist Stor Manager" Hi, I've specced a design for a new TSM server and as recom

Lun versus logical volume for DB volumes

2014-07-15 Thread Steven Harris
Hi, I've specced a design for a new TSM server and as recommended have specified multiple luns for the database. The folklore is that DB2 will start one thread per lun so for a big database you use 8 luns and hence get 8 threads. My AIX guy is asking whether I really need 8 luns or will 8 AIX lo

Re: Adding TSM DB volumes

2011-11-17 Thread Howard Coles
L@VM.MARIST.EDU] On Behalf Of Andrew Carlson Sent: Thursday, November 17, 2011 9:09 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Adding TSM DB volumes I ran into this issue with 6.2.2 and ultimately, after talking with IBM, I had to do a dump/restore to have it start using the space. I wou

Re: Adding TSM DB volumes

2011-11-17 Thread Andrew Carlson
I ran into this issue with 6.2.2 and ultimately, after talking with IBM, I had to do a dump/restore to have it start using the space. I would get ahold of IBM and see if they have figured out a different way to do this. On Thu, Nov 17, 2011 at 08:34, Ehresman,David E. wrote: > My TSM 6.2.3 TSM D

Adding TSM DB volumes

2011-11-17 Thread Ehresman,David E.
My TSM 6.2.3 TSM DB (running on AIX) was getting a bit full for comfort, so I added a 5th DB volume. It immediately showed 19.28BM used on the new volume but no more space has been used there over the last week or two. Is this the way it is supposed to work? When should it start to use the ne

Load TSM DB from db volumes on disk

2010-09-30 Thread Mario Behring
Hi all, How can I reload database files (*.dsm) using the dsmserv commands? I used the dsmserv format instead of loadformat so I have empty database files with default configuration The old DB files and RecLog files are therehow can I use it again? TSM is 5.5.4.0 running on Windows 2003

Reload TSM DB from db volumes on disk

2010-09-30 Thread Mario Behring
Hi list, Is there any way to reload the TSM database after issuing a dsmserv format command? The volumes from the previous TSM Database and RecLog are availablebut now TSM is pointing to new empty volumes. TSM is 5.5.4.0 running on Windows 2003. Thanks Mario

Re: Reload TSM DB from db volumes on disk

2010-09-29 Thread Grigori Solonovitch
To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Reload TSM DB from db volumes on disk Hi list, Is there any way to reload the TSM database after issuing a dsmserv format command? The volumes from the previous TSM Database and RecLog are availablebut now TSM is pointing to new empty volumes. TSM

Reload TSM DB from db volumes on disk

2010-09-29 Thread Mario Behring
Hi list, Is there any way to reload the TSM database after issuing a dsmserv format command? The volumes from the previous TSM Database and RecLog are availablebut now TSM is pointing to new empty volumes. TSM is 5.5.4.0 running on Windows 2003. Thanks Mario

DB Volumes

2006-04-21 Thread Baughman, Ray
I have only one mount point for a 20G TSM database which is 70% utilized. Which is more effecent one big volume, several medium sized volumes or many smaller volumes? I'm on 5.3.2. Ray Baughman TSM & Engineering Systems Administrator National Machinery LLC Phone 419-443-2257 Fax 419-443-2376 E

Re: Deleting TSM db volumes in lightly utilized db

2005-12-09 Thread Remco Post
Eric Winters wrote: > Dear All, > > Cannot seem to find a way to delete db volumes in a lightly used TSM db. > > Environment is as follows; > > TSM Server 5.3 on Windows. > > q db > > Available Assigned Maximum Maximum Page Total > Used

Re: Deleting TSM db volumes in lightly utilized db

2005-12-08 Thread David le Blanc
[EMAIL PROTECTED] > -Original Message- > From: Eric Winters [mailto:[EMAIL PROTECTED] > Sent: Friday, 9 December 2005 2:21 PM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Deleting TSM db volumes in lightly utilized db > > Dear All, > > Cannot seem to find

Deleting TSM db volumes in lightly utilized db

2005-12-08 Thread Eric Winters
Dear All, Cannot seem to find a way to delete db volumes in a lightly used TSM db. Environment is as follows; TSM Server 5.3 on Windows. q db Available Assigned Maximum Maximum Page Total Used PctMax. SpaceCapacity ExtensionReduction

Re: mirror DB Volumes as remote-SAN device?

2005-07-13 Thread Jin Bae Chi
Matt, Can you share more about the distance and SAN infrastructure that TSM I/O travels through? Many answers would be depending on them. As we know, TSM DB mirroring is at the SW level after OS or HW. First, try to avoid the redundant mirroring at TSM application with OS or HW since you con

mirror DB Volumes as remote-SAN device?

2005-07-13 Thread Warren, Matthew (Retail)
Hi *SM'ers, We are looking into the possibility of placing TSM DB mirror volumes on remote SAN devices. Has anyone already done this, and have any gotchas or issues? My first concern would be latency, but With mirrorwrite sequential it seems from the explanation that the primary mirror volume is

Re: Question about mirrored DB volumes

2005-05-27 Thread Roger Deschner
Shouldn't be a problem, as long as you continue to use TSM mirroring for all parts of it. There have been lively debates as to whether TSM mirroring, OS mirroring, or hardware/microcode RAID is best for the database. Some combinations are known to be dangerous for data integrity - OS mirroring on

Question about mirrored DB volumes

2005-05-26 Thread Farren Minns
Morning all Running TSM 5.1.6.2 on Solaris. At present I am running the TSM server on a Sun E250 server with 4 internal 17GB disks. Two of them are used for the OS ( software mirrored ) and the other two are used to house the TSM database and log volumes ( using TSM mirroring ). At the moment the

Re: TSM DB Volumes

2005-01-20 Thread Daniel Sparrman
: Dist Stor Manager" 2005-01-20 17:20 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject TSM DB Volumes Hi all I'm reading on how to delete DB volume ... and I'm a bit confuse ... In the Admin book .. they take 4 small volumes

TSM DB Volumes

2005-01-20 Thread Luc Beaudoin
Hi all I'm reading on how to delete DB volume ... and I'm a bit confuse ... In the Admin book .. they take 4 small volumes and move them to one big one ... Is there a best practice or advantages to have 1 big volume or 5 small ones In my case I have 4 volumes of 4GB and 1 of 20GB .. I would

Re: TSM Performance across many small DB Volumes?

2004-12-10 Thread Andrew Raibeck
I have no experience-based input to offer on the performance benefits of multiple, smaller db volumes versus fewer, larger db volumes. But regarding a couple of other points you raised: - For a database restore, there is no requirement to map the database volumes one for one. As long as the

Re: TSM Performance across many small DB Volumes?

2004-12-10 Thread Richard Sims
On Dec 10, 2004, at 9:43 AM, David Moore wrote: ...If I consolidate the database over fewer volumes (say, 10 2500MB volumes, rather than 50 500MB volumes), will there be any performance gains? ... David - The TSM Performance Tuning Guide recommends for OS/390: Place the TSM server database an

Re: TSM Performance across many small DB Volumes?

2004-12-10 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Moore >Also, if I do move forward with the volume consolidation, >should I do a UNLOADDB, LOADFORMAT, LOADDB first? Will that >lead to smoother database maintenance? You need to dig into the TSM administrator manuals mo

TSM Performance across many small DB Volumes?

2004-12-10 Thread David Moore
Hello List - TSM 5.2.3 z/OS 1.5 When I came on board as the TSM Admin eight months ago, my site had 46 db volumes of 500MB each. Since that time, I've had to increase the DB a few times, so (not knowing otherwise), I've added 4 more volumes of 500MB each. I have no complaints ab

Re: Maximum number of DB volumes

2003-06-16 Thread Stapleton, Mark
From: Ford, Phillip [mailto:[EMAIL PROTECTED] > We have TSM version 4.2.1.15 (moving soon to a 5... level) > running on AIX > 4.3.3. Another TSM manager told me that there should be a > maximum of 16 DB > volumes. They said that there could be more but that they > had hea

Re: Maximum number of DB volumes

2003-06-16 Thread Thach, Kevin
According to the training manuals for TSM 4.X and 5.X, you should not have more than 12 DB volumes. Yet we have 16, and at one point we had 32 and saw no performance degradation. There seems to be no end to the debate on this issue. We are on AIX 4.3.3 and have been with this config from 4.2.X

Re: Maximum number of DB volumes

2003-06-16 Thread Miller, Ryan
Storage Manager v4.1 -Original Message- From: Ford, Phillip [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:05 PM To: [EMAIL PROTECTED] Subject: Maximum number of DB volumes We have TSM version 4.2.1.15 (moving soon to a 5... level) running on AIX 4.3.3. Another TSM manager told

Maximum number of DB volumes

2003-06-16 Thread Ford, Phillip
We have TSM version 4.2.1.15 (moving soon to a 5... level) running on AIX 4.3.3. Another TSM manager told me that there should be a maximum of 16 DB volumes. They said that there could be more but that they had heard that there is system degradation if one was to use more that 16 DB volumes

Re: How many DB volumes?

2003-06-13 Thread Richard Sims
>Are there advantages to using 10 X 2GB dbvols as >opposed to using 1 X 20GB? Thank you.. You'll find years of discussions on this in the List archives... More disk arms obviously mean better opportunity for performance. More volumes means a server thread dedicated to each, and so another opportun

How many DB volumes?

2003-06-13 Thread Douglas Currell
Are there advantages to using 10 X 2GB dbvols as opposed to using 1 X 20GB? Thank you.. __ Post your free ad now! http://personals.yahoo.ca

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Gianluca Mariani1
Placing TSM DB volumes over multiple physical volumes can improve performances because the DB is read-oriented, the LVM will spread the load over the various volumes. if the number of volumes is too high, though, your performance will be hit by the overhead on the Logical Volume Manager. the

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Seay, Paul
-Original Message- From: Dan Foster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 3:08 AM To: [EMAIL PROTECTED] Subject: Re: Does TSM use all DB Volumes for I/O? Hot Diggety! Kilchenmann Timo was rumored to have written: > I would vary much appreciate an answer to

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread David Longo
Basically it uses DB and LOG volumes by filling up the first then moving to the next one. Of course as things progress, some of the first volumes can be less than 100% full, this is more so on DB Volumes. The LOG is a sequentially written device. This is most easily observered when a new

Re: Does TSM use all DB Volumes for I/O?

2002-10-01 Thread Dan Foster
Hot Diggety! Kilchenmann Timo was rumored to have written: > I would vary much appreciate an answer to the question: Does TSM use all DB > volumes for I/O (like round-robin) or does it fill a volume and then goes > to the next one? I do not know for sure, because I don't know o

Does TSM use all DB Volumes for I/O?

2002-10-01 Thread Kilchenmann Timo
Dear all, I have looked through the adsm.org archives. The answers I got from the archives are not consistent. I would vary much appreciate an answer to the question: Does TSM use all DB volumes for I/O (like round-robin) or does it fill a volume and then goes to the next one? What about LOG

Re: DB Volumes

2002-04-12 Thread Boireau, Eric (MED)
1 30 70 39 30, DC: 8*644 3930 mailto:[EMAIL PROTECTED] -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 7:08 PM To: [EMAIL PROTECTED] Subject: DB Volumes Question: Lets say I have 4 36gb disks. Is it better to create one db volume

Re: DB Volumes

2002-04-12 Thread Andrew Carlson
ffrey L. wrote: > Question: > > Lets say I have 4 36gb disks. > > Is it better to create one db volume sized at 33gb on 2 disks, and mirror it > on the others, or should you create 2 16.5gb db volumes on each 36gb disk > and mirror those on the other 2 disks? > > Geoff Gil

DB Volumes

2002-04-12 Thread Gill, Geoffrey L.
Question: Lets say I have 4 36gb disks. Is it better to create one db volume sized at 33gb on 2 disks, and mirror it on the others, or should you create 2 16.5gb db volumes on each 36gb disk and mirror those on the other 2 disks? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E

Re: TSM OS/390 DB "volumes"

2001-09-19 Thread Jim Armstrong
Zoltan, I've moved TSM database components using DFDSS copy successfully. Only restriction is that you need TSM down of course, but as you say, its a lot faster, and easier than using the 'delete dbvolume' command Jim == For more information on Standard Life, visit our website http

Re: TSM OS/390 DB "volumes"

2001-09-18 Thread Zoltan Forray/AC/VCU
t; 09/18/2001 12:24 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: TSM OS/390 DB "volumes" It's so easy to move using TSM processes, why would you want to use some other utility. The good thing about

Re: TSM OS/390 DB "volumes"

2001-09-18 Thread Jim Sporer
It's so easy to move using TSM processes, why would you want to use some other utility. The good thing about using TSM to do the move is you don't even have to take the TSM server down. All you have to do is allocate and format the new volume, then add it as a mirror and delete the old volume. J

TSM OS/390 DB "volumes"

2001-09-18 Thread Zoltan Forray/AC/VCU
Is there anything internal for a OS/390 TSM DataBase "volume" (i.e. the VSAM LINEAR d/s), that prevents me from moving it using a standard system utility ? Could I move the linear d/s, using FDR or DSS or are there internal location-type pointers that would destroy the DB if pyhsically moved usi

log and db volumes on emc symmetrix disk

2001-06-28 Thread Joel Fuhrman
A long time back there was a discussion as to whether it's better to have one or multiple tsm volumes per physical disk. As I remember, the answer was: assuming the entire physical disk volume was being used by one storage pool, it was best to create one large tsm volume rather than several small

Re: How to delete db volumes?

2001-05-11 Thread Joe Faracchio
get 0 volumes found but there are 4 db > volumes tape volume is libv . > By query libv i can see them and query volhist also i can see. > > >delete volhist type=dbbackup todate=today > > i get above message that 0 seqvolumes found. > what is going wrong? > > pl help > t

Re: How to delete db volumes?

2001-05-11 Thread Fred Johanson
o: [EMAIL PROTECTED] >Subject: Re: How to delete db volumes? > > >Are they the active dbb? That can't be deleted. > > >At 11:13 AM 5/11/2001 -0500, you wrote: > >Hi > > > >when the following cmd is given i get 0 volumes found but there are 4 db >

Re: How to delete db volumes?

2001-05-11 Thread PINNI, BALANAND (SBCSI)
PROTECTED]] Sent: Friday, May 11, 2001 11:19 AM To: [EMAIL PROTECTED] Subject: Re: How to delete db volumes? Are they the active dbb? That can't be deleted. At 11:13 AM 5/11/2001 -0500, you wrote: >Hi > >when the following cmd is given i get 0 volumes found but there are 4 db >vo

Re: How to delete db volumes?

2001-05-11 Thread Fred Johanson
Are they the active dbb? That can't be deleted. At 11:13 AM 5/11/2001 -0500, you wrote: >Hi > >when the following cmd is given i get 0 volumes found but there are 4 db >volumes tape volume is libv . >By query libv i can see them and query volhist also i can see. >

How to delete db volumes?

2001-05-11 Thread PINNI, BALANAND (SBCSI)
Hi when the following cmd is given i get 0 volumes found but there are 4 db volumes tape volume is libv . By query libv i can see them and query volhist also i can see. >delete volhist type=dbbackup todate=today i get above message that 0 seqvolumes found. what is going wrong? pl help tha