DB2 not connecting to TSM
Will one of you wonderful people that has worked with DB2 point me in the right direction? TSM Server 5.1.6.5 running on AIX 5.1. Client is 5.1.5.15 on AIX 5.2. Our DBA is trying to make his first backup from DB2 to TSM. The TSM client is installed and works fine. I don't see anything about error 2230 in the TSM client help. /home/pshcm1/sqllib/adsm is a link to /usr/opt/db2_08_01/adsm64. The API is 64bit. -Original Message- From: Robert Jans Sent: Wednesday, July 30, 2003 16:07 To: Kai Hintze Subject:TSM problem? Kai, I'm receiving an error when I try to use TSM to backup the databases on IBM51. Chris Williams from IBM mentioned that there was some specific patch/module/magic wand needed for DB2 V8 which we're using. Here's a dump of the error I received and the commands to run the backup. Can you assist at all? CONNECT TO PSHCM1; QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS; CONNECT RESET; BACKUP DATABASE PSHCM1 USE TSM OPEN 1 SESSIONS WITH 1 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING; CONNECT TO PSHCM1; UNQUIESCE DATABASE; CONNECT RESET; SQL2062N An error occurred while accessing media /home/pshcm1/sqllib/adsm/libtsm.a. Reason code: 2230. Explanation: An unexpected error occurred while accessing a device, file, TSM or the vendor shared library during the processing of a database utility. The following is a list of reason codes: 1 An attempt to initialize a device, file, TSM or the vendor shared library failed. 2 An attempt to terminate a device, file, TSM or the vendor shared library failed. other If you are using TSM, this is an error code returned by TSM. The utility stops processing. User Response: Ensure the device, file, TSM or vendor shared library used by the utility is available and resubmit the utility command. If the command is still unsuccessful, contact your technical service representative.
Re: TSM Backup Schedule
If you want different management classes you will have to create multiple nodes on the same box. Otherwise if you just change management class with the same node name then you keep rebinding the files to one MC, then the other. - Kai. -Original Message- From: Scott Kromarek [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 June 2003 1:08 PM To: [EMAIL PROTECTED] Subject: TSM Backup Schedule -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Scott Kromarek [EMAIL PROTECTED] Subject: TSM Backup Schedule -- - Can anyone tell me if its possible to select a management class other than the default for the Policy Domain when setting up a client backup schedule? We have a new Windows client which wants to back up one directory on weekdays, and another directory on Saturdays. I created a new Policy Domain, Policy Set, MC, and Backup Copy Group to handle the weekday backups. Can I create another MC and Backup Copy Group under the same Policy Domain for the Saturday backup, or do I need an entirely new Policy Domain? I've found how to specify a MC for an archive, but I can't find anything similar for backups. Thanks, Scott Scott A Kromarek Systems Software Specialist BIT - State of SD 700 E Broadway Pierre, SD 57501-2586 Phone 605-773-6351 Fax 605-773-4378
How many copies in copypool?
Greetings oh wise and varied *SM'ers! I have an internals question. I have a primary disk pool BACKUP_DISK, with a collocated primary tape pool BACKUP_TAPE that BACKUP_DISK spools to when it gets full (or at 16:30, whichever comes first :). I have enough disk that I seldom need to migrate data out of BACKUP_DISK during the night, but occasionally we have a really heavy day, and BACKUP_DISK goes over its threshold and migrates before its schedule. For disaster recovery I have a non-collocated tape copypool BACKUP_OFF. During the day our DRM script does a backup stg BACKUP_DISK BACKUP_OFF then backup stg BACKUP_TAPE BACKUP_OFF, in case we had a migration in the night. So far that is fairly straightforward, but now comes the tricky part If a long-running backup pushes BACKUP_DISK over its threshold after some of the files are sent from BACKUP_DISK to BACKUP_OFF, but before the backup from BACKUP_TAPE to BACKUP_OFF starts, then the files are there to be backed up to BACKUP_OFF *again* from BACKUP_TAPE. So the question is: Does TSM recognize that the files are already in BACKUP_OFF, or does it make another copy? The reason I am asking is that we are using LOTS of tapes, and management wants me to see if I can cut back on the burn rate. I know that tape to tape copy would be slower because I would have multiple input mounts per output tape, but I don't do the disk to offsite backup, but instead migrate, then tape to offsite backup then I know that the offsite pool only has one copy of all the files. Thanks for any insights. - Kai.
Re: HELP!!! EMERGENCY!!!
How are your disk pools? Full or still have room? What is your tape status? Do you have other communications problems? (Slow printing, slow terminals, slow FTP...) -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED] Sent: Friday, 04 April 2003 12:13 PM To: [EMAIL PROTECTED] Subject: HELP!!! EMERGENCY!!! -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Joni Moyer [EMAIL PROTECTED] Subject: HELP!!! EMERGENCY!!! -- - I am running TSM 4.1.5 on OS/390 2.10 I am getting calls from clients about slow backups, restores,etc. on TSM. I went out and looked and there are 100 sessions going for different clients, but they aren't ending. Some are in the IDLEW status, but a majority of them are in the run status. What should I look into? Thanks! Joni Moyer Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: Finding system objects to delete
Thanks for clearing that up. Can I trouble you with a couple more questions? 1) When I try to delete or rename the filespace by name most of the time I get a response that not such filespace exists. I have gotten somewhat better luck by renaming the filespace to something without spaces by using the FSID, then trying to delete the renamed space. But that doesn't always work either. 2) I frequently get lock errors trying to delete the system object file spaces. I have seen them occasionally before, but this is pretty much guaranteed to cause them, so severly that I have to cycle the TSM server to get things working again. Any suggestions how to avoid this? 03/13/03 16:09:00 ANR0538I A resource waiter has been aborted. 03/13/03 16:09:00 ANRD bfcreate.c(671): ThreadId95 Error 82 getting information for object 0.102099013. 03/13/03 16:09:00 ANRD imutil.c(6259): ThreadId95 Error 19 deleting dependent bitfile 0.102099013. 03/13/03 16:09:00 ANR0985I Process 59 for DELETE FILESPACE running in the BACKGROUND completed with completion state FAILURE a t 16:09:00. 03/13/03 16:09:40 ANR8810I Volume 810778 has been labeled in library ES. 03/13/03 16:10:00 ANR0538I A resource waiter has been aborted. 03/13/03 16:10:00 ANR1029W Migration process 55 terminated for storage pool AR_SHORT_DISK - lock conflict. Thanks, Kai. -Original Message- From: Prather, Wanda To: '[EMAIL PROTECTED]' Sent: 3/14/03 12:21 PM Subject: RE: Finding system objects to delete The SYSTEM OBJECT filespace is only created for Win2K systems, using at least the 4.1 backup client. The SYSTEM OBJECT filespace includes the registry, the COM+DB, the RSM data base, and other Win2K-only constructs. WinNT machines do back up the registry, but don't create a separate filespace, and don't have the dreaded system object bloat problem. You only have to worry about cleaning up the existing SYSTEM OBJECT filespaces. -Original Message- From: Kai Hintze [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 4:37 PM To: [EMAIL PROTECTED] Subject: Finding system objects to delete Oh wise and experienceds star-sum wizards! I crave the boon of a clarification: Summary: If I don't see a file system named SYSTEM OBJECT for a given node does that mean that we aren't backing up the system object on that box? Discussion: I want to clean up our TSM 4.2.1.6 server (AIX 4.3.3) before I migrate it to a different box (AIX 5.1.latest) and upgrade TSM to 5.reasonably_stable. Among other things, the database is getting much larger than we expected, so I suspect that I am victim of the dreaded system object bloat, given the level of TSM server I am running. I went back through the archives researching the topic delete system object. I found several references to rename/delete the SYSTEM OBJECT filespace. But only about 1 in 10 of our WinNT systems has a SYSTEM OBJECT filespace listed in the filespaces table. Does that mean that most of our windows servers don't back up their system object? That would be mixed news at this point, but before I can deal with it, I need to know for sure what I am dealing with. Thank you in advance for your help. - Kai.
Finding system objects to delete
Oh wise and experienceds star-sum wizards! I crave the boon of a clarification: Summary: If I don't see a file system named SYSTEM OBJECT for a given node does that mean that we aren't backing up the system object on that box? Discussion: I want to clean up our TSM 4.2.1.6 server (AIX 4.3.3) before I migrate it to a different box (AIX 5.1.latest) and upgrade TSM to 5.reasonably_stable. Among other things, the database is getting much larger than we expected, so I suspect that I am victim of the dreaded system object bloat, given the level of TSM server I am running. I went back through the archives researching the topic delete system object. I found several references to rename/delete the SYSTEM OBJECT filespace. But only about 1 in 10 of our WinNT systems has a SYSTEM OBJECT filespace listed in the filespaces table. Does that mean that most of our windows servers don't back up their system object? That would be mixed news at this point, but before I can deal with it, I need to know for sure what I am dealing with. Thank you in advance for your help. - Kai.
Re: progressive backup vs. full + incremental
TSM can give very quick restores, but beware fragmentation in uncollocated tape pools. We had to rebuild a small (350GB) unix server last year that required upward of 300 tape mounts, and finding a single file in the middle of each tape. It took days. Since then I have gotten funding to buy enough tapes for collocation, and last week at 200GB restore took about 45 minutes. - Kai. -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, 05 March 2003 7:21 AM To: [EMAIL PROTECTED] Subject: progressive backup vs. full + incremental -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Joni Moyer [EMAIL PROTECTED] Subject: progressive backup vs. full + incremental -- - Hello everyone! I was wondering why the full + incremental would result in a longer restore time than the progressive backup methodology? From several co-workers point of view they thought that it would be quicker on the full + incremental because you wouldn't have to go back to the beginning backups of the file and restore all of the incrementals, you would just go back to the most recent full backup and apply the incrementals after that point. When I went to explain the reasoning behind this, I had some problems understanding the concept myself, so I was hoping someone could explain both methods and why they differ in restore time and why progressive is better than the full + incremental. Thank you so much for any help you can lend on this matter! Joni Moyer Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: ACSLS or Native TSM manager
We used to have an STK 9710 that we let TSM manage because it was dedicated to TSM. But we kept having to shut down the library so we could open it to fix problems (at 30 to 60 minutes downtime) that I can do in software on my IBM silos. STK told me that I needed to buy ACSLS to get software control of the robot. When it worked it worked well. But fixing problems is much easier with control software. - Kai. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gretchen L. Thiele Sent: Wednesday, February 26, 2003 12:42 PM To: [EMAIL PROTECTED] Subject: Re: ACSLS or Native TSM manager Dameon White wrote: We just bought a used STK L700 with 4 DLT7000 drives. We have TSM 5.1.5.2 on AIX and I am confused as to why/if I would need to use ACSLS to manage the library? Does ACSLS You don't need ACSLS for an L700. I found that I could do everything I wanted without it (I do have ACSLS managing a 'regular' silo and two L700s without it). My L700s are dedicated to TSM - if yours are not, you probably could benefit from ACSLS. Gretchen Thiele Princeton University
Re: Exclude options
Hmmm..., I pulled exclude.fs out of the documentation, but it was 4.2 doco, so I would have thought it would work. Do you have anything in you dsmerror.log about the excludes? What does dsmc q inclexcl tell you? exclude /.../u01/.../* will certainly avoid backing up the files under /u01, but it will still examine each file in the file system to see if it should be backed up. The trees I want to avoid generally are structured /db /db/database1 /db/database1/d01 /db/database1/d02 /db/database1/d03 /db/database2 /db/database2/d01 /db/database2/d02 /db/database2/d03 where each d0? is a separate file system, and new branches can be added without warning. That being the case I generally exclude.dir /db. That way I get notices for each file system that it is excluded but the client doesn't spend lots of time traversing the trees. And I don't get burned if someone adds another filesystem to the tree and forgets to tell me. Luck! - Kai. The reason most people fail instead of succeed is that they trade what they want most for what they want at the moment. Don't make failure a priority! -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Monday, 27 January 2003 7:40 AM To: [EMAIL PROTECTED] Subject: Re: Exclude options -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Andrews, Bert A [EMAIL PROTECTED] Subject: Re: Exclude options -- - Kai, We are 4.1 and it looks the /.../u01/.../* works for this version. If we use the exclude.fs /u02/* this will still backup everything. I think that if we upgrade to a higher level like version 5 maybe this will go away. Any Suggestions? Thanks Bert Andrews -Original Message- From: Kai Hintze [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 5:51 PM To: [EMAIL PROTECTED] Subject: Re: Exclude options You don't say which version of TSM you are using, but if it is anywhere near recent, and you want to exclude the entire file system then I would say exclude.fs /u01 exclude.fs /u02 ... Have fun! Kai. Nobody ever lay on their deathbed saying, 'Gee! I wish I had spent more time at the office.' -- Linda Ellerbee -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 January 2003 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Exclude options -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Andrews, Bert A [EMAIL PROTECTED] Subject: Re: Exclude options -- - is this the right syntax for excluding a filesystem? exclude/.../unix/../ exclude/.../core/../ exclude/.../.SpaceMan/.../* exclude.fs /.../u01/.../* exclude.fs /.../u02/.../* exclude.fs /.../u03/.../ exclude.fs /.../u04/.../* OR should we use the: exclude.dir /u01/* exclude.dir /u02/* exclude.dir /u03/* exclude.dir /u04/* The mounted filesystems are : /dev/u01lv 15466496 10011152 36% 860 1% /u01 /dev/u02lv 15597568 13718904 13% 2498 2% /u02 /dev/u03lv 15597568 5892928 63% 478 1% /u03 /dev/u04lv 15466496 8779884 44% 6218 3% /u04
Scalar 24 remotely
1) Can you run LAN-free when your SAN and tape drives are in one location and your TSM server is in another location? We have our main data center with the big TSM server in Boise, Idaho. We have a smaller data center with a small SAN in Phoenix, AZ, about 2000km away. The Phoenix data center has its own SAN that is just a little too large to back up across the WAN. We're wondering if we can avoid having to buy a separate TSM server and just put a small library in Phoenix that would run LAN-free, with IP robot controller that talks to the TSM server in Boise. Conceptually, can it work? 2) What do you know about/think of Scalar 24 libraries, specifically for LAN-free work? The small library we are looking at is a Scalar 24 from Adic. I've never actually seen one, but the brochures talk about LAN-free connections. If the remote use concept is possible, will this library work? Thanks, Kai.
Re: Exclude options
You don't say which version of TSM you are using, but if it is anywhere near recent, and you want to exclude the entire file system then I would say exclude.fs /u01 exclude.fs /u02 ... Have fun! Kai. Nobody ever lay on their deathbed saying, 'Gee! I wish I had spent more time at the office.' -- Linda Ellerbee -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 January 2003 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Exclude options -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Andrews, Bert A [EMAIL PROTECTED] Subject: Re: Exclude options -- - is this the right syntax for excluding a filesystem? exclude/.../unix/../ exclude/.../core/../ exclude/.../.SpaceMan/.../* exclude.fs /.../u01/.../* exclude.fs /.../u02/.../* exclude.fs /.../u03/.../ exclude.fs /.../u04/.../* OR should we use the: exclude.dir /u01/* exclude.dir /u02/* exclude.dir /u03/* exclude.dir /u04/* The mounted filesystems are : /dev/u01lv 15466496 10011152 36% 860 1% /u01 /dev/u02lv 15597568 13718904 13% 2498 2% /u02 /dev/u03lv 15597568 5892928 63% 478 1% /u03 /dev/u04lv 15466496 8779884 44% 6218 3% /u04
Re: Client password problem
You may need to delete the TSM.PWD file on the client. On aix433 with TSM client version 4.2.2.1 the file name is /etc/security/adsm/TSM.PWD. Have fun! -Kai. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Hunley, Ike Sent: Tuesday, January 07, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: Client password problem I moved server backups to a different MVS TSM. Now each time the server attempts to access TSM I get the dreaded 137 authentication failure. I've added password access generate to DSM.SYS and recycled the TSM scheduler several times. What else can I do to correct this? Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: [Very OT] Can we cut out the me, toos
Hey guys, lighten up! And read what he said. Those of us forced to use poorly designed mailers might find it easier to have both addresses in the Reply-To field. Personally, I disagree, but I will do so politely. (And I can speak with authority about poorly designed mailers. I am forced not only to use Outlook, but some bright person disabled Reply All so that in my office we _have_ to cut and paste to carry out a group conversation.) Yes, people should think about who they are sending to. Yes, education might help, but awareness helps more. But a good mail client would make it easier. BTW, netiquette never was what it used to be (or at least it hasn't been since 1979). - Kai. Do just once what others say you can't do, and you will never pay attention to their limitations again. -- James R. Cook -Original Message- From: Remco Post [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 December 2002 4:39 AM To: [EMAIL PROTECTED] Subject: [Very OT] Re: Can we cut out the me, toos (was Re: TSM Presentation) -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Remco Post [EMAIL PROTECTED] Subject: [Very OT] Re: Can we cut out the me, toos (was Re: TSM Presentation) -- - On Tue, 17 Dec 2002 10:45:05 +0100 Gerhard Rentschler [EMAIL PROTECTED] wrote: Hello, probably a change in the listserv config of this mailing list may help. Each mail I get from this list has the list as reply address. For replying to the sender you have to cut the mail address from the mail and do a forward. This is the case at least with Outlook. It might help a little bit if with reply to all I could get both addresses, the list's and the sender's address. If I want to reply only to the sender, I could remove the list address. Best regards Gerhard So now the list is at fault when people choose to use e-mail clients that cannot behave. errr. Probably, people should start thinking about to who they send their emails, and what they send. Apart from me-toos, annoying behaviour includes the out-of-office autoreplys (perfreably to the list ;-) and the ~20 line standard disclaimer, which in itself is complete nonsense on any mailinglist, and probably even in normal person-to-person e-mail. Netiquette isn't what it used to be... :-)
Re: Linux Client
Personally, I would go to ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/ client/v5r1/Linux/Linux86/v515/ and download the client. - Kai. Nothing is impossible. Some things are just less likely than others. -- Jonathan Winters -Original Message- From: Anderson, Michael - HMIS [mailto:[EMAIL PROTECTED]] Sent: Monday, 09 December 2002 12:11 PM To: [EMAIL PROTECTED] Subject: Linux Client -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Anderson, Michael - HMIS [EMAIL PROTECTED] Subject: Linux Client -- - We have a new server going in and it is running Linux Red hat 7.2. I know I need a Linux client but when I called our vendor, he said he did not believe there is such a client for the red hat. My question for the list is this a true fact, then what do I do. Or is there a Linux client that will work for this version. Any suggestions would be appreciated Mike Anderson [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: include/exclude syntax question for TSM Unix Client
exclude.dir trumps the include.file. If you exclude a directory TSM won't glance at any files under that directory even if you explicitly tell it to do so. You will have to either exclude all the directories but that one exclude.dir /u[0-2,4-9][0-9] exclude.dir /u[3][0-7,9] Or you might look at a domain statement to limit your backups. Have fun! Kai. All the world's a stage and most of us are desperately unrehearsed. -Sean O'Casey, playwright (1880-1964) -Original Message- From: Peppers, Holly [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 04 December 2002 2:53 PM To: [EMAIL PROTECTED] Subject: include/exclude syntax question for TSM Unix Client Hi All, I was hoping I could get some feedback on the syntax of a set of files that I am trying to include during backup. Currently, my exclude.list file looks like so: exclude.dir /u[0-9][0-9] include.file /u38/exp/.../*.* I'm trying to get TSM to backup all the files and subdirs under /u38/exp, but still exclude all the the other u* directories and files. I must be doing something wrong, as TSM is still excluding /u38/exp. I've tried a few different combinations, but with no luck. Does anyone have any suggestions? Thanks. Holly L. Peppers BCBSFL Cpacity Planning Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: Can backup throughput be deliberately throttled on a per node basis.
I've had to throttle some of mine as well. First I set Resource Utilization to 1. Then if still more is needed I degrade the network. Bizarre, isn't it? - Kai. What we observe is not nature itself, but nature exposed to our method of questioning. -- Werner Karl Heisenberg -Original Message- From: Eric Winters [mailto:[EMAIL PROTECTED]] Sent: Monday, 02 December 2002 3:46 PM To: [EMAIL PROTECTED] Subject: Can backup throughput be deliberately throttled on a per node basis. I have an unusual situation where we are interested in deliberately throttling network performance, that's right, we might want to slow down backups from nodes and from server to server. Furthermore it has been suggested to me that this capability is available in TSM. Apart from tweaking the communication options to impair client and server communication performance (breaks my heart to consider doing it), is there something specificly designed to restrict bandwidth usage within TSM? I appreciate the feedback, Regards, Eric Winters Sydney Australia
Re: Permissions change after a retrieve
find /start/path -user=olduser -exec /usr/bin/chown olduser newuser {} \; root has to run this because only root can chown. You might want to run find /start/path -user=olduser -ls just to make sure you catch all the files you want and only the files you want first. Have fun! Kai. He who angers you conquers you. -- Elizabeth Kenny -Original Message- From: Rob Hefty [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 November 2002 10:26 AM To: [EMAIL PROTECTED] Subject: Permissions change after a retrieve Hello all, Server version: 4.2.2 Aixnode1: TSM - 4.1.0 ,OS - 4.3.3.06 Aixnode2: TSM - 4.2.2 ,OS - 5.1.02 We recently retrieved a file from Aixnode1 to Aixnode2 via the client gui. The two nodes are not exactly the same in users groups in that the owner of the original file doesn't exist on Aixnode2 and will not. Is there any way to specify a user in the retrieval process so we don't have to go through every object and change ownership on it? One idea I had was to create these users on Aixnode2 just for the purpose of the retrieval and then if there was a command to change ownership on ALL files owned by this user to another we could then eliminate that user. Unfortunately my Aix background is quite limited. Any help is appreciated! Thanks. Rob
Re: How to move datacentres.
Steve, I didn't notice that anyone addressed this part of your mail. I found a bunch of good stuff on Google with the string 3494 autoloader AIX. The day I ran it the 4th item down was most useful to me, but that may or may not be its location today. :) - Kai. -Original Message- From: Steve Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 20 November 2002 7:40 PM To: [EMAIL PROTECTED] Subject: How to move datacentres. snip Can anyone point me at a utility that can do this or suggest a different ap= proach to the problem? Also I'd love some real world information on how to = set up the 3494 autoloader mode and use it from AIX, just to be sure that I= 've got that bit right.=20 TIA Steve Harris Unix, Backup and Storage Admin Queensland Health, Brisbane Australia
Re: Anyone remember how to assign category # using mtlib ?
I ejected a volume yesterday with this string: mtlib -l /dev/lmcp0 -C -tFF10 -V 800791 -Original Message- From: Zig Zag [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 November 2002 12:47 PM To: [EMAIL PROTECTED] Subject: Anyone remember how to assign category # using mtlib ? I keep getting this error: root@buffy 174 [/root] mtlib -l /dev/lmcp0 -r -#190 mtlib: A host id must be specified. been a few years.
Re: Activity Log
I run a cron job every midnight that dumps the previous day's actlog, status, and a few other interesting figures to a text file. I keep two year's worth. As David said, they are useful in tracking down problems. - Kai. A life spent making mistakes is not only more honorable, but more useful than a life spent doing nothing. -- George Bernard Shaw -Original Message- From: David Longo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 20 November 2002 7:52 AM To: [EMAIL PROTECTED] Subject: Re: Activity Log -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: David Longo [EMAIL PROTECTED] Subject: Re: Activity Log -- - The actlog is another table in the TSM DB. Do a q status and Activity Log Retention Period will show how many days you are keeping. I would keep a minimum of 7 days, I keep 30 days. It can be very useful in tracking down problems. To change use set actlogretention. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] [EMAIL PROTECTED] 11/20/02 09:44AM Good Morning TSM'ers, Can someone tell me where the activity log maps to on the AIX side. I would like to expand the duration of the log, but I need to know how much is being utilized currently before I do that. Thanks in advance -kane MMS health-first.org made the following annotations on 11/20/2002 09:53:23 AM -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
more on moving atl
AIX 4.3.3, TSM 4.2 I currently have a 3494 ATL that I share with the mainframe. 3 3590K drives are fibre attached to my aix. The ATL control is lan attached. They want to move my tape drives and all my tapes to a new ATL. As best I can tell if I just edit /etc/ibmatl.conf to use the new IP address AIX and TSM should think nothing has changed since the drives are physically moving too. To move the tapes I think I need to move media the volumes to offsite. With the remove=yes option it should eject the tapes. Then I check them in again to the new library. Is there anything else I need to do? Thanks, Kai.
Re: more on moving atl
Of course it can't be quite that simple. move media doesn't like to work with tapes in Pending status. I guess that makes sense, the original reason for move media is to hold mountable tapes outside the library, and pending tapes aren't really mountable. I guess I will just check them out, then check them back in - Kai. The entire physical universe, including this product, may one day collapse back into an infinitesimally small space. Should another universe subsequently and spontaneously re-emerge, the existence of this message in that universe cannot be guaranteed. -Original Message- From: Kai Hintze To: [EMAIL PROTECTED] Sent: 11/15/02 11:44 AM Subject: more on moving atl AIX 4.3.3, TSM 4.2 I currently have a 3494 ATL that I share with the mainframe. 3 3590K drives are fibre attached to my aix. The ATL control is lan attached. They want to move my tape drives and all my tapes to a new ATL. As best I can tell if I just edit /etc/ibmatl.conf to use the new IP address AIX and TSM should think nothing has changed since the drives are physically moving too. To move the tapes I think I need to move media the volumes to offsite. With the remove=yes option it should eject the tapes. Then I check them in again to the new library. Is there anything else I need to do? Thanks, Kai.
moving ATL's
Greetings, oh wiseness of *SM! We are about to move all my 3590 tapes from one ATL to another one. It looks to me like I can change the definition in /etc/ibmatl.conf and leave the library defined as it is in TSM. True? Thanks, Kai.
not like underscore
Oh wiseness of wizards of tsm-flavored SQL, how do you match an underscore? I need to find node names that do not contain an underscore ('_'). I thought that would be no problem, just select node_name from nodes where node_name not like '%_%', but that doesn't find anything. A bit more research revealed that '_' is the single character match, so that expression parsed out to something like select node_names without any characters. Not what I wanted at all. I've played with a couple of things to escape the underscore, but I haven't found anything that works yet. I thought I remembered reading something about match and wildcards in this list, but all I can find in the archives is the mention that underscore is the single character wildcard. If I can't find an answer fairly quickly I will just dump everything to a file and parse out the results with perl or something, but I really think what I need to do could be done easily in SQL if I could just parse out the underscore. I thank you in advance for any light you could shed on my difficulty. - Kai.
Re: not like underscore
Unfortunately getting the node names is only the first part. Where I am really heading is something like: select node_name, sum(capacity) as MB available, sum(capacity * pct_util / 100) as MB used from filespaces where (cast(days(current_date) - days(backup_end)) as integer 5) and node_name not like '%_%' group by node_name But first I have to find out how to exclude node names with underscores. - Kai. -Original Message- From: Cook, Dwight E To: '[EMAIL PROTECTED]' Sent: 11/12/02 11:47 AM Subject: RE: not like underscore Well, q node *_* works...??? Dwight -Original Message- From: Kai Hintze [mailto:kai.hintze;ALBERTSONS.COM] Sent: Tuesday, November 12, 2002 12:16 PM To: [EMAIL PROTECTED] Subject: not like underscore Oh wiseness of wizards of tsm-flavored SQL, how do you match an underscore? I need to find node names that do not contain an underscore ('_'). I thought that would be no problem, just select node_name from nodes where node_name not like '%_%', but that doesn't find anything. A bit more research revealed that '_' is the single character match, so that expression parsed out to something like select node_names without any characters. Not what I wanted at all. I've played with a couple of things to escape the underscore, but I haven't found anything that works yet. I thought I remembered reading something about match and wildcards in this list, but all I can find in the archives is the mention that underscore is the single character wildcard. If I can't find an answer fairly quickly I will just dump everything to a file and parse out the results with perl or something, but I really think what I need to do could be done easily in SQL if I could just parse out the underscore. I thank you in advance for any light you could shed on my difficulty. - Kai.
quoting question
Greetings Oh Gurus of TSMness, I have a question with quotes in a script I am trying to define. This works: tsm: TSMESdefine script tapeuse select v2.stgpool_name, count(*) as Vols_Used, (select s1.maxscratch from stgpools s1 where s1.devclass='3590K' and s1.stgpool_name=v2.stgpool_name) as MaxScratch from volumes v2 where v2.devclass_name='3590K' group by v2.stgpool_name descr='Tape pool utilization' ANR1454I DEFINE SCRIPT: Command script TAPEUSE defined. tsm: TSMESrun tapeuse STGPOOL_NAME VOLS_USED MAXSCRATCH -- --- --- AR_LONG_OFF 1 40 AR_LONG_TAPE 3 40 AR_SHORT_OFF34 50 AR_SHORT_TAPE 37 50 BACKUP_OFF 148 150 BACKUP_TAPE211 225 STATIC_OFF 8 40 STATIC_TAPE 33 40 ANR1462I RUN: Command script TAPEUSE completed successfully. /quote But Vols_Used and MaxScratch come out upper case. This works and preserves the case: tkxh05aibm41:/home/tkxh05a dsmadmc -id=my -pass=mypass select v2.stgpool_name, count(*) as \Vols Used\, (select s1.maxscratch from stgpools s1 where s1.devclass='3590K' and s1.stgpool_name=v2.stgpool_name) as \MaxScratch\ from volumes v2 where v2.devclass_name='3590K' group by v2.stgpool_name Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSMES: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 11/08/02 12:20:55 Last access: 11/08/02 12:18:28 ANS8000I Server command: 'select v2.stgpool_name, count(*) as Vols Used , (select s1.maxscratch from stgpools s1 where s1.devclass ='3590K' and s1.stgpool_name=v2.stgpool_name) as MaxScratch from volumes v2 where v2.devclass_name='3590K' group by v2.stgpool_name' STGPOOL_NAME Vols Used MaxScratch -- --- --- AR_LONG_OFF 1 40 AR_LONG_TAPE 3 40 AR_SHORT_OFF34 50 AR_SHORT_TAPE 37 50 BACKUP_OFF 149 150 BACKUP_TAPE211 225 STATIC_OFF 8 40 STATIC_TAPE 33 40 ANS8002I Highest return code was 0. tkxh05aibm41:/home/tkxh05a /quote But I have to run it from a unix command line. Fortunately I can pull it from my history, but I can't share it easily. This acts like it is going to work, but when I try to run it, it fails: tkxh05aibm41:/home/tkxh05a dsmadmc -id=me -pass=mypass define script tapeuse \select v2.stgpool_name, count(*) as 'Vols Used', (select s1.maxscratch from stgpools s1 where s1.devclass='3590K' and s1.stgpool_name=v2.stgpool_name) as 'MaxScratch' from volumes v2 where v2.devclass_name='3590K' group by v2.stgpool_name\ descr='Show tape pool usage' Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSMES: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 11/08/02 12:27:50 Last access: 11/08/02 12:18:28 ANS8000I Server command: 'define script tapeuse select v2.stgpool_name, count(*) as 'Vols Used', (select s1.maxscratch from stgpool s s1 where s1.devclass='3590K' and s1.stgpool_name=v2.stgpool_name) as 'MaxScratch' from volumes v2 where v2.devclass_name='3590K' g roup by v2.stgpool_name descr='Show tape pool usage'' ANR1454I DEFINE SCRIPT: Command script TAPEUSE defined. ANS8002I Highest return code was 0. tkxh05aibm41:/home/tkxh05a dsmadmc -id=me -pass=mypass run tapeuse Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSMES: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 11/08/02 12:30:13 Last access: 11/08/02 12:18:28 ANS8000I Server command: 'run tapeuse' ANR2906E Unexpected SQL literal token - 'Vols Used'. | V.. select v2.stgpool_name, count(*) as 'Vols Used', (select s1.max ANR1463E RUN: Command script TAPEUSE completed in error. ANS8001I Return code 4. ANS8002I Highest return code was 4. tkxh05aibm41:/home/tkxh05a /quote Trying to type the same thing inside dsmadmc fails in the same way: tsm: TSMESdefine script tapeuse select v2.stgpool_name, count(*) as 'Vols Used', (select s1.maxscratch from stgpools s1 where s1 .devclass='3590K' and
Re: description indicator of private volumes
Off-hand, if the volume was written outside TSM then I wouldn't check it into TSM. Do you have a particular requirement that TSM manage ALL your tapes? - Kai. -Original Message- From: Marcel J.E. Mol [mailto:marcel;mesa.nl] Sent: Wednesday, 30 October 2002 11:49 AM To: [EMAIL PROTECTED] Subject: Re: description indicator of private volumes On Wed, Oct 30, 2002 at 08:17:33AM -0800, Joshua Bassi wrote: Unfortunately you cannot change the last-use column - this is strictly controlled by the TSM server. Is there perhaps a different way to recognise private volumes within TSM that are written to outside TSM? -Marcel -- Joshua S. Bassi -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L;VM.MARIST.EDU] On Behalf Of Marcel J.E. Mol Sent: Wednesday, October 30, 2002 1:39 AM To: [EMAIL PROTECTED] Subject: description indicator of private volumes Hello, I want to create a few private volumes in TSM for storing mksysb. To make it clear from within TSM that these volumes are used in this way I'd like to add some description for these volumes. I was thinking of uses the 'last_use' field in the 'q libvol' output (e.g the libvolumes table). So the question is: How can I change the 'last_use' column? -Marcel
Re: adsm.org unusable
When I tried this last Friday I got the archives all right, in a middle column with fixed width. Since I was at a satellite location with IE 5.0, and VGA--that's right, 640x480--the middle column was _way_ too thin. There was a scroll bar to let me shift back and forth--at the bottom of the message, so it was usually a screen below where I was trying to read. On the other hand, it does look good today with IE 5.5 and 1280x1024. - Kai. -Original Message- From: Seay, Paul [mailto:seay_pd;NAPTHEON.COM] Sent: Thursday, 24 October 2002 8:08 PM To: [EMAIL PROTECTED] Subject: Re: adsm.org unusable -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Seay, Paul [EMAIL PROTECTED] Subject: Re: adsm.org unusable -- - I posted the information on this the other day. You do not have to login. Just select the ADSM-L archives in that left bar area. It will take you to the search engine area. I have found that Netscape 4.76 does not work with this site. However, search.adsm.org does look like a better choice. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Nelson, Doug [mailto:DNelson;CHITTENDEN.COM] Sent: Thursday, October 24, 2002 8:15 PM To: [EMAIL PROTECTED] Subject: Re: adsm.org unusable Try http://search.adsm.org/ it works for me. I agree about the home page (adsm.org). Douglas C. Nelson Distributed Computing Consultant Alltel Information Services Chittenden Data Center 2 Burlington Square Burlington, Vt. 05401 802-660-2336 -Original Message- From: Kai Hintze [mailto:kai.hintze;ALBERTSONS.COM] Sent: Thursday, October 24, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: adsm.org unusable What happened to adsm.org? I tried to go and look for something in the archives but they weren't there! Instead the site was some funky discussion board with several columns. The meat of the board was the middle column. But the column was too narrow so I couldn't see an entire message without scrolling left and right, but the scroll bar was two screens below the message so I couldn't ever read an entire message. The right hand column was a poll that didn't let me participate. The left hand column invited me to log in, and had numerous resource lists--one of which was the archives, but I STILL CAN'T READ THEM BECAUSE THE COLUMN IS TOO NARROW! And I DON'T want yet another place to log in. Please, _please_, PLEASE give me back the archives. - Kai
Re: Monitor retrieving
What sort of monitoring are you trying to do? You can see current activity on the server with dsmadmc -console. You can see what nodes have sessions running with dsmadmc q ses. You can see what has run recently with dsmadmc q actlog. The client job should return success or failure to the client. - Kai. PS, Jiang, my attempt to reply directly to you bounced with this message: Illegal address specified as host: mail.nethouston.com -Original Message- From: Tao Jiang [mailto:tjiang;cobantech.com] Sent: Monday, 28 October 2002 11:14 AM To: [EMAIL PROTECTED] Subject: Monitor retrieving -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Tao Jiang [EMAIL PROTECTED] Subject: Monitor retrieving -- - Hi, Gurus, I issue a script command for retrieving to TSM, how can I monitor if the retrieving successed, failed, or is processing from a query of scripts? It seems the retrieving job is not written to PROCESS table. My TSM is 5.1.1/Win2k NT. Thanks for any informaiton. Tao Jiang Coban Research Technologies www.cobantech.com 713-271-7888 ext. 207
adsm.org unusable
What happened to adsm.org? I tried to go and look for something in the archives but they weren't there! Instead the site was some funky discussion board with several columns. The meat of the board was the middle column. But the column was too narrow so I couldn't see an entire message without scrolling left and right, but the scroll bar was two screens below the message so I couldn't ever read an entire message. The right hand column was a poll that didn't let me participate. The left hand column invited me to log in, and had numerous resource lists--one of which was the archives, but I STILL CAN'T READ THEM BECAUSE THE COLUMN IS TOO NARROW! And I DON'T want yet another place to log in. Please, _please_, PLEASE give me back the archives. - Kai
I think it must be something in the environment
I installed the latest TSM client today on our new SunFire server. I can use TSM just fine as root, but I can't use it as myself. I looked in adsm-l archives for clues and found the suggestion that perhaps I need to export LANG=en_US. But that didn't help. As best I can tell I have the same environment as root for LANG (nothing set) and TSM. But something is different! I have two problems running as myself: 1) ANS0101E NLInit: Unable to open message repository '/opt/tivoli/tsm/client/ba/bin/en_US/dsmclientV3.cat'. But the file does exist, I can read it, and it has content. and 2) ANS1503E Valid password not available for server 'TSMES'. The administrator for your system must run TSM and enter the password to store it locally. But I have run dsmc as root and it seems to have stored the password fine--as long as I am root Help please! Thanks, Kai. rootsun13 # uname -a SunOS sun13 5.8 Generic_108528-16 sun4u sparc SUNW,Sun-Fire rootsun13 # env | grep DSM DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm.opt DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSMI_LOG=/var/tsm_logs DSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.opt DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_LOG=/var/tsm_logs rootsun13 # ^D tkxh05asun13:/home/tkxh05a env | grep DSM DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm.opt DSM_LOG=/home/tkxh05a DSMI_LOG=/home/tkxh05a DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.opt DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 tkxh05asun13:/home/tkxh05a dsmc q ses Tivoli Storage Manager Command Line Backup Client Interface - Version 4, Release 2, Level 3.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Node Name: SUN13 ANS0101E NLInit: Unable to open message repository '/opt/tivoli/tsm/client/ba/bin/en_US/dsmclientV3.cat'. ANS1503E Valid password not available for server 'TSMES'. The administrator for your system must run TSM and enter the password to store it locally. tkxh05asun13:/home/tkxh05a export LANG=en_US tkxh05asun13:/home/tkxh05a dsmc q ses Tivoli Storage Manager Command Line Backup Client Interface - Version 4, Release 2, Level 3.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Node Name: SUN13 ANS0101E NLInit: Unable to open message repository 'US/dsmclientV3.cat/en_US/dsmclientV3.cat'. ANS1503E Valid password not available for server 'TSMES'. The administrator for your system must run TSM and enter the password to store it locally. tkxh05asun13:/home/tkxh05a su - rootsun13 # dsmc q ses Tivoli Storage Manager Command Line Backup Client Interface - Version 4, Release 2, Level 3.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Node Name: SUN13 Session established with server TSMES: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Data compression forced on by the server Server date/time: 10/24/02 18:31:09 Last access: 10/24/02 18:13:34 TSM Server Connection Information Server Name.: TSMES Server Type.: AIX-RS/6000 Server Version..: Ver. 4, Rel. 2, Lev. 2.5 Last Access Date: 10/24/02 18:13:34 Delete Backup Files.: Yes Delete Archive Files: Yes Node Name...: SUN13 User Name...: root rootsun13 #
Re: Macros
I push the problem back a level and keep the admin passwords in a reversibly encrypted file. Then I can go and look up the password for the administrator (based on unix id) running the script. - Kai. -Original Message- From: Roger Deschner [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 October 2002 11:33 PM To: [EMAIL PROTECTED] Subject: Re: Macros -- Information from the mail header --- Sender: ADSM: Dist Stor Manager [EMAIL PROTECTED] Poster: Roger Deschner [EMAIL PROTECTED] Subject: Re: Macros -- - The big advantage of ITSM Server Scripts over OS Shell Scripts (whether Unix shell, CMS EXEC, or whatever) is passwords. With a Server Script, you are not execuring dsmadmc for each command - it is done form within an administrator session. Authentication has already been performed, so admin ids and passwords are simply not involved. However, for an OS script that issues the dsmadmc command for each ITSM command, you've got to put an all-powerful ITSM admin id and password on the command line, in clear text. This is a big security hazard. Has anyone figured out a way around this? Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] Give a man a computer program and you give him a headache, but teach him to program computers and you give him the power to create headaches for others for the rest of his life. -- R. B. Forest On Thu, 10 Oct 2002, Alex Paschal wrote: Well, I'll assume you mean TSM server scripts instead of shell scripts. Macros are really useful for multiple one time commands, like generating and executing multiple commands where you don't want to have to answer Yes/No for each command (move datas are a good example). Server scripts are more useful for more general scheduled tasks. Quite frankly, I have never used server scripts. If I have to do something complicated enough to use variable substitution and logic, I use cron'd shell or perl scripts for my management instead. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 12:04 PM To: [EMAIL PROTECTED] Subject: Macros Why would one use macros instead of a server script? Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone or directly reply to the original message(s) sent. Thank you.
Linux No domain available
Greetings oh Guru's of TSM! My first linux client complains that there is No domain available when I try to run your basic incremental. The same server domain works fine on other systems. I looked at the ADSM-L archives and found a clue that Linux may not have a default domain, so I tried to set it, but I'm still not having any luck. I have tried a domain statement in both dsm.opt and dsm.sys but neither worked. According to the manual, a file specification trumps a domain statement, and sure enough dsmc incr / -subdir=yes works. So it is a problem with the client domain. What am I overlooking? TIA! - Kai. [root@mylinux bin]# uname -a Linux mylinux 2.4.18-3smp #1 SMP Thu Apr 18 07:27:31 EDT 2002 i686 unknown [root@mylinx bin]# dsmc incr Tivoli Storage Manager Command Line Backup Client Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Node Name: MYLINIX Session established with server TSMAA: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 09/19/2002 13:26:30 Last access: 09/19/2002 13:05:21 ANS1149E No domain available for incremental backup [root@mylinux bin]# cat dsm.opt Servername tsmaa tapeprompt no domain all-local *virtualnodeclient [root@mylinux bin]# more dsm.sys SErvername tsmaa COMMmethod TCPIP TCPSERVERADDRESS tsmaa TXNBYTE8192 compressionoff nodename mylinux domain all-local changingretries 1 inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl maxcmdretries8 retryperiod 15 schedlogname /var/adm/schedule.log queryschedperiod 1 schedmodeprompted passwordaccess generate schedlogretention10 d mailprog /usr/bin/mail root txnbytelimit 25600 tcpbuffsize 512 tcpwindowsize640 largecommbuffers yes resourceutilization 6 dirmcstatic ## and in case it really is the server domain [root@mylinux bin]# dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Enter your user id: me Enter your password: Session established with server TSMAA: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 09/19/2002 13:13:02 Last access: 09/19/2002 09:27:13 tsm: TSMAAq node mylinux f=d Node Name: mylinux Platform: Linux86 Client OS Level: 2.4.18-3s Client Version: Version 4, Release 2, Level 2.1 Policy Domain Name: AA_DOMAIN Last Access Date/Time: 09/19/2002 13:05:21 Days Since Last Access: 1 Password Set Date/Time: 09/16/2002 17:22:08 Days Since Password Set: 3 Invalid Sign-on Count: 0 Locked?: No Contact: staff Compression: Client Archive Delete Allowed?: Yes Backup Delete Allowed?: Yes Registration Date/Time: 09/16/2002 17:22:08 Registering Administrator: ME Last Communication Method Used: Tcp/Ip Bytes Received Last Session: 1,756 Bytes Sent Last Session: 6,395 Duration of Last Session: 3.01 Pct. Idle Wait Last Session: 162.81 Pct. Comm. Wait Last Session: 0.00 Pct. Media Wait Last Session: 0.00 Optionset: URL: Node Type: Client Password Expiration Period: Keep Mount Point?: No Maximum Mount Points Allowed: 1 Auto Filespace Rename : No tsm: TSMAAq dom AA_domain PolicyActivated Activated Number of Description DomainPolicyDefault Registered Name Set Mgmt Nodes Class - - - -- AA_DOMAIN STANDARD STANDARD 12 Back up to AA tsm: TSMAAq pol AA_domain standard PolicyPolicyDefault Description DomainSet Name Mgmt NameClass Name - - - AA_DOMAIN STANDARD STANDARD Default policy tsm: TSMAAq pol AA_domain standard f=d PolicyPolicyDefault Description Last Update by Last Upda- Managing profile DomainSet Name Mgmt (administrator) te Date/T- NameClass ime Name - - - --- -- -AA_DOMAIN STANDARD STANDARD Default policy ME 07/24/2002 tsm: TSMAAq mgmt AA_domain standard standard f=d
Re: ANS1075E : Program Memory Exhausted
This is Windows. How long has it been since you rebooted the file server? - Kai. -Original Message- From: Rob Hefty [mailto:[EMAIL PROTECTED]] Sent: Monday, 19 August 2002 11:20 AM To: [EMAIL PROTECTED] Subject: ANS1075E : Program Memory Exhausted Hello all, We have a win2k file server here running 4.2 that we have been doing incrementals on for months with journaling enabled and had no problems until recently. The error listed above outputs almost immediately after the initial run of it. We then rerun it (through a 3rd party scheduler) and it completes normally, backing up the normal amount. I tried the Tivoli website to no avail since this message is not documented and am waiting in a call back queue on it but have not heard back anything. Any help is appreciated. Thanks, Rob Hefty IS Operations Lab Safety Supply
Re: Antwort: Web Admin Interface - grrr
But it is precisely because I _do_ have boatloads of clients that I prefer the CLI. I can type 2 or 3 lines of parameters as someone said a few messages back much more quickly than I can click wait click wait click wait More, I seldom type long parameters. I have samples of anything I have defined/updated/deleted that I can quickly copy to a text editor, change the few characters that change, and dump into a CLI session. I specify everything so that if the defaults change they don't take me by surprise, and I seldom have to look back to the manuals find a syntax. The only trick is when I change versions I do have to go through the list and compare to the new Admin Reference. - Kai. -Original Message- From: Kauffman, Tom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 13 August 2002 8:38 AM To: [EMAIL PROTECTED] Subject: Re: Antwort: Web Admin Interface - grrr I'm afraid I'm another vote for the CLI. snip . . . But I don't have boatloads of clients to administer, so I'm probably not seeing the issues the rest of you are fighting. :-) Tom Kauffman NIBCO, Inc
Re: Antwort: Web Admin Interface - grrr
Laugh I usually just open the command line and use that. The only reason I ever used the web interface was so that I could talk to our mainframe TSM. Then I realized that I could define our Unix TSM server to the mainframe TSM and haven't bothered with a GUI since. - Kai. -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]] Sent: Monday, 12 August 2002 12:53 PM To: [EMAIL PROTECTED] Subject: Re: Antwort: Web Admin Interface - grrr Well, not really meaing to be on either one side or the other, 1-valid point for the web version is not needing to install the gui on every machine you may want to use to administer the server(s). Yes, I agree the web interface needs major improvements...Does anyone really use any of the main options besides OBJECT VIEW ? I have yet to find a need for the other three options. Always go straight to OBJECT VIEW ! Remeta, Mark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 08/12/2002 01:59 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Antwort: Web Admin Interface - grrr count me in as one that uses the old Windows GUI too. I wish Tivoli would bring it back and ditch the web admin... -Original Message- From: Gerhard Wolkerstorfer [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 1:01 PM To: [EMAIL PROTECTED] Subject: Antwort: Web Admin Interface - grrr Thomas, I can feel what you mean... I also use the good old Windows GUI.. E.g. .) you cannot sort the output from any Query - I want to sort for example all my volumes by reclamation-factor .) You cannot easily have 4 or more Windows in one big window (Open is always the PROCESS, SESSION, VOLUME window and sometimes any others) Yes , you can have more Browser Sessions - but believe me - when I open the fourth or fifth Browser Window, the whole Netscape will crash.. .) You cannot adapt the width of the columns to your requirements, and so on and on and on ,. So I use the old GUI and I love it.. Gerhard Wolkerstorfer [EMAIL PROTECTED] (Rupp Thomas (Illwerke)) am 12.08.2002 18:44:31 Bitte antworten an [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT) Thema:Web Admin Interface - grrr Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: pipes in help
Turns out I had upgraded from 4.2.0.0 to 4.2.2.1 without stopping at 4.2.2.0 along the way. The 4.2.2.0 patch includes updates to the message files. - Kai. -Original Message- From: Kai Hintze [mailto:[EMAIL PROTECTED]] Sent: Monday, 08 July 2002 1:56 PM To: [EMAIL PROTECTED] Subject: pipes in help Has anyone seen pipes instead of CR in your online help? How do you fix it? Thanks, Kai. ibm41:/home/root# oslevel 4.3.3.0 ibm41:/home/root# dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSM: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 07/08/02 13:51:11 Last access: 07/08/02 13:34:45 tsm: TSMhelp help HELP||HELP (Get Help on Commands and Error Messages)||Use this command to display administrative commands and error messages. You|can issue the command from an administrative command line client.||Privilege Class||Any administrator can issue this command.||Syntax||-Help+ ---+-- -| +-help_menu_number--+| +-command_name-+--+-+| | '-subcommand_name--' || '-message_number'|||Parameters||help_menu_number| Specifies the number of
Re: AIX Question!
Just be aware that find will also go down subdirectories, so if you have files with similar names in lower levels that you want to keep you have to find another way. If there are no subdirs, or if the subdirs don't have similar names then find works great. Someone mentioned xargs. xargs works great and was faster in a test I saw (but we are only talking fractions of a second per 1000 files :). Another way is to ls filespec delthem. Then edit delthem and put rm in front of every line. (Hint: in vi use :%s/^/rm /). This gives you very fine control, but is slowest. There are perl scripts (and I'm sure REXX, python, etc) that wrap around rm and read the directory to handle large directories. I could go on, but Have fun! Kai. -Original Message- From: Hamish Marson To: [EMAIL PROTECTED] Sent: 7/10/02 8:15 AM Subject: Re: AIX Question! Al'shaebani, Bassam wrote: Hello All, I'm came across an issue yesteday, does anyone know a way around deleting a large number of files without getting the 'parameter too long' message. i.e. I was trying to delete all the file that began with program*. There were too many files, so I had to actually cut my search down, to something like program01* and so forth, to avoid the error message. That's a shell issue, not necessarily an AIX issue. The problem is that the shell is responsible for expanding the commandline parameters. Thus typing *, the shell expands that to ALL the file that match (i.e. all of them). For instances like this, there are probably more ways than I have fingers, but genrally one that will always work is using find. e.g. find dir -name '*' -exec rm {} \; Thanks.. Regards, Bassam -- I don't suffer from Insanity... | Linux User #16396 I enjoy every minute of it... | | http://www.travellingkiwi.com/ |
Re: Antwort: odbc ?
The API is an entry into the application (ie, write custom backup clients, or use TDP). ODBC is view of TSM database. - Kai. Live in such a way that you would not be ashamed to sell your parrot to the town gossip. -- Will Rogers -Original Message- From: Burak Demircan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 09 July 2002 5:10 AM To: [EMAIL PROTECTED] Subject: Re: Antwort: odbc ? Merhaba Tsm, Then why is API is included in the client installation set? (it gives us the option to install or not) Thanks Burak [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09.07.2002 14:06 Please respond to ADSM-L To: [EMAIL PROTECTED] cc: Subject: Antwort: odbc ? Merhaba Burak An ODBC driver allows you to use a relational database product such as SQL to query the database and display the results. Client installation does not set include everything we need. You have to install API and ODBC separately. selamlar...
Re: pipes in help
Peter, Thanks for your advice. This was a fresh install. I didn't install the web stuff though. I'll go back and look at those packages. - Kai. -Original Message- From: Peter Pijpelink - P.L.C.S. BV Storage Consultants [mailto:[EMAIL PROTECTED]] Sent: Monday, 08 July 2002 2:01 PM To: [EMAIL PROTECTED] Subject: Re: pipes in help hello I've had this before, make sure you install all the webhelp and message files. Also do this with option latest available in smitty. Did you do an upgrade from version 4.1.x? good luck Peter At 13:56 08-07-2002 -0600, Kai Hintze wrote: Has anyone seen pipes instead of CR in your online help? How do you fix it? Thanks, Kai. ibm41:/home/root# oslevel 4.3.3.0 ibm41:/home/root# dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSM: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 07/08/02 13:51:11 Last access: 07/08/02 13:34:45 tsm: TSMhelp help HELP||HELP (Get Help on Commands and Error Messages)||Use this command to display administrative commands and error messages. You|can issue the command from an administrative command line client.||Privilege Class||Any administrator can issue this command.||Syntax||-Help+--- +-- -| +-help_menu_number--+| +-command_name-+--+-+| | '-subcommand_name--' || '-message_number'|||Parameters||help_menu_number| Specifies the number of
pipes in help
Has anyone seen pipes instead of CR in your online help? How do you fix it? Thanks, Kai. ibm41:/home/root# oslevel 4.3.3.0 ibm41:/home/root# dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.1 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server TSM: AIX-RS/6000 Server Version 4, Release 2, Level 2.5 Server date/time: 07/08/02 13:51:11 Last access: 07/08/02 13:34:45 tsm: TSMhelp help HELP||HELP (Get Help on Commands and Error Messages)||Use this command to display administrative commands and error messages. You|can issue the command from an administrative command line client.||Privilege Class||Any administrator can issue this command.||Syntax||-Help+---+-- -| +-help_menu_number--+| +-command_name-+--+-+| | '-subcommand_name--' || '-message_number'|||Parameters||help_menu_number| Specifies the number of
Re: checkin label scratch volumes
The label command includes a checkin option, as you have used, so you can do both with this one command. Have fun! Kai. -Original Message- From: Robert Ouzen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 03 July 2002 5:30 AM To: [EMAIL PROTECTED] Subject: checkin label scratch volumes Hi I have a scalar 1000 library and need to add a lot of new scratch volumes. Can I do just a: checkin libv scalar status=scratch search=bulk checklabel=barcode or I need the first time to do: label libv scalar checkin=scratch search=bulk labelsource=barcode volrange=01,50 When I did a label libv each cartridge was mounted in the drive and the process can take a long time. Regards Robert Ouzen
can I archive under excluded directories?
Oh most excellent TSM'ers, who have been there and done that! Using 4.x client talking to a 4.x host: If I exclude.dir a subdirectory, can I archive files from beneath that directory and have them last? The Using the B/A client manual says that you can perform selective backups from underneath an excluded directory, but the files expire with the next incremental. Will archives work anyway, or do I need to set up another node on the same box with a complementary inclexcl list? Thanks, Kai.
Re: End of Service for Server 4.2
audit volume - Kai. -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, 01 July 2002 11:57 AM To: [EMAIL PROTECTED] Subject: Re: End of Service for Server 4.2 Hi: I have a volume in an odd state: VOLUME_NAME STGPOOL_NAMEACCESS PCT_UTILIZEDPCT_RECLAIM 000324 OFFSITEVOLS READWRITE 0 99.9 As one of the offsite being returned it will not return to the scratch pool. If I do a move data, the message returns ANR2209W Volume 000324 contains no data. ANS8001I Return code 11. However, if I do a del volume I get a: ANS8001I Return code 13. 07/01/02 13:55:24 ANR2017I Administrator ADMIN issued command: DELETE VOLUME 000324 discard=yes 07/01/02 13:55:24 ANR2406E DELETE VOLUME: Volume 000324 still contains data. There no getting rid of it! Any suggestions? ***
Re: Why my LAN free backup even slower then my LAN backup
SAN (aka LANfree) protocols are good for moving a few huge files. If you have lots of little files (as is common in W2K) then you are better off with TCP (what your LAN probably uses). Have fun! Kai. -Original Message- From: Mike Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 26 June 2002 10:26 AM To: [EMAIL PROTECTED] Subject: Why my LAN free backup even slower then my LAN backup Why my LAN free backup even slower then my LAN backup? I got really bad performance, 1.2MBps for LAN, 900KBps for LANfree Backup. My TSM server is Version 4.2.1.11 in AIX 4.3.3, p640, 1 power3 processor, 1G memory; My TSM Storage Agent veriosn 4.2.1.11 on Win2k Advanced server, TSM client 4.2.1.20 on same machin, this is a compaq Deskpro EP/SB, 1 PII 350MHz processor, 256M memory, Emulex LP800 HBA; 3583 Library, 2109 Switch, 2108r03 bridge; During LANFree Backup, performance is about 900KBps, win2k host have 15% CPU utilization, 70% Disk I/O, memory utilization keep low, , even worse then LAN backup; Paramenters: TCPWINDOWSIZE 63(IBM recommaned in release notes); TCPBUFFSIZE 512; RESOURCEUTILIZATION 50 (looks like same as set to 10); During LAN backup, the tsm client win2k host have 95% CPU utilization, performance is about 1.2MBps; I hate this Compaq crap. None of the individual are full utilizated, e.g. CPU, Memory, or DISK IO, but the whole system together is just simply slow. What should be my performance expectation, how come my LAN free backup even slower then my LAN backup? For some other host, I am OK, e.g: When I use the other RS/6000 P640 box as the TSM LAN client, I can get 7.0MBps by using LAN backup; When I use the other IBM NetVista, 950MHz, Intel, 256M Memory, I can get 1.9MBps by using LAN, with 100% Disk IO Usage; Mike Brown - Do You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup
Re: Keeping an handle on client systems' large drives
Microsoft Policy Editor. I hate it personally, because I do know what I am doing, why, and where, but it does force the default data directories for the great unwashed to be on the data server. It takes a conscious (and annoying) effort to save something on your local drive. - Kai. -Original Message- From: Dan Foster To: [EMAIL PROTECTED] Sent: 6/13/02 9:24 PM Subject: Keeping an handle on client systems' large drives I've always been curious about something. How do you keep an handle on the fact that commodity PC storage is growing at a far faster rate than tape capacity/system is? For example, if I had a small LAN of about 300 PCs -- let's say, an academic or corporate departmental LAN environment... each has at least a 40 GB HD, and probably a fair amount of apps and files on them. In the stores, I see drives up to 160 GB, with even larger ones on the way! So let's say, an average of 25 GB utilization per system... a single full backup would be about 7.5 TB, which is quite a few tapes ;) Not everybody is using LTO or higher capacity. So do those sites rely purely on the incrementals to save you? Or some site specific policy such as tailoring backups to exclude (let's say) C:\Program Files, or some such...? Just wondering. Not every site is lucky enough to be able to convince the beancounters the merits of having a backup system that keeps up with the needs of the end users, even if it means one has to explain doomsday predictions on the business bottom line -- they invariably hear that then say Oh, pshaw, you're just exaggerating because you want money It sucks to be the one that's right ;) And the ones who warns well before a nasty event occurs may also be the first one to be fired out of spite after something happens and gets the blame for not having prevented it. -Dan Foster IP Systems Engineering (IPSE) Global Crossing Telecommunications
Re: what happens to the data
That's why you want to have a copypool Having said that, a couple of days ago we were having problems reading the label on a tape, so we did checkout verify=no remove=no label status=private overwrite=yes We recovered the data. Good luck! Kai. -Original Message- From: Ruksana Siddiqui To: [EMAIL PROTECTED] Sent: 6/11/02 9:36 PM Subject: what happens to the data Hi all, TSM has marked one of my tape which has VIMP data on it as unavailable and I managed to make its access READONLY. q libv is not picking the vol - and I can see ( physically ) that the tape is in the library - On the panel of the library the tape is referred as something else and I believe the barcode is stuffed. I checked the tape out of the library manually and sure now that is the tape I want. Now can I check this tape in as private and see if it recognizes it - ? what else can I do - I can't efford to lose the data on the tape. with regards, CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Re: tsm ftp server
So you probably don't want to install _all_ the patches. But if you want to know when a new patch comes out so you can look it over there are many products that can monitor a web site for changes. I'm sure that at least some of them could watch a tree on an ftp site that allows anonymous access. Have fun! - kai. -Original Message- From: Zlatko Krastev/ACIT To: [EMAIL PROTECTED] Sent: 6/6/02 5:20 AM Subject: Re: tsm ftp server Burak, the reason is that patches are released to fix specific problems (that's why they are *patches*) and do not go through full testing procedure. Whereas maintenance and rarely *some* patches get more testing and become recommended and pointed by web site. Think as ftp site holding all versions but web site pointing the last *recommended* one. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:tsm ftp server Hi Everybody, Why is the following web site is always behind ftp servers? Does anybody can answer it? All development stuff in IBM does good job and releases maintenances and patches but the web stuff does not need to update the htmls immediately. I am bored to surf inside the ftp archive to find whether there is a new release or patch etc. Regards, Burak http://www.tivoli.com/support/storage_mgr/adsercli.htm
stgpool configuration philosophy
Greetings oh wise and experienced TSM gurus, experts, workers, and knowlegable newbies! I am about to build a new TSM server from the ground up. It's been a long time since I last configured storage pools, etc, and I am wondering what the current state of the art in configuration philosophy recommends. I will check this list's archives, and the Tivoli RedBook section, and will see what I can find in the SHARE archive (although I mostly got HTML errors last time I tried to look there). Does anyone have other resources, web sites, articles, or other information they have found helpful recently they could point me to? Thanks! - Kai. You are making progress when every mistake you make is a new one.
checking inclexcl syntax
Greetings, friends and comrades! Can you please help me confirm that I have my include/exclude list set up correctly? I am using TDP for Informix 4.1.3 with TSM API 4.2.2.1. My DBA's want to do 1 level0 backup on the weekend, and 1 level1 backup during the week. They want to keep a month's worth of each. Of course we also need to backup the logs. I have created a management class for the logs whose backup copygroup has VerExists=1, VerDeleted=0, RetExtra=30, RetOnly=30 (I know, some redundancy there, but I am occasionally paranoid :). I created a management class for the dbspaces with VerExists=4, VerDeleted=1, RetExtra=30, RetOnly=30. The informixserver is named inf2 and the servernum is 2. Since the inclexcl evaluates from the bottom up, I put it like this: exclude /var/adm/schedule.log include /inf2/inf2/.../* db_dbspace include /inf2/inf2/2/* db_log If I understand the documentation correctly, that should find the log files and assign them to the db_log management class. The dbspaces (assuming we don't have one named 2) should be trapped by the next line, and get assigned to db_dbspace. I will run some tests, of course, but before I get very far I wanted to check with people who may have done this before. Thanks! Kai.
Re: 'q libv' question
Greetings Chuck, Sometimes when we have problems with labels we get tapes marked private. Also we have the rare tape that should have been released back to the scratch pool that just doesn't get updated for some reason after reclamation. I 'q contents' just as a double check that the database really doesn't have anything on the tape, check the database backups to make sure it isn't a mislabeld member of that set, then 'update libvol $lib $tape status=scratch'. - Kai. Date:Thu, 2 May 2002 16:33:47 -0700 From:Chuck Lam [EMAIL PROTECTED] Subject: 'q libv' question Hi - List, TSM 4.1.4 runs on AIX4.3.3. I noticed the following when I do 'q libv' recently: Three of the tapes were marked 'Private' under STATUS, but were blank under LAST USE. Usually when a tape is scratched, the LAST USE then becomes blank. A Private tapes is associated with DATA under LAST USE. I did not know how that came about and how to fix it. Any suggestions? TIA
Re: NetWare, Compression Slow Backups
Quite to the contrary. You usually do want COMPRESSALWAYS when you use client side compression. The question most often is whether you should compress at all. There are (as far as I know) two reasons to use client compression: 1) When you have small disk pools you need to feed them already compressed data to minimize the load. In this case you do not want COMPRESSALWAYS because you want to minimize the file size--whether that is compressed, or uncompressed. But since disks are fairly cheap today I think small disk pools would be uncommon. 2) Slow network between client and server. This is the vastly more common reason for client compresion. In this case (nearly always) you want to minimize the network traffic. If COMPRESSALWAYS=NO the client sends the server the size of the uncompressed file, then it starts compressing the file and sending the compressed version. If it sends 1 more byte compressed than the uncompressed size it says Compressed file grew (in effect, Whoops :) and STARTS THE WHOLE FILE AGAIN uncompressed. In other words, you have *doubled* your network traffic. Not what you were after at all. So you are probably thinking at this point So if I have a slow network I should always use COMPRESSALWAYS.. Not necessarily. If most of your data was already compressed (gz, ZIP, GIF, or JPEG files for instance), or is otherwise not amenable to compression then you should not compress it again because the overhead will cause most of your files to grow--thus increasing network load. Look at your data. Test and find out. But if you do compress because of a slow network you should use COMPRESSALWAYS. Have fun! - Kai. You are making progress when every mistake you make is a new one. Date:Wed, 10 Apr 2002 16:18:48 +0200 From:Daniel Sparrman [EMAIL PROTECTED] Subject: Re: NetWare, Compression Slow Backups Hi You shouldn't use Compressalways YES. If the file grows, instead of shrinks, TSM will keep on compressing the file. This will make the backups take a whole lot longer. Best Regards Daniel Sparrman --- Flemming Hougaard [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2002-04-10 14:08 Please respond to ADSM: Dist Stor Manager Hi all I have read most of the bulletins about NetWare and slow backups - and one of those issues there keeps coming up in most of these bulletins, is about compression. I really need the Client compression, but my question is: - Should you use the 'COMPRESSALWAYS YES? If not why? Best regards Flemming Hougaard
[no subject]
Matt, I'm sorry, I've lost track of which OS you are using, but on AIX if I use dsmadmc -id=id -pass=pass -tab command outfile I get all fields all on one line. Using AS to rename a field is irrelevant because all headers are gone, only the output from the command remains. There are no fixed length fields because it is tab delimited. It is perfect for programming with if you can split out fields on a delimiter though. This works with ADSM 3.1 and TSM 4.2. - Kai. From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of MC Matt Cooper (2838) Sent: Wednesday, March 27, 2002 2:25 PM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS I have tried everyone's suggestions. I believe the fact that I have one AS statement in the script that it will ignore the attempts of fixing the output into a 1 line per node output. The -COMMAdelimited , -TABdelimited, -OUT didn't work. I was able to get a 1 line output, with a title line and some other 'extra' lines of TSM header and msgs. The only way I seem to have in controlling this is with the suggestion from Paul, using an AS big area . This whole 'programming' area seems to go by a lot of undocumented rules. Why don't they document them somewhere? Or give a direct reference to which other product doc to look at? I am able to directly control the length of a numeric output with 'decimal(xx)' statement. What about character output? I am still disappointed that I can not seem to get an output that would be nothing more than what I really want 12 character node name delimiter 4 digit number of days since last access delimiter contact field name of 20 characters,then the next line . The best I came up with is as follows. SCRIPT... select node_name as NODE, - cast((current_timestamp-lastacc_time)days as decimal(4)) as DAYS, - contact asCONTACTfrom nodes where - cast((current_timestamp-lastacc_time)days as decimal) = 7
Re: Backup StgPool Issue Discovered
I would say it is a problem. If the backup can't get to some of the data then it is an error. - Kai Date:Tue, 19 Mar 2002 16:04:04 -0500 From:Seay, Paul [EMAIL PROTECTED] Subject: Re: Backup StgPool Issue Discovered The question I have: Does anyone consider this a problem or are you OK with it working like this? I found out today it appears that a BACKUP STGpool command will just skip tapes that are in an UNAVAILABLE, DESTROYED, or DAMAGED status and put out a little warning message and give you a SUCCESS. DESTROYED is not a problem because I took the overt action to say it was destroyed, but skipping UNAVAILABLE or DAMAGED is not good. I would bet there are hundreds of customers not aware of this. The exposure is your copypool (disaster recovery set) may not include all of the data and not a valid restore point. Unfortunately, a tape can get in the UNAVAILABLE status just because the tape library had a problem dismounting the tape.
Re: TSM server buffering client IP address ?
Arnaud, Yes, the server does remember the last address the client accessed it from. After you change the client address, and reboot the client to make sure the new address is firm, you want to run some query like dsmc q sched or dsmc q ses to make the most recent contact come from the new address. - Kai. Date:Fri, 8 Mar 2002 10:49:09 +0100 From:PAC Brion Arnaud [EMAIL PROTECTED] Subject: TSM server buffering client IP address ? Hi gurus ! I'm facing the following problem : we have a client node which IP = address has been modified yesterday morning, the machine has then been = rebooted, and of course, TSM client restarted. But this morning TSM = showed me the scheduled nightly backup for this node as missed.=20 I have a test schedule, that can be started manually, to test a = connection between TSM and client node. After having been restarting = client once again, I tried to execute this schedule, and this time = obtained missed. Ping between client and sever works in both directions, so there is no = connection issue. Dsmsched log and error files don't show any problem. After several retries, I decided with our network admin to trace IP = exchanges between the two machines, and we found that after having been = restarting the scheduler, systems where using the new node IP address = for some transactions, but at a certain point, TSM tried to use the OLD = ip address of the node ! Thus our test schedule fails ! Could anybody tell me if there is any kind of buffer in TSM, that = needs a certain time to be flushed before attributing new ip addresses = to nodes, or something like this ? How does exactly works TSM node - server relation when starting a = schedule, is there any kind of explanation ? Please help me, I absolutely have no idea of what happens. The picture : TSM server v 4.1.3 on aix 4.3.3 TSM node v 3.1.0.7 on aix 4.3.3 , in a DNZ (firewall = ports and IP addresses have been verified and are opened) Thanks in advance ! Arnaud
Re: Point in Time Backups
Dave, I am puzzled, but willing to learn--Why do you say that backupsets and archiving are not viable ways of doing PIT backups? Backupsets are more oriented to a PIT restore, but they do provide a snapshot of what the active files are at a given time. And archives seem like the arch-typical PIT snapshot to me. - Kai Date:Fri, 8 Mar 2002 11:06:20 - From:Frost, Dave [EMAIL PROTECTED] Subject: Re: Point in Time Backups Cheri This is our biggest headache with TSM which has NO suitable facility to provide what you want. Backupsets and archiving are not viable ways of doing it. snip
Re: How do you secure the passwd in a TSM admin command run a vi a batch script
expect works really well if you are used to TCL/c-shell type logic. If you are more of a ksh person, or already know perl you will probably prefer the perl version. It works well if you are running it from AIX or Solaris. HP/UX handles tty's in a strange fashion, and perl expect does not work there. If you are an HP/UX shop there is perl Net::Telnet. It runs on the three platforms I have tested, but as the name implies, you are opening a new telnet session under your current process, so you need to provide logon credentials as well as the TSM credentials. Once you are connected though, it is very powerful. My personal preference is to run everything from an AIX base, and if I need to do something on an HP box I use perl expect to control /usr/bin/telnet to the HP box. grin If you decide to use the perl expect you might want to borrow a copy of the O'Rielly Expect book (sorry, I can't remember the name) to read once for concepts. The perl version works well, but is not as thoroughly documented. - Kai On Mon, 18 Feb 2002 12:29:33 -0800, Alex Paschal [EMAIL PROTECTED] wrote: If you like, you can use something like expect to script your dsmadmc commands. For applications that block regular STDIN piping and redirecting, like telnet or dsmadmc, expect does the magic tty swapping that's necessary to feed the password into the password prompt so it won't show in the ps. I don't know much more about it because it's a little higher powered programming than I've done in years, but if the security is that important to you, it might be worth your time. Here's the web site. http://expect.nist.gov/ There's also a Perl version, but I don't know how good it's cross-platform functionality is. http://search.cpan.org/search?dist=Expect
Re: accounting log into database
I should have specified that I'm looking for a central database that any of our group can query from anywhere, not a desktop, single user limit. If no-one has something already I will write some perl to dump it into a mysql db on a linux box. But before I re-invent the wheel, I thought I would check what other people have done. Thanks, - Kai. Date:Tue, 22 Jan 2002 14:08:21 -0800 From:Doug Thorneycroft [EMAIL PROTECTED] Subject: Re: accounting log into database You can import the file directly into Excel or Access. I use access, and have the import run as a macro whenever I open the file. -Original Message- From: Kai Hintze [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:06 PM To: [EMAIL PROTECTED] Subject:accounting log into database Does anyone have a process they could share to insert the accounting log into a database so I could query it? I have some perl scripts that give me a few reports, but writing a new program every time I want to ask an ad-hoc question just isn't cost effective. - Kai.
moving log volume
Greetings, Oh TSM Gurus of Greater Experience than I! I need to move my transaction log to another volume. It is (of course) mirrored, but only once. I am thinking that if I mirror it a second time in the place where I need for it to end up, then some time when the server is quiet undefine the original location, I should end up with two copies where I need them. Should that work? Cautions, warnings, queries? Platform is TSM server 4.2.1.7 on AIX 4.3.3. Thank you in advance for your insights. - Kai.
Which conference do you recommend?
Looking at next year's education budget. My boss says he will send me to one (and only one) conference. The two leading contenders at this time are SHARE (March in Nashville) and the Storage Symposium (August in Salt Lake City). From people who have been to one or both, which do you recommend and why? Is there another conference I ought to look at?* My job is largely TSM administration, but also a fair amount of general Unix System Admin. Also, does anyone know where I can get information from the two sessions titled Everything you always wanted to know about TSM Database, parts 1 and 2 in last years Storage Symposium? Thanks, Kai. * I know about the TSM Symposium at Oxford, but I don't think he will spring to send me across the Pond. I also glanced at the Usenix/ACM FAST, but that seems rather more oriented to computer scientists, and less to do with Information Services.
DiskXtender 2000 experience
So what is the latest on DiskXtender 2000? I have been told that I will be installing it later this week. What is people's experience to date? Thumbs up/thumbs down? Warnings, caveats? We have a number of NT, Solaris, AIX, and HP boxes talking to TSM 4.2 servers on mainframes. TIA! - Kai
HP/UX client not finding dsm.opt
Have you ever seen a client try to use the DSM_DIR directory for its opt file? Yesterday I downloaded the HP/UX 4.1.latest client from Tivoli's web site to use with a Storage Management Server for MVS - Version 4, Release 1, Level 0.0. It seemed to install ok, but when I try to connect to the server it claims that octal 260 is an invalid character in the opt file. A (commented) session looks something like this: # the client is a new HP 8xx series running HP/UX 11.0. newhp:/#uname -a HP-UX newhp B.11.00 U 9000/800 616339383 unlimited-user license # I created a small script to export the environment. It seems to work. newhp:/#. /opt/tivoli/tsm_env newhp:/#env | grep -i dsm DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.opt newhp:/#cd $DSM_DIR # At this point I should be able to connect to the server, but newhp:/opt/tivoli/tsm/client/ba/bin#dsmc ANS1036S Invalid option '°' found in options file '/opt/tivoli/tsm/client/ba/bin' at line number : 1 Invalid entry : '' # It does seem to be looking at the file it says--the directory! # dsm.opt is pretty standard newhp:/opt/tivoli/tsm/client/ba/bin#od -c dsm.opt 000 s e r v e r n a m e 020 t s m \n t a p e p r o m p 040 t n o \n 055 newhp:/opt/tivoli/tsm/client/ba/bin#cat dsm.opt servername tsm tapeprompt no # but the bin dir does seem to start with the strange character newhp:/opt/tivoli/tsm/client/ba/bin dsmc | od -c 000 \n A N S 0 1 1 0 E L o g M s g 020 : U n a b l e t o o p e n 040 e r r o r l o g f i l e 060 ' d s m e r r o r . l o g ' f 100 o r o u t p u t . \n A N S 1 0 120 3 6 S I n v a l i d o p t i 140 o n ' 001 260 ' f o u n d i n ^^^ 160 o p t i o n s f i l e ' / 200 o p t / t i v o l i / t s m / c 220 l i e n t / b a / b i n ' \n \t 240 a t l i n e n u m b e r : 260 1 \n \t I n v a l i d e n t 300 r y : ' ' \n \n 311 newhp:/opt/tivoli/tsm/client/ba/bin od -c . |head 000 001 260 \0 \0 364 \0 \0 001 340 \0 220 001 \ 002 020 ^^^ 020 \0 \0 \0 324 \0 \0 001 260 \0 \0 \0 \0 001 240 \0 \0 040 \0 \0 001 310 \0 \0 \0 D 002 \0 300 \0 \0 \0 \0 060 001 l \0 \0 \0 \0 \0 X 001 \0 \0 001 034 \0 \0 100 002 $ \0 \0 \0 \0 \f 372 \0 024 \0 007 \0 \0 d s 120 m . s y s a t e \0 \0 013 301 \0 024 \0 \t # it seems like it may be using unicode since it is taking a 2 byte # character. # for completeness sake, here is the dsm.sys newhp:/opt/tivoli/tsm/client/ba/bin#cat dsm.sys *ADSM CLIENT SYSTEM OPTIONS FILE FOR QUICKINSTALL * to direct the schedule log to /var the /adsmlog * directory must be created with the mkdir command * before the dsmc sched daemon is run. SERVERNAME tsm COMMMETHOD TCPIP TCPSERVERADDRESS ibm2-1 nodename newhp COMPRESSION off changingretries 2 inclexcl /opt/tivoli/tsm/client/ba/bin maxcmdretries8 retryperiod 15 schedlogname /var/adm/schedule.log queryschedperiod 2 schedmodeprompted passwordaccess generate schedlogretention5 d mailprog /usr/bin/mail root txnbytelimit 10240 tcpbuffsize 32 tcpwindowsize48 errorlogretention 10 D newhp:/opt/tivoli/tsm/client/ba/bin# I'm trying to RTFM, but not finding anything. Suggestions, pointers, fixes will be gratefully attempted. - Kai.
Re: select statement
Date:Tue, 2 Oct 2001 08:23:22 -0700 From:Gill, Geoffrey L. [EMAIL PROTECTED] Subject: select statement Hello all, Can anyone help with this question? I'm wondering if it's possible to get this from a select statement or other query. I want to find out how much data all nodes backed up the previous night, how much time it took and maybe the transfer rate. Put it in order by what took the longest. What you want is not stored nicely in the database, but TSM can write accounting records to a flat file that you can parse. I'm playing with them and will post my scripts to coderelief when I have them ready for production. Write me offline if you are in a hurry and want the beta code. Thanks for the help. You're welcome. - Kai. Geoff Gill TSM Administrator
Does compression cause retries?
Oh vastly experienced TSM wise ones! We have a box with some large files, and a slow network, so I turned on compression to see if it would speed the backup, but I think it may have backfired. It looks to me like I just caused resends. From the client schedule.log: 10/02/2001 04:45:27 Normal File-- 109,740,032 /fnsw/local/oracle/oraIDB_sig Compressed Data Grew 10/02/2001 04:45:47 Retry # 1 Normal File-- 109,740,032 /fnsw/local/oracle/oraIDB_sig Sent From the UNIX Using the Backup-Archive Clients manual: The compression option compresses files before you send them to the server. Compressing your files reduces data storage for backup versions and archive copies of your files. It can, however, affect TSM throughput. A fast processor on a slow network connection benefits from compression, but a slow processor on a fast network connection does not. If you specify compressalways=yes, compression continues even if the file size increases. To stop compression if the file size grows, and resend the file uncompressed, specify compressalways=No. /quote Am I really reading that right, that the client sent the data twice? I was hoping that it would compress it client side, then if it looked good it would send the compressed version, otherwise it would send the uncompressed version. But it looks like it sends most of the compressed version, and then the uncompressed version. How annoying. If that is the case then I need to go through and count up how many (and how large) files grew during compression and compare with the count and size of the files that didn't and decide if I should use compression allways, or turn compression back off. But before I go to that much work I wanted to confirm that I am reading the situation correctly. Thanks for your input! Kai.
Re: volume status being changed erroneously
I certainly would not dismiss the possiblity of an error at the factory. As it happens I am at this moment in the process of giving some tapes one last chance. They went status=private while last_use is blank because of problems reading the labels. 90% of the time I can fix that with checkout libvol mylib problem_vol1 checklabel=no remove=no checkout libvol mylib problem_vol2 checklabel=no remove=no label libvol mylib search=yes labelsource=barcode checkin=scratch overwrite=yes Nearly always creating a new label like this is sufficient. Of course I keep an eye on the tape for the next several days, and first sign of any more trouble I move data from the tape and get rid of it. Luck! - Kai. -Original Message- From: Taylor, David [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:11 AM To: [EMAIL PROTECTED] Subject: volume status being changed erroneously TSM Gurus, I found several reference to my problem in the archive but, did not find an explanation or a real fix for it. If I over looked it, I will shamefully take the time-out chair in the corner. Our TSM environment is relatively new ( 6 mos). We are running 4.1.3 server on AIX 4.3.3 ML6 with a 3583 LTO library. The clients are all 4.1.3 AIX and NT. A few TDP clients for Exchange, M$SQL and DB2 on AIX. The problem is that I keep seeing several of my scratch volumes' status being changed from scratch to private and the last use column is blank. The first time I noticed this it was suggested, by our Business Partner, that the tapes were probably checked in improperly. I checked them out and then back in as scratch. Within the last two weeks I recall seeing several consecutively labeled volumes again with a status of private and no last use.Again I changed their status back to scratch. This morning I see the same thing with the same group of tapes. I also happened to catch it in the activity log, stating that there were I/O errors on these volumes and the status change was to prevent re-access. If it were one or two tapes, I could accept it. But the fact that these seven tapes represent roughly 30% of the library's current population AND the fact that they are consecutively numbered AND have never previously been used, to me can't be explained as coincidental. The tapes and the labels arrived separately. So we can dismiss a error at the factory. Any help would be greatly appreciated! Thanks David Taylor Senior Software Systems Engineer West Bend Mutual Insurance (262) 335-7077 [EMAIL PROTECTED]
Re: expiration of backups
From: Zosimo Noriega (ADNOC IST) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 9:43 AM To: [EMAIL PROTECTED] Subject: expiration of backups i have a management calss with this propeties: === LAN-SERV-DOMAIN:ACTIVE:LAN-SERV-MC1:STANDARD - Properties - Length of time to retain extra backup version : 10 Length of time to retain only backup version : 60 It is not clear to about the expiration, i know i deleted a file from the client it will expired after 60 days starting from the deletion date. But my question is, if i stop the backup operations from the client, is the client data will expire? Or it will never expire. Any help from you is really appreciated. If you stop backup operations on the client then nothing ever notifies the server to expire the data, so all of it lasts forever (or until you finally run another backup, or delete the filespace from the server, or eliminate the server, whichever comes first). - Kai. Do not condemn the judgement of another because it differs from your own. You may both be wrong. -- Dandemis
Getting accounting log out of SMF
Please help a hapless unix administrator thrust into managing TSM on a mainframe. I've been running ADSM on AIX for years, but after a merger I am suddenly trying to work outside may current knowledge base. I'm trying to view the accounting log to get some client histories. My mainframe contact says they are in SMF and we don't have a report for it. 1) What is SMF? Why do I need a report? 2) Does anyone have a report that would let me dump the accounting logs to a text file where I can analyze them? Thanks! Kai. If you find a path with no obstacles, it probably doesn't lead anywhere. -- Franklin Clark
Re: missing volumes
Hi Steve, Yes, the tape is scratchable, but you have to explicitly update libvol 3575lib1 11824f status=scratch. You might want to q content 11824f first just to make sure there isn't anything on the tape. As you surmised, the library gets confused sometimes and when it can't find the tape it was looking for it marks the tape private so that TSM doesn't look for it any more. - Kai. Date:Fri, 13 Jul 2001 09:46:05 +0800 From:Steve de Souza [EMAIL PROTECTED] Subject: missing volumes Hi All, I have some volumes which appears in a q libv as follows...(ythis is just one of them) 3575LIB1 11824F Private59 The usual forth field of Data is not displayed. Does this mean that this is a scratchable tape??? Also, from the actlog, the last entry for this tape is an atempted checkin, which has failed as ADSM says that the tape is already in the library. The next most recent entry for the tape is a checkout from the library, which has failed, because the tape it got was the wrong one(I think the inventory is stuffed.) As I am physically holding this tape in my hand, I am very confused as to what is going on. Several tapes are like this. It also seems that after doing a tapeutil -f /dev/smc0 inventory that some of the tapes that are displayed are not the ones that physically appear in the slot that it says. Quite strange. Has anyone got some clues on how to sanity check and fix this inventory issue please? cheers steve
Can't reclaim volume using 0 bytes
I have a volume that apparently has 0 bytes used that I can't seem to reuse. Space reclamation is putting this in the activity log once an hour: 07/09/2001 13:15:55 ANR0984I Process 853 for SPACE RECLAMATION started in the BACKGROUND at 13:15:55. 07/09/2001 13:15:55 ANR1040I Space reclamation started for volume 700232, storage pool UNIX_TAPEPOOL (process number 853). 07/09/2001 13:15:55 ANR1044I Removable volume 700232 is required for space reclamation. 07/09/2001 13:15:55 ANR8324I DLT volume 700232 is expected to be mounted (R/O). 07/09/2001 13:15:55 ANR0985I Process 853 for SPACE RECLAMATION running in the BACKGROUND completed with completion state SUCCESS at 13:15:55. 07/09/2001 13:15:55 ANR1041I Space reclamation ended for volume 700232. 07/09/2001 13:15:56 ANRD afmigr.c(2619): Reconstruction of aggregates is disabled. Run audit reclaim utilities to re-enable reconstruction of aggregates. 07/09/2001 13:15:56 ANRD afmigr.c(2787): Error deleting transaction for 0 bytes moved reclamation - volume 700232. Move data says there is nothing to move and quits: ANS8000I Server command: 'move data 700232' ANR2209W Volume 700232 contains no data. ANS8001I Return code 11. ANS8002I Highest return code was 11. I tried just deleting the volume. The control session says: ANS8000I Server command: 'delete vol 700232 discard=yes' ANS8001I Return code 13. ANS8002I Highest return code was 13. While the activity log says: ANR2017I Administrator ADMIN issued command: DELETE VOLUME 700232 discard=yes ANR2406E DELETE VOLUME: Volume 700232 still contains data. ANR2017I Administrator ADMIN issued command: ROLLBACK Huh? I thought discard=yes deleted the volume regardless of what data it may contain!? Besides, query volume shows it empty: ANS8000I Server command: 'query vol 700232 f=d' Volume Name: 700232 Storage Pool Name: UNIX_TAPEPOOL Device Class Name: 9710DEV Estimated Capacity (MB): 67,941.2 Pct Util: 0.0 Volume Status: Full Access: Read/Write Pct. Reclaimable Space: 100.0 Scratch Volume?: Yes In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 18 Write Pass Number: 1 Approx. Date Last Written: 04/23/2001 05:49:50 Approx. Date Last Read: 06/19/2001 04:15:16 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: Last Update by (administrator): Last Update Date/Time: 04/19/2001 05:33:19 ANS8002I Highest return code was 0. I'm down to just checking the tape out of the library and leaving it on the shelf until the volhist expires. Any other suggestions? Environment is ADSM Server Version 3, Release 1, Level 2.20 running on AIX 4.1.5.0 (I know, but first I've got to get the money to buy a box that will accept AIX 4.3.x then I can upgrade to a recent TSM. The boss says Real Soon Now.) Thanks! Kai. True leadership is the art of changing a group from what it is to what it ought to be. -- Virginia Allan
Re: Pl answer to this question or mail me directly
Balanand, Salary depends on what field (retail, research, non-profit, government,...) and what part of the country you live in as much as your job title and background. Most management, HR, and trade magazines do periodic surveys to find out what people are likely to make given those parameters. For example, ComputerWorld's 2000 salary survey is available at http://www.computerworld.com/computerworld/records/images/pdf/990906salary.p df (http://www.computerworld.com - Careers - Surveys and Reports -- Salary Related - 2000 report). Good luck! Shekar, First, I think you are pretty arrogant to tell the whole list what we will and won't do. Second, everyone should ask such questions. The only people who don't want you to know what a reasonable salary is are anal-retentive HR types who think that only _their_ priesthood should know salary information (as opposed to good HR types that want to treat people well) and top-level executives who don't want you to know how much more they make than you do. How else can you request a reasonable salary if you don't know what reasonable is? - Kai. Date:Fri, 1 Jun 2001 15:38:53 -0400 From:Dhotre, Shekhar [EMAIL PROTECTED] Subject: Re: Pl answer to this question or mail me directly Bala first thing nobody will answer such kind of questions on this AIX disscussioin list , and nobody should ask such kind of questions .. -Original Message- From: PINNI, BALANAND (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:07 PM To: [EMAIL PROTECTED] Subject: Pl answer to this question or mail me directly Importance: High FYI ALL Its a humble request pl. May be some may get surprised with this question.Pl delete this mail if u feel .I wanted to know this because no one tells me here in USA. I wanted to know what whould be salary per year for the following data 1.AIX/HP/SUN/TSM ADMIN 2.With network and DBA background for for past 14 years. BALANAND PINNI. PHONE 314-206-5911. EM:[EMAIL PROTECTED] PG:1-800-451-6897.
Re: Library audit (AGAIN)
checkin -search=yes? - Kai. --- Original message follows --- Date:Mon, 16 Apr 2001 07:45:05 -0700 From:"Gill, Geoffrey L." [EMAIL PROTECTED] Subject: Library audit (AGAIN) This is truly a surprise to find this happening so soon after the problem I listed last week. That one I still haven't fixed. The first problem is tapes in the library: U00288 0064 00 10 00 U01063 0064 00 10 00 U01076 0064 00 10 00 U01077 0064 00 10 00 that are supposed to be in the vault, which they are not because I looked myself. U00288 Vault09/25/00 11:22:21 U01063 Vault04/03/01 14:03:03 U01076 Vault04/03/01 14:03:03 U01077 Vault04/03/01 14:03:03 They won't check out through TSM. Now the problem is tapes that were in the vault this morning, moved to onsiteretrieve, put in the library, but won't check in to TSM, it thinks they are not there for whatever reason. U00136 FF00 00 10 00 U00151 FF00 00 10 00 I ran an audit on the library on Friday through TSM, now I'm wondering if there is a way to audit the library through AIX, then reaudit the library through TSM and have it pick up the changes. I don't have any books to refer to with the mtlib commands so I don't know what to do. If anyone knows an online manual with this stuff it would help. I'll probably call TSM on this but if anyone has any ideas that might help it would also be appreciated. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: Long Term Archive for Databases
It's not our job to tell the business what they can and cannot back up. On the other hand, sometimes when we present them with the cost--be sure to include the cost of maintaining the current tape library plus the new ones you will need by then--they realize that might be a better way to keep the information they really need. I strongly second the suggestion that if they do think they need the whole database that it be dumped to ascii flat files so that you have a chance of reading it 7 years from now. Be sure to include the downtime on the database to create a consistent dump in your cost estimate. - Kai. "Text processing has made it possible to right-justify any idea, even one which cannot be justified on any other grounds." -- J. Finnegan, USC On Thursday, April 05, 2001 10:48 AM, Jim Taylor asked: I keep getting this pressure from clients to keep copies of their 500GB oracle database for 7 years. They don't seem to know why they want it kept for seven years. Like most others they don't think of what their restore requirements are. Has anyone had to restore/retrieve a large database that was, say more than 2 years old. If so was it successful and was it as simple as restoring just the DB.
Re: Labelling the tapes in 3590-E11 Jukebox
With our STK 9710 I can issue a "label libvol library_name search=bulk labelsource=barcode overwrite=yes" I'm pretty sure that is the syntax, I'm not connected to our adsm servers at the moment. - Kai. -- Kai Hintze currently using the mailer [EMAIL PROTECTED] Ganu Sachin, IBM wrote: Hi We have RS6000/SP wide node with AIX 4.3.3, Tivoli Storage manager 3.7.0 and IBM 3590 E11 jukebox. We are planning to use it for Informix database (ver. 7.24 UC 3 on SAP R/3 ver 4.0B) backup. Presently, we are labelling the tape from priority slot and then do a "check-in". But there is no fun it. We would like stack 4 tapes in the ACF and label them one by one. Does any one know how to label the tapes in single step ? Thanks in advance Regards Sachin Ganu IBM Global Services - India
Re: Compaq (nee Digital) TL895?
Run away! Run away! We have had ongoing problems with our DLT library. If we had known we were going to spend so much to get it to run we would have just spent the same amount of money up front and bought a 3950 library that would work. - Kai -- Kai Hintze Senior System Programmer Albertson's Pat Wilson wrote: We've been offered a good deal on a StorageWorks TL895 DLT library. Anyone using one and have advice, pro or con? We'll most likely wind up hooking it to an RS/6000 H70, if that makes a difference... Thanks. Pat Wilson Dartmouth College
Re: what to do with bad tapes
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.
getting rid of onbar log backups
Still trying to get rid of outdated informix onbar log backups. While I am trying to get expire to work I have run out of tapes. Something in the last set of mails clicked an idea--If I read the mgmt class correctly only onbar log backups should be on the tapes in question, so I may be able to just delete volume discarddate=yes to release the tapes back to the scratch pool. How can I find out what tapes the logs are on? How can I verify that the only thing on the tapes Thanks for your help! -Kai. "Space isn't remote at all. It's only an hour's drive away if your car could go straight upwards." -- Fred Hoyle, Astronomer, mathematician, writer (1915- ) -- Kai Hintze currently using the mailer [EMAIL PROTECTED]
deleting onbar logs - continued
A couple of days ago I asked for help deleting informix logs backed up with onbar. Several people suggested that I download the expire program by Christoph Martin. I got the source, and it compiled cleanly, but I'm not having any luck running it. Can someone familiar with the API give me a pointer? I'm trying to RTFM, but I'm running out of scratch tapes and getting desparate. -- quote -- adsm show version f1n5e_db /* /infprd18 : /infprd18/18/ 10 (MC: DBLOGS_MC) Active, Inserted 06/29/00 07:12:26 /infprd18 : /infprd18/18/ 11 (MC: DBLOGS_MC) Active, Inserted 06/29/00 07:22:04 adsm quit f1n9e:/usr/lpp/adsm/api/bin# ./expire_logs f1n5e_db /infprd18/18/11 argc:3, argv[1]:f1n5e_db, argv[2]:/infprd18/18/11: API Library Version = 3.1.0 Application Version = 3.1.0 *** BSAMarkObjectInactive failed: (96) ADSM error. See the error log file. f1n9e:/usr/lpp/adsm/api/bin# cat dsierror.log 10/03/2000 08:30:21 ANS0223E (RC2016) Filespace name should start with the directory delimiter. f1n9e:/usr/lpp/adsm/api/bin# uname -a AIX f1n9e 1 4 0008520FA400 f1n9e:/usr/lpp/adsm/api/bin# oslevel 4.1.5.0 f1n9e:/usr/lpp/adsm/api/bin# dsmc q ses ADSTAR Distributed Storage Manager Command Line Backup Client Interface - Version 3, Release 1, Level 0.0 (C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved. Node Name: AIXDEV Session established with server DUBLIN01: AIX-RS/6000 Server Version 3, Release 1, Level 2.20 Server date/time: 10/03/2000 08:47:33 Last access: 10/03/2000 08:30:21 ADSM Server Connection Information Server Name.: DUBLIN01 Server Type.: AIX-RS/6000 Server Version..: Ver. 3, Rel. 1, Lev. 2.20 Last Access Date: 10/03/2000 08:30:21 Delete Backup Files.: No Delete Archive Files: Yes Node Name...: AIXDEV User Name...: root f1n9e:/usr/lpp/adsm/api/bin# -- end quote -- I can send the source to expire.c to anyone interested, but it is long enough I didn't want to send it to the whole list. THANKS! - Kai. "Everywhere is walking distance if you have the time." -- Steven Wright, comedian (1955- ) -- Kai Hintze currently using the mailer [EMAIL PROTECTED]
Re: exclude statement
Hi, Is this exclude statement valid? **inclexcl*** exclude /home/hosp*/data/.../*.TMP I believe it should be exclude /home/hosp.../data/.../*.TMP The directory wildcard is "..." not "*". - Kai. I still getting this error : ***dsmsched.log 09/27/00 20:02:54 ANS1228E Sending of bject '/home/hospc3/data/doc/srvinst4.TMP' failed 09/27/00 20:02:54 ANS4005E Error processing '/home/hospc3/data/doc/srvinst4.TMP': file not found Thanks, Estee Chen (GLIC)
How to delete OnBar log backups
How do you delete OnBar backups? I inherited an ADSM setup where OnBar backups are filling our tape library. How do I get delete the old backups that are no longer relevant. I can see them sometimes. In dsmadmc I can run these commands: adsm q file ibm12_db Node Name Filespace Platform Filespace Capacity Pct Name Type (MB) Util -- --- - - IBM12_DB /infprd18 XOpen/A- L 0.0 0.0 DSM adsm show version ibm12_db /* /infprd18 : /infprd18/18/ 104130 (MC: DEFAULT) Active, Inserted 07/26/00 13:52:07 /infprd18 : /infprd18/18/ 104131 (MC: DEFAULT) Active, Inserted 07/26/00 13:53:53 /infprd18 : /infprd18/18/ 104132 (MC: DEFAULT) Active, Inserted 07/26/00 13:55:49 /infprd18 : /infprd18/18/ 104133 (MC: DEFAULT) Active, Inserted 07/26/00 13:57:51 goes on for pages Anything more than a week old is outdated, and can be deleted. But when I go to dsmc to delete them, I can't see them: dsmc q backup /infprd18 ANS4095E No files matching search criteria were found dsmc q backup /infprd18/* ANS4095E No files matching search criteria were found dsmc q backup /infprd18/18 ANS4095E No files matching search criteria were found dsmc q backup infprd18/18/* ANS4095E No files matching search criteria were found dsmc This is with Server version 3.1.2.20, client version 2.1.06G. Thanks! Kai.