Re: Versioning

2004-10-13 Thread Hurst, David(LIT)
Richard I would highly recommend using a versioning tool such as CVS for change control . This only stores the delta's between versions making it much more efficient in terms of storage . We use it in our software house , the backend is based on MySql which we dump to file each night ( after do

TSM DB and RLOG sizes

2004-10-13 Thread Yiannakis Vakis
Up to now I kept my DB and Rlog sizes to a minimum (96MB and 50MB respectively). Most of my backups are SQL dbases or large files so there was no need to increase them. However, I have a new client (windows) that requires to backup a complex folder structure with about 30 million files! These are c

BMR restore Win2000

2004-10-13 Thread Robert Ouzen
Hello There I am trying to do a BMR (Bare Metal Restore) , to WIN2000 server. meaning Restore a Complete server to Another Machine. The machines are IDENTICAL IBM X-345 Model , with Raid controller 5I . I install the same OS (WIN2000 SP4) . (same Machine name , same Disk label) restore C:\* -

Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Hi, I am trying to make some useful reports by queryring the TSM database, but I can not find out how to fetch the first N rows in that query. In the DB2-manuals I find the "fetch" command, but it does not seem to work here. Also tried googling and searching the archives here. Example where I

Library upgrade question

2004-10-13 Thread Dirk Kastens
Hi, we are going to exchange our Adic Scalar 100 for a Scalar 1000, soon. Would it be possible to simply move the DLT tapes from the old library to the new one, if we keep the names of the library and the drives in TSM (doing an audit library afterwards)? Or do we have to connect both libraries to

Sun server 5.2.2.0 fails to install

2004-10-13 Thread Tom Tann{s
Hi! When trying to install, the license acceptance tool fails. Has anyone seen this? Any suggestions on how to make it work? bit.uio.no# uname -a SunOS bit.uio.no 5.8 Generic_108528-27 sun4u sparc SUNW,Sun-Fire-480R bit.uio.no# Processing package instance from Tivoli Storage Manager/Sun Serv

Re: TSM DB and RLOG sizes

2004-10-13 Thread Christo Heuer
Hi, You can increase your database a hundred(maybe even a thousand), times bigger without suffering performance problems. In the Admin guide the space occupied by each object (30Million of them), is explained. You will definately need to increase your db size. Regards ChristoH > Up to now I kep

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hans Christian Riksheim >I am trying to make some useful reports by queryring the TSM >database, but I can not find out how to fetch the first N rows >in that query. In the DB2-manuals I find the "fetch" command, >but it does

Re: Weird tape utilization

2004-10-13 Thread Loon, E.J. van - SPLXM
Well, it took some time convincing Level 2 support, but IBM has opened APAR IC43086 for this behavior! So, in the future we don't have to run the SQL statement down below anymore. Good thing, because it runs for 9 hours in my shop! A nasty side affect is that it puts a lock on your storage pool whi

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
> Install Perl on your (I assume) Windows machine and imbed your select statement within a Perl script that does what you > > want. > > Welcome to an operating system that doesn't come with anything resembling a decent scripting language. Usually Perl is what I use on all platforms, but in th

Re: BMR restore Win2000

2004-10-13 Thread Henrik Wahlstedt
Hi, Cant tell, which client version are you using? There might be a fix for this in 5.1.7.0. //Henrik Robert Ouzen <[EMAIL PROTECTED]To: [EMAIL PROTECTED] IFA.AC.IL> cc: (bcc: Henrik Wahlstedt)

Re: Failed backup

2004-10-13 Thread Richard Sims
... >ANS1329S Server out of data storage space ... Shukrie - See that message number in http://people.bu.edu/rbs/ADSM.QuickFacts for what we've learned from our collective experience with it. Richard Sims

Re: TSM DB and RLOG sizes

2004-10-13 Thread Richard Sims
>Up to now I kept my DB and Rlog sizes to a minimum (96MB and 50MB >respectively). Most of my backups are SQL dbases or large files so there was >no need to increase them. >However, I have a new client (windows) that requires to backup a complex >folder structure with about 30 million files! These

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Richard Sims
>I am trying to make some useful reports by queryring the TSM database, >but I can not find out how to fetch the first N rows in that query. In >the DB2-manuals I find the "fetch" command, but it does not seem to work >here. Also tried googling and searching the archives here. ... Hans - The TSM d

Re: BMR restore Win2000

2004-10-13 Thread Bill Boyer
Another thing to concider is the partitions. Was the original install done with the IBM CD's? I think that a small partition is created in addition to the boot partition. Then if you just used the Windows install CD's to do the BMR, the information in BOOT.INI wouldn't match. Before doing the resto

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread goc
hi it's DB2 derivate , right ? - Original Message - From: "Richard Sims" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 13, 2004 2:19 PM Subject: Re: Equivalent of UNIX "tail/head" in TSM SQL query >I am trying to make some useful reports by queryring the TSM database

Re: Library upgrade question

2004-10-13 Thread Ochs, Duane
Dirk, If you are using the same media type, yes you can place the existing media in the new Library. First, you will have to define the new library and update the device class definition to reflect the new library. After loading your tapes in the library you will need to perform a library audit.

Domino TDP backups to LTO2

2004-10-13 Thread Zoltan Forray/AC/VCU
I have been experimenting with doing Domino backups directly to LTO tape. We are trying to do this since in the future, our Domino systems will expand to address 40,000+ ID's and 3-6TB of storage that will need to be backed up (no clue how much on a daily basis but weekly will be big due to the "r

Re: Library upgrade question

2004-10-13 Thread Bill Boyer
I would create all new definitions for the 1000 library. Once you're up to TSM 5.2.3 level, the drives and library have the serial number as part of the definition. If you point the same library/drive to a different physical drive, you get error messages that it's not the same device becuase the s

Re: Domino TDP backups to LTO2

2004-10-13 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU >We are trying to do this since in the future, our Domino >systems will expand to address 40,000+ ID's and 3-6TB of >storage that will need to be backed up (no clue how much on a >daily basis but weekly wi

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Thank you for the information! Since it doesn't work I limit the searches by a 'where' statement. (Btw. any reason for the limitations? Are they afraid we're going to use the TSM-database for other purposes?) Best regards Hans Chr. --- Hans - The TSM database is not an SQL db. The SQL ope

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Richard Sims
>it's DB2 derivate , right ? The TSM database is a proprietary, b-tree db tied to TSM. There have been product futures considerations for making the database more mainstream, as can be seen in the List archives, but that may compromise performance. It's one of those issues where flexibility and p

