Re: Help with brbackup

2004-03-26 Thread Anoop Das
Cud u send me the .utl and the .sap files. Anoop T.Das 'Before you discover, you need to explore' Richard van Denzel To: [EMAIL PROTECTED] <[EMAIL PROTECTED]cc: ROUP.COM>

Re: Tape library eval

2004-03-26 Thread Chris Murphy
We are a differnet case than Tom's, it appears. We have been extremely happy with our STK unit: was an L40, upgraded to L80. Just our 2-bits... Chris Murphy IT Network Analyst Idaho Dept. of Lands [EMAIL PROTECTED] -Original Message- From: James Lepre [mailto:[EMAIL PROTECTED] Sent: Th

Re: Incremental backup hanging

2004-03-26 Thread Richard Sims
>We are running TSM 5.2.1 on an AIX 5.2 platform. Until recently we have had no >problems >with our incremental backups. Now one of our servers hangs in the /usr directory >during >incremental backups. Any experienced this problem before? What diagnostic work have you done? Have you done a Sele

Incremental backup hanging

2004-03-26 Thread James W. Fletcher
** Proprietary ** We are running TSM 5.2.1 on an AIX 5.2 platform. Until recently we have had no problems with our incremental backups. Now one of our servers hangs in the /usr directory during incremental backups. Any experienced this problem before? James Fletcher Supervisor, Operating Systems

Re: DB2 and TSM

2004-03-26 Thread Lathrop, Andrew R.
It is built into DB2. Andrew Lathrop Olympia, WA 98504 (360) 664-8115 -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 9:09 AM To: [EMAIL PROTECTED] Subject: DB2 and TSM Please forgive my ignorance on this but someone is looking to add

Re: ?Can Linux or (Win?) replace AIX for I/O intensive TSM service?

2004-03-26 Thread Roger Deschner
First, take what you've got and throw a LOT more RAM at it. I can't believe you're getting what you are actually getting out of only 3GB, without memory constraint showing up somewhere, such as lowered database cache hit ratios, or tape I/O buffers being too small which will slow down your tape dri

Re: Question about recovery log

2004-03-26 Thread Miller, Ryan
Roger makes an EXCELLENT point that everyone should follow, I found out the hard way as I had a recovery log fill up and only had 100 MB for emergency, it wasn't enough and I ended up spending 8 hours restoring a TSM server. I now follow the practice of leaving the emergency space, everyone sho

total storage ultrium autoloader

2004-03-26 Thread Joe Crnjanski
Hi All, We are planning to buy IBM 3581L23 200/400 LTO2 total storage ultrium autoloader. Our environment is not really huge, and we think that this tape would be sufficient for us. Our primary pool is disk and we would use this tape drive only for copy pool. Is there anything I should be worryi

Re: Question about recovery log

2004-03-26 Thread Roger Deschner
1. Never make it larger than 12GB! Someday, your log will fill up, and you've got to have room under the 13gb limit to be able to add an emergency extent, otherwise you'll find yourself dug in so deep you can't dig out. 2. You will find it a convenience to make it two 6gb halves. That way you can

Element addresses for new scsi LTO drive

2004-03-26 Thread CORP Rick Willmore
Hey all, I noticed that others of the list seem to have similar element address problems but I didnt see my solution so I was hoping to throw this one out and see what sticks. I just added a new LTO (ver1) drive to our Scalar 100 Library. I used lbtest and can see the element address reported b

Re: DB2 and TSM

2004-03-26 Thread Orville Lantto
The "Agent" for DB2 is built in to DB2. Look at the DB2 command BACKUP for the parameter "USE TSM" Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] CONFIDENTIALITY N

Re: Bare metal restore, ASR etc.

2004-03-26 Thread Mike Dile
TSM_User <[EMAIL PROTECTED]> wrote: "ASR is only available on Win2003 not on other versions of windows." This is not true. ASR is available on both Windows XP and Windows 2003. Regards, Mike Dile Tivoli Storage Manager Client Development Tivoli Software, IBM Software Group [EMAIL PROTECTED]

Re: DB2 and TSM

2004-03-26 Thread Andrew Raibeck
Geoff, Try checking the IBM web site at http://www.ibm.com. In the search box at the top of the page even simple criteria like +tsm +db2 will yield fruitful results. (There a lot of hits, but you should find something pertinent in the top 2 hits!) Regards, Andy Andy Raibeck IBM Software Gr

