Re: Help with select for non-mirrored database volumes

2002-07-26 Thread Braich, Raminder
Nicholas try this: select copy1_name, avail_space_mb from dbvolumes where copy2_name is null It worked for me from the web interface. Raminder Braich SAP/ORACLE/TSM DBA The Davey Tree Expert Company Kent, OH 44240 330-673-9515 Ext 270 -Original Message- From: Nicholas Cassimatis [mailt

Re: RMAN error

2002-07-26 Thread David Longo
Perhaps the TSM schedule you are runninng isn't running as "Oracle" user. The schedule should be setup as "Action: Command: and the "Objects" should be like this: su - oracle -c "/db_eng/rman/hotbkup.sh" (Your script or path might be different) This is how we run RMAN backups on AIX 4.3.3 clie

TDP for Domino backup (new) issues.....

2002-07-26 Thread Zoltan Forray/AC/VCU
Still working on getting all of our Domino/Notes DB's backed-up. Seeing these errors in the logs (lot of themthis is a snippet.). 07/26/2002 08:09:16 cuGetBackQryResp: Unknown objInfo header format:8,,\CSRV461.NTF 07/26/2002 08:09:16 cuGetBackQryResp: Unknown objInfo header format:8,,\CS

Re: diskpool performance

2002-07-26 Thread Seay, Paul
You are probably running at source disk speed in both cases. Just because it if fibre disk does not mean it is fast. It really depends on how you configured it, what type it is, etc. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Orville Lan

Re: LTO Tape OR 9840

2002-07-26 Thread David Longo
Some quick answers. I have a IBM 3584 LTO library with 8 drives and IBM tapes, have had about 6 months. Drives are FC-AL through McData ES-1000 switches to IBM PSeries (RS6000) 6H1. I find no problems with tapes. We compress on tape, not client. Getting about 275GB on tapes - range from 220 to

Re: New Policy Domain

2002-07-26 Thread Don France
Changing domain assignment will affect retention parameters -- not data location. If you want the data moved, using 5.1.1.1 or later (the only level I would consider using on a 5.1 server), use the new MOVE NODEDATA command to get the old data into the new storage pool. Alternative, under 4.x is

Réf. : LTO Tape OR 9840

2002-07-26 Thread Guillaume Gilbert
Hi Joni I personnaly prefer 9840's but the bean counters love the LTO because the drives are very much lower cost and the cost per GB is lower. The 9840 is probably the best drive/tape on the market today. The native thruput of 9840b's is 20 mb/sec while the LTO is 16 mb/sec. The start/stop on

Re: diskpool performance

2002-07-26 Thread Orville Lantto
Yes, there is overhead on tape, but the tape drives will theoretically write at rated write speed TIMES THE COMPRESSION RATIO. I have seen a sustained 60 MB/second into a 3590 tape drive. It required high powered hardware and significant tuning to get this rate. Such high performance is only a

Re: diskpool performance

2002-07-26 Thread Pearson, Dave
ON Tape... It take time to unwind, take the tape out, put another tape in then start processing... With Diskpool. Thre is non of this. My thought Dave Pearson > -Original Message- > From: Orville Lantto [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 11:03 AM > To: [EMAIL P

Re: Question about using global characters in a select statement

2002-07-26 Thread Andy Raibeck
Try using: ... where node_name like 'AD1%' Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goe

Re: Question about using global characters in a select statement

2002-07-26 Thread Thomas Denier
> For example if I use something like: > > select node_name, filespace_name from filespaces where node_name='AD1%' > > to get information about all nodes whose node_names begin with 'AD1' I get the > following error: > > ANR2002E Missing closing quote character. The correct form for the where cl

Re: TDP R/3

2002-07-26 Thread Kauffman, Tom
That may well be the key. I don't use collocation on my TDP/R3 stuff because they run direct to tape anyway and I've different management classes and storage pools for production and other environments. For one thing, the other environments don't get copied for off-site storage because the D/R rec

Re: Question about using global characters in a select statement

2002-07-26 Thread PINNI, BALANAND (SBCSI)
I think last node_name='AD1%' has syntax problem.It should be like clause . Go to Oracle.com and do search on select statement for like u get tons of info. Balanand Pinni SBC Services Inc. Work:314-206-5911 Pager:1-800-451-6897 Email ID :[EMAIL PROTECTED] [EMAIL PROTECTED] e.mail pager -

Re: Dr. Watson Error in drive C:\

2002-07-26 Thread Christian Astuni
Mark, thanks for your response ... and I answering your question: I do a archive of drive C: once a week and because I want to have the information in case the server crahs. I never try to restore this, but if I have and archive of drive C: and I need to rebuild the server .. that is work with the

Re: Occupancy comparison script

2002-07-26 Thread Jolliff, Dale
Thanks to everyone for the help. I haven't seen exactly what I'm looking for yet, so I'm inventing this wheel. I'll post back what I come up with. -Original Message- From: Ilja G. Coolen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 2:28 AM To: [EMAIL PROTECTED] Subject: Re

Re: RMAN error

2002-07-26 Thread Chris Gibes
It looks to me like the dsmc sched process is not running as root. Also, before you start the dsmc sched process, be sure to "export DSM_CONFIG=/oracle/home/sched/dsm.opt" (or wherever you happen to place the TDP's dsm.opt file). -Original Message- From: ADSM: Dist Stor Manager [mailto:[E

Re: diskpool performance

2002-07-26 Thread Kelly J. Lipp
Our experience with disk pools on RAID5 volumes has indicated that slow performance is the norm rather than the exception. This is especially true when more than one operation was running at a time, i.e., more than one client session, more than one migration or backup stg operation. We have take

Re: Gigabit Ethernet Performance

2002-07-26 Thread PINNI, BALANAND (SBCSI)
Andrew MTU and Jumbo enable on Card go together. Balanand Pinni SBC Services Inc. Work:314-206-5911 Pager:1-800-451-6897 Email ID :[EMAIL PROTECTED] [EMAIL PROTECTED] e.mail pager -Original Message- From: Andrew Carlson [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 2:52 PM

Re: Gigabit Ethernet Performance

2002-07-26 Thread Andrew Carlson
Has anyone experimented with Jumbo Packets, and it's impact on TSM? We are putting some money in the budget next year to get a switch and try it, I was just wondering if anyone already knows. Thanks. Andy Carlson|\ _,,,---,,_ Senior Technical Specialist

Re: Offsite Archives & DRM

2002-07-26 Thread Tab Trepagnier
Gordon, We do something similar. Selected locations on our network are archived with permanent-retention once per month and the primary tapes are sent offsite. As with you those are for legal archives and are almost never requested for retrieves. We do not use DRM. We leave the access to read

Disaster recovery with copy storage pools.

2002-07-26 Thread John C Dury
We currently have 2 TSM servers. TSM1 which holds the data backups of all the fileservers in the company. TSM2 which is off-site and is used only as a copy storage pool which is defined on TSM1 and nightly we do a backup of the primary storage pool (3494libpool2 on TSM1) to the copy storage

Re: Please elaborate on Bare Metal (was: question on dsmsched.log for system object backup w/active di rectory)

2002-07-26 Thread Rushforth, Tim
The IBM Redbook Procedure (http://www.redbooks.ibm.com/redbooks/SG246141.html) -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: July 24, 2002 7:28 PM To: [EMAIL PROTECTED] Subject: Re: Please elaborate on Bare Metal (was: question on dsmsched.log for system object back

Re: diskpool performance

2002-07-26 Thread Alex Paschal
Steve, You can check your disk performance. When you're backing up to diskpool, check your CPU's Wait I/O using vmstat 1 10 If you're getting significant Wait I/O, you can do an iostat 1 10 to check which volumes are getting hit the hardest. If you don't have significant Wait I/O, I would sugg

install library STORAGE TEK L20

2002-07-26 Thread CARLOS RAMON BRAVO ARREDONDO
I need of their help. I have a server TSM 4.1 in a HP-UX 11.00 and I need to add a library STORAGE TEK L20. Which is the procedure to install the library and 2 drives DLT7000? Thank you for their help. Carlos R. Bravo Arredondo [EMAIL PROTECTED] Tel. 51741924

Re: V4.2.2.7 Is Installed So Far So GOOD.

2002-07-26 Thread Talafous, John G.
Can you hear me now? 8-) How is it working? John G. Talafous IS Technical Principal The Timken CompanyGlobal Software Support P.O. Box 6927 Data Management 1835 Dueber Ave. S.W. Phone: (330)-471-3390 Canton, Ohio USA 44706-0927 Fax : (330)-471-4

Re: recovery log filling

2002-07-26 Thread Talafous, John G.
Joe, I've noticed that no one responded to your post and since I have had some experience with recovery log filling with TSM 4.1 and normal mode, I thought I would respond. My experience is that the TSM log can fill with long running clients. In our shop, particularly OS2 and VMS clients will

Remote IBM Magstar 3494 Library

2002-07-26 Thread Manuel Sanchez
Hi everyone! This is what we have: - Two remote sites ( Atlanta and Miami). - Two TSM v4r2l1.9 servers on AIX 5.1, one on each site. - Each TSM server has a serial connected IBM Magstar 3494 Library, with FC attached 3590 E tape drives, through Brocade 2800 switch. - Each TSM server backing up its

Re: Redirect Output in Windows dsmadmc

2002-07-26 Thread Andy Raibeck
You and John Monahan both came up with that same nifty little tip... :-) Thanks! Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb que

TSM & Microsoft Windows .NET

2002-07-26 Thread Mike Dile
Windows .Net is not yet officially supported by TSM, though development is actively working on it--witness the .Net references in the v5.1.0 Windows doc that we didn't quite get removed when Microsoft slipped their GA date. As Mark Stapleton indicates it would hard to declare official certificati

Re: TSM Client Licensing

2002-07-26 Thread Jon Adams
Thank you for your comment. However, you bring up another question by mentioning that a "node does not equal a system nor a license." I was wondering if my MS Cluster servers take a "license" for every separate resource I am backing up with a separate schedule/dsm.opt, and therefore a separate n

Re: Gigabit Ethernet Performance

2002-07-26 Thread PINNI, BALANAND (SBCSI)
Please could u give file sets that u used to install Gb ethernet card. Since U might need 4 of them . One is on AIX CD . What about these did u? devices.pci.ae120100 devices.pci.ethernet devices.pci.pciclass.02 Balanand Pinni SBC Services Inc. Work:314-206-5911 Pager:1-800-451-6897 Email ID

Re: TSM & Microsoft .NET

2002-07-26 Thread Tab Trepagnier
Mark, I have the beta of .Net Server through my MSDN subscription. Any developer who wanted to target .Net Server could do so today. Tab Trepagnier TSM Administrator Laitram Corporation Mark Stapleton <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 07/25/2002 09:

TDP/R3 v3.2.0.11 available at ftp.software.ibm.com

2002-07-26 Thread Cook, Dwight E
FYI... if anyone else was waiting on it. Dwight

Re: Redirect Output in Windows dsmadmc

2002-07-26 Thread Sjerps, Marco
Use the -out directive .. Works fine .. Even formatted if you want it's in the admin guide -Original Message- From: Richard Cowen [mailto:[EMAIL PROTECTED]] Sent: donderdag 25 juli 2002 15:30 To: [EMAIL PROTECTED] Subject: Re: Redirect Output in Windows dsmadmc When will we be able to d

Re: Offsite Archives & DRM

2002-07-26 Thread Gordon Woodward
Thanks for the reply Paul, strangely enough your original reply never reached me through the mailing list. From the information you have given me it looks like we are in a bit of difficulty as Tivoli Storage Management was originaly sold to us under the premise that it would be able to do this

Re: Réf. : LTO Tape OR 9840

2002-07-26 Thread Guillaume Gilbert
The licensing for Gresham is pretty good. I don't have the details but IIRC it's per Silo used. We've been using it for about 5 years and it works great. We interface with Library Station on Z/OS wihout a hitch. As for Library sharing, it does all the work. No need to go through TSM for that, just

Re: TSM & Microsoft .NET

2002-07-26 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Boireau, Eric (MED) > We are joinning the JDP on .net and I want to know if I will be able to > backup my .net servers with TSM (Currently TSM 4.2.1.6. on Win2K ADV). > Does TSM (Client) support MS .NET ? Does someone tried ? Whe

TSM Client 4.2.2.1 issue -- hanging

2002-07-26 Thread Aldrich, Jamie
> I am running on AIX 4.3.3.0 with TSM Client 4.2.2.1 to a 4.2.2.4 Server on > AIX 4.3.3.0. > > > Has anyone seen an issue when running an archive, the client connects to > the server, but waits for 6-8 minutes? > > I have several other clients (180) running to the same server over the > same netw

Re: Redirect Output in Windows dsmadmc

2002-07-26 Thread John Monahan
Like Unix, the windows "shell" has special characters too, with > being one of them. You can use quotes or escape the special character, similar to the unix way of things. The escape character for windows is ^. The following works: dsmadmc -id=admin -pa= select * from nodes where max_mp_

Help with select for non-mirrored database volumes

2002-07-26 Thread Nicholas Cassimatis
I'm on the right path, I think. It's all right there in the dbvolumes, I just can't get the info to come out right. I want to find out how large the unmirrored volumes are, so I can go get the space to mirror them. I've tried: tsm: SERVER>select copy1_name,avail_space_mb from dbvolumes where c

Tape I/O error on defining path 3494 NT SDGW

2002-07-26 Thread Koen Willems
Dear Listers, I have the following setup. 3494 with 3 3590 drives 2108 sdgw emulex lp8000 NT SP 6 I have a problem with the tape drives in the 3494. I can define my library and the library path in TSM. I can define a tapedrive in TSM, Then when I want to define a tape path I get I/O error's

recovery log filling

2002-07-26 Thread Wholey, Joseph (TGA\\MLOL)
Environment: TSM SERVER: 4.1.3.0 S/390 We're currently in the process of consolidating 4 TSM servers into 1. Over the course of about 3 weeks we've been redirecting clients to the new server. Originally this new TSM server was in logmode roll forward. As the volume to this server increased (i

Re: Swappin Silos

2002-07-26 Thread Daniel Sparrman
Hi Did this a few month ago. We moved 6000 9840B cartridges between two different PowderHorns. Easiest thing to do is to do a checkout from the old library, and checkin from the new library. What you have to think about is to checkout one category at a time(storagepool volumes, scratch volume

RMAN error

2002-07-26 Thread Jin Bae Chi
Hi, TSM experts, We've just set TDP for Oracle on AIX 4.3.3. The script works from crontab, but not from TSM client scheduler. It shows that the schedule has missed and RMAN log gives message like this; Recovery Manager: Release 8.1.6.3.0 - Production RMAN-00571: ===

Re: Redirect Output in Windows dsmadmc

2002-07-26 Thread Ilja G. Coolen
You can escape redirect chars in dos/windows too. To make windows/dos handle <> as text escape is using ^. Try this one : dsmadmc -id=youradmin -pa=yourpassw select * from nodes where max_mp_allowed^>1 Check the ANS8000I message in the following response: Tivoli Storage Manager Comman

Re: Swappin Silos

2002-07-26 Thread Cook, Dwight E
I agree with Don... Just connect in the new library and stick in all the tapes. Data/tapes are bound to a device class, then the device class is bound to a library What I'd do is get a list of all your tape volsers in a file and assemble checkout commands checkout libvol checklabel=no r

Re: Redirect Output in Windows dsmadmc

2002-07-26 Thread Andy Raibeck
That one is a little tougher. The problem is that the Windows command processor doesn't pass the '>' symbol to the program (to any program, not just TSM). You can verify this for yourself by compiling this simple C program: /* args.c */ #include int main