SQL restore

2004-10-13 Thread Luc Beaudoin
Hi All Is there a way to restore a SQL database on the same server but with a different name thanks Luc

Re: Versioning

2004-10-13 Thread Richard Mochnaczewski
We are actually using a version control program called Continuus and moving to CVS in the future. My question was more how daily backups are handled in terms of file changes .. If you keep 5 copies of a file , is that enough ? If the file is modified in one week five times and the backup picks up

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Richard Sims
... >(Btw. any reason for the limitations? Are they afraid we're going to use >the TSM-database for other purposes?) Probably a matter of where to best deploy experienced programming talent in the areas where the product needs the most development. IBM only seems to have inexhaustable resources..

Re: SQL restore

2004-10-13 Thread Del Hoobler
Luc, Yes. If using the GUI, after selecting the database on the restore tab use the right-mouse button on the database entry in order to enter the new database name... and also to choose the locations for the new database files. You can also do this from the command-line. You might find some other

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Warren, Matthew (Retail)
A moot point from me, as Richard has settled the DB type question but, You should still be able to execute system 'dsmadmc' commands and collect the output into perl? IE, using the backticks notation or system() or something similar to just do @output=`dsmadmc -id= -pa= select stuff from the_db

Re: Version 5, Release 2, Level 3.2

2004-10-13 Thread Owings, Don
Hi list. We have recently upgraded to TSM Version 5, Release 2, Level 3.2. The SA community did the install and have no follow up documentation. So far I've been unable to find any related Admin reference docs or Redbooks. Since there have been some obvious modifications with the upgrade I w

Re: Version 5, Release 2, Level 3.2

2004-10-13 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Owings, Don >Hi list. We have recently upgraded to TSM Version 5, Release >2, Level 3.2. The SA community did the install and have no >follow up documentation. So far I've been unable to find any >related Admin reference do

Re: Version 5, Release 2, Level 3.2

2004-10-13 Thread Owings, Don
The look and feel of the GUI has changed, most of my scripts won't work now so I have just begun to dig into what changes have disabled them and the SA's indicated that there is new reporting functionality built into this latest patch (but as of yet I've been unable to find what that is). -

Re: Version 5, Release 2, Level 3.2

2004-10-13 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Owings, Don >The look and feel of the GUI has changed, most of my scripts >won't work now so I have just begun to dig into what changes >have disabled them and the SA's indicated that there is new >reporting functionality buil

Re: Equivalent of UNIX "tail/head" in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Yes, that is possible. Wrapping perl around a lot of TSM-queries has been my method of choice until recently. But then I heard about TSM Console and used that since. I really recommend it. Takes about two minutes to set up and you have it running with a default report. Fully customizable with your

Re: Cannot see File Level Information for NDMP Backup/Restore

2004-10-13 Thread Joni Moyer
Hello! I don't mean to barge in on the conversation, but I am in the process of setting up the web client for NDMP backups and I was wondering if anyone would be able to tell me what I am doing wrong? We have successfully backed up and restored NDMP backed up data, but I would like to get to the

Help Configuring ADIC i2000 on Win2K

2004-10-13 Thread Prather, Wanda
Trying to connect an ADIC i2000 to a WIn2K 5.2.3 TSM server. There is only 1 partition in the ADIC i2000, the box is dedicated tot TSM. Support for ADIC i2000 was added in 5.2.1, according to the README. Windows is showing the LTO2 drives as expected, but it shows the i2000 as a "SCSI array devic

Re: BMR restore Win2000

2004-10-13 Thread Terry McColgan
Even though it may not be needed for Win2K I cannot speak highly enough about Christie Bare Metal Restore. (http://www.christie.co.uk) Terry McColgan -Original Message- From: Robert Ouzen [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 4:27 AM To: [EMAIL PROTECTED] Subject: BM

Re: checkin libvol

2004-10-13 Thread Terry McColgan
Try this: LABEL LIBV SEARCH=B LABELS=B CHECKIN=SCR OVERWRITE=Y We use a 3583 library. I assume your syntax may differ. Terry McColgan "Go ahead ... backup." -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 8:26 AM To: [EMAIL PROTE

TSM Windows Migration 5.1.x to 5.2.x Gotchas, Issues, Problems, Documentation, Errors

2004-10-13 Thread Dwight McCann
After previously asking why my 5.1.8.3 to 5.2.3 migration failed when there was no information in the readme and I didn't see anything of note on the list, I got two replies. The first suggested that I should read the Quick Start. The other noted that there is a problem with the license manager.

TSM client on linux for zSeries dsm.opt file

2004-10-13 Thread R. Knutsen
Would anyone share their dsm.opt, especially includes and excludes for a TSM client V5 running on Linux for zSeries? Does anyone know where to find the a installation and users guide for V5.2.2 TSM client running on Linux for zSeries? Thanks for any help.

include exclude list

2004-10-13 Thread Hashim, Shukrie BSP-ISM/116
hi all, I would like to know exactly ... what I should type if I want to exclude any directory that is named ".snapshot" and all the files in it of course for example I have these directory and filesystems (Unix system) /apps/.snapshot/ /.snapshot/ /local/apps/.snapshot/ /local/long/short/down/

Re: TSM DB and RLOG sizes

2004-10-13 Thread Roger Deschner
With that many files, I think Richard Sims is on target as to where your problems will arise. Your database will grow quite a bit, but you can calculate that from the Admin Guide formulas. Our DB is over 100GB and it runs fine, so just throw some disk space at it and it will be fine. One thing you

Storage pool

2004-10-13 Thread Pan, Sanjoy
Hello, Although there are sufficient no. of tapes in the prime & offsite pool, the estimated capacity can be seen as 0. Is there any issue? I can't find any error in actlog though. Your input will be highly appreciated. Thanks & best regards, Sanjoy tsm: TSM3.USSNTC6>q stg Storage