TDP for MS SQL - Restore DB

2004-03-23 Thread Yiannakis Vakis
Hi, I have the following schedules for a SQL dbase: Saturdays - full backup of dbase Weekdays - difffull backup of dbase I wanted to restore the dbase on Wednesday to another server, so I used the command line as follows: tdpsqlc restore ChequeEnquiry full /relocate=ChequeEnquiryuiry_Data /to=H:\

Re: GIGE connectivity via TSM

2004-03-23 Thread Ted Byrne
You might also want to set up a static route on the client to the TSM server, specifying the GigE card as the gateway address. Ted At 10:37 AM 3/23/2004 -0500, you wrote: In your DSM.OPT on the client (this is from the book): Tcpclientaddress ... What is the best/recommended way to ensure data i

Re: Urgent License & Database Backup Problem

2004-03-23 Thread sujay dinakar
Hello, Thank u for all, for helping my in solving my problem in license. Thank once again, regards Dinakar R. __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html

Re: Sizing an AIX platform and tape libraries

2004-03-23 Thread Dan Foster
Hot Diggety! Nancy R. Brizuela was rumored to have written: > > 1) Right now we are backing up about 150 GB/ night, but we need to add > Exchange and a new student information system (Banner) to this. We are > estimating that we will soon grow to at least 500 -600 GB/night. > > 2) Workload consi

Re: Sizing an AIX platform and tape libraries

2004-03-23 Thread Steve Harris
Hi Nancy We are similar size now to what you will be. Our big backup is 2x150GB SAP/DB2 streams, with about another 100GB of other stuff, mostly small nodes. We have a lot of small apps on a sun cluster and each app gets its own node and dsmcad process so we can fail them over individually. Ab

Re: Sizing an AIX platform and tape libraries

2004-03-23 Thread David Longo
Well, looks like what I have right now would work for you! I have pSeries p660 (6H1) with 2x 600MHx procs and 2GB RAM with AIX 4.3.3 and TSM server 4.2. Use GbE NIC's. Have IBM 3584-L32 library with 8 LTO1 drives FC attached. Also use FAStT 200HA disk for TSM DB and Storage pool. (have 4 tota

Sizing an AIX platform and tape libraries

2004-03-23 Thread Nancy R. Brizuela
Hello All, We will be phasing out our OS/390 mainframe in the next few years. Currently, we have our TSM server installed on the mainframe, so we will need to move it off and on to something else. Based on conversations to this list and the Redbook, IBM Tivoli Storage Manager Implementation Guide

Re: TSM license audit not equal number of nodes

