Re: Backup time taking too high ... how to solve
It's very difficult to guide you on backup performance without knowing the configuration of servers used or operating system. Regarding the message of database changes, it is not related to your backup time as its means that you need to take a TSM database backup. Regards Akash -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Raju Gv Sent: Thursday, 10 March 2005 7:01 AM To: ADSM-L@VM.MARIST.EDU Subject: Backup time taking too high ... how to solve Hi All, To day the backup time for 180 GB is taking more time for us. Normally it will take around 2hrs 15 mnts. If i see in q actlog, one attention message is appearing like === more than 1mb of database changes use backup db to provide for database recovery ... = The above message is coming in the log. Also, the q session output is showing bytes sent as 149k and bytes received as 68k Please guide me in this matter immediately, as some more schedules are getting delayed. Regards G V Raju
Re: LTO Volume
Hi After running and observation from past so many days it has been observed that backup is going on two LTO volumes i.e. TAPE LEAKING as per the term used. Now please update me the resolution for the same? Output of the query in my set up is as follows: - STORAGE POOL : TAPEPOOL VOLNAME: BT0557 PCT UTIL: 100.0 MB_CAPACITY: 360693.4 ACCESS: READWRITE LAST_WRITE_DATE: 2005-03-10 10:46:53 STORAGE POOL : TAPEPOOL VOLNAME: BT0558 PCT UTIL: 11.9 MB_CAPACITY: 20.0 ACCESS: READWRITE LAST_WRITE_DATE: 2005-03-08 05:57:28 Regards Akash -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Richard Sims Sent: Sunday, 6 March 2005 1:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: LTO Volume Akash - I term this "Tape leak", as I summarize in http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of this about 6 months ago on ADSM-L. One member was pursuing it with IBM as a problem. For administration at my site, I created a macro called "filling", which does the following: SELECT STGPOOL_NAME AS "STORAGE POOL ", CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CHAR(ACCESS,11) AS "ACCESS", LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE" FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME This is handy for monitoring tapes which are in Filling state, and also watching for tapes which become Readonly due to events occurring as they are filling. Richard Sims On Mar 5, 2005, at 12:27 PM, Akash Jain wrote: > Hi experts, > > I have one simple query. > > While taking backups on LTO through, it occupies new LTO volume only > after > the used and in process volume will display status as 'FULL'. > > But in my case I had observed that it had started taking backup on > other LTO > volume in spite of the previous one in 'FILLING' status. > > BTO557TAPEPOOL LTOCLASS528,305.3 100.0 > Filling > BT0558TAPEPOOL LTOCLASS200,000.0 15.5 > Filling > > Kindly provide the logical reasoning if any for the same. > > > Regards > Akash
Re: Export feasibility
On 10/03/2005, at 8:15 AM, Ragnar Sundblad wrote: We don't want to give up storing away a complete snapshot of our systems off site every few months, over time maybe reusing the off site tapes so that we finally save a snapshot a year. I think that the most logical way to accomplish this with TSM is to do a complete export like export server filedata=allactive ... What's wrong with using backup sets? The end result is the same -- all currently active data is stored on tape and can be moved offsite, without needing any maintenance from the main TSM server. Given LTO 3 with an maximum data speed of 50 MB/s uncompressed, a moderate guess (I hope) for the data transfer rate would be 30 MB/s, which would give 93 hours to write it down. Given that a tape has a capacity of 400 GB uncompressed, it would take at the most 25 tapes. We would obviously want to be able to use the backup server as usual while doing the export. Then you would need to make sure that your server has enough capacity, in terms of tape drives (and connectivity to the tape drives), network bandwidth (to cover both the export and the backups), and such like to cope with both the export (or backup set generation) and regular backups simultaneously. From my point of view, being in the middle of fiddling around with exports (server to server in my case) for various "last ditch" DR systems, I'd suggest keeping it simple. If backup sets (see the "generate backupset" command in the admin reference manual) fill your needs, my advice would be to make use of them, rather than using the rather fragile option of server data exports.
Re: Volume sequence
I've tried that script, but I need to know the file sequence. Eg. I have a large database of 170GB.It should occupied more than 1 tape. How do I know which tape is the first one, and which is next . ~Norita Hasan~ -Original Message- From: goc [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 8:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Volume sequence you can try this ... it givec a lot more and it's useful i think select vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.vo lume_name - from volumeusage vu,volumes vo - where vo.volume_name=vu.volume_name - group by vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.vo lume_name - order by vo.volume_name, - vu.node_name,vu.copy_type,vo.pct_utilized - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 09, 2005 11:51 AM Subject: Volume sequence > Hi, > > Is there any select statement that can display the volume sequence number > so > that I can list all the volumes in sequence that has been used by specific > node. > > NORITA BINTI HASAN > Senior Programmer > Enterprise Systems Services > Information Communication Tech.Div > 6th Floor, Pos Malaysia Berhad > 50670 Kuala Lumpur > > Tel : 03 - 22756638 > > > > Pos Malaysia Berhad is Malaysia's national postal company > Visit us online at www.pos.com.my > > NOTICE > This message may contain privileged and/or confidential > information. If you are not the addressee or authorised > to receive this email, you must not use, copy, disclose > or take any action based on this email. If you have > received this email in error, please advise the sender > immediately by reply e-mail and delete this message. > Pos Malaysia Berhad takes no responsibility for the > contents of this email. > Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Re: Retrieves failing on files with future archive attributes
Thanks Andy. I'll talk to support but I'm still curious about if TSM looks at the archive attribute at all. Andrew Ferris Network Support Analyst iCAPTURE Research Centre University of British Columbia >>> [EMAIL PROTECTED] 3/8/2005 3:19:20 PM >>> Hmmm. it seems odd to me that you'd get ANS1301E without a corresponding message on the server. That message should derive from a transaction that the server aborted, and I'd think the server would show some evidence of a problem as well. I don't think there's anything more I can do on this forum to help. I'd recommend running a SERVICE trace of the RETRIEVE operation, contacting IBM support, and sending them the trace along with an explanation of your recreate scenario. 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] 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" wrote on 2005-03-08 16:04:50: > Thank you Andy for the reply. > > Here's the server's activity log during an archive and retrieve with a > failure: > > 03/08/2005 10:16:11 ANR0402I Session 27276 started for administrator > AFERRIS (WebConsole) (Tcp/Ip). (SESSION: 27276) > 03/08/2005 10:20:16 ANR0406I Session 27277 started for node > HOME_SERVER (NetWare) (Tcp/Ip 192.168.x.x(-27347)). (SESSION: 27277) > > 03/08/2005 10:22:39 ANR8337I LTO volume ICA046L2 mounted in drive > F1R2 (mt1.0.0.4). (SESSION: 27277) > 03/08/2005 10:22:39 ANR0511I Session 27277 opened output volume > ICA046L2. (SESSION: 27277) > 03/08/2005 10:25:26 ANE4952I (Session: 27277, Node: HOME_SERVER) > Total number of objects inspected: 1,739 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4953I (Session: 27277, Node: HOME_SERVER) > Total number of objects archived: 1,739 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4958I (Session: 27277, Node: HOME_SERVER) > Total number of objects updated: 0 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4960I (Session: 27277, Node: HOME_SERVER) > Total number of objects rebound: 0 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4957I (Session: 27277, Node: HOME_SERVER) > Total number of objects deleted: 0 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4970I (Session: 27277, Node: HOME_SERVER) > Total number of objects expired: 0 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4959I (Session: 27277, Node: HOME_SERVER) > Total number of objects failed: 0 (SESSION: 27277) > 03/08/2005 10:25:26 ANE4961I (Session: 27277, Node: HOME_SERVER) > Total number of bytes transferred: 315.98 MB (SESSION: 27277) > 03/08/2005 10:25:26 ANE4963I (Session: 27277, Node: HOME_SERVER) > Data transfer time: 95.07 sec (SESSION: 27277) > > 03/08/2005 10:25:26 ANE4966I (Session: 27277, Node: HOME_SERVER) > Network data transfer rate: 3,403.51 KB/sec (SESSION: 27277) > 03/08/2005 10:25:26 ANE4967I (Session: 27277, Node: HOME_SERVER) > Aggregate data transfer rate: 1,659.51 KB/sec (SESSION: 27277) > 03/08/2005 10:25:26 ANE4968I (Session: 27277, Node: HOME_SERVER) > Objects compressed by: 0% (SESSION: 27277) > 03/08/2005 10:25:26 ANE4964I (Session: 27277, Node: HOME_SERVER) > Elapsed processing time: 00:03:14 (SESSION: 27277) > 03/08/2005 10:25:27 ANR0514I Session 27277 closed volume ICA046L2. > (SESSION: 27277) > 03/08/2005 10:25:27 ANR0403I Session 27277 ended for node HOME_SERVER > (NetWare). (SESSION: 27277) > 03/08/2005 10:25:36 ANR0406I Session 27278 started for node > HOME_SERVER (NetWare) (Tcp/Ip 192.168.x.x(-27346)). (SESSION: 27278) > > 03/08/2005 10:26:09 ANR0510I Session 27278 opened input volume > ICA046L2. (SESSION: 27278) > 03/08/2005 10:27:16 ANE4956I (Session: 27278, Node: HOME_SERVER) > Total number of objects retrieved:1,707 (SESSION: 27278) > 03/08/2005 10:27:16 ANE4959I (Session: 27278, Node: HOME_SERVER) > Total number of objects failed: 1 (SESSION: 27278) > 03/08/2005 10:27:16 ANE4961I (Session: 27278, Node: HOME_SERVER) > Total number of bytes transferred: 305.07 MB (SESSION: 27278) > 03/08/2005 10:27:16 ANE4963I (Session: 27278, Node: HOME_SERVER) > Data transfer time: 8.26 sec (SESSION: 27278) > > 03/08/2005 10:27:16 ANE4966I (Session: 27278, Node: HOME_SERVER) > Network data transfer rate: 37,820.51 KB/sec (SESSION: 27278) > 03/08/2005 10:27:16 ANE4967I (Session: 27278, Node: HOME_SERVER) > Aggregate data transfer rate: 4,594.08 KB/sec (SESSION: 27278) > 03/08/2005 10:27:16 ANE4964I (Session: 27278, Node: HOME_SERVER) > Elapsed processing time: 00:01:08 (SESSION: 27278) > 03/08/2005 10:27:25 ANR0407I Session 27279 started for administrator > AFERRIS (WebBrowser) (HTTP 192.168.x.x(3528)). (SESSION: 27279) > 03/08/2005 10:27:25 ANR0405I Session 27279 ended for administrator > AFERRIS (WebBrowser). (SESSION: 27279) > 03/08/2005 10:27:31 ANR2017I Administrator AFERRIS issued command: > QUERY ACTLOG BEGINDATE=03/08/2005 B
Backup time taking too high ... how to solve
Hi All, To day the backup time for 180 GB is taking more time for us. Normally it will take around 2hrs 15 mnts. If i see in q actlog, one attention message is appearing like === more than 1mb of database changes use backup db to provide for database recovery ... = The above message is coming in the log. Also, the q session output is showing bytes sent as 149k and bytes received as 68k Please guide me in this matter immediately, as some more schedules are getting delayed. Regards G V Raju ---DISCLAIMER This Message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet cannot guarantee the integrity of this message. INGVysya Bank (and its subsidiaries) shall (will) not therefore be liable for the message if modified.
Export feasibility
Hello all, We are investigating replacing our old backup systems with TSM. We don't want to give up storing away a complete snapshot of our systems off site every few months, over time maybe reusing the off site tapes so that we finally save a snapshot a year. I think that the most logical way to accomplish this with TSM is to do a complete export like export server filedata=allactive ... I have played with it with a smaller data set, 100 gigs or so, and it seems to work pretty fine. But I have no idea what will happen when we have a lot of data. We estimate a filedata=allactive export to about 10 TB (and somewhere between 30 million and 100 million files, that numbers is yet unknown). Given LTO 3 with an maximum data speed of 50 MB/s uncompressed, a moderate guess (I hope) for the data transfer rate would be 30 MB/s, which would give 93 hours to write it down. Given that a tape has a capacity of 400 GB uncompressed, it would take at the most 25 tapes. We would obviously want to be able to use the backup server as usual while doing the export. I have seen concerns about that the export mechanism would easily bail out at smaller problems, and maybe other issues with it, that make people avoid using it even for smaller amounts of data. If this (still?) is true, doing a 74 hour multi tape export may just not be practical. Is the above feasible at all? Is anyone doing this? Are there any other comments or ideas on the above? Thanks for sharing your knowledge and experience! Ragnar Sundblad - Department for Numerical Analysis and Computer Science Royal Institute of Technology Stockholm, Sweden
Re: Need a script
Very sorry for the delay in reply. Also sorry for the unattractive format - they do not make it easy to get the TECHNOTE into a form you can mail. 1166289 How to remove a single file from a TSM backup tape volume Technote (FAQ) Problem For customers with security sensitive files already backed up to tape. The following workaround can be used to remove a single file object from backup tape. Cause A need can arise where a classified file breaches the security of the customer and the customer needs to remove the file from the backup volume without losing the rest of the active data on tape volume Solution A. Find the volume(s) containing the file: . 1) Run a select statement to view a particular file and get the Object_ID 2) show bfo 0 3) locate the super-bitfile (The superbitfile is basically the first bit file object in an aggregate) 4) show bfo 0 (This will list all of the bit files within the aggregate and the at the bottom, show you the volume name for the primary and the copy) . Here's what it looks like: . 1) tsm:AIX21>select * from backups where node_name='KEITHTECHVIT' and ll_name='dsmsched.log' . NODE_NAME: KEITHTECHVIT FILESPACE_NAME: / STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: / LL_NAME: dsmsched.log OBJECT_ID: 553769 BACKUP_DATE: 2001-07-20 14:18:12.00 DEACTIVATE_DATE: OWNER: root CLASS_NAME: KEITHTECHVIT . 2) tsm: AIX21>show bfo 0 553769 . Bitfile Object: 0.553769 **Sub-bitfile 0.553769 is stored in the following aggregate(s) Super-bitfile: 0.553747, Offset: 0.146740, Length 0.933 . 3) tsm: AIX21>show bfo 0 553747 . Bitfile Object: 0.553747 **Super-bitfile 0.553747 contains following aggregated bitfiles 0.553747 0.553748 0.553749 0.553750 0.553751 0.553752 0.553755 0.553756 0.553757 0.553758 0.553759 0.553760 0.553761 0.553762 0.553763 0.553764 0.553765 0.553766 0.553767 0.553768 0.553769 . **Sub-bitfile 0.553747 is stored in the following aggregate(s) Super-bitfile: 0.553747, Offset: 0.0, Length 0.1315 . **Disk Bitfile Entry Bitfile Type: PRIMARY Storage Format: 6 Logical Size: 0.147865 Physical Size: 0.151552 Number of Segments: 2 Storage Pool ID: 1 Volume ID: 7 Volume Name: /tsm/bvol001.dsm Storage Pool ID: 1 Volume ID: 7 Volume Name: /tsm/bvol001.dsm **Archival Bitfile Entry Bitfile Type: COPY Storage Format: 6 Bitfile Size: 0.147865 Number of Segments: 1 Storage Pool ID: -7 Volume ID: 702 Volume Name: 002 . B. Define a new management class/copy group with the following expiration parameters versions exist - 1 versions deleted - 0 retain extra - 0 retain only - 0 . C. Next, set up the client's dsm.opt to include ONLY the targeted file and exclude all others include /path/file . D. Run a backup. When the backup completes, run expiration. . E. Once the tapes are available, run move data to move the data (except the expired file) off the original tape(s) F. Lastly, check each original tape out of the library Product Alias/Synonym TSM ITSM -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Sent: Saturday, February 19, 2005 12:10 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Need a script Wanda Try to download the article without success I have an IBM passport advantage but say not enough . It will be to much to ask if you have the article to send it to me, I will really appreciate. Thanks again, Regards Robert E-mail: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Thursday, February 17, 2005 10:46 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Need a script AFAIK, The only way you can do it is with a SHOW command. If the file is stored in an aggregate, it's a 2-step process. See www.ibm.com, search for technote 1166278. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Sent: Thursday, February 17, 2005 11:45 AM To: ADSM-L@VM.MARIST.EDU Subject: Need a script Hi to all Does anyone have a script to retrieve volume name on which a specific file is (active and inactive file) I succeeded to retrieve the volume name for specific nodename and filespace but I want to drill down to a specific file. Here is the script I use: select node_name , volume_name, stgpool_name, filespace_name from volumeusage where node_name=upper('$1') and filespace_name=('$2') T.I.A Regards Robert Ouzen E-mail: [EMAIL PROTECTED]
Re: TDP Domino PIT
Can you restore any of the desired inactive backups when you don't specify PIT? You should contact IBM support so the problem can be diagnosed. Eduardo "ADSM: Dist Stor Manager" wrote on 03/08/2005 03:28:17 PM: > TDP Domino 5.1.5 on Domino 6.5.3 on Windows 2003 > We are attempting to do Point-in-Time restores of databases backed up > since early 2001. > If we look at the inactive backups in the TDP GUI we can see multiple > versions going back through the years. If we do a point-in-time, with the > PIT set to 12/31/2001, TSM reports that there are no databases to be > restored. We get the same results using the Command Line client and > /Pick. Over the years this has been a pretty reliable system so I don't > think we've missed many backups. > Any help would be appreciated. > Tab Trepagnier > TSM Administrator > Laitram LLC
Re: Listserver subscription hosed
I already checked with our email system administrators (first thing I do since we have had issues in the past where our anti-spam/anti-virus systems got hung up). Nothing on their end. The last email I got from ADSM-L was 3/2/2005. I do recall a few message being echoed-duplicated. I also remember when I sent two posts, I got nasty-grams from the listserver saying that I was trying to post, twice, which I was not. Nothing after that ! Stapleton, Mark wrote: From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray My apologies to the list, but I can't seem to do this another way. Can someone who manages this listserver please contact me. I have sent two emails to Marist and can't seem to get a response. This is the default behavior. One of the administrators sent a test message to the list in the last 7 days; see if you can find it. (I deleted it accidently.) We (another co-worker is also on this list and has the same problem) have stopped getting ADSM-L mail since last week. When I tried SET ADSM-L MAIL, it said I wasn't subscribed. When I try to resubscribe, it tells me "550 Invalid user". When I send a SIGNOFF it takes a long time for a response and then get the same Invalid user" error. Have we been blacklisted for some reason ? Doubtful. Check to see if your mail administrator has been dinking with your email account. Since email servers allow multiple usernames to feed the same inbox, and if your administrator changed the default address you send out when you post an email, you may be broadcasting an email address that is not the address you originally subscribed with. (Happened to me a couple of years ago; a lot of email administrators don't pay attention to consequences like this.) -- Mark Stapleton ([EMAIL PROTECTED]) Office 262.521.5627
Re: Listserver subscription hosed
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray >My apologies to the list, but I can't seem to do this another way. > >Can someone who manages this listserver please contact me. I >have sent >two emails to Marist and can't seem to get a response. This is the default behavior. One of the administrators sent a test message to the list in the last 7 days; see if you can find it. (I deleted it accidently.) >We (another co-worker is also on this list and has the same problem) >have stopped getting ADSM-L mail since last week. > >When I tried SET ADSM-L MAIL, it said I wasn't subscribed. >When I try to >resubscribe, it tells me "550 Invalid user". When I send a SIGNOFF it >takes a long time for a response and then get the same >Invalid user" error. > >Have we been blacklisted for some reason ? Doubtful. Check to see if your mail administrator has been dinking with your email account. Since email servers allow multiple usernames to feed the same inbox, and if your administrator changed the default address you send out when you post an email, you may be broadcasting an email address that is not the address you originally subscribed with. (Happened to me a couple of years ago; a lot of email administrators don't pay attention to consequences like this.) -- Mark Stapleton ([EMAIL PROTECTED]) Office 262.521.5627
Re: Multi-process Reclamtion/migration 5.3
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes >Has anyone set up Multi-process Reclamation/Migration for TSM 5.3? >If so is there any documentation on how to set it up? where? >I only found bits and pieces of it being talked about. Read the Fine Manual. def stg migproc= reclaimprocess= from the DEFINE STGPOOL pages of the TSM 5.3 Administrator's Reference. -- Mark Stapleton ([EMAIL PROTECTED]) Office 262.521.5627
Re: space in storage pool
Daft to ask but have you any scratch tapes in the library? Regards Neil Sharp <[EMAIL PROTECTED]>, Norita binti Hassan <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 09/03/2005 09:25 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@vm.marist.edu cc Subject Re: space in storage pool I've run that select statement.. and here it is tsm: TIVOLISVR>select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' group by a.stgpool_name,b.stgpool_name,a.maxscratch STGPOOL_NAME MAXUSED -- --- --- 359POOL4 500 68 359POOL5 500 76 359POOL6 500 62 ~Norita Hasan~ -Original Message- From: goc [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 4:25 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: space in storage pool to be absolutely sure run this query : select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b - where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' - group by a.stgpool_name,b.stgpool_name,a.maxscratch okay ? - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 09, 2005 8:49 AM Subject: Re: space in storage pool > I've set max is 500 and I don't even reach that figure. Any other reason? > > ~Norita Hasan~ > > > -Original Message- > From: Stef Coene [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 09, 2005 3:42 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: space in storage pool > > On Wednesday 09 March 2005 04:49, Norita binti Hassan wrote: >> Hi, >> >> I got this message, but when I checked my storage pool,there's a scratch >> volume that can be use for this backup. Can anybody explain this ? > Check the number of scratch volumes the storage pool may use. Maybe this > maximum is reached. > > > Stef > > > Pos Malaysia Berhad is Malaysia's national postal company > Visit us online at www.pos.com.my > > NOTICE > This message may contain privileged and/or confidential > information. If you are not the addressee or authorised > to receive this email, you must not use, copy, disclose > or take any action based on this email. If you have > received this email in error, please advise the sender > immediately by reply e-mail and delete this message. > Pos Malaysia Berhad takes no responsibility for the > contents of this email. > Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Multi-process Reclamtion/migration 5.3
Hello, Has anyone set up Multi-process Reclamation/Migration for TSM 5.3? If so is there any documentation on how to set it up? where? I only found bits and pieces of it being talked about. TSM 5.3.0.1 RS/6000 Aix5.2 p670 Thanks for any assistance!
Listserver subscription hosed
My apologies to the list, but I can't seem to do this another way. Can someone who manages this listserver please contact me. I have sent two emails to Marist and can't seem to get a response. We (another co-worker is also on this list and has the same problem) have stopped getting ADSM-L mail since last week. When I tried SET ADSM-L MAIL, it said I wasn't subscribed. When I try to resubscribe, it tells me "550 Invalid user". When I send a SIGNOFF it takes a long time for a response and then get the same Invalid user" error. Have we been blacklisted for some reason ? I have resubscribed via an alternate email system but need to clear up this issue for my primary email account.
Re: SUSPECT: (MSW) Re: Directory path backed up again and again ...
Andy, I tried to activate the traceflag FIOATTRIBS, however to simulate the same conditions as usual, I had to issue an incremental backup command without specifying any object : the output was huge ! I then tried to understand it, and found out that only the objects having "Mod Time different: returning ATTRIBS_BACKUP" where eligible for backup, unfortunately none of those objects was my "/export/mksysb". However I found something strange, looking like this : 09.03.2005 16:37:06.860 : unxfilio.cpp(1449): fioCmpAttribs: Attribute comparison of two files Attribute Old New - --- --- ctime 1110357049 1110360549 mtime 1110357049 1110360549 atime 1110357026 1110357744 File mode OCT 242755 242755 uid 3 3 gid 3 3 size 10241024 ACL size 0 0 ACL checksum 0 0 inode2 2 09.03.2005 16:37:06.860 : fileio.cpp (4735): fioCmpAttribs(): old attrib's data from build (IBM TSM 5.2.3.1) 09.03.2005 16:37:06.860 : unxfilio.cpp(1488): -->Mod Time different: returning ATTRIBS_BACKUP === 09.03.2005 16:37:06.877 : incrdrv.cpp (9567): Incremental attrib compare for: /export/mksysb/lost+found 09.03.2005 16:37:06.878 : unxfilio.cpp(1393): fioCmpAttribs: Attribute comparison of two directories Attribute Old New - --- --- File mode82424 82424 uid 0 0 gid 0 0 ACL size 0 0 ACL checksum 0 0 09.03.2005 16:37:06.878 : fileio.cpp (4735): fioCmpAttribs(): old attrib's data from build (IBM TSM 5.2.3.1) 09.03.2005 16:37:06.878 : unxfilio.cpp(1434): -->Attribs equal: returning ATTRIBS_EQUAL It looks like "something" is eligible for backup, which is the first object in the series concerning the contents of /export/mksysb, but the trace doesn't name it ?! Also, something comes to my mind, which may be important : this /export/mksysb is not a subdirectory from /export, but the mount point for a filesystem, could that have any impact ? Thanks for your answers, and take your time for responding : night is coming in Switzerland, and I'm living the office till tomorrow ... Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Tuesday, 08 March, 2005 20:15 To: ADSM-L@VM.MARIST.EDU Subject: SUSPECT: (MSW) Re: Directory path backed up again and again ... Thanks, Richard, for pointing out the distinction. You are correct, on Unix, regular incremental backup of normal directories does not include the timestamp data as criteria. On Windows, if the last write time for the directory has changed, then it is a candidate for incremental backup. Create and access times are not part of the criteria for incremental backup. The FIOATTRIBS trace class can be used to help determine what TSM is seeing as changed. If I were going to look at the trace, I'd want to add POLICY and VERBINFO just so I can verify that the directories are not being bound to a management class whose copygroup mode setting is ABSOLUTE, in case FIOATTRIBS doesn't yield the answer. 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] 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" wrote on 2005-03-08 08:47:56: > On Mar 8, 2005, at 10:16 AM, Andrew Raibeck wrote: > > > Hi Arnaud, > > > >> As Andy says it in his excellent web page : A normal Incremental > >> Backup will *not* back up directories whose timestamp has changed > >> since the last backup. > > > > This statement is wrong. I'm not certain you are referring to me (I > > don't have a web page) or another Andy, but it would help to know > > the context of this information. If the directory timestamp changes, > > I would expect it to be backed up.
Re: TDP for SQL error
Hi Richard! Actually they do! Why didn't I check them first... Thank you (and Dell too) for the solution. I thought the mountwait only applies to restores, but apparently it's also backup related. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 13:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL error Eric - Do the ADSM QuickFacts notes on that msg meet your conditions? It's exasperating that so many TSM messages are this vague. Richard On Mar 9, 2005, at 5:10 AM, Loon, E.J. van - SPLXM wrote: > ANS1309W (RC9) Requested data is offline ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
JR-RH 7.2 Enterprise Cluster using IPVS
I have a 2 node Red Hat 7.2 cluster using IPVS and I would like to know the following: How to configure TSM to backup data on the cluster. My experience with clustering is Active-Passive, my understanding with IPVS is it's Active-Active. Typically I would setup a clustered resource and back it up via the virtual node. Thanks in advanced.
TSM 5.1.5 Client TSM 5.3 restore compatiblity
Hello, Can a TSM 5.1.5 client be restored to a 5.3 server using the Backup/Restore/ Java Gui? Or it has to be done from the command line only? Also, If I wanted to restore a file to it's original location for example cd/usx/mvm/qamp I would type in the following from the command line in the path that I want the file restored to? dsmc restore /usx/mvm/qamp/file name >From what I read, I'm pretty sure this correct I just want to make 100% sure. Sorry, but I usually do restores from the Java Gui learning to do them from the command line now Thanks for any replies TSM client 5.1.5 TSM Server 5.3.0.1
Re: TDP for SQL error
Eric, If Richard's pointers provide no help, go to: http://www.ibm.com/us/ and in the Search box, enter: ANS1309W There are a few hits that might help. Thanks, Del "ADSM: Dist Stor Manager" wrote on 03/09/2005 05:10:04 AM: > Hi *SM-ers! > One of our SQL guys tries to backup his SQL node to our test server. > Everything works fine when he uses our production server, but when he backs > up to the test server he receives the following error: > > ANS1309W (RC9) Requested data is offline > > In the tdpsql.log I see the following lines: > > 03/09/2005 09:28:37 ACO5436E A failure occurred on stripe number (0), rc = > 418 > 03/09/2005 09:28:37 ANS1309W (RC9)Requested data is offline > 03/09/2005 09:28:39 Backup of i3_eic failed. > 03/09/2005 09:28:39 ANS1309W (RC9)Requested data is offline > > And in the server log I see the following lines: > > ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3006 Data > Protection for SQL: Starting backup for server TS07. (SESSION: 14838) > > ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3000 Data > Protection for SQL: Starting full backup of database i3_eic from server > TS07. (SESSION: 14838) > > ANR1013I During a store operation, the server is switching to a next pool in > the storage hierarchy. The next storage pool will inherit the simultaneous > write configuration from the destination primary storage pool. (SESSION: > 14838) > > ANE4993E (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3002 Data > Protection for SQL: full backup of database i3_eic from server TS07 failed, > rc = 418. (SESSION: 14838) > > ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3008 Data > Protection for SQL: Backup of server TS07 is complete. Total SQL backups > selected: 1 Total SQL backups attempted: 1 > Total SQL backups completed: 0 Total SQL backups excluded: > 0 Total SQL backups inactivated:0Throughput rate: > 5,864.85 Kb/Sec Total bytes transferred: 484,442,112 > Elapsed processing time: 80.67 Secs (SESSION: 14838) > ANR0403I Session 14838 ended for node TS07-SQL (TDP MSSQL Win32). (SESSION: > 14838) > > > There is plenty of space in the target storage pool, so I cannot explain > this 'switching' nor why it results in a failure... > Thank you very much for your help in advance! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines
Re: Can't restore Exchange
Nghiatd, HRESULT: 0xc7ff1004 is returned when the Exchange Server encounters something that it did not expect. Many times this means that there was a missed step during the rebuild of the Exchange Server. I would check the specific disaster recovery steps for Exchange 2000 here: http://www.microsoft.com/technet/prodtechnol/exchange/2000/library/disrec00.mspx to make sure that you are not missing a critical step. If you can not identify the problem, please place a call with IBM support so that the proper documentation can be gathered to diagnose this. Thanks, Del "ADSM: Dist Stor Manager" wrote on 03/09/2005 06:29:43 AM: > Hi all, > > I use TDP for Mail ver 5.2.1 to backup Echange 2000. > > I implement : > a.. restore system drive and system state. > b.. reinstall Exchange using setup /Disaster Recovery > c.. using TDP restore database. > When restore mail server, i receive error message: > > ACN0151E Errors occurred while processing the request. > Restore failed ACN5798E MS Exchange API HRESERESTORECOMPLETE() > failed with HRESULT: 0xc7ff1004 - Error return from an ESE function > call (-514). > > Help me to fix it, > > Nghiatd,
Re: QUERY FILESPACE: No match found using this criteria
Thanks. //Henrik "Das, Samiran (IDS ECCS)" To: ADSM-L@VM.MARIST.EDU Subject: Re: QUERY FILESPACE: No match found using this criteria Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 2005-03-09 13:08 Please respond to "ADSM: Dist Stor Manager" Henrik, Add nametype=unicode at the end of the command line. tsm: x>q fi sto-tw02 \\sto-tw02\c$ nametype=unicode Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: Wednesday, March 09, 2005 7:00 AM To: ADSM-L@VM.MARIST.EDU Subject: QUERY FILESPACE: No match found using this criteria Hi, I dont get this logic when I do a 'q fi'. Anyone who knows what might be wrong or seen this before? I´m not doing anything else except q fi againt thoose filespaces. TSM 5.2.2.5 on w2k3. Thanks Henrik tsm: x>q fi sto-tw01 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01SYSTEM 1 WinNTSYSTEM No 0.0 0.0 OBJECT STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ STO-TW01SYSTEM 3 WinNTSYSTEM Yes 0.0 0.0 STATE STO-TW01SYSTEM 4 WinNTSYSTEM Yes 0.0 0.0 SERVICES STO-TW01ASR5 WinNTNTFS Yes 0.0 0.0 tsm: x>q fi sto-tw01 \\sto-tw01\c$ Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ tsm: x>q fi sto-tw02 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- ---
Re: TDP for SQL error
Eric - Do the ADSM QuickFacts notes on that msg meet your conditions? It's exasperating that so many TSM messages are this vague. Richard On Mar 9, 2005, at 5:10 AM, Loon, E.J. van - SPLXM wrote: ANS1309W (RC9) Requested data is offline
Re: Volume sequence
you can try this ... it givec a lot more and it's useful i think select vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name - from volumeusage vu,volumes vo - where vo.volume_name=vu.volume_name - group by vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name - order by vo.volume_name, - vu.node_name,vu.copy_type,vo.pct_utilized - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 09, 2005 11:51 AM Subject: Volume sequence Hi, Is there any select statement that can display the volume sequence number so that I can list all the volumes in sequence that has been used by specific node. NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communication Tech.Div 6th Floor, Pos Malaysia Berhad 50670 Kuala Lumpur Tel : 03 - 22756638 Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Re: Commands Issued
On Mar 9, 2005, at 6:58 AM, Akash Jain wrote: Is there any script for Solaris that I can schedule to identify the commands issued in Tivoli at regular intervals? You need to explain more what you are trying to get... If you mean that you seek to report all the dsm* and like commands issued at the Solaris operating system level, you can employ the traditional Unix 'acctcom' command and egrep for the commands you want reported. You could put that combination into a bsh/csh script and run that via cron; or you could meld that into the traditional nightly runacct which processes Unix process accounting records. Richard Sims
Re: QUERY FILESPACE: No match found using this criteria
Henrik, Add nametype=unicode at the end of the command line. tsm: x>q fi sto-tw02 \\sto-tw02\c$ nametype=unicode Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: Wednesday, March 09, 2005 7:00 AM To: ADSM-L@VM.MARIST.EDU Subject: QUERY FILESPACE: No match found using this criteria Hi, I dont get this logic when I do a 'q fi'. Anyone who knows what might be wrong or seen this before? I´m not doing anything else except q fi againt thoose filespaces. TSM 5.2.2.5 on w2k3. Thanks Henrik tsm: x>q fi sto-tw01 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01SYSTEM 1 WinNTSYSTEM No 0.0 0.0 OBJECT STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ STO-TW01SYSTEM 3 WinNTSYSTEM Yes 0.0 0.0 STATE STO-TW01SYSTEM 4 WinNTSYSTEM Yes 0.0 0.0 SERVICES STO-TW01ASR5 WinNTNTFS Yes 0.0 0.0 tsm: x>q fi sto-tw01 \\sto-tw01\c$ Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ tsm: x>q fi sto-tw02 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW02SYSTEM 1 WinNTSYSTEM Yes 0.0 0.0 OBJECT STO-TW02\\sto-tw02-2 WinNTNTFS Yes17,320.1 26.7 \c$ STO-TW02\\sto-tw02-3 WinNTNTFS Yes17,367.9 9.0 \e$ STO-TW02SYSTEM 4 WinNTSYSTEM Yes 0.0 0.0 STATE STO-TW02SYSTEM 5 WinNTSYSTEM Yes 0.0 0.0 SERVICES STO-TW02ASR6 WinNTNTFS Yes 0.0 0.0 tsm: x>q fi sto-tw02 \\sto-tw02\c$ ANR2034E QUERY FILESPACE: No match found using this criteria. ANS8001I Return code 11. --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you. If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
QUERY FILESPACE: No match found using this criteria
Hi, I dont get this logic when I do a 'q fi'. Anyone who knows what might be wrong or seen this before? I´m not doing anything else except q fi againt thoose filespaces. TSM 5.2.2.5 on w2k3. Thanks Henrik tsm: x>q fi sto-tw01 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01SYSTEM 1 WinNTSYSTEM No 0.0 0.0 OBJECT STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ STO-TW01SYSTEM 3 WinNTSYSTEM Yes 0.0 0.0 STATE STO-TW01SYSTEM 4 WinNTSYSTEM Yes 0.0 0.0 SERVICES STO-TW01ASR5 WinNTNTFS Yes 0.0 0.0 tsm: x>q fi sto-tw01 \\sto-tw01\c$ Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW01\\sto-tw01-2 WinNTNTFS No 34,691.9 25.1 \c$ tsm: x>q fi sto-tw02 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace(MB) Util Unicode? --- --- - - - STO-TW02SYSTEM 1 WinNTSYSTEM Yes 0.0 0.0 OBJECT STO-TW02\\sto-tw02-2 WinNTNTFS Yes17,320.1 26.7 \c$ STO-TW02\\sto-tw02-3 WinNTNTFS Yes17,367.9 9.0 \e$ STO-TW02SYSTEM 4 WinNTSYSTEM Yes 0.0 0.0 STATE STO-TW02SYSTEM 5 WinNTSYSTEM Yes 0.0 0.0 SERVICES STO-TW02ASR6 WinNTNTFS Yes 0.0 0.0 tsm: x>q fi sto-tw02 \\sto-tw02\c$ ANR2034E QUERY FILESPACE: No match found using this criteria. ANS8001I Return code 11. --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Commands Issued
Hi experts, Is there any script for Solaris that I can schedule to identify the commands issued in Tivoli at regular intervals? Regards Akash
Can't restore Exchange
Hi all, I use TDP for Mail ver 5.2.1 to backup Echange 2000. I implement : a.. restore system drive and system state. b.. reinstall Exchange using setup /Disaster Recovery c.. using TDP restore database. When restore mail server, i receive error message: ACN0151E Errors occurred while processing the request. Restore failed ACN5798E MS Exchange API HRESERESTORECOMPLETE() failed with HRESULT: 0xc7ff1004 - Error return from an ESE function call (-514). Help me to fix it, Nghiatd,
Volume sequence
Hi, Is there any select statement that can display the volume sequence number so that I can list all the volumes in sequence that has been used by specific node. NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communication Tech.Div 6th Floor, Pos Malaysia Berhad 50670 Kuala Lumpur Tel : 03 - 22756638 Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
TDP for SQL error
Hi *SM-ers! One of our SQL guys tries to backup his SQL node to our test server. Everything works fine when he uses our production server, but when he backs up to the test server he receives the following error: ANS1309W (RC9) Requested data is offline In the tdpsql.log I see the following lines: 03/09/2005 09:28:37 ACO5436E A failure occurred on stripe number (0), rc = 418 03/09/2005 09:28:37 ANS1309W (RC9)Requested data is offline 03/09/2005 09:28:39 Backup of i3_eic failed. 03/09/2005 09:28:39 ANS1309W (RC9)Requested data is offline And in the server log I see the following lines: ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3006 Data Protection for SQL: Starting backup for server TS07. (SESSION: 14838) ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3000 Data Protection for SQL: Starting full backup of database i3_eic from server TS07. (SESSION: 14838) ANR1013I During a store operation, the server is switching to a next pool in the storage hierarchy. The next storage pool will inherit the simultaneous write configuration from the destination primary storage pool. (SESSION: 14838) ANE4993E (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3002 Data Protection for SQL: full backup of database i3_eic from server TS07 failed, rc = 418. (SESSION: 14838) ANE4991I (Session: 14838, Node: TS07-SQL) TDP MSSQL Win32 ACO3008 Data Protection for SQL: Backup of server TS07 is complete. Total SQL backups selected: 1 Total SQL backups attempted: 1 Total SQL backups completed: 0 Total SQL backups excluded: 0 Total SQL backups inactivated:0Throughput rate: 5,864.85 Kb/Sec Total bytes transferred: 484,442,112 Elapsed processing time: 80.67 Secs (SESSION: 14838) ANR0403I Session 14838 ended for node TS07-SQL (TDP MSSQL Win32). (SESSION: 14838) There is plenty of space in the target storage pool, so I cannot explain this 'switching' nor why it results in a failure... Thank you very much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Query Contents
Terry, Yeah I realise that I will only get which volume is on which tapes. How ever what I can't do is get that information with out specifying a tape ID. I want to get information about all the tapes without having to specify maually a tape ID. So that I can run a command or query that will tell me about all the tapes in our nasmonthly pool, ie: what tapes hold which volumes. Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Terry McColgan Sent: 08 March 2005 19:44 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Query Contents q con where stg equals a NDMP pool will yield only which volume is on the tape, not the contents on the volume. - t -Original Message- From: Iain Barnetson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 6:20 AM To: ADSM-L@VM.MARIST.EDU Subject:Re: Query Contents Can anyone suggest a query to get detailed information on the contents of the tapes of a stg pool WITHOUT me having to input the tape ID. I've tried using the * wild card with a q cont query but this wasn't allowed. This is to be used with 5.2.4 on Windows 2000 AdvSrv. The stg in question is a NDMP stg. Iain
Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2
Mark, Well, TSM allows for pre-backup and post-backup scripts as well for a given stanza. But I still think a cron/TSM scheduled job executing a script that will put the tablespaces in backup mode, followed by executing the dsmc client locally, and then putting the tablespaces back in normal is a simple way of doing it. This way, the dsmc scheduler (if using TSM scheduler) will only execute the first script, and then you run a number of manual dsmc sessions in your script backing up the necessary files. Also, this way you will have a good control of what is being backed up. Lets say you have a scenario where the dba adds more data files in a new file system. In your stanza you would have to update the DOMAIN variable manually to have this system added, and restart the dsmc -sched process. But if running the dsmc from the client, you can generate a list of files from Oracle, and then figure out which file systems that needs to be backed up, and change the command-line domain accordingly. Running the dsmc client you can on the command line change the domain. As long as the node is using its default domain/copygroup your files will end up in the correct pool. Mind you, I haven't tried this recently, but I believe the concept should still work with TSM 5.2. /Andreas Mark Tindall wrote: Andreas, this was sort of the way I had thought of but I still have one problem and that is how to take the tablespaces out of backup mode after the backup has finished. With Netbackup there were 2 scripts which were used - one pre backup and one post backup - which made sure tha backups were always started / completed before the tablespaces were placed in / taken out of backup mode. As far as I know TSM will only kick off one script which you must use to do the lot. Many thanks for your help, Mark Tindall On Wed, 9 Mar 2005 10:06:35 +0100, Andreas Almroth <[EMAIL PROTECTED]> wrote: Hi, I at least see two ways of doing it; 1) Put tablespaces in backup mode and run the TSM backup on the file systems where the data files are, or 2) Use RMAN (at least for your 8.x.x instances) to disk, and then have TSM to backup the RMAN backup pieces (If you have a lot of extra disk space this is OK) For most installations #1 would probably the most effective way to do it. There will still be a lot of manual work, and a good backup script. Both ways means you will need to have a good copy group or a dedicated domain in order to keep the backups for the retention period required. Also, using #1 means you will not need to do manual housekeeping in RMAN to synchronise with what you have got in TSM. #1 is also well documented way of doing Oracle backups, and the only thing you will need is to encapsulate those scripts so that they can be called by the TSM scheduler as command. In command script you would put the database tablespaces in backup mode, generating the list of files to be backed up, doing some grep/sort/sed/awk to figure which file systems to backup, then running the dsmc client on the file systems (don't forget any archive log files), and last put the tablespaces back in normal mode. Or instead of using TSM scheduler, just use a cron scheduled script. I'm sure there are other ways, perhaps even better ways... /Andreas Mark Tindall wrote: Hi, I am very new to Tivoli having previously used Veritas Netbackup to perform all the backups of our many databases. Our servers our now being relocated and as such will now have to make use of Tivoli for their backup schedules. As I understand it TSM 5.2 can only be used to backup Oracle databases of versions 8.1.7 and above (via RMAN). This presents a huge problem since we still have a number of production instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell me a way that I can perform backups on these databases with TSM 5.2 ? Thanks, Mark Tindall Database Administrator Thomson Scientific Tel: 0207 424 2093 Fax: 0207 424 2815
Re: space in storage pool
I've run that select statement.. and here it is tsm: TIVOLISVR>select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' group by a.stgpool_name,b.stgpool_name,a.maxscratch STGPOOL_NAME MAXUSED -- --- --- 359POOL4 500 68 359POOL5 500 76 359POOL6 500 62 ~Norita Hasan~ -Original Message- From: goc [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 4:25 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: space in storage pool to be absolutely sure run this query : select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b - where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' - group by a.stgpool_name,b.stgpool_name,a.maxscratch okay ? - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 09, 2005 8:49 AM Subject: Re: space in storage pool > I've set max is 500 and I don't even reach that figure. Any other reason? > > ~Norita Hasan~ > > > -Original Message- > From: Stef Coene [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 09, 2005 3:42 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: space in storage pool > > On Wednesday 09 March 2005 04:49, Norita binti Hassan wrote: >> Hi, >> >> I got this message, but when I checked my storage pool,there's a scratch >> volume that can be use for this backup. Can anybody explain this ? > Check the number of scratch volumes the storage pool may use. Maybe this > maximum is reached. > > > Stef > > > Pos Malaysia Berhad is Malaysia's national postal company > Visit us online at www.pos.com.my > > NOTICE > This message may contain privileged and/or confidential > information. If you are not the addressee or authorised > to receive this email, you must not use, copy, disclose > or take any action based on this email. If you have > received this email in error, please advise the sender > immediately by reply e-mail and delete this message. > Pos Malaysia Berhad takes no responsibility for the > contents of this email. > Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2
Andreas, this was sort of the way I had thought of but I still have one problem and that is how to take the tablespaces out of backup mode after the backup has finished. With Netbackup there were 2 scripts which were used - one pre backup and one post backup - which made sure tha backups were always started / completed before the tablespaces were placed in / taken out of backup mode. As far as I know TSM will only kick off one script which you must use to do the lot. Many thanks for your help, Mark Tindall On Wed, 9 Mar 2005 10:06:35 +0100, Andreas Almroth <[EMAIL PROTECTED]> wrote: > Hi, > > I at least see two ways of doing it; > > 1) Put tablespaces in backup mode and run the TSM backup on the file > systems where the data files are, or > 2) Use RMAN (at least for your 8.x.x instances) to disk, and then have > TSM to backup the RMAN backup pieces (If you have a lot of extra disk > space this is OK) > > For most installations #1 would probably the most effective way to do > it. There will still be a lot of manual work, and a good backup script. > Both ways means you will need to have a good copy group or a dedicated > domain in order to keep the backups for the retention period required. > Also, using #1 means you will not need to do manual housekeeping in RMAN > to synchronise with what you have got in TSM. > #1 is also well documented way of doing Oracle backups, and the only > thing you will need is to encapsulate those scripts so that they can be > called by the TSM scheduler as command. > > In command script you would put the database tablespaces in backup mode, > generating the list of files to be backed up, doing some > grep/sort/sed/awk to figure which file systems to backup, then running > the dsmc client on the file systems (don't forget any archive log > files), and last put the tablespaces back in normal mode. > Or instead of using TSM scheduler, just use a cron scheduled script. > > I'm sure there are other ways, perhaps even better ways... > > /Andreas > > > Mark Tindall wrote: > > >Hi, > > > >I am very new to Tivoli having previously used Veritas Netbackup to > >perform all the backups of our many databases. Our servers our now > >being relocated and as such will now have to make use of Tivoli for > >their backup schedules. As I understand it TSM 5.2 can only be used to > >backup Oracle databases of versions 8.1.7 and above (via RMAN). This > >presents a huge problem since we still have a number of production > >instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell > >me a way that I can perform backups on these databases with TSM 5.2 ? > > > >Thanks, > > > >Mark Tindall > >Database Administrator > >Thomson Scientific > >Tel: 0207 424 2093 > >Fax: 0207 424 2815 > > > > >
Re: Oracle 7.3.4 / 8.0.6 and TSM 5.2
Hi, I at least see two ways of doing it; 1) Put tablespaces in backup mode and run the TSM backup on the file systems where the data files are, or 2) Use RMAN (at least for your 8.x.x instances) to disk, and then have TSM to backup the RMAN backup pieces (If you have a lot of extra disk space this is OK) For most installations #1 would probably the most effective way to do it. There will still be a lot of manual work, and a good backup script. Both ways means you will need to have a good copy group or a dedicated domain in order to keep the backups for the retention period required. Also, using #1 means you will not need to do manual housekeeping in RMAN to synchronise with what you have got in TSM. #1 is also well documented way of doing Oracle backups, and the only thing you will need is to encapsulate those scripts so that they can be called by the TSM scheduler as command. In command script you would put the database tablespaces in backup mode, generating the list of files to be backed up, doing some grep/sort/sed/awk to figure which file systems to backup, then running the dsmc client on the file systems (don't forget any archive log files), and last put the tablespaces back in normal mode. Or instead of using TSM scheduler, just use a cron scheduled script. I'm sure there are other ways, perhaps even better ways... /Andreas Mark Tindall wrote: Hi, I am very new to Tivoli having previously used Veritas Netbackup to perform all the backups of our many databases. Our servers our now being relocated and as such will now have to make use of Tivoli for their backup schedules. As I understand it TSM 5.2 can only be used to backup Oracle databases of versions 8.1.7 and above (via RMAN). This presents a huge problem since we still have a number of production instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell me a way that I can perform backups on these databases with TSM 5.2 ? Thanks, Mark Tindall Database Administrator Thomson Scientific Tel: 0207 424 2093 Fax: 0207 424 2815
Re: Event Retention Period
If you want to go back 20 days you need to restore database backup that is 10 days old Then to go back 30 days you need another restore database backup that is 20 days old If you haven't got database backups that go back that far, you can't do it. Norita binti Hassan <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 09/03/2005 02:35 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@vm.marist.edu cc Subject Event Retention Period Hi, My current installation have set Event Record Retention Period for 10 days. How can I get back all those event record for the past 20 or 30 days. Can it be done? Thanks NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communication Tech.Div 6th Floor, Pos Malaysia Berhad 50670 Kuala Lumpur Tel : 03 - 22756638 Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email. ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. 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. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC, S+S and SSE Power Distribution are trading names of the Scottish and Southern Energy Group. **
Re: space in storage pool
to be absolutely sure run this query : select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from stgpools a,volumes b - where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' - group by a.stgpool_name,b.stgpool_name,a.maxscratch okay ? - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 09, 2005 8:49 AM Subject: Re: space in storage pool I've set max is 500 and I don't even reach that figure. Any other reason? ~Norita Hasan~ -Original Message- From: Stef Coene [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: space in storage pool On Wednesday 09 March 2005 04:49, Norita binti Hassan wrote: Hi, I got this message, but when I checked my storage pool,there's a scratch volume that can be use for this backup. Can anybody explain this ? Check the number of scratch volumes the storage pool may use. Maybe this maximum is reached. Stef Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Oracle 7.3.4 / 8.0.6 and TSM 5.2
Hi, I am very new to Tivoli having previously used Veritas Netbackup to perform all the backups of our many databases. Our servers our now being relocated and as such will now have to make use of Tivoli for their backup schedules. As I understand it TSM 5.2 can only be used to backup Oracle databases of versions 8.1.7 and above (via RMAN). This presents a huge problem since we still have a number of production instances that are still on versions 7.3.4 and 8.0.6. Can anyone tell me a way that I can perform backups on these databases with TSM 5.2 ? Thanks, Mark Tindall Database Administrator Thomson Scientific Tel: 0207 424 2093 Fax: 0207 424 2815