locate files in the tsm database

2001-08-30 Thread Henrik Ursin
A filesystem on a tsm node contained a lot of different init.dat files (all erased). Is it possible to make a query in the tsm database to find out where these files are positioned in the filesystem - some kind of select command? Med venlig hilsen / Regards Henrik UrsinTlf./Phone

Re: locate files in the tsm database

2001-08-30 Thread David McClelland
Hi Henrik, Try something simple, like: select NODE_NAME, FILESPACE_NAME, FILE_NAME, FILE_SIZE from CONTENTS where FILE_NAME like '% init.dat' This should find all instances of 'init.dat' whether backups or archives. I'm sure you could probably format this better, but the bare bones are

Re: locate files in the tsm database

2001-08-30 Thread Carsten Moldrup
select hl_name from backups where node_name='X' and filespace_name='\\X\c$' and ll_name='init.dat' Henrik Ursin [EMAIL PROTECTED] on 30-08-2001 10:21:52 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Carsten Moldrup/SCA/CSC) Subject: locate

CopyStoragePool tapes not expiring?

2001-08-30 Thread Eugene Awyong - Singapore
Hi, I seem to have a problem with some of my 'copystoragepool' tapes. Whenever i check out these tapes, I update the volumes as access=offsite, but it seems that when the original tape expires, they do not. See below for an example. SA2_006 already has 0.0% Pct Util and has a volume

Re: CopyStoragePool tapes not expiring?

2001-08-30 Thread Herfried Abel
Hi, did you perform an UPD VOL SA2_006 ACC=READWR after this it should be deleted from the stg pool and return to scratch state. herfried Eugene Awyong - Singapore [EMAIL PROTECTED]@VM.MARIST.EDU on 30.08.2001 12:23:13 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:

Re: TSM backup of MS Exchange

2001-08-30 Thread Del Hoobler
I do MS Exchange backup using TSM's TDP for MS Exchange. On TSM admin command line when I issue query filesp nodename f=d it gives me following output. Capacity (MB): 0.0 PCT Util: 0.0 Is this correct? Or it is not doing any backup? On all other UNIX and

Re: expiration of backups ....

2001-08-30 Thread MC Matt Cooper (2838)
Yes. -Original Message- From: Zosimo Noriega (ADNOC IST) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 1:22 AM To: [EMAIL PROTECTED] Subject: Re: expiration of backups Meaning the most recent backup will not expire and it will keeps forever in ADSM storage.

Re: Restore MS Exchange data to a different machine

2001-08-30 Thread Del Hoobler
Is it possible to move MS Exchange data from one Exchange server to another? I want to try to restore Exchange data to another server same way it works with other TSM clients, by giving access from source node to target node and than by starting client on target node using

Desaster Recovery for Win2K Clients

2001-08-30 Thread Volker Reinen
Moin, Does anybody have a description like a Cookbook to make a successfull desaster recovery on Win2K clients? Mit freundlichen Gruessen - Yours sincerely Volker Reinen System Engineering GE CompuNet Essen Severinstrasse 42, 45127 Essen, Germany Phone: +49-(0)201-2012-650, Fax:

Re: CopyStoragePool tapes not expiring?

2001-08-30 Thread Alan Davenport
I've also noticed that empty tapes that are in offsite status will not release. I run this script once per day to make sure that empty offsite tapes go to scratch: Name Line Command Number -- --

Re: Scratching empty tapes

2001-08-30 Thread Lindsay Morris
You might post q vol and q libvol... I assume you know about the MAXSCRATCH parameter on the storage pool... Are you checking in volumes as private, or as scratch? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Wolfgang Herkenrath Sent:

Re: Desaster Recovery for Win2K Clients

2001-08-30 Thread Ray Schafer
Volker, Here is a link to a posting by Wanda Prather to this list made about a year ago. It describes a manual process of doing a Bare Metal Restore for Win2k Professional: http://msgs.adsm.org/cgi-bin/get/adsm0009/304.html The Kernel Group has a commercial product called Bare Metal Restore

Re: Restore MS Exchange data to a different machine

2001-08-30 Thread Robert van Bussel
With TDP for Exchange V 2.2 it is supported and it works !!! We have restored data from an Exchange/2000 server to another Exchange/2000 server with another name. The trick is to specify the TSM-nodename of the FROM-server when you restore on the TO-server. For instance: tdpexcc restore

Re: Restore MS Exchange data to a different machine

2001-08-30 Thread Jeff Bach
Did you try setting up an isolated system with the same system name? Or hard coding the nodename in the dsm.opt file. Your system name may have to be the same, do you may have to isolate the environment (a test lab or something). Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores,

Re: Desaster Recovery for Win2K Clients

2001-08-30 Thread William Boyer
Also, http://www.coderelief.com/depot.htm has made their site available to upload all kinds of different things for TSM. Scripts...SQL queriesprocedures... Good place to put things and tell the list instead of a flurry of the 'Me Too!' replies. I believe Wanda put her document there. Lots of

Re: Restore MS Exchange data to a different machine

