Estimate of backup files

2004-09-21 Thread RAMNAWAZ NAVEEN
Hi, I would like to use the command line interface to run a command (or select statement) to get an estimate of the total size of objects backed up under a particular filesystem by a particular node for a particular date. In fact I want to achive the same result as provided by the TSM client

Re: D2D on AIX

2004-09-21 Thread Loon, E.J. van - SPLXM
Hi Ian! Because you can't reclaim DISK volumes. TSM stores files in aggregates which will only be freed when all files within the aggregate become expired. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Ian Hobbs [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: D2D on AIX

2004-09-21 Thread Loon, E.J. van - SPLXM
Hi Eliza! You do want several smaller files, rather than a few very large files because each client session will allocate a volume. File volumes cannot be used concurrently by more than one session. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Eliza

Which TSM client code to use for Linux

2004-09-21 Thread David Browne
We are ordering 2 IBM Blade servers for a Oracle project. They will be running Red Hat Linux Enterprise Advanced Server 3.0. What is the most stable TSM client code? The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL

Urgent .. Empty files restored ..!!!

2004-09-21 Thread hussein hasan
HI TSMers under ZOS , using TSM4.2 one client W2000 formated the hard disk and he needs to restore his files After restore operation completed . objects failed =0 objects restored = 13766 but number of bytes transferred = 0! some file names looks rubbish and all the files are

Re: Which TSM client code to use for Linux

2004-09-21 Thread David E Ehresman
We've been using 5.1.6.0 with no problems. I expect we'll move to the latest 5.2 sometime in the not so distant future just to stay current. David Ehresman University of Louisville [EMAIL PROTECTED] 9/21/2004 7:21:29 AM We are ordering 2 IBM Blade servers for a Oracle project. They will be

Re: Urgent .. Empty files restored ..!!!

2004-09-21 Thread Richard Sims
On Sep 21, 2004, at 8:54 AM, hussein hasan wrote: ... some file names looks rubbish and all the files are empty , i mean the size=0 bytes for all ... Hussein - My first thought would be to do 'dsmc q backup -ina FileName' for at least one of the problem filenames and see what's in the

Re: Urgent .. Empty files restored ..!!!

2004-09-21 Thread Curtis Stewart
If he used dsmc to run the restore, is there a chance that all he got was directories? I've done that in the past with poorly typed dsmc commands, albeit under Unix, not Windows. [EMAIL PROTECTED] Richard Sims [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/21/2004

Re: D2D on AIX

2004-09-21 Thread Johnson, Milton
IBM gave a webinar on DISK ONLY backups including the advantages of DISK vs. FILE device classes. While your mileage may vary, in general it seems that a FILE devclass will give better performance for large pools (read TB not GB). Two quick examples: 1) With DISK TSM keeps track of each 4K block

AIX/TSM Paging Space and Memory Settings

