Low scratch tape problems
Folks, Have a problem with low scratch tapes and my copypool This past weekend, my coworker successfully completed a node migration from one storage pool to another of approximately 4TB Unfortunately, when my tapepool - tapecopy script launched, it is making copies of all the new tapes that were created as well as the normal night's backups. Is there anyway to seperate the tapes that were created via the node migration and the normal night's backups? Thanks!
OFF CONTENT - Are my messages getting through?
Just trying to find if my email is getting through to thr group Thanks! [EMAIL PROTECTED]
Re: ACSLS ejects not working... help!
We had a similar problem concerning ACSLS and an SL8500 library. After troubleshooting by TSM and the SL8500 technicians, we were instructed to add the following to the dsmserv.opt file: AcsTimeoutX 15 We restarted TSM and ACSLS and everything ran fine. BTWWe have to specifiy the CAP in our MOVE statements: MOVE DRMEDIA * wherest=mo tost=va cmd=VOL w=n rem=Untileefull cap=0,1,0 Hope this helps Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Sung Y Lee [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU OM cc: Sent by: ADSM: Subject: Re: [ADSM-L] ACSLS ejects not working... help! Dist Stor Manager [EMAIL PROTECTED] .EDU 07/31/2006 03:32 PM Please respond to ADSM: Dist Stor Manager This could be just normal process. Sometimes when all TSM drives are all in use or mounted, move media command will fail. Even you tell not to check label, when label is not readable, it will still need to mount the tape into the drive for processing. Thanks, Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/31/2006 11:27:14 AM: Hello everyone, I have TSM 5.2.7.1 on AIX 5.3 and I also have an STK SL8500 with IBM LTO2 tapes/drives. I'm just doing a move media and trying to eject all of our NAS NDMP backup tapes. As you can see it is failing. My main question is: Is this a TSM server issue or a library issue? I have been doing this for over 2 years now and have not had any issues ejecting the tapes, but for the past 2 ejects the tapes ARE ejecting from the library, but within TSM it is stating that it there is a timeout issue and it doesn't update the tapes as mountablenotinlib. Any ideas/suggestions would be appreciated! Thanks! Date/Time Message -- 07/31/06 10:15:19 ANR2017I Administrator OPERATIONS issued command: MOVE MEDIA * stg=tape_ndmp_offsite wherestate=mountableinlib wherestatus=ful,fil rem=b checkl=n ovflo=Vital Records,Inc. (SESSION: 308754) 07/31/06 10:15:19 ANR0984I Process 8407 for MOVE MEDIA started in the BACKGROUND at 10:15:19. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:19 ANR0609I MOVE MEDIA started as process 8407. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:19 ANR0610I MOVE MEDIA started by OPERATIONS as process 8407. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:19 ANR2017I Administrator OPERATIONS issued command: MOVE MEDIA * stg=tape_ndmp_offsite wherestate=mountableinlib wherestatus=ful,fil rem=b checkl=n ovflo=Vital Records,Inc. (SESSION: 308755) 07/31/06 10:15:19 ANR0984I Process 8408 for MOVE MEDIA started in the BACKGROUND at 10:15:19. (SESSION: 308755, PROCESS: 8408) 07/31/06 10:15:19 ANR0609I MOVE MEDIA started as process 8408. (SESSION: 308755, PROCESS: 8408) 07/31/06 10:15:19 ANR0610I MOVE MEDIA started by OPERATIONS as process 8408. (SESSION: 308755, PROCESS: 8408) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00173 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00178 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00185 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00186 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00189 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00191 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00194 in library NASLIB starting. (SESSION: 308754, PROCESS: 8407) 07/31/06 10:15:33 ANR6696I MOVE MEDIA: CHECKOUT LIBVOLUME for volume N00246
Re: ACSLS ejects not working... help!
Yes, I was a little confused myself but I was told that there was a bug in the code that could appear using the default value. I'm not sure why 15 was used. Tivoli said that they were working on a true fix but that setting the value to 15 was a workaround for now. I also heard of another site that had the same problem and solved it the same way. Unfortunately, I do not have the contact information for that site, I was also told that this bug does not appear on each site and also that the value of 15 may not apply to your site. Both my site and the other site that applied the fix were running 9840C drives. Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Joni Moyer [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU ARK.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] ACSLS ejects not working... help! Dist Stor Manager [EMAIL PROTECTED] .EDU 08/01/2006 07:53 AM Please respond to ADSM: Dist Stor Manager Hi Dave, Thanks for the suggestions! When I looked up the definition of ACSTIMEOUTX parameter I wasn't exactly sure how this pertains to an eject for a library? Mine is currently set to 1 which is the default. So, am I to assume that it only has 600 seconds/10 min. to actually eject the tapes or to just begin ejecting them? I guess I am just not quite sure what the true meaning of this parameter is... ACSTIMEOUTX Specifies the multiple for the built-in timeout value for ACSLS APIs. The built-in timeout value for the ACS audit API is 1800 seconds; for all other ACSLS APIs it is 600 seconds. For example, if the multiple value specified is 5, the timeout value for audit API becomes 9000 seconds, and all other APIs become 3000 seconds. Syntax -ACSTIMEOUTX--value-- Parameters value Specifies the multiple for the built-in timeout value for ACSLS API. The range is from 1 to 100. The default is 1. Examples acstimeoutx 1 Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 08/01/2006 06:41 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: ACSLS ejects not working... help! We had a similar problem concerning ACSLS and an SL8500 library. After troubleshooting by TSM and the SL8500 technicians, we were instructed to add the following to the dsmserv.opt file: AcsTimeoutX 15 We restarted TSM and ACSLS and everything ran fine. BTWWe have to specifiy the CAP in our MOVE statements: MOVE DRMEDIA * wherest=mo tost=va cmd=VOL w=n rem=Untileefull cap=0,1,0 Hope this helps Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Sung Y Lee [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU OM cc: Sent by: ADSM: Subject: Re: [ADSM-L] ACSLS ejects not working... help! Dist Stor Manager [EMAIL PROTECTED] .EDU 07/31/2006 03:32 PM Please respond to ADSM: Dist Stor Manager This could be just normal process. Sometimes when all TSM drives are all in use or mounted, move media command will fail. Even you tell not to check label, when label is not readable, it will still need to mount the tape into the drive for processing. Thanks, Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/31/2006 11:27:14 AM: Hello everyone, I have TSM 5.2.7.1 on AIX 5.3 and I also have an STK SL8500 with IBM LTO2 tapes/drives. I'm just doing a move media and trying to eject all of our NAS NDMP backup tapes. As you can see it is failing. My main question is: Is this a TSM server issue or a library issue? I have been doing this for over 2 years now and have not had any issues ejecting the tapes, but for the past 2 ejects the tapes ARE ejecting from the library, but within TSM it is stating that it there is a timeout issue and it doesn't update the tapes as mountablenotinlib. Any ideas/suggestions would be appreciated! Thanks! Date/Time Message -- 07/31/06 10:15:19 ANR2017I Administrator OPERATIONS issued command: MOVE MEDIA * stg=tape_ndmp_offsite wherestate=mountableinlib
Re: Drive state is UNKNOWN (SOLVED)
Thanks! The path was off-line... I brought the path to the drive on-line. TSM took awhile but it used the drive last night successfully Thanks to all for responding so quickly! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Andy Huebner [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU ONLABS.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] Drive state is UNKNOWN Dist Stor Manager [EMAIL PROTECTED] .EDU 07/20/2006 11:33 AM Please respond to ADSM: Dist Stor Manager Any drive taken off-line then brought on-line will have a state of unknown. As long as the path is on-line TSM will use the drive. As soon as TSM uses the drive the state will change to something other than unknown. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bernaldo de Quiros, Iban 1 Sent: Thursday, July 20, 2006 5:01 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Drive state is UNKNOWN Have you tried to re-define the path of the tape drive ¿? Regards, Ibán Bernaldo de Quirós Márquez Technical Specialist cell: + 34 659 01 91 12 Sun Microsystems Iberia -Original Message- From: ADSM: Dist Stor Manager on behalf of Dave Zarnoch Sent: Wed 19/07/2006 18:05 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Drive state is UNKNOWN A couple of days ago, we had a bad tape in one of our drives. TSM reported the problem and took the drive off-line I removed the tape and brought the drive back on-line But now it shows it's state as being UNKNOWN and TSM is not using it. Anyone have a solution? Below is the query result: tsm: PROVTSMq dr C_LIBR MT8 f=d Library Name: C_LIBR Drive Name: MT8 Device Type: ECARTRIDGE On-Line: Yes Read Formats: T9840C-C,T9840C,9840-C,9840 Write Formats: T9840C-C,T9840C ACS DriveId: 0,0,1,7 Drive State: UNKNOWN Volume Name: Allocated to: WWN: 500104F0008A889E Serial Number: 50020177 Last Update by (administrator): ADMIN Last Update Date/Time: 07/17/06 06:55:48 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information
Drive state is UNKNOWN
A couple of days ago, we had a bad tape in one of our drives. TSM reported the problem and took the drive off-line I removed the tape and brought the drive back on-line But now it shows it's state as being UNKNOWN and TSM is not using it. Anyone have a solution? Below is the query result: tsm: PROVTSMq dr C_LIBR MT8 f=d Library Name: C_LIBR Drive Name: MT8 Device Type: ECARTRIDGE On-Line: Yes Read Formats: T9840C-C,T9840C,9840-C,9840 Write Formats: T9840C-C,T9840C ACS DriveId: 0,0,1,7 Drive State: UNKNOWN Volume Name: Allocated to: WWN: 500104F0008A889E Serial Number: 50020177 Last Update by (administrator): ADMIN Last Update Date/Time: 07/17/06 06:55:48 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
scratch tape question
As a result of expiration, reclamation and removal of a large storage pool. We are getting back approximately 100 scratch tapes/week We run an SL8500 library with 1600 cells of which 600 are free. Is there any difference whether I check these scratch tapes in as they arrive or place them in an inventory outside the silo. Right now we have 250 scratch tapes in the silo and use approximately 15/night. 60 more are coming in today. I can see that placing them in an inventory will require an extra step to keep the tapes in some sort of order. But, is there any disadvantages to have so many scratch tapes available in the silo? AdThanksvance! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
Re: DR and LOGANDDB.VOLUMES.INSTALL Problems (SOLVED)
Thank you all for your answers! This group is GREAT! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Mark D. Rodriguez To: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: COM Subject: Re: [ADSM-L] DR and LOGANDDB.VOLUMES.INSTALL Problems Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 03/01/2006 05:02 PM Please respond to ADSM: Dist Stor Manager Dave Zarnoch wrote: We are having some problems concerning a disaster recovery test (We already ran LOGANDDB.VOLUMES.CREATE) When we launch: LOGANDDB.VOLUMES.INSTALL Which contains: #!/bin/ksh set -x # Purpose: Initialize the log and database volumes. # Recovery Administrator: Run this to initialize the server # database and log volumes. /usr/bin/dsmserv format \ 2 file:/adsmlv/recovery/LOG.VOLUMES \ 2 file:/adsmlv/recovery/DB.VOLUMES (Each log volume is 1GB each DB volume is 2GB) LOG.VOLUMES /adsmlv02/log1.dsm /adsmlv03/log.dsm DB.VOLUMES /adsmlv02/db3.dsm /adsmlv03/db2.dsm We get: ANR0301I Recovery log format in progress; 2000 megabytes of 2000. ANR0302I Recovery log formatting took 593233 milliseconds. ANR0303I Format rate: 1726.1 pages/second. ANR0304I Page service time: 0.6 ms. ANR0305I Recovery log format complete. ANR0306I Recovery log volume mount in progress. ANR0353I Recovery log analysis pass in progress. ANR0354I Recovery log redo pass in progress. ANR0355I Recovery log undo pass in progress. ANR0352I Transaction recovery complete. ANR0992I Server installation complete. It looks like it doesn't get to the DB,VOLUMES Any help? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Dave, What you saw is normal and correct. I guess you are looking for some sort of format of the DB but that does not occur. So I would say based on what you have shown us that there are no problems with this part of the process. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting Education The very best in Technical Training and Consulting. IBM Premier Business Partner, VMware Enterprise VIP Reseller Certified Consultants and Instructors Supporting: AIX, Linux, Windows, Tivoli, Lotus, WebSphere, DB2, VMware ===
DR and LOGANDDB.VOLUMES.INSTALL Problems
We are having some problems concerning a disaster recovery test (We already ran LOGANDDB.VOLUMES.CREATE) When we launch: LOGANDDB.VOLUMES.INSTALL Which contains: #!/bin/ksh set -x # Purpose: Initialize the log and database volumes. # Recovery Administrator: Run this to initialize the server # database and log volumes. /usr/bin/dsmserv format \ 2 file:/adsmlv/recovery/LOG.VOLUMES \ 2 file:/adsmlv/recovery/DB.VOLUMES (Each log volume is 1GB each DB volume is 2GB) LOG.VOLUMES /adsmlv02/log1.dsm /adsmlv03/log.dsm DB.VOLUMES /adsmlv02/db3.dsm /adsmlv03/db2.dsm We get: ANR0301I Recovery log format in progress; 2000 megabytes of 2000. ANR0302I Recovery log formatting took 593233 milliseconds. ANR0303I Format rate: 1726.1 pages/second. ANR0304I Page service time: 0.6 ms. ANR0305I Recovery log format complete. ANR0306I Recovery log volume mount in progress. ANR0353I Recovery log analysis pass in progress. ANR0354I Recovery log redo pass in progress. ANR0355I Recovery log undo pass in progress. ANR0352I Transaction recovery complete. ANR0992I Server installation complete. It looks like it doesn't get to the DB,VOLUMES Any help? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
BACKUP DB Question
We have a TSM DB Backup that occurs every morning: Here are the results: 02/23/06 06:31:46 ANR2017I Administrator ADMIN issued command: BACKUP DB devclass=C_DEVC type=full wait=yes (SESSION: 17232) 02/23/06 06:34:46 ANR0984I Process 918 for DATABASE BACKUP started in the FOREGROUND at 06:34:46. (SESSION: 17232, PROCESS: 918) 02/23/06 06:34:46 ANR2280I Full database backup started as process 918. (SESSION: 17232, PROCESS: 918) 02/23/06 06:38:16 ANR8337I ECARTRIDGE volume 303008 mounted in drive MT0 (/dev/mt0). (SESSION: 17232, PROCESS: 918) 02/23/06 07:18:47 ANR1361I Output volume 303008 closed. (SESSION: 17232, PROCESS: 918) 02/23/06 07:18:47 ANR0515I Process 918 closed volume 303008. (SESSION: 17232, PROCESS: 918) 02/23/06 07:18:47 ANR4550I Full database backup (process 918) complete, 16707519 pages copied. (SESSION: 17232, PROCESS: 918) 02/23/06 07:18:47 ANR0985I Process 918 for DATABASE BACKUP running in the FOREGROUND completed with completion state SUCCESS at 07:18:47. (SESSION: 17232, PROCESS: 918) 02/23/06 07:18:47 ANR0405I Session 17232 ended for administrator ADMIN (AIX). (SESSION: 17232) We are using 9840 tape cartridges in an SL8500 tape silo running Server Version 5, Release 3, Level 1.2 I'm a little bit leary that it also tells me that it fit the backup on 1 tape. Is there some special compression going on? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
Re: BACKUP DB Question
I calculated that our DB is @61GB The manufacturer says the tape can hold 50GB compressed What do you think is happening? Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] BACKUP DB Question Manager [EMAIL PROTECTED] .EDU 02/23/2006 10:01 AM Please respond to ADSM: Dist Stor Manager On Feb 23, 2006, at 9:50 AM, Dave Zarnoch wrote: We have a TSM DB Backup that occurs every morning: ... 02/23/06 07:18:47 ANR4550I Full database backup (process 918) complete, 16707519 pages copied. (SESSION: 17232, PROCESS: 918) ... I'm a little bit leary that it also tells me that it fit the backup on 1 tape. ... Dave - If you do 'Query DB Format=Detailed' you will see your db page size and thereby can compute the actual amount of space required on the backup volume. Compare that with your technology specs, and take into consideration compression which may be in effect per your Devclass. Richard Sims
Re: BACKUP DB Question
I understandbut the money man doesn't... :0) We are using 9840C drives Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] BACKUP DB Question Manager [EMAIL PROTECTED] .EDU 02/23/2006 11:47 AM Please respond to ADSM: Dist Stor Manager On Feb 23, 2006, at 10:48 AM, Dave Zarnoch wrote: I calculated that our DB is @61GB The manufacturer says the tape can hold 50GB compressed What do you think is happening? Magic. Your posting did not specify which level of 9840 drive/cartridge technology is being used. I'll then assume 9840A. Info I found online says of the basic 9840: The native 20GB cartridge capacity can be significantly extended by StorageTek's enhanced LZ-1 compression technology (4:1 compression is typical). As your concerns express, however, you are near the edge of a cliff, and the best general advice in life is Stay away from the edge. I would pursue modernization of tape technologies there. If demands pushed your TSM db further, you might consider firing up a second TSM server. Richard Sims
Re: Automating server scripts
Through the GUI: Operation View Automate Operations Or you can use cron. Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Timothy Hughes [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU TATE.NJ.US cc: Sent by: ADSM: Dist Subject: [ADSM-L] Automating server scripts Stor Manager ADSM-L@VM.MARIST.EDU 02/08/2006 08:47 AM Please respond to ADSM: Dist Stor Manager Hello, Does anyone know of a way to Automate sever scripts to run on there own?? I have scripts set up that I would like to run say every two hours. I know to run a script you would use the run command but can that be automated? TSM 5.3.2.1 AIX 5.3 Thanks for any help or suggestions Regards
Re: Full backup direct from client server
Wouldn't a dsmc sel work? Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Allen S. Rout [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] Full backup direct from client server Manager [EMAIL PROTECTED] .EDU 02/06/2006 09:49 AM Please respond to ADSM: Dist Stor Manager On Sun, 5 Feb 2006 21:31:17 +1100, Paul Dudley [EMAIL PROTECTED] said: Is it possible to schedule a full client server backup onto tape where the data comes direct from the client server? From my understanding of the gen backupset command it appears that it grabs the server data from existing backups already on tape. I would prefer to get the data direct from the client server as I have had a lot of problems with the gen backupset command. There've been several suggestions about defining new nodes. I would add an observation that you're not going to change much of the process by cutting a backupset off a new node. If your problems with gen backupset have to do with bad media on which current data is stored, then taking a new 'full' of the box will certainly help. But you might want to consider addressing the bad-data problem also / instead (copypools?). Similarly, if you feel there's some problem with the distribution of data amongst your primary volumes, a new backup could help, but again you might want to rethink things like collocation. But other than that, you will be placing yourself in an analogous logical position before you start the gen backupset; a good incremental, data in your TSM server, etc. The backupset is generated from current primary data on the TSM server, and not directly from the client box. So I'd expect you to encounter the same problem when you try to gen backupset from the new node. This could end up being immensely frustrating, especially if the node is large and taking the new copy is inconvenient. - Allen S. Rout
redirect output in readable format
Simple question? When I do a $TSMCMD q vol 302302 f=d result from a UNIX command line. I get the file result in unformatted output. How do I redirect the command from TSM to a file in readable format from a UNIX command line? Yes.i have read the manual and have searched the web for this already. Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: redirect output in readable format
The -displaymode=list worked great! When I tried -dataonly=yes I got: ANS8017E Command line parameter 3: 'dataonly=yes' is not valid. ANS8002I Highest return code was 9. I'm running TSM Ver 5.3.1.2 Is that the problem? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 David E Ehresman [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU LLE.EDU cc: Sent by: ADSM: Subject: Re: [ADSM-L] redirect output in readable format Dist Stor Manager [EMAIL PROTECTED] .EDU 01/31/2006 09:22 AM Please respond to ADSM: Dist Stor Manager Not sure I know what you mean by unformated output but try the -displaymode=list|table parm. David [EMAIL PROTECTED] 01/31/06 8:28 AM Simple question? When I do a $TSMCMD q vol 302302 f=d result from a UNIX command line. I get the file result in unformatted output. How do I redirect the command from TSM to a file in readable format from a UNIX command line? Yes.i have read the manual and have searched the web for this already. Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: redirect output in readable format
The server is at 5.3.1.2 But, the Command Line Interface is: Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 1.25 Sooo...I need to upgrade the client on the server? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] redirect output in readable format Manager [EMAIL PROTECTED] .EDU 01/31/2006 10:01 AM Please respond to ADSM: Dist Stor Manager On Jan 31, 2006, at 9:49 AM, Dave Zarnoch wrote: The -displaymode=list worked great! When I tried -dataonly=yes I got: ANS8017E Command line parameter 3: 'dataonly=yes' is not valid. ANS8002I Highest return code was 9. I'm running TSM Ver 5.3.1.2 Is that the problem? Is it your server that is 5.3.1.2 or your dsmadmc client? -DATAOnly was introduced at the 5.2 client level. Richard Sims
Re: redirect output in readable format(SOLVED)
Got it. My bad I thought that the 'command line interface was running from the server section of the software not the client. But now I see in /usr/bin: dsmadmc - /usr/tivoli/tsm/client/ba/bin/dsmadmc as opposed to dsmfmt - /usr/tivoli/tsm/server/bin/dsmfmt Thanks for the clarification Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Andrew Raibeck [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU OM cc: Sent by: ADSM: Subject: Re: [ADSM-L] redirect output in readable format Dist Stor Manager [EMAIL PROTECTED] .EDU 01/31/2006 10:32 AM Please respond to ADSM: Dist Stor Manager I don't understand this question: Sooo...I need to upgrade the client on the server? Can you elaborate on what you mean by client on the server? You are using the program dsmadmc.exe that is packaged with the backup-archive client, rght? You need to use an admin command line interface that supports the -dataonly=yes option, as Richard pointed out. The machine on which you run the admin interface is immaterial. Note that 4.2 is long out of support. You should get your clients updated to more current levels. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/31/2006 08:19:56 AM: The server is at 5.3.1.2 But, the Command Line Interface is: Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 1.25 Sooo...I need to upgrade the client on the server? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM- L] redirect output in readable format Manager [EMAIL PROTECTED] .EDU 01/31/2006 10:01 AM Please respond to ADSM: Dist Stor Manager On Jan 31, 2006, at 9:49 AM, Dave Zarnoch wrote: The -displaymode=list worked great! When I tried -dataonly=yes I got: ANS8017E Command line parameter 3: 'dataonly=yes' is not valid. ANS8002I Highest return code was 9. I'm running TSM Ver 5.3.1.2 Is that the problem? Is it your server that is 5.3.1.2 or your dsmadmc client? -DATAOnly was introduced at the 5.2 client level. Richard Sims
Re: query libv confusion
I once did an audit on the library within ACSLS, and it took about 3 minutes. Is there a special audit that I need to perform? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 Gerald Michalak [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] query libv confusion Dist Stor Manager [EMAIL PROTECTED] .EDU 01/26/2006 05:54 PM Please respond to ADSM: Dist Stor Manager You will need to do 2 audits, 1 within the ACSLS software and 1 from TSM. The rule of thumb I have is that the ACSLS audit will take about 5 seconds per tape. ( 12 tapes per minute, 800 / 12 = 66.67 minutes ) just over an hour. Then the TSM audit library should simply exchange data with the ACSLS server, a few minutes I would guess. Gerald Michalak [EMAIL PROTECTED] ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/26/2006 12:48:31 PM: Thanks Wanda! BTWHow long do you think it would take to audit the library (through TSM) It has 800 tapes It is an ACSLS StorageTek library. 9840C Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Prather, Wanda [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU UAPL.EDUcc: Sent by: ADSM: Subject: Re: [ADSM- L] query libv confusion Dist Stor Manager [EMAIL PROTECTED] .EDU 01/26/2006 12:56 PM Please respond to ADSM: Dist Stor Manager Yep. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: Thursday, January 26, 2006 12:54 PM To: ADSM-L@VM.MARIST.EDU Subject: query libv confusion I have some tapes that show up when I do a q libv as private However. they are not physically present in the silo and show up as full offsite Vault when I do a q vol I have also confirmed that they are off-site. Can I just do a checkout libv lib tape checkl=no rem=no? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
query libv confusion
I have some tapes that show up when I do a q libv as private However. they are not physically present in the silo and show up as full offsite Vault when I do a q vol I have also confirmed that they are off-site. Can I just do a checkout libv lib tape checkl=no rem=no? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: query libv confusion
Thanks Wanda! BTWHow long do you think it would take to audit the library (through TSM) It has 800 tapes It is an ACSLS StorageTek library. 9840C Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] Prather, Wanda [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU UAPL.EDUcc: Sent by: ADSM: Subject: Re: [ADSM-L] query libv confusion Dist Stor Manager [EMAIL PROTECTED] .EDU 01/26/2006 12:56 PM Please respond to ADSM: Dist Stor Manager Yep. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: Thursday, January 26, 2006 12:54 PM To: ADSM-L@VM.MARIST.EDU Subject: query libv confusion I have some tapes that show up when I do a q libv as private However. they are not physically present in the silo and show up as full offsite Vault when I do a q vol I have also confirmed that they are off-site. Can I just do a checkout libv lib tape checkl=no rem=no? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Mixed up libraries
We have somehow screwed up the state of some of our tapes; We had an old library called EAGLELIB which we were sure we migrated all of the tapes over to the new library C_LIBR But we found some EAGLELIB tapes that are duplicates of C_LIBR tapes (e.g.) Tape 300410 q libv EAGLELIB 300410 Library Name Volume Name Status Owner Last Use Home Device Cleanings Left Media Type Element Type --- -- -- - --- -- -- -- EAGLELIB 300410 Private q libv C_LIBR 300410 Library Name Volume Name Status Owner Last Use HomeDevice Element Type --- -- -- - --- -- C_LIBR 300410 Private Data q vol 300410 Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status --- -- - - 300410 C_EAGLETAPE C_DEVC 61,171.3 99.2 Full Which is OK because C_EAGLETAPE is a storage pool in C_LIBR How do w get rid of the EAGLELIB version? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
ssh location?
Can someone tell me where I can get ssh for AIX? I keep getting redirected to IBM when I try different mirrors? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: ssh location?
Whoopswrong group Sorry :0( Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 - Forwarded by David Zarnoch/HOM/NWP on 01/11/2006 06:43 AM - David Zarnoch To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 01/11/2006 06:42 cc: AM Subject: ssh location?(Document link: David Zarnoch) Can someone tell me where I can get ssh for AIX? I keep getting redirected to IBM when I try different mirrors? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Amount of data backed up per node
I want to print out the amount of data that each node backs up daily. I have a macro that I THOUGHT was working properly but some nodes are now showing 0 MB transferred when I know his is not true. Here's the macro: SELECT entity AS Node name,CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS MB xfer FROM sum mary WHERE activity='BACKUP' AND start_time=current_timestamp - 24 hours GROUP BY entity What's wrong with this? Server Version 5, Release 1, Level 6.2 Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: Amount of data backed up per node
I tried the macro that Ben sent, with the same results, there DOES appear to be a bug. Thanks! Does anyone know a way around besides upgrading? Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 David E Ehresman [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU LLE.EDU cc: Sent by: ADSM: Subject: Re: [ADSM-L] Amount of data backed up per node Dist Stor Manager [EMAIL PROTECTED] .EDU 01/10/2006 12:59 PM Please respond to ADSM: Dist Stor Manager You're on an old version of the server code. Somewhere back around that level there was a bug that made the data in the summary table unreliable. You may be seeing that bug. David [EMAIL PROTECTED] 01/10/06 12:32 PM I want to print out the amount of data that each node backs up daily. I have a macro that I THOUGHT was working properly but some nodes are now showing 0 MB transferred when I know his is not true. Here's the macro: SELECT entity AS Node name,CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS MB xfer FROM sum mary WHERE activity='BACKUP' AND start_time=current_timestamp - 24 hours GROUP BY entity What's wrong with this? Server Version 5, Release 1, Level 6.2 Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
MAX command line Objects?
Folks, I attempted a selective backup of one of my servers and tried to list all of the filesystems on the command line, but it gave me an error that there were too many objects parsed to the command I had to split them up. Does anyone know how many objects is the max? (e.g.) sel -subdir=yes /usr/* /opt/* etc Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Full backup?
Probably a FAQ, but... We are planning a DR this weekend and I would like to limit the number of tapes we bring by getting a full backup of the system (Level 0) (I knowcheatercheater) Do I just modify the GUI settings from incremental to selective? Then, in the file space just put in / Sounds too simple. Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Insufficient space in storage pool?
I was attempting to start a reclamation of an offsite copy pool update stg EAGLENOTESCOPY reclaim=85 and rec'd the following message: 11/22/05 08:09:54 ANR1086E Space reclamation is ended for volume 308250. There is insufficient space in storage pool. (PROCESS: 383) Here's the info on the pool: Storage Pool Name: EAGLENOTESCOPY Storage Pool Type: Copy Device Class Name: EGL9840 Estimated Capacity: 146,931 G Space Trigger Util: Pct Util: 61.1 Pct Migr: Pct Logical: 100.0 High Mig Pct: Low Mig Pct: Migration Delay: Migration Continue: Migration Processes: Reclamation Processes: 1 Next Storage Pool: Reclaim Storage Pool: Maximum Size Threshold: Access: Read/Write Description: Lotus Notes Offsite Copy Overflow Location: Cache Migrated Files?: Collocate?: No Reclamation Threshold: 100 Offsite Reclamation Limit: No Limit Maximum Scratch Volumes Allowed: 5,000 Number of Scratch Volumes Used: 3,754 Delay Period for Volume Reuse: 0 Day(s) Migration in Progress?: Amount Migrated (MB): Elapsed Migration Time (seconds): Reclamation in Progress?: No Last Update by (administrator): ADMIN Last Update Date/Time: 11/22/05 08:19:02 Storage Pool Data Format: Native Copy Storage Pool(s): Continue Copy on Error?: CRC Data: No Reclamation Type: Threshold Any help on debugging this? There's not a lot of info about this on Google Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
Re: STATUS_IPC_FAILURE SOLVED
We have solved the problem. It turms out to be a bug in TSM The problem was determined as a bug in TSM which flagged the vaue ACS_TIMEOUTX=100 as invalid. The value has been changed to 15 per TSM support An APAR will be generated by TSM support Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 Bernd Wiedmann [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU EK.DE cc: Sent by: ADSM: Subject: [ADSM-L] Antw: [ADSM-L] STATUS_IPC_FAILURE Dist Stor Manager [EMAIL PROTECTED] .EDU 11/08/2005 04:23 AM Please respond to ADSM: Dist Stor Manager hi, is your ssi-daemon running?? Bernd Wiedmann IT-Spezialist Gmünder Ersatzkasse GEK Abteilung Information und Kommunikation Gottlieb-Daimler-Str. 29 D-73529 Schwäbisch Gmünd E-Mail: [EMAIL PROTECTED] Internet: http://www.gek.de Telefon: +49 (7171) 801-1707 Telefax: +49 (7171) 801-706 [EMAIL PROTECTED] 07.11.2005 21:10:15 Anybody see this: 11/07/05 14:06:44 ANR8856E ACSAPI sequence(1) request(0) timed out, elapse time=00:01:01. 11/07/05 14:06:44 ANR8855E ACSAPI(acs_query_server) response with unsuccessful status, status=STATUS_IPC_FAILURE. 11/07/05 14:06:44 ANR8855E ACSAPI(acs_query_server) response with unsuccessful status, status=STATUS_IPC_FAILURE. Whenever we try to do a tape operation We have a StorageTEK SL8500 We are running TSM Ver 5.3.1.2 on AIX 5 We are running ACSLS between the TSM server and tape silo We are also running two libraries as a result of a problem with StorageTek drives Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
STATUS_IPC_FAILURE
Anybody see this: 11/07/05 14:06:44 ANR8856E ACSAPI sequence(1) request(0) timed out, elapse time=00:01:01. 11/07/05 14:06:44 ANR8855E ACSAPI(acs_query_server) response with unsuccessful status, status=STATUS_IPC_FAILURE. 11/07/05 14:06:44 ANR8855E ACSAPI(acs_query_server) response with unsuccessful status, status=STATUS_IPC_FAILURE. Whenever we try to do a tape operation We have a StorageTEK SL8500 We are running TSM Ver 5.3.1.2 on AIX 5 We are running ACSLS between the TSM server and tape silo We are also running two libraries as a result of a problem with StorageTek drives Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
DR tapes not changing states
Folks, We are in the process of moving from a l700 StorageTek lib to a l8500 lib using ACSLS and doing some testing. When we issue the following command: MOVE DRMEDIA * wherest=mo tost=va cmd=VOL w=n rem=Untileefull cap=0,1,0 The system responds: 10/19/05 05:50:37 ANR6696I MOVE DRMEDIA: CHECKOUT LIBVOLUME for volume 309069 in library 8500 starting. (SESSION: 1923, PROCESS: 41) The tape is ejected into the cap but the state stays as MountableinLib and doesn't change to vault Anyone see this before? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Re: DR tapes not changing states
Yeah... We just ran a test and confirmed that if you immediately remove the tapes, TSM changes the state. Unfortunately, we got an I/O error from ACSLS before we removed them the first time so TSM never changed the state Must be a way to change the ACSLS time-out? Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 Gerald Michalak [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] DR tapes not changing states Dist Stor Manager [EMAIL PROTECTED] .EDU 10/19/2005 11:13 AM Please respond to ADSM: Dist Stor Manager I've seen this before with ACSLS, and TSM doesn't finish the move, and change the status, until the tapes are removed from the CAP slots on the library. Gerald Michalak 630-691-4819 pager 800-759-8352 # 1076423 AIX - Certified Support Technician ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/19/2005 09:13:23 AM: Folks, We are in the process of moving from a l700 StorageTek lib to a l8500 lib using ACSLS and doing some testing. When we issue the following command: MOVE DRMEDIA * wherest=mo tost=va cmd=VOL w=n rem=Untileefull cap=0,1,0 The system responds: 10/19/05 05:50:37 ANR6696I MOVE DRMEDIA: CHECKOUT LIBVOLUME for volume 309069 in library 8500 starting. (SESSION: 1923, PROCESS: 41) The tape is ejected into the cap but the state stays as MountableinLib and doesn't change to vault Anyone see this before? Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
Would like some advice for TSM server upgrade
Folks, We are soon planning to upgrade our version of TSM from: Server Version 5, Release 1, Level 6.2 To: Server Version 5, Release 3, Level 1.2 Any bumps in the road Any advice? I have also opened a call with TSM service but, would like to hear some other information if possible Thanks! Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
TSM Ver 5.3.1.2 and DBs
Folks, We're about to upgrade to TSM version 5.3.1.2 Anyone experience any gotchas with the following environments: Oracle Informix SQL BackTrack (Tivoli has been very closed lipped) Thanks! DaveZ Dave Zarnoch Nationwide Provident [EMAIL PROTECTED]
Re: TSM Ver 5.3 and ACSLS (SOLVED)
Thanks! I actually found out that there were some minor problems with TSM ver 5.3.1.0 but were fixed in 5.3.1.1 Here's the email that was posted to this group on 04/08/05 by a TSM representative: APAR IC45703 resolves an issue where ACSLS libraries are unable to mount scratch volumes. ACLSL libraries will fail to mount scratch volumes, though private volumes can be successfully mounted. Any attempt to mount a scratch volume will fail with the following error: ANR1405W Scratch volume mount request denied - no scratch volume available. If your tape library is ACSLS, please wait to install 5.3.1.0 until 5.3.1.1 is available where this problem is corrected. We are in the process of refreshing the README on the FTP site indicating that this level should not be installed by customers using ACSLS libraries. We apologize for this inconvenience. Thanks again! DaveZ TSM_User [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU OM cc: Sent by: ADSM: Subject: Re: [ADSM-L] TSM Ver 5.3 and ACSLS Dist Stor Manager [EMAIL PROTECTED] .EDU 08/25/2005 11:50 PM Please respond to ADSM: Dist Stor Manager TSM has been able to connect to an STK library running ACSLS since V5.1. New in V5.3 is the ability to share the library between two or more TSM instances within TSM. Prior to V5.3 you had to purchase EDT to share drives in an STK library controlled by ACSLS. I haven't seen anything posted about not supporting ACSLS in V5.3. Dave Zarnoch [EMAIL PROTECTED] wrote: Folks, I remember seeing an email previously announcing that TSM Ver 5.3 and ACSLS is not supported at this time. Am I correct? Thanks! DaveZ - Start your day with Yahoo! - make it your home page
Re: TSM Ver 5.3 and ACSLS (SOLVED)
Folks, Thanks! This was also confirmed from Tivoli support. DaveZ Neil Schofield [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU ATER.CO.UK cc: Sent by: ADSM: Dist Stor Subject: Re: [ADSM-L] TSM Ver 5.3 and ACSLS Manager ADSM-L@VM.MARIST.EDU 08/26/2005 05:09 AM Please respond to ADSM: Dist Stor Manager Dave I think ACSLS support got broken in 5.3.1.0, but was fixed again in 5.3.1.1. The relevant APAR is IC45703. Regards Neil Schofield Yorkshire Water Services Ltd Check out our new website at http://www.yorkshirewater.com YORKSHIRE WATER - WINNER OF THE UTILITY OF THE YEAR AWARD The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House Halifax Road Bradford BD6 2SZ Registered in England and Wales No 2366682
TSM Ver 5.3 and ACSLS
Folks, I remember seeing an email previously announcing that TSM Ver 5.3 and ACSLS is not supported at this time. Am I correct? Thanks! DaveZ
Re: Mountable not in library SOLVED
Richard, Thanks!!! Here's what I did... tsm: PROVTSMmove media 307119 stg=eagletape wherestate=MOUNTABLENotinlib WHERESTATUs=FULl tsm: PROVTSMcheckin libvol eaglelib search=yes checklabel=barcode status=private The volume is now available and mounted in the library DaveZ Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] Mountable not in library Manager [EMAIL PROTECTED] .EDU 08/11/2005 08:40 AM Please respond to ADSM: Dist Stor Manager On Aug 10, 2005, at 2:08 PM, Dave Zarnoch wrote: Folks, Don't know how this may have happened, but I have several tapes listed as the following: Volume Name: 307556 State: Mountable not in library Location: ? I have verified that they are physically present in the library I tried to reset them using move media, but it cannot find the tape to make the transition These tapes are full and are marked as readwrite How do I get TSM to see them again? Dave - We're handicapped in not knowing the cannot find error message or Move Media command used or library type; but if you got an ANR6691E error, follow the advice in ADSM QuickFacts and specify WHERESTATUs=FULl for the command to work. I would research the Activity Log per the timestamps in Query MEDia Format=Detailed to see what went on then, to prevent further burbles. Richard Sims
Mountable not in library
Folks, Don't know how this may have happened, but I have several tapes listed as the following: Volume Name: 307556 State: Mountable not in library Location: ? I have verified that they are physically present in the library I tried to reset them using move media, but it cannot find the tape to make the transition These tapes are full and are marked as readwrite How do I get TSM to see them again? Thanks! DaveZ
decrease in return tapes
Folks, Lately, I have noticed that our weekly return of tapes from our storage facility has decreased from about 120 tapes to about 40 tapes. Can anybody point me in the right direction to investigate possible problems? Thanks! DaveZ
formatted output
Folks, Probably a FAQ but.. How would I execute a select statement to send data to an external file and make it readable? Here is an example: select * from volumes where access='UNAVAILABLE' and location is null /tmp/outfile the outfile looks like this: VOLUME_NAMESTGPOOL_NAME DEVCLASS_NAME EST_CA PACITY_MB PCT_UTILIZED STATUS ACCESS PCT _RECLAIM SCRATCHERROR_STATENUM_SIDES TIMES_M OUNTED WRITE_PASSLAST_WRITE_DATE LAST_READ_DATE P ENDING_DATE WRITE_ERRORS READ_ERRORS LOCATION CHG_TIME CHG_ADMIN -- -- -- --- - -- -- --- -- -- - --- -- --- -- -- --- --- --- -- -- -- 303028 EAGLETAPE EGL9840 20959.7 6.2 FULL UNAVAILABLE 93.7 YesNo 1 27 1 2005-06-16 2005-07-07 0 0 2005-07-07 ADMIN etc. Thanks! DaveZ
Discrepancy select vs. q act
FolksI have a problem when creating a report: Using q act begind=-1 se=PROV1010: 06/23/05 02:19:35 ANE4961I (Session: 201, Node: PROV1010) Total number of bytes transferred: 2.14 GB Using select * from summary: START_TIME: 2005-06-23 00:48:03.00 END_TIME: 2005-06-23 02:19:35.00 ACTIVITY: BACKUP NUMBER: 201 ENTITY: PROV1010 COMMMETH: Tcp/Ip ADDRESS: 172.28.254.70:32385 SCHEDULE_NAME: PROV1010 EXAMINED: 1103951 AFFECTED: 2727 FAILED: 2 BYTES: 0 IDLE: 0 MEDIAW: 0 PROCESSES: 1 SUCCESSFUL: YES VOLUME_NAME: DRIVE_NAME: Why is the select statement giving me 0 bytes instead of 2.14GB Am I missing something here? Thanks! DaveZ
Re: Discrepancy select vs. q act
Sorry. Server Version 5, Release 1, Level 6.2 DaveZ Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: Re: [ADSM-L] Discrepancy select vs. q act Manager [EMAIL PROTECTED] .EDU 06/23/2005 10:09 AM Please respond to ADSM: Dist Stor Manager When posting such questions, please include the level of the software involved, as the problem may be corrected in an available APAR... See APAR IC34462 as a possible fix for this. Richard Sims On Jun 23, 2005, at 9:56 AM, Dave Zarnoch wrote: FolksI have a problem when creating a report: Using q act begind=-1 se=PROV1010: 06/23/05 02:19:35 ANE4961I (Session: 201, Node: PROV1010) Total number of bytes transferred: 2.14 GB Using select * from summary: START_TIME: 2005-06-23 00:48:03.00 END_TIME: 2005-06-23 02:19:35.00 ACTIVITY: BACKUP NUMBER: 201 ENTITY: PROV1010 COMMMETH: Tcp/Ip ADDRESS: 172.28.254.70:32385 SCHEDULE_NAME: PROV1010 EXAMINED: 1103951 AFFECTED: 2727 FAILED: 2 BYTES: 0 IDLE: 0 MEDIAW: 0 PROCESSES: 1 SUCCESSFUL: YES VOLUME_NAME: DRIVE_NAME: Why is the select statement giving me 0 bytes instead of 2.14GB Am I missing something here? Thanks! DaveZ
reclamation tape predicting (SUMMARY)
To all Thanks for all of your GREAT suggestions!! I have been having good success with Bill's suggestion... Basically this is what I do: After expiration and migration is finished: Change the MOUNTWAIT on the devclass to 1 Change all of the tapes on the overflow shelf to status of readw Run reclamation for about two hours without intervention. Stop reclamation and search the act log for all unavailable tapes. Change the status of these tapes to readw Check these tapes into the library Change the MOUNTWAIT on the devclass back to normal Restart reclamation (Of course, I control all of this through scripts) This has reduced my manual insertion times from about 20/day to about 3/day What a difference! Thanks again! DaveZ Bill Dourado [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU TEC.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] reclamation tape predicting Dist Stor Manager [EMAIL PROTECTED] .EDU 06/07/2005 11:22 AM Please respond to ADSM: Dist Stor Manager Few years back I was in a similar suitation. I had 300 online tapes but only 60 slots. I first of all made sure that I only would perform restores ! I left all the online tapes that couldn't be housed in the library as available close by. They were mostly full and readonly. When I needed to do reclamation I used to set mountwait to 1 minute, so that after one minute if tape was available reclamtation would end. UPDATE DEVCLASS device-class_name MOUNTWAIT=1 UPDATE STG COPYTAPEPOOL RECLAIM=60 Ran reclamtion for a while, say 30 mins, and ended up with a list of tapes required, from the activity log. UPDATE STG COPYTAPEPOOL RECLAIM=100 I then checked in the tapes made them available and repeated reclamation. I similarly ran large restores, with restores always remembering to update mountwait to 60 or even longer, after the first trial run . Bill Matthew Large [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 07/06/2005 15:03 Please respond to ADSM: Dist Stor Manager To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: [ADSM-L] reclamation tape predicting Same situation here, but we have 120 tapes in our 60 slot 3583. When space reclamation runs, it fails everyday, so they take a list of tapes TSM asked for, get them off the shelf, and check them all in. I think this was asked a very long time ago, and there was no real answer - you'll have to run it to acquire a list of required volumes. ..unless there IS in fact a way of determining these volumes.. It would be great to hear it. Matthew Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 07/06/2005 14:55 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] reclamation tape predicting Oh mighty gurus. We have had to relocate some of our tapes to an overflow location because of our silo capacity. I basically mark them as unavailable and shelf. When reclamation starts, I redefine some of the tapes to readw and wait to see if TSM calls for them. I then have to physically insert them into the silo for each request. Is there anyway to query TSM to generate a list of tapes that it will require for reclamation? That way, I can redefine just those tapes and load them all at once into the library. Thanks! DaveZ Aviva plc Registered Office: St. Helen's, 1 Undershaft, London EC3P 3DQ Registered in England Number 02468686 www.aviva.com This message and any attachments are confidential. If you are not the intended recipient, please telephone or e-mail the sender and delete this message and any attachment from your system. Also, if you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
reclamation tape predicting
Oh mighty gurus. We have had to relocate some of our tapes to an overflow location because of our silo capacity. I basically mark them as unavailable and shelf. When reclamation starts, I redefine some of the tapes to readw and wait to see if TSM calls for them. I then have to physically insert them into the silo for each request. Is there anyway to query TSM to generate a list of tapes that it will require for reclamation? That way, I can redefine just those tapes and load them all at once into the library. Thanks! DaveZ
Confused about reclamation
Folks, I'm a little confused about space reclamation... I ran out of empty slots in my silo so I had to move some tapes to a shelf location. I was really careful to only move tapes that TSM says are full and 100% utilized. I now see a request for one of those tapes for space reclamation. 1 - Why is TSM calling for this tape? 2 - Should I mark all of my tapes on the shelf as unavailable? (I hesitate to do this because of problems that may occur if a restore is called that needs this tape) 3 - What will happen when expiration runs? (Will the tapes be called for?) Thanks! DaveZ
silo slots filling up quickly
Folks, Unfortunately our library is running out of slots very quickly and we are not gaining many scratch tapes even though we are very aggressive with reclamation. I have been relocating tapes to an external rack giving the condition: wherestatus=Full and days=120 However, the system has recently been asking for many of these tapes to be inserted back into the library for reclamation. Does anyone have any advice on which tapes that are the best to remove from the active silo into a storage rack? Thanks again! DaveZ
Re: Scratch tape questions
John, Thanks! It's been very helpful... A question on reclamation I have the following occurring constantly during reclamation: 05/17/05 11:41:12 ANR1040I Space reclamation started for volume 304048, storage pool EAGLECOPY (process number 8619). 05/17/05 11:50:02 ANR1163W Offsite volume 304048 still contains files which could not be moved. 05/17/05 11:50:02 ANR1041I Space reclamation ended for volume 304048. This has occurred for 8 tapes in the last 24 hours. Why is TSM attempting to use this tape for reclamation when it has been labeled as vault and is offsite? Thanks! DaveZ Talafous, John [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU RBEE.COMcc: Sent by: ADSM: Subject: Re: [ADSM-L] Scratch tape questions Dist Stor Manager [EMAIL PROTECTED] .EDU 05/13/2005 04:13 PM Please respond to ADSM: Dist Stor Manager I always say, The only naïve/stupid/dumb question you have is the one you don't ask. 1.) Previously answered by Mr. Stapleton 2.) There are ways to manually audit (and I have done this) the various entries for TSM Tapes. Tapes are either in the DRMEDIA inventory and offsite, onsite and used by a storage pool, offsite and unused or onsite and unused. This is a complex process and must be approached carefully. But very doable!!! Contact me if you desire additional information. 3.) Run an SQL SELECT statement to list your environment's tape inventory. I like to look at volumes used by STGPOOL as well as TSM Library inventory levels. A: Volumes used by STGPOOL: select stgpool_name,devclass_name,count(*) as VOLUMES from volumes group by stgpool_name,devclass_name NOTE: This will list volumes for ALL device classes, not just tape. B: TSM Library inventory: select count(*) as Volumes,status,library_name,owner,last_use from libvolumes group by library_name,owner,status,last_use NOTE: This will report volumes used in a TSM Library sharing environment. If NOT in library sharing, you may have to alter accordingly. Watch your stgpool volume utilizations from #3.a and your scratch count availability from #3.b. Hopefully, you are able to maintain a healthy scratch count. If not, these queries will let you know. You could also add a report to show reclamation opportunities by storage pool to assist determining where to focus your reclamation efforts. John G. Talafous Berbee Information Networks [EMAIL PROTECTED] http://www.berbee.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: Friday, May 13, 2005 12:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Scratch tape questions I hope these aren't naive questions. 1 - How do I know if there are any tapes at the offsite
Re: Scratch tape questions SOLVED
Dave, YOU DA MAN! I ran the command and found UNAVAILABLE tapes. These tapes were located in an overflow location in our server room. I issued the command: upd vol VOL access=readw Now, TSM is requesting the tapes and awaiting mounts. I think what happened was: A prior admin had checked out some tapes to an overflow location but did not monitor the system for requests. I created a script that emails me when a request is generated. The tapes that were marked UNAVAILABLE were created after TSM gave up on the requests in the past. Sound right? Thanks! DaveZ David E Ehresman [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU LLE.EDU cc: Sent by: ADSM: Subject: Re: [ADSM-L] Scratch tape questions Dist Stor Manager [EMAIL PROTECTED] .EDU 05/18/2005 10:53 AM Please respond to ADSM: Dist Stor Manager Why is TSM attempting to use this tape for reclamation when it has been labeled as vault and is offsite? Its not. TSM is trying to using the primary pool version of the data to recreated the copy pool version of the data and is unable to do so because it is not for some reason able to read the primary pool version of the data. Check to see if you have any primary pool tapes that are UNAVAILABLE (q vol access=unavail) or whether the primary pool tapes are being used by other processes when the reclaim is running. David Ehresman University of Louisville
Scratch tape questions
I hope these aren't naive questions. 1 - How do I know if there are any tapes at the offsite storage that should be onsite and be available for scratch? This includes DB backups and normal backups. 2 - How would I tell if TSM is actually processing tapes correctly? (e.g.) From vault -- vault retrieve -- courier -- courier retrieve 3 - How do I know if reclamation is actually increasing the scratch count? Thanks! DaveZ
Excluding Command Line verbiage
Folks, Sorry if this is a FAQ.. How do I exclude the Command Line Administrative Interface verbiage when I run a command? Thanks! DaveZ
Re: [spam] Excluding Command Line verbiage
Thanks! DaveZ David McClelland [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU EUTERS.COMcc: Sent by: ADSM:Subject: Re: [ADSM-L] [spam] Excluding Command Line verbiage Dist Stor Manager [EMAIL PROTECTED] DU 05/11/2005 09:32 AM Please respond to ADSM: Dist Stor Manager Dave, With the '-dataonly=yes' directive - eg. dsmadmc -dataonly=yes -id=id -passw=passw q proc If I recall, you'll need to be at client level 5.2 or above for this to work. David McClelland Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: 11 May 2005 14:21 To: ADSM-L@VM.MARIST.EDU Subject: [spam] Excluding Command Line verbiage Folks, Sorry if this is a FAQ.. How do I exclude the Command Line Administrative Interface verbiage when I run a command? Thanks! DaveZ - Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re: [spam] Excluding Command Line verbiage
Yup... That's what I use now... I have version 5.1 Thanks! DaveZ Ford, Phillip [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU ORP.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] [spam] Excluding Command Line verbiage Dist Stor Manager [EMAIL PROTECTED] .EDU 05/11/2005 10:22 AM Please respond to ADSM: Dist Stor Manager If you are below that version we do it with a grip -v -e dsmadmc directive | grep -v -e Highest -e Tivoli -e Command -e Copyright -e Session -e Server The above is from one of my scripts. -- Phillip Ford Senior Software Specialist Enterprise Computing Services Schering-Plough Corp. (901) 320-4462 (901) 320-4856 FAX [EMAIL PROTECTED] -Original Message- From: David McClelland [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 8:33 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [spam] Excluding Command Line verbiage Dave, With the '-dataonly=yes' directive - eg. dsmadmc -dataonly=yes -id=id -passw=passw q proc If I recall, you'll need to be at client level 5.2 or above for this to work. David McClelland Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: 11 May 2005 14:21 To: ADSM-L@VM.MARIST.EDU Subject: [spam] Excluding Command Line verbiage Folks, Sorry if this is a FAQ.. How do I exclude the Command Line Administrative Interface verbiage when I run a command? Thanks! DaveZ - Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd. * This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete.
TSM, Lotus Notes and SQL BACKTRACK
Folks, We have been eating up a LOT of tapes doing Notes and SQL backups (Oracle). Does anyone have any pointers concerning tape management and these? BTWWe have a permanent retention policy on our Notes backups dictated by Corporate. Also, I was told that we cannot do incrementals on either Notes or SQL backups. Thanks! DaveZ
Out of scratch tapes?
Folks, UNfortunately as a result of miscommunication with our supplier, we will be running out of scratch tapes in the next few days. We should have a new shipment returning on Monday but, in the meantime, it appears that we will run out Sunday evening. Aside from missing backups, what other repercussions can we expect? Thanks so much! DaveZ
Time limit on TSM DB?
Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB?
I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB? SOLVED
Folks, Thanks! That clears up some things.. Activity Log Retention Period: 2 Day(s) Activity Summary Retention Period: 30 Day(s) Thanks again! DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:34 PM Please respond to ADSM: Dist Stor Manager You are searching the activity log, which has a user defined retention period. You can set the retention using the command: set actlogretention ## Where ## is the number of days to retaining records. You can see your current settings by issuing a query status command. Doug Thorneycroft Systems Analyst Computer Technology Section County Sanitation Districts of Los Angeles County (562) 699-7411 Ext. 1058 FAX (562) 699-6756 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 9:21 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Time limit on TSM DB? I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Select statement question
Folks, I have a select statement that I use to determine the amount of MB backed up during a specific time period: (e.g.) SELECT entity AS Node name,CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS MB xfer FROM summary WHERE activity='BACKUP' AND start_time= '2005-04-01 06:00' AND end_time= '2005-04-07 06:00' GROUP BY entity How would I include the Policy Domain Name? Thanks! DaveZ
Re: Select statement question
Very nice! Just what I needed! DaveZ Curtis Stewart [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU AWSON.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] Select statement question Dist Stor Manager [EMAIL PROTECTED] .EDU 05/04/2005 08:34 AM Please respond to ADSM: Dist Stor Manager Here's what I use... select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between current_timestamp - 24 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc [EMAIL PROTECTED] Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 05/04/2005 07:26 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Select statement question Folks, I have a select statement that I use to determine the amount of MB backed up during a specific time period: (e.g.) SELECT entity AS Node name,CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS MB xfer FROM summary WHERE activity='BACKUP' AND start_time= '2005-04-01 06:00' AND end_time= '2005-04-07 06:00' GROUP BY entity How would I include the Policy Domain Name? Thanks! DaveZ
Re: Select statement question
Thought I had it How would I need to adjust the macro to include information between two dates? I tried the following and got no info: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where start_time= '2005-05-09 06:00' AND end_time= '2005-05-11 06:00' and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc Thanks! DaveZ Curtis Stewart [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU AWSON.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] Select statement question Dist Stor Manager [EMAIL PROTECTED] .EDU 05/04/2005 08:34 AM Please respond to ADSM: Dist Stor Manager Here's what I use... select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between current_timestamp - 24 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc [EMAIL PROTECTED] Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 05/04/2005 07:26 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Select statement question Folks, I have a select statement that I use to determine the amount of MB backed up during a specific time period: (e.g.) SELECT entity AS Node name,CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS MB xfer FROM summary WHERE activity='BACKUP' AND start_time= '2005-04-01 06:00' AND end_time= '2005-04-07 06:00' GROUP BY entity How would I include the Policy Domain Name? Thanks! DaveZ
Re: Select statement question
Curtis, Thanks! I made a little change, though where (end_time between '2005-05-01' and '2005-05-04') DaveZ Curtis Stewart [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU AWSON.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] Select statement question Dist Stor Manager [EMAIL PROTECTED] .EDU 05/04/2005 12:10 PM Please respond to ADSM: Dist Stor Manager Thought I had it How would I need to adjust the macro to include information between two dates? Try this... select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between current_timestamp - $1 hours and current_timestamp - $2 hours) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity $1 is the start time in hour past... like 72 for three days $2 is the end time [EMAIL PROTECTED]
Re: Top 10 Tips for Improving Tivoli Storage Manager Performance
Rich, Not to be a pain... After I registered, everytime I try to view this page I get redirected to Get Access page. Something I'm missing? Thanks! DaveZ Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc: Dist StorSubject: [ADSM-L] Top 10 Tips for Improving Tivoli Storage Manager Performance Manager [EMAIL PROTECTED] .EDU 04/27/2005 07:49 AM Please respond to ADSM: Dist Stor Manager A recent IBM site Technote (1200328) summarizes some TSM 5.3 and other opportunities to improve TSM performance and throughput, presented in the form of slides with notes. Access via http://www-1.ibm.com/support/docview.wss?uid=swg21200328 (requires registration). Richard Sims
nodes and tapes
Folks, Has anyone written a statement that will display the tapes that were used in a nightly backup related to specific nodes? (e.g.) NodeVolumes node1 200134 200135 node2 200136 etc Thanks! DaveZ
Old tapes
Oh mighty Gurus. Please forgive my naive question.. We are running out of slots in our library and I have examined some of the tapes and have found that some of them haven't been read for 1 1/2 years and some haven't been written to in 3 or 4 years. Can I eject these tapes and store them in a rack? I tried 5 of them and used the following commands: update volume vol loc=shelf checkout libv lib vol checkl=no rem=b Is this kosher? Thanks! DaveZ
Re: Old tapes SOLVED
Oh mighty ones!! Thank you so much for all your help! I was able to move 100 tapes out of the silo I used the move media command. DaveZ
All new tapes I/O errors
Folks, I think I've seen this before but I can't remember Every new scratch tape I try to insert into the library is giving me: ANR8355E I/O Error reading label The tape appears to be checked in as scratch but when TSM tries to use them, they error out. Thanks! DaveZ
Re: All new tapes I/O errors SOLVED
Folks, It appears that the script we normally use wasn't working on these batch of tapes... I used the following and was successful: label libv library_name search=bulk labelsource=barcode checkin=scratch overwrite=yes Everything worked fine! Thanks for all of your help and your quick responses DaveZ UNIX Admin William Rosette [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU AJOHNS.COM cc: Sent by: ADSM: Subject: Re: [ADSM-L] All new tapes I/O errors Dist Stor Manager [EMAIL PROTECTED] .EDU 03/29/2005 10:02 AM Please respond to ADSM: Dist Stor Manager I had trouble with some new ones and come to find out they were formatted wrong from the company we received them from. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD Jonathan Kaufman [EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU KER.COM cc: Sent by: ADSM: Subject: Re: All new tapes I/O errors Dist Stor Manager [EMAIL PROTECTED] .EDU 03/29/2005 10:01 AM Please respond to ADSM: Dist Stor Manager My experience with new tapes is that you have to label them first before you can use them within tsm. If you have a barcode reader and a library with bulk I/O slots (like I do) the command would be: label libv library_name search=bulk labels=barcode checkin=scr Which would label all the volumes in the bulk I/O slots using the barcode reader to aquire their labels and check them in as scratch. As usual, if this isn't quite your config you can get help within tsm by using h label libv. Jonathan Kaufman Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/29/2005 08:32 AM Please respond to ADSM: Dist Stor Manager To: ADSM-L@VM.MARIST.EDU cc: Subject:All new tapes I/O errors Folks, I think I've seen this before but I can't remember Every new scratch tape I try to insert into the library is giving me: ANR8355E I/O Error reading label The tape appears to be checked in as scratch but when TSM tries to use them, they error out. Thanks! DaveZ
