Re: IBM 3494 Library Sharing
Are all the servers connected to the library? What is the connection the TSM servers have to the library? TCP/IP or RS232? TCP/IP What is the connection the servers have to the tape drives? FC or SCSI? Migrating, some FC, most are still SCSI. Are you happy with the library sharing solution? At the moment yes. We were considering drive sharing using twin tailed SCSI until we went FC, but now are slowly realising that if/when we go SAN that we need to set up the Library Manager Server and Clients. We are not too happy about this as it appears that all our media mounts then depend upon one server being alive. If this server goes down then we get no media mounts until it's repaired. Can anyone else comment on whether this is true, or is there a backup Library Manager Server ability? Did you have to set a Library Manager Server and make the rest of the servers Library Clients? Any documents I must read? READMEs are a must. Please give an explanation of the steps that were followed to share the library. Not done SAN sharing yet. If you want to know about just SCSI and TCP/IP then mail me. Paul. -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net GMX Tipp: Machen Sie Ihr Hobby zu Geld bei unserem Partner 11! http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
Re: IBM 3494 Library Sharing
What I am looking for is a solution that allows TSM servers to mount tapes in any available drive. Is that what you have? No, we just have dedicated drives per TSM server, but share the library. We want to share the drives as well, but we are moving to SAN/FC before we attempt any drive sharing. Are your TSM Servers on the same computer? In that case your solution of using a script to swap drives sounds ok. To do library sharing is TCP/IP required? or Can we keep the RS232 connection? Sorry, I don't know. If all your servers are on one computer then I would have thought it would be ok. erm, if you've got 6 drives that you can swap between TSM Servers aren't you already doing library sharing? -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net GMX Tipp: Machen Sie Ihr Hobby zu Geld bei unserem Partner 11! http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
Re: TSM tapes out of sync. with Library manager
...shows the tape as FF00 [Insert category]... Does anyone know how to remove a tape from the library by using the console that's attached? I haven't seen anything but that doesn't mean it can't be done. The more recent Library Manager software has a Manage Import/Export Volumes menu, wherein Manage Insert Volumes claims ejectability. Or use the command: # mtlib -l/dev/lmcp0 -C -V XX -s FF00 -t FF10 Change the category of tape XX from FF00 (checkin) to FF10 (eject). This has the effect of removing the tape from the library. -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net GMX Tipp: Machen Sie Ihr Hobby zu Geld bei unserem Partner 11! http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
TSM Documentation in German or Russian
Hello, I know this question has been asked before, but maybe someone has done something like this since. Has anybody got any introductory texts or information about TSM that would help me teach TSM. I know Mr Helmut Richter has a web site at LRZ, but I need more server side documentation. If anyone has anything in german or russian, or knows where some is please let me know. Thanks. Paul Baines. -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net GMX Tipp: Machen Sie Ihr Hobby zu Geld bei unserem Partner 11! http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
Re: AW: DSM.OPT override question.
Is this not simply using the DSM_CONFIG environment variable to point to a different DSM.OPT file? Thank you Andy. Our group is under the impression that the vendor is thinking about the old-style (non-*SM) type of incremental backups where an operating system utility is used to take a full backup then incrementals throughout the week. In this scenario files that were deleted throughout the week could get restored if the full then all incrementals are restored. This could of course be a source of problems for some apps. In this case the vendor has a valid point. Of course *SM does not behave this way and a point in time restore can be done without restoring deleted files. What I'm doing is looking for ways to accommodate them if in fact, we must. IS it possible to specify a different client options file for a particular backup schedule? If this is the case there is no real problem. If not, then I have to look at trying something as ugly as defining two separate *SM nodes on the server. ): Al [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Fri, 27 Apr 2001 07:33:48 -0700 Subject: Re: AW: DSM.OPT override question. If the product's vendor is making a recommendation about how to back up (or how not to back up) their product, it's probably a good idea to heed that recommendation. You do not want to be in a position where you need to restore, and the vendor can not help because you did not follow their recommended backup procedure. That said, it would be a good idea to ask the vendor why they make that recommendation, so that you can evaluate its technical merits. In this case, the vendor may have a very good reason for recomending against incremental backups; on the other hand, perhaps they do not understand what is meant by incremental backup, so again, a discussion as to why they make the recommendation is a good idea, so that all parties understand the issues. Regards, Andy _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: AW: finding unused mgmt classes - why didn't this work?
Hi, here is a management class I use for archive: tsm: ADSM_SP02q copygroup UNIX t=a PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - UNIX ACTIVESTANDARD STANDARD 3,650 UNIX STANDARD STANDARD STANDARD 3,650 and a select from the database: tsm: ADSM_SP02select * from archives where node_name='SV001463' and filespace_name='/test_adsm' and hl_name='/tmp/' and type='FILE' ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute. Do you wish to proceed? (Yes/No) y NODE_NAME: SV001463 FILESPACE_NAME: /test_adsm TYPE: FILE HL_NAME: /tmp/ LL_NAME: tsm_actlog_SP01.arc OBJECT_ID: 209238661 ARCHIVE_DATE: 2001-04-12 15:22:06.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT NODE_NAME: SV001463 FILESPACE_NAME: /test_adsm TYPE: FILE HL_NAME: /tmp/ LL_NAME: tsm_actlog_SP01.arc OBJECT_ID: 209696157 ARCHIVE_DATE: 2001-04-15 00:39:04.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT more... (ENTER to continue, 'C' to cancel) This says that my class name is "DEFAULT", but I don't have a class name "DEFAULT", it's called "STANDARD". Here "DEFAULT" would seem to be saying that the class name used is the default class name and not a class name called default. Am I understanding this correctly? Then CLASS_NAME is only the class name if it isn't the default class, otherwise it's DEFAULT. Or did I have too much to dream last night? TRY (if you have some time): select node_name,class_name,count(*) from backups where type 'DIR' group by node_name,class_name to have an overview about your used managementclasses. Regards, Stefan Holzwarth -Urspr|ngliche Nachricht- Von: Gina Glenewinkel [mailto:[EMAIL PROTECTED]] Gesendet am: Dienstag, 17. April 2001 17:18 An: [EMAIL PROTECTED] Betreff: finding unused mgmt classes - why didn't this work? Some time ago I posted to this list a question about how to find out if my old management classes are still managing any client data. A couple of you responded suggesting this select statement: select * from archives where class_name='classname' and the same for backups. I ran this on several management classes and got "no match found for this query". Thinking that meant there was no data found governed by that management class, I deleted it and got the expected message about any data will be rebound to the default management class. I did not expect any data to be rebound. Turns out, I deleted some active management classes by mistake because I thought they weren't being used. Can anyone tell me why my select statement didn't work as expected? /gina _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: AW: finding unused mgmt classes - why didn't this work?
My default management class is STANDARD. This means that the CLASS_NAME column of the ARCHIVES table only reflects the class name when it is not the default management class name. This sounds like a bug, except that these columns aren't documented anywhere as far as I know, so it's not a bug, it's a feature. Go to the active policy set and check which Mgmt class is default . Default is not the mgmt class :))) paul baines paulbaines@HOTo: [EMAIL PROTECTED] TMAIL.COMcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Re: AW: finding unused mgmt classes - why didn't this work? "ADSM: Dist Stor Manager" [EMAIL PROTECTED] IST.EDU 18.04.2001 16:10 Please respond to "ADSM: Dist Stor Manager" Hi, here is a management class I use for archive: tsm: ADSM_SP02q copygroup UNIX t=a PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - UNIX ACTIVESTANDARD STANDARD 3,650 UNIX STANDARD STANDARD STANDARD 3,650 and a select from the database: tsm: ADSM_SP02select * from archives where node_name='SV001463' and filespace_name='/test_adsm' and hl_name='/tmp/' and type='FILE' ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute. Do you wish to proceed? (Yes/No) y NODE_NAME: SV001463 FILESPACE_NAME: /test_adsm TYPE: FILE HL_NAME: /tmp/ LL_NAME: tsm_actlog_SP01.arc OBJECT_ID: 209238661 ARCHIVE_DATE: 2001-04-12 15:22:06.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT NODE_NAME: SV001463 FILESPACE_NAME: /test_adsm TYPE: FILE HL_NAME: /tmp/ LL_NAME: tsm_actlog_SP01.arc OBJECT_ID: 209696157 ARCHIVE_DATE: 2001-04-15 00:39:04.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT more... (ENTER to continue, 'C' to cancel) This says that my class name is "DEFAULT", but I don't have a class name "DEFAULT", it's called "STANDARD". Here "DEFAULT" would seem to be saying that the class name used is the default class name and not a class name called default. Am I understanding this correctly? Then CLASS_NAME is only the class name if it isn't the default class, otherwise it's DEFAULT. Or did I have too much to dream last night? TRY (if you have some time): select node_name,class_name,count(*) from backups where type 'DIR' group by node_name,class_name to have an overview about your used managementclasses. Regards, Stefan Holzwarth -Urspr|ngliche Nachricht- Von: Gina Glenewinkel [mailto:[EMAIL PROTECTED]] Gesendet am: Dienstag, 17. April 2001 17:18 An: [EMAIL PROTECTED] Betreff: finding unused mgmt classes - why didn't this work? Some time ago I posted to this list a question about how to find out if my old management classes are still managing any client data. A couple of you responded suggesting this select statement: select * from archives where class_name='classname' and the same for backups. I ran this on several management classes and got "no match found for this query". Thinking that meant there was no data found governed by that management class, I deleted it and got the expected message about any data will be rebound to the default management class. I did not expect any data to be rebound. Turns out, I deleted some active management classes by mistake because I thought they weren't being used. Can anyone tell me why my select statement didn't work as expected? /gina _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Export Question
Maybe the missing data is copy storagepool data that isn't included in an export? I am working on an Export process and I am running into some capacity discrepancies. Below is the process that I followed. 1. Run AUDIT LICENSE 2. QUERY AUDITOCC 3. The node shows that ADSM has 845GB of data. 4. I run EXPORT NODE FILEDATA=ALL PREVIEW=YES and that shows that only 440GB will be exported. Is my database corrupt or do the numbers from the audit and the export differ? I tried calling ADSM support but, as of 4/1/01 all support even 1st level has been dropped. Regards, Blaine _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Find Size of a table in TSM DB?
Does anyone know of a way to determine the size of a particular table that
resides in the TSM DB?
select count(*) from table_name ??? or do you mean the amount of Mb it is
taking up? The tables are really balanced trees ("SHOW OBJD" command) You
can determine the sizes of these by running the SHOW TREE against the tree
of choice:
TSM show tree Activity.Log
add up leaf-nodes and non-leaf-nodes for the number of pages used.
Because these commands are undocumented, this is only my guess at what the
output is telling me :-)
Also, don't run this command against Backup.Objects on a 60Gb database
unless you don't mind a weeks wait.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Solaris client tcpip and 3494 mtlib
3) We have a collection of old management classes laying around that I would like to get rid of. Is there an easy way to tell whether any client data is still being stored under these management classes? I was thinking of "query occupancy" but that doesn't seem to have what I need. Is there a "select" statement I could issue that will tell me? There is a field name CLASS_NAME in the BACKUPS and ARCHIVES tables, SELECT * FROM BACKUPS WHERE CLASS_NAME='MYCLASS_NAME' I think this will run for hours and hours. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Remote Storage Pool Copy.. Urgent Help Needed!!!
Well I ain't no guru, but if you're talking about server-to-server then maybe you can edit this up (and look in the Server to Server Redbook which is very good.) Source server: DEFINE SERVER TARGET SERVERPASS=TARGET HLA=100.100.100.100 LLA=1500 NODENAME=HOST PASSWORD=HOST DEFINE DEVCLASS SERVER DEVT=SERVER SERVERNAME=TARGET MAXCAP=2G Target server: DEFINE DOMAIN HOST DEFINE POLICYSET HOST STANDARD DEFINE MGMTCLASS HOST STANDARD STANDARD ASSIGN DEFMGMTCLASS HOST STANDARD STANDARD DEFINE COPYGROUP HOST STANDARD STANDARD STANDARD TYPE=ARCHIVE DESTINATION=TAPEPOOL_3494 ACTIVATE POLICYSET HOST STANDARD REG NODE HOST HOST TYPE=SERVER DOMAIN=HOST Of course you have to define your storage pool on the source as well. Help me Oh Great Adsm Guru's... I need to run daily copies of a local tape stg pool to a remote tape stg pool... I have just had a long hard Sunday at work and can't remember, and can't find it in the manuals.. Has someone got a procedure that I can follow please... from "define stg" to "ba stg" (for both nodes as applicable.) I am using V4.1 on NT servers.. Many Thanks and Humble Greetings to All Tony Morgan Fortis Bank UK _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: NT Client - Out of Memory
Or have a look at the MEMORYEFFICIENTBACKUP parameter. From: "Chibois, Herve" [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: NT Client - Out of Memory Date: Mon, 2 Apr 2001 17:42:18 +0200 MIME-Version: 1.0 Received: from [148.100.1.2] by hotmail.com (3.2) with ESMTP id MHotMailBC91E8CE0078D820F3EB9464010297780; Mon Apr 02 08:42:09 2001 Received: by VM.MARIST.EDU (IBM VM SMTP Level 320) via spool with SMTP id 2181 ; Mon, 02 Apr 2001 11:41:00 EDT Received: from VM.MARIST.EDU (NJE origin LISTSERV@MARIST) by VM.MARIST.EDU (LMail V1.2b/1.8b) with BSMTP id 8725; Mon, 2 Apr 2001 11:40:49 -0400 Received: from VM.MARIST.EDU by VM.MARIST.EDU (LISTSERV release 1.8d) with NJE id 3928 for [EMAIL PROTECTED]; Mon, 2 Apr 2001 11:40:45 -0400 Received: from MARIST (NJE origin SMTP@MARIST) by VM.MARIST.EDU (LMail V1.2b/1.8b) with BSMTP id 8721; Mon, 2 Apr 2001 11:40:45 -0400 Received: from smtp2.admiral.fr [212.11.25.35] by VM.MARIST.EDU (IBM VM SMTP Level 320) via TCP with ESMTP ; Mon, 02 Apr 2001 11:40:44 EDT Received: from ad-pa-mail1.admiral.fr (unverified) by smtp2.admiral.fr (Content Technologies SMTPRS 2.0.15) with ESMTP id [EMAIL PROTECTED] for [EMAIL PROTECTED]; lun., 02 avr. 2001 17:41:29 +0200 Received: by AD-PA-MAIL1 with Internet Mail Service (5.5.2650.21) id H001PMQH; Mon, 2 Apr 2001 17:42:20 +0200 From [EMAIL PROTECTED] Mon Apr 02 08:42:55 2001 X-Mailer: Internet Mail Service (5.5.2650.21) Message-ID: 11AE4BC5F998D211933300805FD644D30130473E@AD-PA-MAIL1 Sender: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] Hi David, Close all the useless client applis and services on the NT box Have you changed the 'resourceutilization' param ? If yes, set it to 1 in dsm.opt. What are your TCPxxx parameters and TNXBYTELIMIT ? How big is your server ? If it is the first time you backup this machine, try to send drives one by one, of huge-directories one by one. If this is a normal incrimental session, add some RAM ! rv -Message d'origine- De : David Nash [mailto:[EMAIL PROTECTED]] Envoyi : lundi 2 avril 2001 17:34 @ : [EMAIL PROTECTED] Objet : NT Client - Out of Memory We are having a problem with an NT Client. We are using 4.1.3 client and server. The NT Client (NT Server 4.0 SP6a) is getting an error message when we try to back it up. The error is ANS1030E, which states "Out of memory...". Is there anything I can do short of adding more memory or increasing the pagefile? This server has a RAID5 partition that contains about 100 GB of small files. Thanks, --David Nash Systems Administrator The GSI Group _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windows)
4. Is there a MAC agent that allows for the "illegal characters" associated with Apple/Macintosh naming conventions? EXAMPLE: We have an NT server that the MAC clients connect to. This NT server contains the home directories for all the MAC clients. Veritas' Backup Exec handles these files (and their "illegal characters") correctly, but TSM has problems. I believe this is controlled by the USEUNICODEFILENAMES parameter. I am not certain, (test it yourself), but you would need to set up two clients on your server, one DSM.OPT containing USEUNICODEFILENAMES YES; LANG AMENG; and EXCLUDE.DIR all the NT directories. And one DSM.OPT containing USEUNICODEFILENAMES NO; and EXCLUDE.DIR all Mac directories. This means, of course, 2 client licenses per box. -- Sent through GMX FreeMail - http://www.gmx.net
Re: import node into a different domain
Hi, I assumed that the domain= on import referred to domains on the export volume that you want to import, not that I see much use for this. Whenever I have imported to a different domain I had the new domain already defined with the node registered and then imported the data from the export volume without specifying a domain= option (defaults to all domains.) Paul. Hi, I have several node definitions I want to move from serverA to serverB, also changing the name of the domains as I go. Seems plausible. I have done export node filedata=none and then import node with dom=new which successfully does nothing at all and imports nothing. I can only get it to import if I specify a domain exactly like on the original server. I thought that specifying dom=xxx on import would override what was in the export file? I have tried with/without replacedefs option. Am I missing something obvious here? [AIX 433 and TSM 3740] Thanks for any help, Sheelagh -- Sheelagh Treweek Oxford University Computing Services Email: [EMAIL PROTECTED] Phone: +44 (0)1865 273205 Fax:-273275 -- Sent through GMX FreeMail - http://www.gmx.net
Re: Server to Server
Hi, sorry if this is a silly suggestion, but check your maxscratch on the copy pool definition. Paul. Hello All I have a problem with sending copies of primary stg pool using server to server. I have a source server defined on a target server that I am able to send nightly DB backups to the target server...I have everything defined and have the node registered as a server on the target server. The devclass=server. No problems there. I am encountering problems when attempting to send copies of primary storg pools. I have set up a stg pool type=copy that the devclass is assigned to a devclass=server. When I attempt to "backup stg NT_Logs cpy_pool" I see a message in the activity log that states ANR1221E BACKUP STGPOOL: Process 12 terminated insufficient space in target copy storage pool. I was under the assumption that the stg pool I created on the source server is just a stg pool with no disk space defined. Since this stg pool is type=copy the definition of the devclass points the copy of the storage pool to the target server.I have assigned the node to its own policy domain which only contains two policy sets and two mgmt classes and one archive copy group and one backup copygroup. What am I missing. Thx Arturo -- Sent through GMX FreeMail - http://www.gmx.net
Re: Export/Import Data between servers
Hi, to import the node onto the target server you need to define the target server as a server to itself. Also you need to have the storage pool name defined on your target server that was defined on the source OR you need to predefine the node in a domain/policy/mgmtclass/copygroup that points to another storage pool. Something like: DEFINE SERVER TARGET SERVERPASS=XXX HLA=100.100.100.100 LLA=1500 NODENAME=SOURCE PASSWORD=XXX DEFINE DEV TARGET DEVT=SERVER SERVERNAME=TARGET MAXCAP=2G Where the HLA is your target server IP address. Then your import should be along the lines of: IMPORT NODE * DEVCLASS=TARGET VOLUME=TARGET.EXP.987654321 The self reference makes the naming conventions a bit wierd, I hope you can follow this. The server to server redbook has quite a bit on this procedure if I remember correctly. Paul. I am trying to export nodes from a source server to a target server and them import them on the target server. I have the export part working OK. The import instructions are unclear to non-existent in either the Administrator's Reference or the Administrator's Guide. To export, I did the following setup: On the source server: DEFINE SERVER TARGET NODENAME=SOURCE PASSWORD=XXX. DEFINE DEVCLASS TARGET SERVERNAME=TARGET On the target server: REGISTER NODE SOURCE XXX TYPE=SERVER . To export on the source server: EXPORT NODE * DOMAIN=X1234 DEVCLASS=TARGET This command works OK and creates a virtual EXPORT volume on the source server (the data is actually stored as an archive file under node SOURCE on the target server): TARGET.EXP.987654321 My question is: What definitions are required to be able to import this data on the target server? I need to be able to: IMPORT NODE * DEVCLASS= VOLUME=??? Thanks, --- Don Coleman, Queen's University Information Technology Services Kingston, Ont. Canada K7L 3N6 Tel: (613) 533-2034 Fax: (613) 533-2168 Email: [EMAIL PROTECTED] -- Sent through GMX FreeMail - http://www.gmx.net
Joining BACKUPS and CONTENTS tables.
Is it possible to answer the question "How much (Mb) data that is over 1 year old is stored on my server?"? The way I see this working is by joining the BACKUPS and CONTENTS tables. The problem is that the join between these two tables cannot be perfectly done. You cannot differentiate between ACTIVE and INACTIVE in the CONTENTS table, so that if you had three versions in the BACKUPS table, you would match each of these three times in the contents table (cartesian product?) (This has been discussed by Reinhard Mersch u.a. earlier on this list.) Another way could be by using the OBJECT_ID field from BACKUPS and awk/pipe/whatever it into a SHOW INVO command (for all 60 zillion backup objects over a year old!) and then awk out the sizes. Has anyone any ways round these "problems" or any other suggestions? Paul. -- Sent through GMX FreeMail - http://www.gmx.net
Re: Joining BACKUPS and CONTENTS tables.
You cannot differentiate between ACTIVE and INACTIVE in the CONTENTS table, so that if you had three versions in the BACKUPS table, you would match each of these three times in the contents table... Paul - In the BACKUPS table, a null value for the DEACTIVATE_DATE column indicates that the file is the Active copy, and a date value indicates an Inactive copy, if that helps. Richard Sims, BU This also seems to be reflected in the STATE column, but it is the lack of this in the CONTENTS table that means I cannot join them. If the OBJECT_ID field was also in the CONTENTS table that would be a solution. I've thought about this quite a bit today and I think there's no solution :-( Thanks, Paul. -- Sent through GMX FreeMail - http://www.gmx.net
Re: Virtual volume - physical Volume
Or select object_id from archives where hl_name='ADSM/virtual volume name' and then do a show bfo 0 xxx where xxx is the object_id(s) from the query, to get the volsers. Hi, does anybody know how I can find out on which physical volume a virtual volume ist stored. I have only the name of the virtual volume. Regards winfried A VV is simply stored as an archive object, so querying the contents table of the appropriate storage pool on the target server should do the job. Hth, -- Horst SCHERZER e-Mail: [EMAIL PROTECTED] Zentraler Informatikdienst Uni Wien Phone: (+43 1) 4277 x14053 Universitaetsstr.7 Fax: (+43 1) 4277 x9140 A-1010 Vienna, Austria URL: http://mailbox.univie.ac.at/~sc Horst.Scherzer.vcf Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Copy Storage-pool Definitions for Cloning a Server
Hi, Is the library definition(s) also left out? It might be that these are deliberately left out of the EXPORT/IMPORT function because they are operating system dependant. Devclass can contain (for FILE) a directory name that is not compatible between, say, Windows and Unix (slashes the "wrong" way round). Devclass also can have a library, whose definition also is operating system dependant. Storage pools are then dependant on a device class. Just my first thoughts on this. Paul. Hi *SM'ers, i cloned my production server into a new one and took EXPORT/IMPORT function for this task. It works wonderful. But I missed the device-classes. It's ok that they aren't there. I can take them from my backuped devconfig file and bring it as macro in my new server. The Storage-Pool Definitions are also missing. How can I bring them from one server to the other? Has anyone an idea? Mit freundlichen Gr|_en / best regards Gerd Becker EMPRISE NETWORK Consulting GmbH Albstr. 14 70597 Stuttgart Tel.: 0711/990083-0 oder Mobil: 0172/4036581 Fax: 0711/990083-9 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.emprise.de http://www.s390.de _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Upgradedb command
Hello, I noticed during an AIX install of TSM that the install ran the following command: dsmserv upgradedb runfile /usr/tivoli/tsm/server/bin/haltsrvr.cmd I have no idea what this means :-) but you could maybe play with that? Don't hold me responsible ...etc. Paul. Hi, When doing an dsmserv upgradedb command, the server continues to run after completion. Is it possible to add a flag that will shut down the server once it has finished upgrading the database? We are attempting to automate some of the server upgrade process, and this one command is halting our progress 8^) Thanks, -Matt *-* Matt Bacchi [EMAIL PROTECTED] IBM Global Services [EMAIL PROTECTED] Dept. F6TG, MD Filesystems/Internet (802) 769-4072 ADSM AFS/DFS Backup(tie) 446-4072 _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Database Space???
Hi, you can run the amazingly useful "show tree" command (unsupported) against the activity log tree to find out how much of the database it's using up. show tree Activity.Log add up leaf-nodes and non-leaf-nodes for the number of pages used. I find its usually less then 0.1%. (!show tree scans the database trees and for some it can take a LONG time!) From: Leo Humar [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Database Space??? Date: Mon, 13 Nov 2000 10:20:16 +1100 The activity log is a possible reason for this. Because the activity log is stored in the database, the size of the activity log must be factored into the amount of space allocated for the database. The activity log size is dependent on the length of time the activity log information is retained. When the length of time is increased, the amount of accumulated data also increases and additional database storage is required You will have to us give more information about your policies and the last couple of days of events so we are able to asses the possible causes. Leo Humar LCS Pty Ltd [EMAIL PROTECTED] No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -Original Message- From: Saad Al-Sakran [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 12 November 2000 19:36 Subject: Database Space??? Hi ever one My database size is increasing sharply and I do not do any changing if u have any possible causes please tell me what is the proper way to deal with this situation. Thanks for all best regards Saad Al-Sakran LAN Administrator _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: Server-to-server COPYPOOL, anyone?
Still, I'd be grateful for further *sizing* and configuration hints. I would think that sizing for a copypool is simply the same size as your primary data? What I notice at our site is that we use one server as a pure target server, the only nodes defined on this machine are ADSM/TSM servers. The two source servers have databases of 58Gb and 40Gb, but the target database is only 812Mb! secondary site, and ideas how to choose the MAXCAPACITY of virtual volumes (in relation to tape capacity). We have 10Gb MAXCAPACITY. The server to server process marks new volumes as full as soon as it opens them so it uses each volume only once to write to. This means that your virtual volumes could be any size between 0.01 and 10 Gb. On the target we have a disk storage pool for each source server, 106Gb and 78Gb One server has 2537 virtual volumes with an average size of 4,7Gb. The other server copied 43,6 Gb to the copy pools today over 100Mb ethernet. Erm,...don't know what else to say. Feel free to write direct to my email address if you have any other questions. Paul. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: what to do with bad tapes
You should also look at the RESTORE VOLUME command which will attempt to recreate your primary storage pool volume (on a different volume) from copy pool volumes. update vol access=destroyed looked like what I wanted, but I thought I ought to get a second opinion. I find the manuals to be useful once I know what I am doing, but not particularly good tutorials. Thanks. I will "move data" first to salvage what I can. - Kai. -- Kai Hintze currently using the mailer [EMAIL PROTECTED] Richard Sims wrote: How do I tell ADSM that a tape is bad and should never be used again? 'UPDate Volume ... ACCess=DEStroyed' or ACCess=UNAVailable. But it's best to deal with the tape data in whatever manner is appropriate and then get it out of the library so that a good tape can be available. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: Oggetto: Re: Select ??????????
Would this SQL give you what you want?
select library_name, volume_name, status, last_use from libvolumes where
status='Private' and volume_name not in (select volume_name from volumes)
That is, any libvolumes in Private status, that are not in the volume table.
Paul.
From: Pieter Groen [EMAIL PROTECTED]
Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Oggetto: Re: Select ??
Date: Wed, 27 Sep 2000 12:11:54 +0200
You are right. The volumes with nothing in last_use column don't show up.
In my opinion this is A BUG!
IBM or Tivoli-people please respond?
Greetings,
Pieter
Alessio Prodon schreef:
Thank you for reply but with this command I show it :
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
I don't know what appening !!!
Alessio Prodon
Pieter Groen [EMAIL PROTECTED] il 27/09/2000 10.48.32
Per favore, rispondere a "ADSM: Dist Stor Manager"
[EMAIL PROTECTED]
Per: [EMAIL PROTECTED]
Cc:(ccr: Alessio Prodon/Centro di Gestione/G-Net/IT)
Oggetto: Re: Select ??
You should not compare upper(something) with 'Data', because 'ata' is
lower
case!
This works:
select * from libvolumes where last_use != 'Data'
LIBRARY_NAME: 3575LIB
VOLUME_NAME: A00215
STATUS: Private
LAST_USE: DbBackup
HOME_ELEMENT: 273
CLEANINGS_LEFT: 0
Greetings,
Pieter
Alessio Prodon schreef:
If I entry " q libv " I have :
adsm q libv
Library Name Volume Name StatusLast Use
--- - -
LIB7332 DS0001 Scratch
LIB7332 DS0003 Private Data
LIB7332 DS0004 Scratch
LIB7332 DS0005 Private
With select I must show only " ds0005 " (because it's in private
state and
last_use isn't = data), but if I try with this select :
select library_name, volume_name, status,last_use from libvolumes
where
upper(status) = 'PRIVATE' and upper(last_use) != 'Data' , I show
LIBRARY_NAME VOLUME_NAMESTATUS
LAST_USE
-- -- --
--
LIB7332DS0003 Private
Data
It isn't correctly
Any suggestion ???
Alessio Prodon
I try with this command :
-- Inoltrato da Alessio Prodon/Centro di
Gestione/G-Net/IT
il 27/09/2000 09.59 ---
Horst Scherzer [EMAIL PROTECTED] il 27/09/2000 09.47.53
Per favore, rispondere a "ADSM: Dist Stor Manager"
[EMAIL PROTECTED]
Per: [EMAIL PROTECTED]
Cc:(ccr: Alessio Prodon/Centro di Gestione/G-Net/IT)
Oggetto: Re: Select ??
Alessio Prodon wrote:
Hello !!!
I'm running ADSM 3.1.2.55 on AIX 4.3.3. I would like a tape's list
in
private
status, not associate to the stgpool.
I see you example :
adsm q libv
Library Name Volume Name StatusLast Use
--- - -
LIB7332 DS0001 Private Data
LIB7332 DS0003 Private Data
LIB7332 DS0004 Scratch
LIB7332 DS0005 Private
I try with select statement :
select * from libvolumes where status='Private' and last_use
'Data'
This command doesn't work !!!
Please, let me know how can I solve this problem.
Thank you in advance.
Alessio Prodon
ANS5100I Session established with server BACKUP: AIX-RS/6000
ANS5101I Server command: 'select library_name, volume_name, status,
last_use from libvolumes where upper(status) = 'PRIVATE' and
upper(last_use) != 'DATA''
LIBRARY_NAME VOLUME_NAMESTATUS LAST_USE
-- -- --
--
IBM3494A00557 PrivateExport
IBM3494A00598 PrivateExport
IBM3494B00100 PrivateDbBackup
IBM3494B00101 PrivateDbBackup
IBM3494B00102 PrivateDbBackup
IBM3494B00103 PrivateDbBackup
IBM3494B00104 PrivateDbBackup
IBM3494B00105 PrivateDbBackup
IBM3494B00106 PrivateDbBackup
ANS5103I Highest return code was 0.
Hth,
--
Horst SCHERZER mailto:
[EMAIL PROTECTED]
Zentraler Informatikdienst Uni-Wien Fax:
SELECT from the EVENTS table doesn't look right.
Hello, Can anyone explain the following results to me? tsm: TESTselect count(*) from events Unnamed[1] --- 117 tsm: TESTselect count(*) from events where '08/01/2000' scheduled_st art Unnamed[1] --- 8507 It seems as if by narrowing down my selection I get more results. This seems to be behaving like a Q EVENTS rather than SQL. Confused of Frankfurt. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: Any way to see which files are associated to a certain Mgt class? ?
The ARCHIVES and BACKUPS tables have a column CLASS_NAME. So you could do
"SELECT * FROM ARCHIVES WHERE CLASS_NAME='your class'"
"SELECT * FROM BACKUPS WHERE CLASS_NAME='your class'"
these queries may run for some time so it might be better to include a WHERE
clause for NODE_NAME such as WHERE NODE_NAME IN ('xxx', 'yyy', 'zzz') for
all the nodes in that domain.
From: Susan Wright [EMAIL PROTECTED]
Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Any way to see which files are associated to a certain Mgt class?
?
Date: Tue, 19 Sep 2000 12:55:48 -0500
I have a management class that was created a while ago and we are cleaning
up things and before we remove this class we want to make sure that there
are no files associated to this class. Is there a way in which to see what
files, if any, there are backed up to this mgt class??
AIX 4.3.3
ADSM 3.1.2.50
TIA
Susan Wright
Operations Specialist
Lab Safety Supply, Wisconsin
[EMAIL PROTECTED]
12:00 pm - 8:30 pm CST.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
Re: How does ADSM Map nodenames to IP's?
Hi, this is based totally on my assumptions of how the stuff is stored in TSM. It could be all BS. You can look at the TSM tables(trees) with the SHOW NODE command. Use SHOW OBJD to get the page numbers for the "Nodes" object and the "Schedule.Node.Addresses". Use SHOW NODE and the number for "Nodes". Find your node name here (The key) and its first data field. If you have more than a handful of nodes you may have to follow the subtree using a further SHOW NODE using the key value nearest and greater than your node name. With the number corresponding to your node, go to the Schedule.Node.Addresses table using SHOW NODE and find the key value that is your node number. The second data field is the IP address. Paul. From: "Taylor, Damon M" [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Date: Wed, 13 Sep 2000 17:26:33 -0500 There may be, but I don't know how,,, in the TSM 3.7 version the IP address shows up along with the node name in the log. You'll see it over and over again with every session started message. It may have showed up in the older versions and I just never noticed. Here's an example: 16:29:26 ANR0406I Session 172131 started for node TDCITD03 (AIX) (Tcp/Ip 149.183.181.203(33529)). -- From: Daniel Swan/TM[SMTP:[EMAIL PROTECTED]] Reply To: ADSM: Dist Stor Manager Sent: Wednesday, September 13, 2000 5:14 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Taylor, is there any way to tell server side what ADSM thinks is the IP of a node? -Original Message- From: Taylor, Damon M [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 4:05 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? When you start your scheduler the client contacts the Hostname specified in the TCPServeraddress field in the dsm.opt/sys. The ADSM server recognizes the node name which you specified in the NODEName field of the dsm.opt/sys and stores the contacting IP address. ADSM then has an IP address to associate with the node name. That's how the server knows what IP address to connect for the specified node... -- From: Sean English[SMTP:[EMAIL PROTECTED]] Reply To: ADSM: Dist Stor Manager Sent: Wednesday, September 13, 2000 3:41 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Daniel, Do you have the TCPClientaddress set to the IP address of the client server? This is located in the dsm.opt file (or dsm.sys) on the client machine. Regards, Sean M. English Distributed Support Services/ADSM IBM Global Services South, Charlotte, NC Good news is just life's way of keeping you off balance. Daniel Swan/TM [EMAIL PROTECTED]@VM.MARIST.EDU on 09/13/2000 04:28:38 PM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: How does ADSM Map nodenames to IP's? I have a nodename, prodwf01, that backs up successfully each day. However, the hostname 'prodwf01' isn't resolved by either DNS, nor does it exist in the host file. The client scheduler is set to 'prompted'. How the heck is ADSM getting in touch with prodwf01? How is the nodename resolving to an IP? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: How does ADSM Map nodenames to IP's?
Hi, if you use 3.7 then the SUMMARY table contains the IP address as well as the node name. Paul. From: "Taylor, Damon M" [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Date: Wed, 13 Sep 2000 17:26:33 -0500 There may be, but I don't know how,,, in the TSM 3.7 version the IP address shows up along with the node name in the log. You'll see it over and over again with every session started message. It may have showed up in the older versions and I just never noticed. Here's an example: 16:29:26 ANR0406I Session 172131 started for node TDCITD03 (AIX) (Tcp/Ip 149.183.181.203(33529)). -- From: Daniel Swan/TM[SMTP:[EMAIL PROTECTED]] Reply To: ADSM: Dist Stor Manager Sent: Wednesday, September 13, 2000 5:14 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Taylor, is there any way to tell server side what ADSM thinks is the IP of a node? -Original Message- From: Taylor, Damon M [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 4:05 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? When you start your scheduler the client contacts the Hostname specified in the TCPServeraddress field in the dsm.opt/sys. The ADSM server recognizes the node name which you specified in the NODEName field of the dsm.opt/sys and stores the contacting IP address. ADSM then has an IP address to associate with the node name. That's how the server knows what IP address to connect for the specified node... -- From: Sean English[SMTP:[EMAIL PROTECTED]] Reply To: ADSM: Dist Stor Manager Sent: Wednesday, September 13, 2000 3:41 PM To: [EMAIL PROTECTED] Subject: Re: How does ADSM Map nodenames to IP's? Daniel, Do you have the TCPClientaddress set to the IP address of the client server? This is located in the dsm.opt file (or dsm.sys) on the client machine. Regards, Sean M. English Distributed Support Services/ADSM IBM Global Services South, Charlotte, NC Good news is just life's way of keeping you off balance. Daniel Swan/TM [EMAIL PROTECTED]@VM.MARIST.EDU on 09/13/2000 04:28:38 PM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: How does ADSM Map nodenames to IP's? I have a nodename, prodwf01, that backs up successfully each day. However, the hostname 'prodwf01' isn't resolved by either DNS, nor does it exist in the host file. The client scheduler is set to 'prompted'. How the heck is ADSM getting in touch with prodwf01? How is the nodename resolving to an IP? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Re: I need delete virtual volumes...
Or you can use the WAIT=YES option on the delete command in a script, which will wait for the current command to run in the foreground before running the next. From: Matthias Hensel [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: I need delete virtual volumes... Date: Mon, 7 Aug 2000 09:40:17 +0200 Claudio, I know your problem, I had it before. You have no chance to delete them all together. You could write a shell-script with a loop that deletes the volumes. But be aware to put "sleep"-commands in between the deletes, otherwise the delete-commands may produce deadlock situations of the server. Take a look at the success of your space reclamation processes for this storagepool. They are likely to having failed with an error condition. Matthias Claudio Cofre Caro schrieb: Hi, i have moreless 3.500 references to non-existant virtual volumes in the ADSM DB that are no more useful. How can i delete all of them quickly (not one by one)? I have ADSM Server 3.1.2.40 on Win NT 4.0, and the volumes are Thanks in advance... Claudio Cofre Caro [EMAIL PROTECTED] Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Re: Server to Server reclamaiton vs move data
If your target server storage pool is a backup pool, then the reclaim on the virtual volumes will be built from the primary pool on the source server and sent over the network in only one direction (although sometimes, 1% of the time, it does pull some data across the network in both directions.) From: "Norback, Jan" [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Server to Server reclamaiton vs move data Date: Tue, 1 Aug 2000 16:54:34 +0200 Jack, I you work server-to-server all your reclaims will go from the remote to the local and back to the remote again thus passing your network twice! Same thing for move data. This, hopefully, should be nicer in a SAN environment but I have not seen that yet. Regards, Jan Norback Origin-IT (MS/DS/OSS Unix) VA-173, PO-box 218, 5600 MD Eindhoven, The Netherlands Groenewoudseweg 1 5621 BA Eindhoven, The Netherlands Email: [EMAIL PROTECTED] Tel: +31 (0)40-2780289 Mobile: +31 (0)6-25233507 Fax : +31 40 2783962 -Original Message- From: Palmadesso Jack [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 4:29 PM To: [EMAIL PROTECTED] Subject: Server to Server reclamaiton vs move data Boy sure is quiet in here lately. Maybe this can stir things up a bit ;) Correct me if I am wrong: I have 2 servers at remote sites that perform server to server db backups and copy storage pools over our WAN. Reclamation usually takes a really long time to complete. Especailly as I approach lower reclamation values. If I set reclamation for the server to server pool at 80 then I have to send at most 20% of each tape down over the WAN. DLT 4000s have 20/40 compression so I could send up to 5/10 gigs of data down the pipe for just for one volume!! That could take all day over the WAN! I am considering using "move data" instead. Again correct me if I am wrong please. When I issue a move data on a server to server volume that volume should be mounted in the remote library as well as another filling volume from that storage pool or just use a new scratch volume. Since these two volumes are mounted in the same library the amount of data that needs to be sent over the WAN is now minimal (I'm not sure about this) In this case the data would be moved much quicker freeing up my scratch volumes. Also communication over the WAN is now minimized because no files are being sent only ADSM DB communication is going on. I know I would need at least 2 mount points available to the storage pool. Can anybody enlighten me on this. Thanks for any help as always, Jack Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Re: Backing up client from ADSM Server
dsmc sel -subdir=y -tapeprompt=n nodename=NTWLAMEZE d:\...\dsm*.log Node Name: DEVELOPMENT Your nodename paramater should have a hyphen before it ( -nodename), here it is connecting as default, DEVELOPMENT, and attempting to backup a file called nodename=NTWLAMEZE. Directory-- 9 /u [Sent] Directory-- 512 /u/operator [Sent] ANS1092E No files matching search criteria were found These directories look like a unix machine's directories, but you want to back up a window's path/file. So, on an AIX node. This syntax will go into a script to be launched by a 3rd party batch scheduler, not by ADSM. is this scheduler sending the script to the right client? Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