2004-09-21 Thread Curtis Stewart
Well, interesting results from the changes we made to our vmtune settings yesterday. We have one TSM instance running with JFS2 for database, logs and storage pools, and another on all raw. We run two database backups daily, a full and a snapshot. Last evening's snapshot was 5,000,000 pages an

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
And with DISK device class there is no multi-session restore. -Original Message- From: Ian Hobbs [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 5:26 PM To: [EMAIL PROTECTED] Subject: Re: D2D on AIX Question, Why not use the DISK device class with RAW volumes?

FW: unsubscribe

2004-09-21 Thread Terry McColgan
bye

Re: D2D on AIX

2004-09-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rushforth, Tim And with DISK device class there is no multi-session restore. Are you sure? I seem to recall using RESOURCEUTILIZATION to run a multi-threaded restore or two from DISKPOOL. -- Mark Stapleton ([EMAIL PROTECTED])

Re: Duel tape write to LTO's

2004-09-21 Thread Timothy Hughes
Hi Milton, When TSM writes simultaneously to the copypool would this be on the 2nd Library for duel tape backup? Johnson, Milton wrote: You should be able to create a PRIMARY STGPOOL named TAPEPOOL and a COPY STGPOOL named COPYPOOL with both of them having a sequential access (tape) DEVICE

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
Yes, try again. If it works it is a bug (don't tell IBM)! If data is on a DISK device class and Tape (or file device class) you can have 1 session from disk and other sessions from tape. -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21,

OT: Flushing 3494 ATL Queue

2004-09-21 Thread Zoltan Forray/AC/VCU
This is slightly OT but came up through TSM on z/OS and hoping some 3494 gurus are listening. Started noticing lots of tape failures/abends (S613-1C) on TSM 5.1.8.x server on z/OS. After doing some digging and noticing the problem was almost always occuring on 1-drive, came upon this weird

Re: Duel tape write to LTO's

2004-09-21 Thread Johnson, Milton
It depends upon where you define the copypool to reside. If it is contained in the 2nd library then yes. Has anyone out there in TSM land actually used this feature? What happens to the back-up when one of the tape volumes fills up? Does it go into a media wait state until the next volume is

Re: AIX/TSM Paging Space and Memory Settings

2004-09-21 Thread Peter Jones
Hi, Since nobody else went in for the big explanation I thought I might. AIX memory tuning can help TSM performance significantly. We run on RAW LVs and set the AIX box to not page at all. From our experience, the key seems to be the paging of the bufferpool. TSM keeps this cache of DB pages

Re: AIX/TSM Paging Space and Memory Settings

2004-09-21 Thread PINNI, BALANAND (SBCSI)
Did you also try with -c Flag too along with -P and -p Flag!!!topas will show its effect too. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Peter Jones Sent: Tuesday, September 21, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: Re: AIX/TSM Paging

Re: D2D on AIX

2004-09-21 Thread Bill Boyer
What about combining both worlds...have the DISK storage pool for your daily backups to get the multi-session backups and faster backups, then migrate to a FILE storage pool for retention. Now you'll get the multi-session restore, less overhead than the large DISK pool, but still have to do

Re: D2D on AIX

2004-09-21 Thread Eliza Lau
Eric, What is the recommended volume size. I have seen someone mentioned 5G, but then the number of volumes will explode from about 800 (current # of 3590 primary tapes) to thousands. How about keeping the staging space so clients backup to staging then migrate to FILE volumes. Then every

Re: OT: Flushing 3494 ATL Queue

2004-09-21 Thread Richard Sims
On Sep 21, 2004, at 11:16 AM, Zoltan Forray/AC/VCU wrote: ...Eventhough the tape drive (3590B) is empty, we can't seem to convince the ATL that the clean has finished. Any tape mount that gets assigned to this drive (via z/OS) eventually fails since the ATL never completes the mount process. ...

Re: OT: Flushing 3494 ATL Queue

2004-09-21 Thread Zoltan Forray/AC/VCU
Thanks for the suggestions. The library won't let us take the drive offline. I forgot to mention that we tried that, as well. It simply says that something is in progress and won't let us disable the drive/controller/frame ! It is very persistant about letting this process complete ! The CE

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
Yes that is basically what we are doing. We are doing it more for fault tolerance. Our file storage pool is on a different disk subsystem. If there were major problems with that we could still do the nightly backups. Note that if you went directly to a File storage pool you would get

disk storage pools and windows compressed file systems

2004-09-21 Thread Steve Bennett
Have any of you used disk primary storage pools which use windows compressed file systems? Comments on performance, etc? We are investigating use of a multi TB raid5 array to use as a buffer between our local primary disk pool and the tapepool. Have seen the posts regarding file vs disk device

Re: TDP Log file backup running for a very long time

2004-09-21 Thread Del Hoobler
Data Protection for SQL creates a separate TSM Server session for each stripe and then waits for the SQL Server to send data to each stripe. The SQL Server determines which data goes to which stripe, and writes the data to it. From what you have put into this append, it appears as if sending the

Re: D2D on AIX

2004-09-21 Thread Bill Boyer
Yes, you would still get the multi-session backup, but only to the limit of your MAXNUMMP,right? What if you're running the FILE stgpool as collocated? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Rushforth, Tim Sent: Tuesday, September 21, 2004

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
I haven't tried this setup but that makes sense. So you would ensure MAXNUMP would be equal to the number of backup sessions you wanted. (You want to update MAXNUMP for restores anyway when restoring from file device class.) I asked the presenter of the Disk Only Backup Technical Exchange about

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
Eliza: At the Disk only Backups Technical Exchange, IBM recommended 2-4 GB volume size. (This was stated by the presenter, it was not written on the PDF presentation.) We started with 25 GB volumes and have now switched to 4 GB volumes. Using smaller volume sizes allows a better utilization of

Re: D2D on AIX

2004-09-21 Thread Johnson, Milton
Now we get into religion. IBM did offer a figure of ~5GB during the webinar, but there are a lot of factors that would affect this such as: REUSE DELAY: you want to be able to use those TSM DB backups RECLAMATION THRESHOLD: A lower threshold should lead to more efficient usage of volumes except

Re: D2D on AIX

2004-09-21 Thread Johnson, Milton
What do use for a reuse delay? How many pending volumes do you average? H. Milton Johnson -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rushforth, Tim Sent: Tuesday, September 21, 2004 1:00 PM To: [EMAIL PROTECTED] Subject: Re: D2D on AIX

Re: D2D on AIX

2004-09-21 Thread Rushforth, Tim
We use 5 days for reuse delay. I did a quick comparison using 25GB and 4GB volumes on our pilot with the following results: Disk Volumes - 25 GB Volumes Stored Data - 236 GB # of Disk Vols - 14 (including 2 pending volumes) Total allocation - 14 * 25GB = 350 GB 67% Utilization Disk Volumes -

Re: D2D on AIX

2004-09-21 Thread asr
== In article [EMAIL PROTECTED], Eliza Lau [EMAIL PROTECTED] writes: What is the recommended volume size. I have seen someone mentioned 5G, but then the number of volumes will explode from about 800 (current # of 3590 primary tapes) to thousands. Consider, this doesn't really cost you much.

Re: Relabel of 3592

2004-09-21 Thread Michael Prix
On Thu, 2004-09-16 at 19:08, Jim Sporer wrote: Have you tried the dsmlabel command with the -overwrite option? Worked. Thanks. -- Michael Prix

Re: disk storage pools and windows compressed file systems

2004-09-21 Thread Rushforth, Tim
The 5.2.2 Performance Tuning Guide says: NTFS file compression should not be used on disk volumes that are used by the TSM server, because of the potential for performance degradation. We use client compression so I don't think it would buy us anything. Report back if you try this out!

Re: Huge system object

2004-09-21 Thread Thomas Denier
For now, at the 5.1.5 client level, it might be easier to put the following in your include/exclude list: exclude.systemobject frs This should cause systemobject backups to skip the FRS object, and avoids the batch file method you mentioned. Thanks. That worked perfectly, and was a lot

Re: D2D on AIX

2004-09-21 Thread Eliza Lau
True. Seek time is tiny compared to tape mounts. I am just concerned that the TSM db has to keep track of thousands of volume. How much will it increase the size of the db. Ours is already 90G at 70% utilized. Eliza == In article [EMAIL PROTECTED], Eliza Lau [EMAIL PROTECTED] writes:

Re: TDP EXCHANGE

2004-09-21 Thread James Lepre
How do you perform a schedule archive for Exchange using TDP for Mail? Thank you James

Re: TDP EXCHANGE

2004-09-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Lepre How do you perform a schedule archive for Exchange using TDP for Mail? IIRC, archives are not supported with most of the TDP products. The best workaround that comes to mind quickly is to restore a backup to a test

Re: TDP EXCHANGE

2004-09-21 Thread Del Hoobler
James, Mark is correct that there is no TSM archive function for Data Protection for Exchange. However, there are a few things that many customers have done: - Set up a special NODENAME (like EXCHSRV1_ARCHIVE) that will bind the backup objects to special management classes that meet your desired

Re: UNIX

2004-09-21 Thread James Lepre
Hello *smers I am having a problem with backing up a certain file structure in AIX 5.2. The file structure is about seven layers deep and in the last directory layer are a set of 10 files that the schedule skips every night. I checked there are no excludes, I tried to put in includes without

Re: UNIX

2004-09-21 Thread Mike
On Tue, 21 Sep 2004, James Lepre wrote: Hello *smers I am having a problem with backing up a certain file structure in AIX 5.2. The file structure is about seven layers deep and in the last directory layer are a set of 10 files that the schedule skips every night. I checked there are no

schedule of SQL LOG backup

2004-09-21 Thread Luc Beaudoin
Hi all Is there a way to make a schedule to take the backup of the SQL LOG every 20 minutes .. I'm not able to find the way to put it in minutes ... thanks TSM SERVER - win2000 5.2.0.2 SQL 2000 - 5.2.1.0 Luc Beaudoin Administrateur RĂ©seau / Network Administrator Hopital General Juif

Re: schedule of SQL LOG backup

2004-09-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Is there a way to make a schedule to take the backup of the SQL LOG every 20 minutes .. Now think about that for a minute; that's three log backups per hour. If you have to restore the database 20 hours after the

Re: schedule of SQL LOG backup

2004-09-21 Thread Luc Beaudoin
thanks Mark .. I thought of doing Full backup every 8 hours and LOG backup every 20 minutes ... Is there a best pratice for SQL backup ?? thanks again Luc Stapleton, Mark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2004-09-21 04:20 PM Please respond to ADSM: Dist

Re: schedule of SQL LOG backup

2004-09-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin I thought of doing Full backup every 8 hours and LOG backup every 20 minutes ... Is there a best pratice for SQL backup ?? What works best is whatever meets your business needs. Most of my customers do a full

Re: schedule of SQL LOG backup

2004-09-21 Thread Luc Beaudoin
Hi Mark ... So with that setup ... worst case ... they will loose 4 hours of work ??? I'm working in a hospital ... so even 1 hours lost of lab result or patient appointment can be kind of hell anyway .. if there is no way of putting minutes ... I will put the minimum ... 1 hours ... thanks a

Re: disk storage pools and windows compressed file systems

2004-09-21 Thread Steve Bennett
Only a few of our clients do compression before sending backup/archive data and since clients backup directly to the local primary disk storage pool with no NTFS compression it should not affect them. Then later as part of the daily maint cycle the local disk pool will get migrated to the

Upgrade time...

2004-09-21 Thread Coats, Jack
I could use a little help. I am at TSM Win 4.2.3.1 on my server and need to upgrade to 5.2 or so. Probably to 5.2.2.3. I have a 3583 with LTO1's, all freshly upgraded to current microcode a week or two ago. Any special gotcha's I should look for? From what I have skimmed (I would say

Re: Upgrade time...

2004-09-21 Thread Zoltan Forray/AC/VCU
Have you done the infamous CLEANUP BACKUPGROUPS ? Coats, Jack [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/21/2004 05:54 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Upgrade time... I could use a little help.

Re: disk storage pools and windows compressed file systems

2004-09-21 Thread Bill Smoldt
I have two instances of storage pool volume corruption due to file compression on Windows 2003. Required a db audit of the storage to get rid of the volumes. It seemed like a good idea to the customer . . . Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager

Re: D2D on AIX

2004-09-21 Thread Steve Harris
How does TSM access the data on file volumes? Does it keep an offset of the start of every file or aggregate? If it does, then yes we could skip to the start of each file or aggregate. If it does not, then we need to read through the volume to find the file we are going to restore. Where we

Re: AIX/TSM Paging Space and Memory Settings

2004-09-21 Thread Dave Canan
I am also curious to see what your settings are for AIXDIRECTIO and AIXSYNCIO. For JFS2 only, we recommend that the AIXDIRECTIO setting be YES and AIXSYNCIO be set to no. In general, we see that if the direct i/o is set to yes, then JFS2 is roughly equal to RLV (raw logical volumes) in

Re: UNIX

2004-09-21 Thread Richard Sims
I am having a problem with backing up a certain file structure in AIX 5.2. The file structure is about seven layers deep and in the last directory layer are a set of 10 files that the schedule skips every night. I checked there are no excludes, I tried to put in includes without anything

Re: AIX Paging Space Utilization

2004-09-21 Thread Tab Trepagnier
Curtis, I'm guessing that the restriction on Maxclient might do the trick. Shortly after updating our TSM and Oracle servers to AIX 5.2, I started using JFS2 for some of the file systems. In a very short time, I saw page file usage in the 60-70% range after YEARS of running less than 10%. I

Re: Upgrade time...

2004-09-21 Thread Coats, Jack
Yep, Thanks for asking :) -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 4:57 PM To: [EMAIL PROTECTED] Subject: Re: Upgrade time... Have you done the infamous CLEANUP BACKUPGROUPS ? Coats, Jack [EMAIL PROTECTED] Sent by:

Re: D2D on AIX

2004-09-21 Thread TSM_User
Eliza, We are using 25 GB volumes right now without any issues but we are still collocateing by node. We are evaluting the savings of using smaller volumes when we move to noncollocated storage pools. I agree that it doesn't make sense to collocate file device class pools but managment

Re: TDP Log file backup running for a very long time

2004-09-21 Thread TSM_User
Thanks Del. Last night I changed everything to the defaults and used one stripe. The backup ran in 2 or 3 minutes. I plan to run more tests next week experiementing with different settings for stripe, buffers and such to see what yeilds the best results. Also, the restore of the 2.5 TB DB I

Re: schedule of SQL LOG backup

2004-09-21 Thread TSM_User
I have a customer that runs log backups every hour. For some systems they can't loose more than 5 minutes of data. For those systems they implement clustering. Going with Marks idea can they afford to wait 10 hours for you to replay logs. In that time they can't backup the data because you

Re: D2D on AIX

2004-09-21 Thread TSM_User
Tim, we recently ran a bunch of tests on client side compression. In every test the backup ran for 2 to 3 times longer. In some cases this wouldn't be a big deal when you look at the backup alone being incremental and all. However, we also believed that it would also cause the restore to run

Re: D2D on AIX

2004-09-21 Thread TSM_User
Good questions. Our real world example:We went from around 8 - 12 GB/hr restore off of tape to over 40 GB/hr from the file device classes. Our test was a file server with a little over 300 GB of data. The File server and the TSM server both had 1 GB NIC's. Resource utilization was set to 10

Re: D2D on AIX

2004-09-21 Thread TSM_User
Good questions. Our real world example:We went from around 8 - 12 GB/hr restore off of tape to over 40 GB/hr from the file device classes. Our test was a file server with a little over 300 GB of data. The File server and the TSM server both had 1 GB NIC's. Resource utilization was set to 10

Re: D2D on AIX

2004-09-21 Thread TSM_User
Good questions. Our real world example:We went from around 8 - 12 GB/hr restore off of tape to over 40 GB/hr from the file device classes. Our test was a file server with a little over 300 GB of data. The File server and the TSM server both had 1 GB NIC's. Resource utilization was set to 10