2001-08-30 Thread Joe Cascanette
Sure it can be done. It took me over 3 weeks to get it to work.. Of course you need to be running all the same versions and service packs for both TSM TP for Exchange (2.2 for me) and Exchange 5.5 (sp4) or 2000 on both machines. Do a full backup of your email server. Go to the restore server

Re: RMAN with TSM anyone ?

2001-08-30 Thread Herfried Abel
Hi, we saw that the ENV directive within the rman script is very important, we are running a little bit older versions but mayby this still helps : Here is a example how I do a full backup: - SHELL SCRIPT ( COMMANDLINE) BEGIN

Re: Restore MS Exchange data to a different machine

2001-08-30 Thread Del Hoobler
With TDP for Exchange V 2.2 it is supported and it works !!! We have restored data from an Exchange/2000 server to another Exchange/2000 server with another name. The trick is to specify the TSM-nodename of the FROM-server when you restore on the TO-server. For instance: tdpexcc

TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread David Longo
I have TSM Server 3.7.4.0 on AIX 4.3.3. I am going to be redoing my disk storage for this machine and have basically two questions. if someone knows the details of how this works. 1. The Disk Storage pool I have is 110GB. Most of the time it is between 20 and 70 percent full - mostly less

Anyone know a Ballpark cost of HSM

2001-08-30 Thread MC Matt Cooper (2838)
Hello all, I need to get a ballpark figure for the cost of Tivoli SPACE MANAGER. We are investigating using TSM's HSM function on UNIX. I have a few calls into Tivoli. This is day two and management is pushing me for at least a ballpark figure. Can anyone answer this? Thanks in

Re: Error

2001-08-30 Thread Andrew Raibeck
The advice to ignore the message is being given to customers within the context of an acknowledged bug (APAR IC30031). After anaylzing the bug, it was deemed safe to ignore the message until such time that the fix could be made available. As I mentioned yesterday in response to the initial query

expiration

2001-08-30 Thread Jeff Bach
Does anyone have any idea with my expiration appears to expire so much data. This would be at a 99.29% expiration. Am I missing something? Server AIX4.3.3 ADSM 4.1.2.0 Process Process Description Status Number -

Anyone have a script to install win95/98/me/2000 4.1/4.2 scheduler without using wizard?

2001-08-30 Thread Keith Kwiatek
Hello, I want to install the scheduler without having to use the wizard. Is there an unattended install doc somewhere? I guess I see a .bat file that runs and just installs the scheduler with certain default settings The bigger picture is that I am using pkzip + self extractor to allow the

Re: Disappearing Tapes

2001-08-30 Thread Yanki Yuksel
Are you also sending out your database backup tapes? If so, do you have a schedule in place that regularly deletes old database volumes? If you do, this would explain your situation. If you send a database volume offsite, it will not show up in a query volume or query libvolume command. The

Re: Anyone have a script to install win95/98/me/2000 4.1/4.2 sche duler without using wizard?

2001-08-30 Thread Prather, Wanda
For WIn2K, look in the client README file under the topic CENTRAL SCHEDULER; see the description of the dsmcutil utility, that does what you want. For WIn95/98, all you need is to copy the scheduler icon into the startup group; there is no background service to run the scheduler. -Original

Re: locate files in the tsm database

2001-08-30 Thread Prather, Wanda
I think it's a lot faster to let the client find it. Start the client (dsm on AIX) Click RESTORE Pull down VIEW, Active and Inactive Click the SEARCH icon (the magnifying glass on the AIX client) Type in the name of the filesystem as start path Type in the name of the file to search for (you can

Cannot delete tape in empty status... media state is incorrect

2001-08-30 Thread Robin Sharpe
Here's a puzzle for you all... I just yesterday upgraded from TSM 3.7.3.0 to 4.1.4.1 on AIX 4.3.3. All went well, and I haven't seen any problems except for this: I discovered a tape in my library that is EMPTY, but it has not been changed to scratch. Details of this tape's status are below. If

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Robin Sharpe
David, In answer to 1), No, in my experience the activity in a disk pool gets spread over all volumes, but not too evenly. In one of my disk pools, which has 13 volumes, some are around 20% full, and some are up around 60%. As for 2), good question. Q DB F=D does not show utilization of the

Re: Oracle Backup Error

2001-08-30 Thread Amini, Mehdi
Trying One more time to see if I get a response. Please Help Mehdi Amini -Original Message- From: Amini, Mehdi Sent: Wednesday, August 15, 2001 7:20 AM To: '[EMAIL PROTECTED]' Subject: Oracle Backup Error We ran Oracle backup for the first time last night and it

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Lindsay Morris
iostat will give you disk-by-disk percent-busy over time; a commercial product shows this graphically. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Robin Sharpe Sent: Thursday, August 30, 2001 11:36 AM To: [EMAIL PROTECTED] Subject: Re:

Re: expiration