2004-03-23 Thread Prather, Wanda
Sorry to bring this up again, but... I KNOW that in TSM 4.1, the server behavior was to stop counting the licenses after 30 days of non-use. It was documented in the server README (I think that's where it was), and I verified it on our running systems. I have not seen it documented anywhere for

Re: mksysb tapes on fibre-attached 3590

2004-03-23 Thread David E Ehresman
There is a TSM for Sysback offering which allows you to store sysback backups on TSM and use network boot or NIM to boot and restore the sysback backup. >>> [EMAIL PROTECTED] 3/22/2004 2:35:43 PM >>> We are considering migrating our TSM system to an AIX system with 3590 tape drives in a 3494 tape

Re: GIGE connectivity via TSM

2004-03-23 Thread Thomas A. La Porte
If it the client GigE <--> Server IP is not the default route in both directions, and they are not on the same subnet, you will have to configure a static route on each host in order to guarantee that the traffic will traverse the chosen route in both directions. IOW, static routes on both client

Re: GIGE connectivity via TSM

2004-03-23 Thread
Bill, I hate to beat this... but my situationa is as follows: I have a TSM server residing on Z/OS with an FQDN and one IP address (as far as I know). My client has multiple NICs. We want to use a particular GIGE card exclusively for backup/restore and the others for applications, so we can'

Re: Looking for information on Tivoli Data Warehouse

2004-03-23 Thread James Thomas
Hi Bill, FWIW, I can tell you that Tivoli Management Framework is the software that allows you to manage and inventory machines on your network. You can inventory their hardware and software, you can install software, distribute and retrieve files, run programs on remote machines all that goo

Re: GIGE connectivity via TSM

2004-03-23 Thread Bill Boyer
If you use the GIGE address of the TSM server in your DSM.OPT file on the client, then the BACKUP data will go over the GIGE card. Any data FROM the TSM server TO the client will go out the network adapter on the TSM server however TCPIP routing takes it. If you have multiple adapters in the TSM se

Looking for information on Tivoli Data Warehouse

2004-03-23 Thread Bill Fitzgerald
I am looking for information on a product that I received along with the most recent set of CD for TSM. The product is Tivoli Data Warehouse. What does it do? what is it for? Is it something I need to install for TSM? I also get CDs for something called Tivoli Monitoring ( we don't use it as we u

Re: GIGE connectivity via TSM

2004-03-23 Thread Dwight Cook
Use a "traceroute" command from your client box to the specific ip address you want to go into on your tsm server. Your backups will take the same path. That simple... Dwight E. Cook Systems Management Integration Professional, Advanced Integrated Storage Management TSM Administration (918) 925-80

Re: GIGE connectivity via TSM

2004-03-23 Thread Zoltan Forray/AC/VCU
FWIW, I found this sentence in another TSM book: The value of the tcpclientaddress option must be the service IP address. This is the IP address used for primary traffic to and from the node. "Wholey, Joseph (IDS DM&DS)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]

Re: GIGE connectivity via TSM

2004-03-23 Thread David Longo
I have followed this discussion this morning. There is another point that I didn't see anyone mention. If you have or can install a 2nd NIC in your TSM server, then assign that NIC an IP address that is on same subnet as the NIC in your client. On the client in the dsm.sys (or dsm.opt for other

Re: GIGE connectivity via TSM

2004-03-23 Thread
OK... now things are getting fuzzy. This was my initial concern. Can anyone confirm exactly what one needs to do to ensure one traverses the GIGE NIC for both inbound and outbound traffic? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dwight Cook

Re: GIGE connectivity via TSM

2004-03-23 Thread
I don't disagree, but does this gaurantee that the data coming from the server will traverse the GIGE NIC as well? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Zoltan Forray/AC/VCU Sent: Tuesday, March 23, 2004 11:07 AM To: [EMAIL PROTECTED] Subjec

Re: TDPO for Oracle

2004-03-23 Thread Davidson, Becky
We use multiple stanzas so the stanza that tdpo requirements don't step on client requirements and vice versa. We connect using different servers it would be server_tdpo for tdpo and server_dsmc for dsmc -Original Message- From: Wholey, Joseph (IDS DM&DS) [mailto:[EMAIL PROTECTED] Sent:

Re: GIGE connectivity via TSM

2004-03-23 Thread Zoltan Forray/AC/VCU
My understanding of TCPCLIENTADDRESS is different. We use it for multi-homed boxes that have a separate NIC that connects to a private, internal, GIGE subnet so that the backups are pushed across it versus the public subnet.   To verify this, when I check the details for a TSM node (on the TSM se

Re: GIGE connectivity via TSM

2004-03-23 Thread
Michael, Yes my client and server are on different networks, as will be the GIGE card relative to other NICs on the client. I didn't want to get into maintaining a routing table, but if that's the only way to ensure communication over the GIGE in both directions, I guess that'll have to do. My

Re: GIGE connectivity via TSM

2004-03-23 Thread Dwight Cook
tcpclientaddress only sets the initial address for the server to come in on (last I remember) beyond that, standard system/network routing takes over. I'm still at 4.2 & 5.1 (moving to 5.2 in the next couple of months) but we currently put route statements on the client nodes to ensure the

Re: GIGE connectivity via TSM

2004-03-23 Thread Richard Sims
>In your DSM.OPT on the client (this is from the book): > >Tcpclientaddress ... Also watch out for any HLAddress, LLAddress server-side definitions for the node. Richard Sims

Re: GIGE connectivity via TSM

2004-03-23 Thread French, Michael
Is your TSM server on a different network from the client? Is the GigE card on a different network then the other interface on the machine? I would assume so, if that is the case, just set a permenant route that points to the TSM server's network and tell it to go out the GigE interface to get

Re: GIGE connectivity via TSM

2004-03-23 Thread Zoltan Forray/AC/VCU
In your DSM.OPT on the client (this is from the book): Tcpclientaddress The tcpclientaddress option specifies a TCP/IP address if your client node has more than one address, and you want the server to contact an address other than the one that was used to make the first server contact. "Whole

GIGE connectivity via TSM

2004-03-23 Thread
This should be an easy one for most... I have a Solaris client running TSM v5.2. It will be getting a GIGE card. What is the best/recommended way to ensure data is traversing the GIGE card (in both directions... outbound/inbound) if it is not set up as the default NIC on the client. thx. ==

Re: TDPO for Oracle

2004-03-23 Thread
You may want to break the link to prevent TDP from using the INCLEXCL file that's normally in a dsm.sys file. If you don't, you'll generate errors. If linked, and commented out, your normal backups won't have an INCLEXCL file, hence, you'll backup everything on your client server during your r

Re: TDPO for Oracle

2004-03-23 Thread Davidson, Becky
We had an issue with this and discovered that it was looking in the api directory for the dsm.sys and not the ba/bin directory so we just put a link in api to bin and it worked. -Original Message- From: Josh-Daniel Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 12:20 AM To:

IBM3584 Tape Drives won't write to Media

2004-03-23 Thread Rajesh Oak
I have an IBM3584 Library that we have divided into 4 Logical Libraries and assigned them to 4 TSM Servers. 3 are AIX Servers and the 4th is a Windows 2000 Server. This is new TSM Server that is not in production yet. The Drives in the 4th TSM Server are attached to the Windows Server thru' the S

Re: Backing up NDS/eDirectory server

2004-03-23 Thread Zoltan Forray/AC/VCU
Let me add a few things gleaned from my (and others) experience with this process. 1. It is best to get the 5.2.2.3 patch release. It addresses memory-leak issues in 5.2.2.0. 2. While the recommendation of running the backup "from the server that holds the master replica" is probably OK in genera

Re: TDP SQL question

2004-03-23 Thread Del Hoobler
Robert, You do not need a SLEEP statement between the two separate Data Protection for SQL commands. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 03/23/2004 08:02:39 AM: >

Re: TDP SQL question

2004-03-23 Thread Robert Ouzen
Hi Del Sorry for the confusion Thank you very much for the explanation , more comprehensible . A more small question did I can run it on same batch , did the process will run the full and only after the log (full with recovery=no and log with recovery=yes (default)) Or I need to add a sleep

Re: TDP SQL question

2004-03-23 Thread Del Hoobler
Robert, No. This is not correct. You still need to restore the log backup after you restore the full backup. The point of my response was to tell you that if you want to restore additional log backups to the database, all of the restores except for the last one need to be run with the /RECOVERY=NO

Re: How to block tape drive?

2004-03-23 Thread Jozef Zatko
Arnaud, thank you very much. It helped. Regards Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618

Re: mksysb tapes on fibre-attached 3590

2004-03-23 Thread Dwight Cook
In the old way, with SCSI attached 3590's you only had to either manually mount your mksysb tape in an attached drive OR use another host defined to the atl to mount the mksysb tape to a drive attached to the host you were wanting to restore. (I always have a ~utility server~ defined to all m

Re: How to block tape drive?

2004-03-23 Thread PAC Brion Arnaud
Hi Josef, Maybe you could make good use of one of those (undocumented) commands : Show library : shows all libraries and drives and their characteristics, including drive state Show asq: shows mount point queue Show asm : shows mounted (or mount in progress) volumes Hope this helped ! Arnaud Br

How to block tape drive?

2004-03-23 Thread Jozef Zatko
Hello guys, can somebody help me with following problem? I need to backup Oracle database (many of them) using b/a TSM client by putting Oracle into backup mode and backup all Oracle data files. Because of activity on Oracle database, before putting Oracle database into backup mode, I need to be su