Re: Help with select for non-mirrored database volumes
Hi. Tricky... I don't know why the not like is not working, but you should try: select copy1_name,avail_space_mb from dbvolumes where copy2_status is null It will do the job. Ran. -Original Message- From: Nicholas Cassimatis [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:09 AM To: [EMAIL PROTECTED] Subject: Help with select for non-mirrored database volumes I'm on the right path, I think. It's all right there in the dbvolumes, I just can't get the info to come out right. I want to find out how large the unmirrored volumes are, so I can go get the space to mirror them. I've tried: tsm: SERVERselect copy1_name,avail_space_mb from dbvolumes where copy2_name not like '/%' tsm: SERVERselect copy1_name,avail_space_mb from dbvolumes where copy2_status not like 'Sync%'(can't do the - 'd - in there, not sure how to get past that) tsm: SERVERselect copy1_name,avail_space_mb from dbvolumes where copy2_name='' Plus a few variations on those themes, and all I get is the proverbial: ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. (And yes, I have unmirrored DB volumes on this machine) I'm missing some fundamental thing here, (along with my SQL guru to a vacation...). Can someone point me in the right direction? Thanks! Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday.
Re: move drmedia
Hi. In DRMSTATUS there is a parameter called: Check Label : It should be No if you wish to check out without checking. just: set drmcheckl no - and that is your answer Ran. -Original Message- From: Burak Demircan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:26 AM To: [EMAIL PROTECTED] Subject: move drmedia Hi, How can I prevent my 3583 library to check barcode labels when using move drmedia command. I could not find checklabel option in the command help. Regards, Burak
Re: Volume deleted from OFFSITETAPES pool
Don't Worry. TSM does not delete volumes every now and then... The volume was probably empty, but unavailable. because you have changed it to reado, it became available, and because it's an offsite volume it became scratch, and deleted from pool. now you can use it as scratch. Regards, Ran. -Original Message- From: Bill Dourado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:16 PM To: [EMAIL PROTECTED] Subject: Volume deleted from OFFSITETAPES pool Hi, I was updating a few unavailable tape volumes to access=reado, and in error typed :- UPDATE VOLUME AD0289 ACCESS=READO (AD0289 being the error). Should I being concerned by the messages below, have I lost some data?, what can I do to recover the situation ? 07/24/2002 10:36:33 ANR2017I Administrator ADMIN issued command: UPDATE VOLUME AD0289 ACCESS=READO 07/24/2002 10:36:33 ANR2208I Volume AD0289 deleted from storage pool OFFSITETAPES. 07/24/2002 10:36:33 ANR1341I Scratch volume AD0289 has been deleted from storage pool OFFSITETAPES. TSM 4.1.4.1 running on a Windows 2000 System. T.I.A Bill Dourado *** Disclaimer *** This email and any files transmitted with it contains privileged and confidential information and is intended for the addressee only. If you are not the intended recipient you must not disseminate, distribute or copy this email. Please notify the sender at once that you have received it by mistake and then delete it from your system. Any views expressed in this email are those of the sender and not necessarily those of ALSTEC or its associated companies. Whereas ALSTEC takes reasonable precautions to ensure this email is virus free, no responsibility will be accepted by it for any loss or damage whether direct or indirect which results from the contents of this email or its attachments. ALSTEC Group Limited - Registered in England No.3939840 - www.alstec.com Registered office: Cambridge Road, Whetstone, Leicester. LE8 6LH. England. Telephone: +44 (0)116 275 0750
Re: AIX Question!
Hi. Not quite a tsm question, but try: ls | xargs rm though, it might take a while Ran. -Original Message- From: Al'shaebani, Bassam [mailto:Bassam.Al'[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 2:26 PM To: [EMAIL PROTECTED] Subject: AIX Question! 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. Thanks.. Regards, Bassam
adsmpipe and windows NT
Hi, All. I have established successfully adsmpipe on AIX. But, I need to use it also on windows NT/2000. Did any of you tried to adjust the sources for compilation on windows environment ? Thanks in advance, Ran
Re: Recovery log space problem
Hi. The log gets filled up all the time. When you backup the TSM database, it gets empty. So, you should define a backup trigger for the database ( Admin Guide ) and consider increasing the size of the log in case it gets filled up too soon. Ran. -Original Message- From: Ganu Sachin, IBM [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 8:23 AM To: [EMAIL PROTECTED] Subject: Recovery log space problem Hi We have TSM server 3.7.0 with TDP for Informix 3.7. Yesterday we got following warning messages (blue font). 06/23/02 04:06:43 ANR0314W Recovery log usage exceeds 90 % of its assigned capacity. 06/23/02 04:06:51 ANR0314W Recovery log usage exceeds 92 % of its assigned capacity. 06/23/02 04:07:01 ANR0314W Recovery log usage exceeds 94 % of its assigned capacity. 06/23/02 04:07:09 ANR0314W Recovery log usage exceeds 96 % of its assigned capacity. 06/23/02 04:07:16 ANR0314W Recovery log usage exceeds 98 % of its assigned capacity. 06/23/02 04:07:18 ANR0356I Recovery log compression started. 06/23/02 04:07:18 ANR0357I Recovery log compression ended. 06/23/02 04:07:42 ANR0400I Session 12186 started for node BRAMHA (TDP Infmx AIX42) (ShMem). 06/23/02 04:07:44 ANR0403I Session 12186 ended for node BRAMHA (TDP Infmx AIX42). 06/23/02 04:09:03 ANR0400I Session 12187 started for node BRAMHA (TDP Infmx AIX42) (ShMem). 06/23/02 04:09:06 ANR0403I Session 12187 ended for node BRAMHA (TDP Infmx AIX42). 06/23/02 04:12:40 ANR0314W Recovery log usage exceeds 90 % of its assigned capacity. 06/23/02 04:12:46 ANR0314W Recovery log usage exceeds 92 % of its assigned capacity. Output of TSM query log is as follows Available Assigned Maximum MaximumPage Total Used Pct Max. Space Capacity Extension ReductionSizeUsable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util - - - --- - - - - 200 200 0 196 4,09650,688 254 0.5 99.6 Is it really a space problem or what could be reason ? Thanks regards Sachin Ganu IBM Global Services (I) Pvt. Ltd.
Re: One Client Two TSM Server
You may also define two entries in the dsm.sys file. Servername SERVER -- -- -- Servername SERVER2 -- -- and thus define two defferent sets of attributes. Then you have to create two separate dsm.opt files and call each time to another file. the one which is not in the default location should be called with dsmc -optfile=filename Ran. -Original Message- From: Alex Paschal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 8:25 PM To: [EMAIL PROTECTED] Subject: Re: One Client Two TSM Server You can use the -tcpserveraddress=hostname to point the client at the appropriate server. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Oliver Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:47 PM To: [EMAIL PROTECTED] Subject: One Client Two TSM Server I have installed an TSM Test Server on it so that I can try same things, but when I want to connect with the command line to the real TSM server I always change the dsm.opt for the new settings. Is this the only way ? By the way I thougth about the possibility to install a second version of the TSM Client, but the install process checkes that there is already one installed. Oli
Re: Expiring Data...in an unconventional manner
Hey. Why don't you use a different management class for that filesystem ? in the include-exclude file: Include /directory management_class then you could have other attributes for that management class... Ran. -Original Message- From: Hagopian, George [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Expiring Data...in an unconventional manner Greetings all... Interesting dilemma...I have an AIX box (unix server) that I am backing up via TSM 4.2...and I need to expire the data on a particular filesystem every 7 days but (knew that was coming) I need to keep the rest of the filesystems on the AIX box forever...is there a way to do this?...ok I know there has to be but I just don't see the lightsome one show me the light please Thank You Very Much George Hagopian ICT Group Inc AIX/TSM Admin
Re: Table Relationship
Try this query: select domain_name,set_name,class_name,destination from bu_copygroups where set_name'ACTIVE' -Original Message- From: Jolliff, Dale [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 6:42 PM To: [EMAIL PROTECTED] Subject: Table Relationship Anything out there that talks about the table relationships in TSM? I'm looking for something that will make it a little easier to generate a pretty picture/chart/graph out of the way policy/domain/managementclass/storagepools relate.
Re: TSM monitored by TME
The problem with the default rls is that the baroc does not match the rls: The old approach for TSM adapter was to create an event class for each message, which ment thousands of classes resulted with heavy load on TME. The new approach is one Server event class and one Client event class and one for each TDP. The problem is that the baroc file is built for the new approach and the rls file matches the old approach. This is on my opinion a bug or something. maybe there is a fix out there, bu I couldn't find it. Anyway, either add the classes which appear in the rls file to the baroc file or change every rule in the rls file to meet with the new approach. The first way is easier... Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We do not intend to monitor clients with TME. Just Media and Library issues. So we actually want to see all occurences. The default RLS does not compile. We are working on it. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:14 AM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME Nice to have some partners out there But I am talking about the hard way... Rules, man, Rules... Suppose you get a message like a hundred times - connection refusal or something like that. I don't want my operators to get lost in the forest... I am trying to write some. Will share when I'm done. Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We are in the process of implementing. Should be this week. We are doing message control from the TSM Server point of view by turning on which ones we want to see. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:43 AM To: [EMAIL PROTECTED] Subject: TSM monitored by TME Hello TSMers. Does any of you monitor his TSM with TME10 TEC ? I have TSM servers version 4.1, TME version 3.7 I happen to find the ibmtsm.baroc and the ibmtsm.rls files shipped with tsm 4.1 to be quite useless since they contain very few rules. Also they don't match - the rls file is still matched to an old version of baroc file in which every message has it's own class. Does anyone there has a nice set of baroc and rls files that I can use, before I'm doing a mass developement of my own? I'll appreciate it !!! Ran.
Re: TSM monitored by TME
Nice to have some partners out there But I am talking about the hard way... Rules, man, Rules... Suppose you get a message like a hundred times - connection refusal or something like that. I don't want my operators to get lost in the forest... I am trying to write some. Will share when I'm done. Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We are in the process of implementing. Should be this week. We are doing message control from the TSM Server point of view by turning on which ones we want to see. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:43 AM To: [EMAIL PROTECTED] Subject: TSM monitored by TME Hello TSMers. Does any of you monitor his TSM with TME10 TEC ? I have TSM servers version 4.1, TME version 3.7 I happen to find the ibmtsm.baroc and the ibmtsm.rls files shipped with tsm 4.1 to be quite useless since they contain very few rules. Also they don't match - the rls file is still matched to an old version of baroc file in which every message has it's own class. Does anyone there has a nice set of baroc and rls files that I can use, before I'm doing a mass developement of my own? I'll appreciate it !!! Ran.
Re: about DRM
Hi. Try move data when the backup volume is stiil out of the lib. I didn't try that, but I think it should use the original copy of files same as with reclaimation. Ran. -Original Message- From: Burak Demircan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 6:49 AM To: [EMAIL PROTECTED] Subject: about DRM Hi, I am trying to understand DRM concept especially the reclamation part. As the volumes become FULL they will be reclaimed when the data is low (define in pool's RECLAIM value) even if they are offsite copies. The primary pool volumes onsite will be used and reclaimed EMPTY copy pool volumes will be returned. Now my point comes. I have a schedule to backup primary pool every day to copy pool. I have one FILLING volume everyday to send to offsite. Then, there will be 20 volumes offsite (with FILLING status, and very little data on it) What is the DRM's solution to reclaim such volumes? Is it to bring them onsite and use MOVE DATA command? Regards, Burak
Re: q event f=d - completed time
Hi. Try in the summary table Regards, Ran. -Original Message- From: Mattice, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:02 AM To: [EMAIL PROTECTED] Subject: q event f=d - completed time What table contains this field as it is not in the events table? Thanks, Dave ADT Security Services
Backup Migrated Chached files
Hi TSMers Does Anyone have a clue: You have a primary storage pool with cached option enabled. You perform a migration to your secondary storage pool. Then you perform a backup storage pool from the secondary storage pool to your copy pool. Could it be true that TSM uses the cached files for the operation in the way it does with restore ? It is documented that when you backup the primary storage pool, tsm will not copy cached files - which means you have to copy the secondary storage pool either - that is clear. Any ideas ? Tnx. Ran
Re: Backup Migrated Chached files
I am trying to back it up before, but I have oracle servers that generates lots of archives all day long, sometimes during the migration process, which means that the high threshold for migration is still 10%. So some files get migrated before they have a chance of getting backed up to the copypool. But still they stay on the cache... I know, I will have to extend the diskpool. The real problem here is not the backup time, but I had recently some incidents, where the files had been backed up to the tape volume, and then the backup failed becuase the tape volume got damaged at the same area, and tsm could not read. Anyway, Tnx. Ran. -Original Message- From: John Naylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: Re: Backup Migrated Chached files If it is documented that it does not use cached copies for backup then I would expect it to be true. But why not copy before you migrate Then it does not matter, Ran Harel [EMAIL PROTECTED] on 05/23/2002 08:18:39 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Backup Migrated Chached files Hi TSMers Does Anyone have a clue: You have a primary storage pool with cached option enabled. You perform a migration to your secondary storage pool. Then you perform a backup storage pool from the secondary storage pool to your copy pool. Could it be true that TSM uses the cached files for the operation in the way it does with restore ? It is documented that when you backup the primary storage pool, tsm will not copy cached files - which means you have to copy the secondary storage pool either - that is clear. Any ideas ? Tnx. Ran ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
TSM monitored by TME
Hello TSMers. Does any of you monitor his TSM with TME10 TEC ? I have TSM servers version 4.1, TME version 3.7 I happen to find the ibmtsm.baroc and the ibmtsm.rls files shipped with tsm 4.1 to be quite useless since they contain very few rules. Also they don't match - the rls file is still matched to an old version of baroc file in which every message has it's own class. Does anyone there has a nice set of baroc and rls files that I can use, before I'm doing a mass developement of my own? I'll appreciate it !!! Ran.
Re: Please help me ------ ANR9999D ANR2121W alert?
Hi. I would backup the DB now... It might be corrupted! try following the actlog before the reboot and after the startup. Also take a look at the computer's system logfile. -Original Message- From: Meensun Ahn [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 1:11 PM To: [EMAIL PROTECTED] Subject: Please help me -- ANRD ANR2121W alert? Hi, All I rebooted TSM server around 3 pm as the servers were dead with some reason. But unusally I've to 4 unavailable drives as soon as rebooted, which I've never seen before. And I tried to update all the unavailable drives.then q dr command hung up and makes netcool alerts continuously. I know is critical message but in this case I don't know how to respond. The set of messages below has been repeating since the reboot.worriedT_T ANR2017I Administrator QUERY issued command: QUERY DRIVE ANRD mmstxn.c(219): ThreadId104 Lock acquisition (sLock) failed for MMS universe lock. ANR2033E QUERY DRIVE: Command failed - lock conflict. Could it have a bad impact on backup process tonight? Also this attention alert is also my concern. Does that mean backup db schedule finished with failure and I need to run it manually now? tsm: SM057q act search='ATTENTION' begint=-04:00 Date/TimeMessage -- 05/23/02 16:58:12 ANR2121W ATTENTION: More than 1553.95 MB of the database has changed and the last database backup was more than 24 hours ago. Use the BACKUP DB command to provide for database recovery. 05/23/02 17:58:12 ANR2121W ATTENTION: More than 1553.95 MB of the database has changed and the last database backup was more than 24 hours ago. Use the BACKUP DB command to provide for database recovery. 05/23/02 18:58:12 ANR2121W ATTENTION: More than 1553.95 MB of the database has changed and the last database backup was more than 24 hours ago. Use the BACKUP DB command to provide for database recovery. 05/23/02 19:58:12 ANR2121W ATTENTION: More than 1554.08 MB of the database has changed and the last database backup was more than 24 hours ago. Use the BACKUP DB command to provide for database recovery. Thanks in advance, Meensun -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Re: HACMP and password-file
Hi, ( I guess you are in active/passive HACMP resource configuration ) Haven't Tried that before with TSM, but I Would Recommand: Use three nodes: one for each basic node excluding the shared directories. one for the resource group service address (new node name), including only the shared directories, keeping the password file ( and all other tsm client files ) in a shared directory. (that way the node will go to the same place nomatter on which host you are on). You should, probably, bring up the tsm scheduler for this node as part of you start script, and bring it down with the stop script. In case you have more than one resource group, implement that for each one, assuming each could be brought up on a separate host. In case of failover, the dsm node wail fail over with the resource group... Good Luck. Ran. -Original Message- From: brian welsh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 10:57 PM To: [EMAIL PROTECTED] Subject: HACMP and password-file Hello, Server AIX 4.3.3, TSM-server 4.1.1.0 and client AIX 4.3.3 and TSM 4.1.x We have some problems with two clients using HACMP. On both clients there is a TSM-client. We use Password Access Generate. When there is a fail-over, the password-file in /etc/security/adsm is deleted and the client is trying to connect the server. This results in 10 to 20 stop and start sessions in the Activity Log and it grows so fast that in a few minutes the Activity Log is unreachable. Besides the errorlog on the client is getting very big. We know why it is happened and how to stop is, but the question is: how are sites setup TSM-clients on HACMP-systems, and how do these clients react in case of fail-over. Thanks, Brian. _ Meld je aan bij de grootste e-mailservice wereldwijd met MSN Hotmail: http://www.hotmail.com/nl
Re: logging in as a different client???
That's Simple: dsmc -machine=node name Ran. -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: logging in as a different client??? Environment: TSM Server @ V4.2 S390 Client: AIX @ 3106 and 4.2 Situation: have client A and Client B. Want to log in to TSM server from client A, but as Client B. I know the syntax on NT, could anyone help me on the AIX platform? Thx. Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]