2001-08-30 Thread Lambelet,Rene,VEVEY,GL-IS/CIS
in fact only object where items can be expired are counted as examined objects ! Your DB contains many more objects. Yours, -Original Message- From: Jeff Bach [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 4:44 PM To: [EMAIL PROTECTED] Subject: expiration Does

Re: locate files in the tsm database

2001-08-30 Thread David McClelland
Hi, Depends how many clients you have I guess - if you're backing up one or two clients then I couldn't agree more, but if you're looking after SP's then the gui approach might not be so appropriate. But hey, each to their own!!! Rgds, David McClelland --- Tivoli

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Lindsay Morris
Do sessions really lock volumes? I had always assumed they didn't. Disk volumes are random access, so for some reason I thought that several sessions could share one disk volume. In fact, I know of one site that regularly has 45-50 backup sessions running simultaneously, but only 37 disk

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Tab Trepagnier
Lindsay, The locked volume is my understanding based on what I've observed and picked up from the list and the manuals. If that is wrong, I apologize. My set of 500 MB volumes is spread across six physical disks so I do get some load balancing. I think my system is network-bound anyway. The

Re: locate files in the tsm database

2001-08-30 Thread Alex Paschal
Actually, if you do a select colname, index_keyseq from syscat.columns where tabname='BACKUPS' you'll find that columns are indexed like so: NODE_NAME 1 FILESPACE_NAME2 STATE 3 TYPE 4 HL_NAME

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Paul Zarnowski
Locking is usually done for as little time as possible, so even if multiple sessions are sharing a volume, I don't think that's a really bad thing. Presumably TSM follows the goal of minimal locking as well. I'm guessing that by having more smaller volumes, you may be avoiding some TSM locking

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Richard Sims
1) there is no need to have multiple ADSM volumes, one big volume fine. One big volume means one big processing thread, which sacrifices parallelism, impairing performance. Richard Sims, BU

Re: Moving a node from a policy domain

2001-08-30 Thread Prather, Wanda
Yes, easily. Just create the new policy domain. Then update the node(s) to specify the new domain. However, it won't cause ANY data movement. Any old data stays where it sits. Any NEWLY ARRIVING data will be bound to the management class in the new domain. -Original Message- From:

Re: expiration

2001-08-30 Thread Maurice van 't Loo
You may want to query the filespaces, to see that there are still some... And count the number of scratchtapes you've got :-) - Original Message - From: Lambelet,Rene,VEVEY,GL-IS/CIS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 6:21 PM Subject: Re: expiration

Re: backup/restore question

2001-08-30 Thread Robin Sharpe
Paul, Our NT admins did just that by doing an archive followed by a retrieve. They were moving to a new machine. You could also do it with backups, probably several ways... here are two off the top of my head: 1. Change the backup copy group to MODE=ABSOLUTE. Do your backup. Mode absolute

No Subject

2001-08-30 Thread Maurice van 't Loo
it will never expire - Original Message - From: Zosimo Noriega (ADNOC IST) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 12:53 PM i have a management calss with this propeties:

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Jeff Bach
The ninth sessions goes to the ninth disk volume allocated in my environment. I have not had a need to test this situation. In my environment, I would have 36 volumes if I had 8 * 9 gigs drives. An SSA disk drive can write 30 meg per second (do a move data and see) Multiple clients can write

Re: Cannot delete tape in empty status... media state is incorrec t

2001-08-30 Thread James healy
Robin, Did the volume checkout successfully before the checkin? Robin Sharpe [EMAIL PROTECTED]@VM.MARIST.EDU on 08/30/2001 03:43:09 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:

Problem with 3494 / 3590 drives only partly seen by library

2001-08-30 Thread Rick Un
Ok, folks got a puzzle for you. here's the environment: H80 / AIX 4.3.3 (relatively latest patches) 3494 with 3590 type E drives (another ADSM and TSM server are also using this library but different drives) 3590 drives are attached via a SAN datagateway Ok, the drives are available and

Re: 4.2 upgrade question

2001-08-30 Thread Daniel Whicker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You definately need the licenses from the 4.2 CD. The 4.1 will NOT work with 4.2 - --Daniel - -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Remeta, Mark Sent: Thursday, August 30, 2001 2:17 PM To:

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Richard L. Rhodes
On 30 Aug 2001, at 14:48, Jeff Bach wrote: 1. A single backups runs to a single volume as perceived by ADSM. The first session runs to the first volume allocated to the storage pool. The second session runs to the second logical volume allocated to the storage pool. The third sessions to

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread asr
= On Thu, 30 Aug 2001 15:56:48 -0400, Lindsay Morris [EMAIL PROTECTED] said: Jeff, clever! run iostat, then watch sessions start and land on different physical disks, on by one. Like the idea. Note; the sessions do not grab and keep individual volumes; They appear to walk down the list of

Re: TSM DB/Disk Pool - Disk tuning question

2001-08-30 Thread Jeff Bach
I see this on 4.1.3.0 Server code. It actually looks like one transaction per volume (as opposed to one file) , then go tot the next volume. I say this because for small files, it appears to not change volumes for each file. Anyone else? Jeff Bach Home Office Open Systems Engineering Wal-Mart