DB2 and TSM

2004-03-26 Thread Gill, Geoffrey L.
Please forgive my ignorance on this but someone is looking to add a server to TSM for backups and wants to know if TSM has an agent for DB2. From what I can tell there is no agent out there on the FTP site. I'm wondering if IBM has functionality built in to the product to back up the DB direct to T

Re: define script problem

2004-03-26 Thread Andrew Raibeck
But Wanda, that takes all the fun out of it! :-) It is a good alternative, though. Just one caveat: the file has to reside on the TSM server machine, not the local machine from which you are running the admin client. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client

Re: define script problem

2004-03-26 Thread Prather, Wanda
This stuff will make you crazy. Give up your pain!!! Use notepad (or vi, or whatever) to create your script in a flat file. Type the SELECT just as you would from the command line, no worry about extra quotes. Then DEFINE SCRIPT VAULTING desc="Create Vault Lists" file=\pathname\filename --

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread David Longo
Although your cache hit pct is great, the most obvious thing I see is that you just have ONE physical volume for this size DB! Spreading this size DB out over multiple volumes will probably increase your performance. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockled

TSM on-line backup

2004-03-26 Thread Sergey Kalinin
Hi, I have Oracle 9.2 databases on RedHat Linux 7.3 and want made on-line (hot) backup them on TSM server. What is release TSM server and backup-archive client supported on-line backup? May be another advices anybody give me? Thanks much.

Re: define script problem

2004-03-26 Thread fred johanson
How about single quotes on the outside and "as" after volume_name. At 03:02 PM 3/26/2004 +, you wrote: Hi, I am trying to create a script that will produce a list of media to send offsite. I defined a script: DEFINE SCRIPT VAULTING "select volume_name "Volumes to go offsite", voltype as "Volu

Re: question about share library

2004-03-26 Thread Prather, Wanda
Yep. (B (BIf it is a SCSI library, you can set up library sharing so that 1 TSM server (Bis the library "master", and the other is a library "client". The "master" (Bis the traffic cop and does all the mounts and drive sharing. (B (BIf it is a 3583, 3584, or 3494 library you can also logical

Re: Help with brbackup

2004-03-26 Thread Hooft, Jeroen
check if "backint -p initB01.ult -f inquire" works. If that works, the the utl-file should be fine. Then the problem can be in initB01.sap. In there you should have an entry like "util_par_file = /oracle/B01/920_64/dbs/initB01.utl" Jeroen -Original Message- From: Richard van Denzel [mai

Re: 9840 vs 9940 Performance

2004-03-26 Thread Prather, Wanda
You are right about the 9840's; they are just screaming fast; I like them even better than 3590's for TSM for that reason. Also incredibly robust. We had some 9840's that we ran days on end, 20 hours a day, doing enormous amounts of reclaims (read LOTS of start/stop activity), with no drive or I/

Re: Antwort: define script problem

2004-03-26 Thread Andrew Raibeck
Ah, OK. Now that makes sense. Thanks for confirming that I'm not not nuts (at least not because of this!) Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb

Re: Antwort: define script problem

2004-03-26 Thread Smith, Rachel
I ran it with single quotes around MOUNTABLE: DEFINE SCRIPT VAULTING "select volume_name as Vol_to_go_offsite, voltype as Volume_Type from drmedia where state='MOUNTABLE' order by volume_name" desc="Create vaulting lists" ANR1462I RUN: Command script VAULTING completed successfully. -Origina

Re: Antwort: define script problem

2004-03-26 Thread Andrew Raibeck
Hi Christian, I am curious as to why a column name longer than 18 characters presents a problem? You can simply put it in quotes, as I showed in a previous response on this subject. Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail

AW: TDP for Oracle

2004-03-26 Thread Thomas Rupp, Vorarlberger Illwerke AG
On Windows I use: DSMC QUERY BACKUP -SUBDIR=YES -NODE=xx {\adsmorc}* On UNIX:DSMC QUERY BACKUP "/adsmorc/*" -SUBDIR=YES -VIRTUALN=xx You have to replace \adsmorc with the name of your TDPO filespace. Thomas Rupp -Ursprüngliche Nachricht- Von: Frank Scolieri [mailto:[EMAIL

TDP for Oracle

2004-03-26 Thread Frank Scolieri
Is there a way to query all files backed up through TDP for Oracle? Thanks

Re: Antwort: define script problem

2004-03-26 Thread Andrew Raibeck
While I agree that it is difficult to argue with success, I don't see how the script could possibly run as written below. You had to have changed something else. Here are the results if you run the script as written (I simply copy & pasted it into the admin command line): tsm: SS2_ADSM_GROUP_SER

Re: DRM question !

2004-03-26 Thread Prather, Wanda
When you run DRM PREPARE, it creates a file with recovery instructions to help you rebuild your TSM server (presumably at a new location). DRM also gives you the opportunity to create your OWN files containing instructions that YOU write explaining how to restore your other machines (presumably th

Help with brbackup

2004-03-26 Thread Richard van Denzel
Hi All, I've installed TDP for ERP on AIX 5.1 (2 SAP servers) and on both servers I run into the same problem when I try to specify the Parameter file within SAPDBA. When I enter the filename initB01.utl, SAPDBA keep comming up with the following message: SAPDBA: Error in brbackup profile/

AW: define script problem

2004-03-26 Thread Salak Juraj
Hi, you are on the right path, it has to do with parameters parsing, an issue common to all command line interpreteres, including tsm command line. You DEFINE SCRIPT command is interpreted as follows: parameter1=VAULTING parameter2=select volume_name Why it end here? It is a str

DRM question !

2004-03-26 Thread goran
hi all, i got this message on PREPARE command : ANR6918W PREPARE: Recovery instructions file /usr/tivoli/tsm/server/backup/instr_plan.RECOVERY.IN- STRUCTIONS.DATABASE not found . . . in messages stands : ANR6918W Command: Recovery instructions file file name not found. Explanation: A source fi

Re: Antwort: define script problem

2004-03-26 Thread Smith, Rachel
I changed the name for vol_to_go... and ran successfully with no errors. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Andrew Raibeck Sent: 26 March 2004 15:27 To: [EMAIL PROTECTED] Subject: Re: Antwort: define script problem The script may get defi

Re: Antwort: define script problem

2004-03-26 Thread Andrew Raibeck
The script may get defined, but it probably won't run. See my other post on this subject. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one t

Re: Antwort: define script problem

2004-03-26 Thread Andrew Raibeck
Correct, but the embedded quotes also makes this a bit tricky. Note that the string comparison in the WHERE clause requires single quotes around MOUNTABLE. So how about this: define script vaulting "select volume_name as ""Volumes to go offsite"", voltype as ""Volume Type"" from drmedi

Re: Antwort: define script problem

2004-03-26 Thread Smith, Rachel
that worked, thanks for that:> -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Christian Demnitz Sent: 26 March 2004 15:19 To: [EMAIL PROTECTED] Subject: Antwort: define script problem sorry my first answer was wrong!!! please try: DEFINE SCRIPT VAU

Antwort: define script problem

2004-03-26 Thread Christian Demnitz
sorry my first answer was wrong!!! please try: DEFINE SCRIPT VAULTING "select volume_name as Vol_to_go_offsite, voltype as Volume_Type from drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault lists" the only restriction is: the name for vol_to_go... should not longer than 1

Re: Retaining Deleted files

2004-03-26 Thread Andrew Raibeck
I do not quite understand your specification. The user wishes to keep up to 6 months worth of transaction files on disk. But this does not necessarily map to a restore requirement. For example, the user might wish to keep 6 months worth of transaction files on disk, but may also wish to be able to

Antwort: define script problem

2004-03-26 Thread Christian Demnitz
Hi, i think you' forgot the "as" between volume_name and "volumes to go Offsite" DEFINE SCRIPT VAULTING "select volume_name as "Volumes to go offsite", voltype as "Volume Type" from drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault lists" Christian Demnitz mailto:[EMAIL P

define script problem

2004-03-26 Thread Smith, Rachel
Hi, I am trying to create a script that will produce a list of media to send offsite. I defined a script: DEFINE SCRIPT VAULTING "select volume_name "Volumes to go offsite", voltype as "Volume Type" from drmedia where state="MOUNTABLE " order by volume_name" desc="Create vault lists" And it fails

Re: Windows Backup and mixed case filenames

2004-03-26 Thread Andrew Raibeck
There was also some discussion in the autumn of last year. Searching the adsm-l archives at http://search.adsm.org or http://my.adsm.org/adsm-l.php with the following criteria: +ntfs +posix will yield some pertinent information. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage M

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread Richard Sims
>Just because I'm currently trying to boost expiration processing: I see your >database is rather large, how long did it take you to expire those 23194393 >objects? >I really tried almost everything, from moving to 15k speed disks, multiple >database volumes, moving to RAW's, the best I have seen i

Re: Windows Backup and mixed case filenames

2004-03-26 Thread Andrew Raibeck
Although the NTFS file system technically permits case-sensitive file names, the Windows operating system provides insufficient mechanisms for applications to distinguish between files whose names differ in casing only. As you have noticed, even the operating system facilities that come with Wi

Re: Windows Backup and mixed case filenames

2004-03-26 Thread Richard Sims
... >So, my question is: is there a way to backup NTFS where some filenames >differ only in uppercase/lowercase? Maybe a newer version of the client? This issue was extensively discussed some six weeks ago. Please check the List archives for such issues.

Windows Backup and mixed case filenames

2004-03-26 Thread Rainer Schöpf
Hello all, we have an IBM NAS 100 Box (a W2K based server appliance) running Services for Unix 2.2 to provide NFS service for our Linux workstations. An NFS client can create two files in the same directory whose names differ only in case, eg. "makefile" and "Makefile". The NTFS on the NAS 100 c

Re: 9840 vs 9940 Performance

2004-03-26 Thread John Benik
I'd be interested in seeing this also, we are looking at 9940's as well. You may want to look at the 9840C cartridges which have a lot more capacity, and will allow you to keep the same drives... John Benik Blue Cross Blue Shield of Minnesota Storage Administration and Performance W. (651)-662-495

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread Luke Dahl
Hi Eric, From our activity log: 03/20/04 06:00:07 ANR0811I Inventory client file expiration started as proc cess 26. (SESSION: 5656, PROCESS: 26) 03/25/04 17:24:44 ANR0812I Inventory file expiration process 26 completed: examined 23979559

Re: question about share library

2004-03-26 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of fenglimian >Hi all,can more than one TSM servers share a library? Yes. Refer to "Library sharing" in your TSM server administrator's guide. -- Mark Stapleton

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread Guillaume Gilbert
Sent this too fast... Must have hit the a wrong key... Not enough coffee yet I have 4 rather large tsm servers, db over 30 gb. 2 are AIX, 2 are sun. The performance on the 2 aix boxes is similar. One server is very old, installed in 97, db is 60 db, and goes through 12 million objects, deleting be

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread Guillaume Gilbert
I have 4 rather large tsm servers, db over 30 gb. 2 are AIX, 2 are sun. The performance on the 2 aix boxes is similar. One server is very old, installed in 97, db is 60 db, and goes through 12 million objects, deleting between 300,00 and 1 million objects. 3000 objects/sec examined, but between 70

AW: Retaining Deleted files

2004-03-26 Thread Salak Juraj
yup, it will do. It will cause the tsm server grow NOLIMIT as well :-) Alternatively, you can offer incrementals to files keep 6 or 7 months only and do archives with deletefiles option for older files. this differntiates from the upper solution in that: - you would be responsible for deleting f

Re: Expiration after TSM upgrade from 5.1.6.4 to 5.2.2.1

2004-03-26 Thread Loon, E.J. van - SPLXM
Hi Luke! Just because I'm currently trying to boost expiration processing: I see your database is rather large, how long did it take you to expire those 23194393 objects? I really tried almost everything, from moving to 15k speed disks, multiple database volumes, moving to RAW's, the best I have se

Re: TDP for MS SQL - Restore DB

2004-03-26 Thread Del Hoobler
Yiannakis, That is correct. Please refer to the User's Guide for the exact syntax. Thanks, Del "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 03/26/2004 01:29:12 AM: > Thanks Del. > So after my full restore I do a second restore wi

9840 vs 9940 Performance

2004-03-26 Thread Frost, Dave
Hello all, Does anybody have any experience with TSM performance of STK 9940's ? We are running 9840's with colocation and have found the performance for large restores of a small file nature to be very good. The only problem with 9840 is the 20GB limitation. I know that large servers will span mu

Retaining Deleted files

2004-03-26 Thread Yiannakis Vakis
Hi, I have the following situation and I need a confirmation here. System information is : TSM 5.2. on Windows 2000, TSM BA client 5.2. on Windows 2000. I'm backing up a folder with the "incremental" option, that contains a complex subfolder tree. The contents of the subfolders are mainly transac