Re: Restoring Database to new Location
The best thing to do is to mirror the database volumes in the new location and then delete the originals -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jason Lee Sent: Friday, October 20, 2006 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restoring Database to new Location HI there, could anyone confirm that if one takes a backup of the database, then changes the location of the database files in devconfig and then does a restore of the db, it'll do the right thing and restore to the new locations... assuming you have dbvs dsmfmt'd in place? I have a 1/2 TB database to move, and going the delete dbv route will take days to complete - hence the question. Thanks Jason -- Jason Lee DreamWorks Animation (818) 695-3782
Re: Restoring Database to new Location
Here is the commands... DEFine DBCopy--volume_name--copy_volume_name-> >--++-->< | .-Wait--=--No--. | '-Formatsize--=--megabytes--+--+-' '-Wait--=--+-No--+-' '-Yes-' Then delete the original ones when the sync process finishes -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jason Lee Sent: Friday, October 20, 2006 11:28 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restoring Database to new Location Interesting, what does that mean, exactly? I have the databases, create a mirror copy, and then do a delete dbv? Thanks for your help. Jason On Oct 20, 2006, at 10:59 AM, Ribeiro, Ricardo wrote: > The best thing to do is to mirror the database volumes in the new > location and then delete the originals > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Jason Lee > Sent: Friday, October 20, 2006 10:52 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Restoring Database to new Location > > HI there, > > could anyone confirm that if one takes a backup of the database, then > changes the location of the database files in devconfig and then does > a restore of the db, it'll do the right thing and restore to the new > locations... assuming you have dbvs dsmfmt'd in place? > > I have a 1/2 TB database to move, and going the delete dbv route will > take days to complete - hence the question. > > > Thanks > > > Jason > > > -- > Jason Lee > DreamWorks Animation > (818) 695-3782
TSM DB occupied space
Hello, Can somebody please tell me if the TSM DB occupy's more space if a node has more data then a node that has more files? Example: Node A has 200 files but 1 TB of storage on the TSM pool Node B has 2 files but 200 GB of storage on the TSM pool Which occupies more space on the TSM DB? Thanks!
Re: How do you verify the Completion and Accuracy of Backups and Restores?
Try ServerGraph or Bocada, they both do a good job on reporting -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Wesley Smith Sent: Wednesday, November 08, 2006 8:41 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How do you verify the Completion and Accuracy of Backups and Restores? Hi All, I've just joined this group and I am pleased to see a lot of healthy discussion going on. The main reason I joined the group has to do with trying to find some way to help out the people who are responsible for dealing with Tivoli Storage Manager at a neighboring agency. I represent a State agency in Louisiana. We do a lot of large applications for Statewide users as well as departmental support. We do not have to deal with the H/W and OS issues. That's someone else's job. That also means that they are responsible for the backup and recovery procedures for our application servers. That's where Tivoli and you guys come in. My problem is that they (that sister agency) do not seem to have a reliable way of verifying that all backups have been properly completed. They don't even seem to have a way to know that all files (that need to be backed up) are being backed up. I've seen the reports that get generated during the backup process and I am definitely unimpressed. Backups start and backups complete. There doesn't seem to be anything that says how many rows are copied or how large the files are or anything else that could be used for verifying the accuracy of the backups. They tell my folks that we should trust Tivoli is doing the job correctly. Trust is the problem We have needed to have restores done on just a few databases in the past and the restores were not complete and up to date. In each case we were able to rebuild the data using logs maintained within the applications but that should not have been necessary. Each recovery was done at a point after a backup and before additional processing had been done within the apps so they should have been complete. In each case, the folks who run Tivoli for us were able to track down and show that problems had occurred during the processing of the backups. They did this through circumstantial evidence and in each case once again said that they have no way of verifying that the backups are actually good. I hear a lot about the difficulty of trying to write a program to process the Tivoli log files. I think I'm at wit's end with these folks and the product. I know that the people are competent and I suspect that the product (like other things available from IBM) really is weak on the reporting and verification issue. I'm hoping that someone out there in the Big Wide World has already solved this problem with an in-house or third-party solution. Sorry for being so long winded. Any ideas...? Wesley Smith
Re:
You could try pointing your web browser to the TCP/IP address of the library and use the gui there to find the physical count of empty slots then check against TSM and see if there is a mismatch, and if so, try running audit library select volume_name from libvolumes where status='Scratch' -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Matt Sent: Wednesday, November 08, 2006 9:23 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Hi all, I am having problems writing a TSM Script or command finding the number of empty slots in an IBM 3584 Library, I am running TSM 5.2.4 on Win2K, and any help will be appreciated. Thank You, Matt Martinez Systems Administrator IDEXX Laboratories, Inc. Phone:207-856-0656 Fax:207-856-8320 [EMAIL PROTECTED]
Re:
I forgot to give you the other command that displays the number select count(volume_name) from libvolumes where status='Scratch' -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Matt Sent: Wednesday, November 08, 2006 9:23 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Hi all, I am having problems writing a TSM Script or command finding the number of empty slots in an IBM 3584 Library, I am running TSM 5.2.4 on Win2K, and any help will be appreciated. Thank You, Matt Martinez Systems Administrator IDEXX Laboratories, Inc. Phone:207-856-0656 Fax:207-856-8320 [EMAIL PROTECTED]
Q DRMEDIA
Hello, Has anybody seen this issue q drmedia ANR2032E QUERY DRMEDIA: Command failed - internal server error detected. ANRD ThreadId<27> issued message 2032 from: <-0x0001007bb104 AdmQueryDRMedia <-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand <-0x000100507694 SmAdminCommandThread <-0x0001e9dc StartThread <-0x092a72dc _pthread_body ANS8001I Return code 4. Activity log output... 11/28/06 11:48:47 ANR8769E External media management function QUERY returned result=**Undefined**.(SESSION: 76853) 11/28/06 11:48:47 ANR2032E QUERY DRMEDIA: Command failed - internal server error detected.(SESSION: 76853) 11/28/06 11:48:47 ANRD ThreadId<27> issued message 2032 from: <-0x00010001bfdc outTextf <-0x0001007bb104 AdmQueryDRMedia <-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand <-0x000100507694 SmAdminCommandThread <-0x0001e9dc StartThread <-0x092a72dc _pthread_body (SESSION: 76853) I am running TSM server version 5.3.3.0 on AIX with 5.3 ML1. Ricardo Ribeiro Sr. Storage Administrator Charles Schwab & Co., Inc Phone 602-977-4629 Cell 623-217-4139 Pager 877-478-7623
TSM support for NoSQL database
Hello, Does TSM support NoSQL database from a backup/restore point of view? I have not been able to find any publications on this. Thank you!
Re: TSM support for NoSQL database
Thanks for the info, but I was thinking more from a "hot" backup mode, with some kind of agent. Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar Thompson Sent: Thursday, May 29, 2014 8:42 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM support for NoSQL database It seems like this would depend on the NoSQL database in question... Even if it does not, you have a variety of options: 1. You could backup the files on disk, assuming the DB supports some kind of write-head logging that allows you to snapshot it safely. 2. You could get some kind of serialized dump out of it, and backup the dump. On Thu, May 29, 2014 at 03:38:45PM +0000, Ribeiro, Ricardo wrote: > Hello, > Does TSM support NoSQL database from a backup/restore point of view? > I have not been able to find any publications on this. > Thank you! -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
Re: TSM support for NoSQL database
Right, I saw that link too, but I did not see anything specific to TSM and native support for NoSQL or Big Data in general. Regardless of the version of NoSQL, I just wanted to know if TSM has support for "Hot" backup modes or native support without exporting the data as most of these types of big data can be in the TB's range and exporting it will not be something we can support easily and the same for using tools like hardware base snaphosts or anything like that... Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ryder, Michael S Sent: Thursday, May 29, 2014 9:16 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM support for NoSQL database Ricardo - which NoSQL DB are you concerned about? This article might help: http://nosql.mypopescu.com/post/73955584612/quick-links-for-how-to-backup-different-nosql Best regards, Mike, x7942 RMD IT Client Services On Thu, May 29, 2014 at 11:44 AM, Ribeiro, Ricardo < ricardo.ribe...@schwab.com> wrote: > Thanks for the info, but I was thinking more from a "hot" backup mode, > with some kind of agent. > Thanks! > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of Skylar Thompson > Sent: Thursday, May 29, 2014 8:42 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] TSM support for NoSQL database > > It seems like this would depend on the NoSQL database in question... > > Even if it does not, you have a variety of options: > > 1. You could backup the files on disk, assuming the DB supports some > kind of write-head logging that allows you to snapshot it safely. > > 2. You could get some kind of serialized dump out of it, and backup > the dump. > > On Thu, May 29, 2014 at 03:38:45PM +, Ribeiro, Ricardo wrote: > > Hello, > > Does TSM support NoSQL database from a backup/restore point of view? > > I have not been able to find any publications on this. > > Thank you! > > -- > -- Skylar Thompson (skyl...@u.washington.edu) > -- Genome Sciences Department, System Administrator > -- Foege Building S046, (206)-685-7354 > -- University of Washington School of Medicine >
Re: Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause?
I didn't think it was possible to go from 5.5 to 7.1 without first going to 6... -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Boyer Sent: Tuesday, July 22, 2014 12:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause? What I think the problem is that the server was ordered with 7200RPM NLSAS volumes. The customer went back and bought 15K SAS drives. I'm re-doing the whole thing starting tomorrow. When the extract/insert phase was "paused" we could watch the disk usage on the 7.1 system going crazy. It just wasn't performing well. Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Michael Roesch Sent: Friday, July 11, 2014 6:51 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause? Hi Bill, are all DB volumes online or do you have some of them varied offline? We had this on our site, where not all DB volume copies were online when we started the upgrade. On Thu, Jul 10, 2014 at 8:48 PM, Bill Boyer wrote: > The extractdb and insertdb phase of the upgrade seems to be paused. > It's been 40 min and the # bytes read and # records inserted/extracted > haven't changed. The disk is being hit hard by the db2syscs process to > the database volumes. I've never seen the extract phase do this > before. This is my first time for a production upgrade. The source is > 30GB at 50% used. During the > 3:20 the extract has been running this pause has occurred twice. First > time for about 50-min and now fo the past 40-min. > > > > Is this normal now for V7.1 upgrades from V5? It's almost like it's > doing the update phase during the extract/insert phase. > > > > Bill Boyer > DSS, Inc. > (610) 927-4407 > "Enjoy life. It has an expiration date." - ?? >
Re: persistent binding T10000D drives on RedHat 6.4
I think for non IBM devices, you go here... For the Tivoli Storage Manager devices: Users can issue autoconf, the Tivoli Storage Manager device driver auto configure script. This script resides in the /opt/tivoli/tsm/devices/bin directory (or in the same directory as the tsmscsi file) to be able to configure devices and get all the current special file names and device information. The device special file name is /dev/mtX for tape devices and /dev/lbX for medium changers. Tip: Special file name: dev/tsmscsi/mt0, /dev/tsmscsi/lb0 Note: Alternatively, reinstalling the IBM device driver. Tivoli Storage Manager device driver updates all the current special file names. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Monday, October 6, 2014 7:51 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] persistent binding T1D drives on RedHat 6.4 Hello everybody, I'm in the process of configuring Oracle T1D tape drives on RedHat 6.4 using the TSM device driver 7.1.1 (LAN-free backup), the TSM server 7.1.1 itself is running on AIX 7.1 . The autoconf and tsmdlst do show all the drives on the Redhat nodes but I would like to add them to the udev rules so that the device files are persistent whenever the server requires a reboot. Until now, we were using IBM LTO drives and had the following entry in the 98-lin_tape.rules file for them: KERNEL=="IBMtape*", ATTRS{serial_num}=="1068100xyz", SYMLINK="lin_tape/tsm_drive" But what is the equivalent entry for a T1D drive? I've tried the following: KERNEL=="sg*", ATTRS{serial_num}=="57900400abcd", SYMLINK="lin_tape/t10d_drive" But that doesn't seem to do the trick. Can anybody assist me towards the correct entry? Many thanks! Best regards, Kurt *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
Re: v7 upgrade woes
These are the steps that will let you monitor the progress... nohup /opt/tivoli/tsm/server/bin/dsmserv insertdb sesswait=60 >insert.out 2>&1 & Monitor the output of the process. Verify that the DSMSERV INSERTDB process has issued the following message before continuing to the next step: ANR1336I INSERTDB: Ready for connections from the source server Issue the following command to monitor the process output in the insert.out file: tail -f insert.out (12) Start the extraction from the original server. Specify the TCP/IP address and port for the V6.3 server. Direct the output of the process to a file for monitoring: run as root ID nohup /usr/tivoli/tsm/upgrade/bin/dsmupgrd extractdb hladdress=10.xxx.xxx.xxx lladdress=1500 >extract.out 2>&1 & nohup /usr/tivoli/tsm/upgrade/bin/dsmupgrd extractdb hladdress=127.0.0.1 lladdress=1500 >extract.out 2>&1 & Monitor the processes for errors and warning messages, and for items that you might need to take action on: tail -f extract.out (13) Ensure you get something similar to this message: ANR0900I Processing options file /home/tsminst1/dsmserv.opt. ANR0921I Tracing is now active to file server.trace. ANR7811I Using instance directory /home/tsminst1. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 13052 megabytes. ANR0201I Database assigned capacity is 143352 megabytes. 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. ANR1635I The server machine GUID, 00.00.00.00.9f.fb.11.db.94.98.08.63.0a.65.cd.15, has initialized. ANR2283I Database backup trigger defined, but is disabled. ANR4726I The NAS-NDMP support module has been loaded. ANR8440E Initialization failed for SCSI library DD565LIB; will retry in 2 minute(s). ANR8440E Initialization failed for SCSI library LANFREELIB; will retry in 2 minute(s). ANR4029I EXTRACTDB: Database checkpoint started. ANR4030I EXTRACTDB: Database checkpoint completed. ANR0610I EXTRACTDB started by ADMINISTRATOR as process 1. ANR8214E Session open with 10.xxx.xxx.xxx failed due to connection refusal. ANR0454E Session rejected by server $UPGRADETARGET$, reason: Communication Failure. ANR1396E EXTRACTDB: Process 1, database extract, has completed with errors. ANR1383I EXTRACTDB: Found 0 database objects. ANR1384I EXTRACTDB: Processed 0 database objects. ANR1385I EXTRACTDB: Skipped 0 empty database objects. ANR1386I EXTRACTDB: Failed to process 0 database objects. ANR1387I EXTRACTDB: Processed 0 database records. ANR1388I EXTRACTDB: Read 0 database pages. ANR1389I EXTRACTDB: Wrote 0 bytes. ANR1390I EXTRACTDB: Elapsed time was 0:00:01. ANR1391I EXTRACTDB: Throughput was 0.00 megabytes per hour. ANR1394E EXTRACTDB: Failed to start or failed to complete successfully. s0017pdv root@/home/tsminst1 -> ANR0478W Session request refused. Server is running in standalone mode. ANR1336I INSERTDB: Ready for connections from the source server. Remaining time: 0:56:00 ANR1337I A DBBACKUP trigger has been removed. ANR1379I INSERTDB: Read 86,445,332 bytes and inserted 378,967 database entries in 0:00:00 (0.00 megabytes per hour). ___ Database Upgrade. ANR1305I Disk volume /dev/rtsmcxdsklv1 varied online. ANR0409I Session 1 ended for server $UPGRADETARGET$ (AIX). ANR1382I EXTRACTDB: Process 1, database extract, has completed. ANR1383I EXTRACTDB: Found 118 database objects. ANR1384I EXTRACTDB: Processed 59 database objects. ANR1385I EXTRACTDB: Skipped 59 empty database objects. ANR1386I EXTRACTDB: Failed to process 0 database objects. ANR1387I EXTRACTDB: Processed 788,564 database records. ANR1388I EXTRACTDB: Read 35,110 database pages. ANR1389I EXTRACTDB: Wrote 140,828,690 bytes. ANR1390I EXTRACTDB: Elapsed time was 0:02:30. ANR1391I EXTRACTDB: Throughput was 3216.00 megabytes per hour. _ Good luck! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Tuesday, June 7, 2016 12:46 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] v7 upgrade woes Sorry to hear that. I just went through this similar upgrade without a hitch, and I'm planning two more. On Tue, Jun 7, 2016 at 1:31 PM, Rhodes, Richard L. < rrho...@firstenergycorp.com> wrote: > This is half plea for help and half rant (grr). > > For the past two months we've been trying to test a TSM v6.3.5 to > v7.1.4/v7.1.5 upgrade . . . . and have completely failed! > > TSM v6.3.5 > AIX 6100-09 > upgrade to TSM v7.1.4 and/or v7.1.5 > > When we run the upgrade it runs to this status message: > Installing: [(99%) com.tivoli.dsm.server.db2.DB2PostInstall ] Then > it sits, doing nothing. AIX sees no db2 activity, no java activity,
Re: Splitting the TSM Database into three
The only way that I know to split then TSM db is to create a new TSM server and export clients to it. Good luck! :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Daad Ali Sent: Monday, July 09, 2007 11:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Splitting the TSM Database into three Hi All, We are discussing a way of splitting our TSM database. It is become very big and slow. We want to split it into 2 or 3(one will be the manager of the other two) I don't know how to split it so I am looking for a procedure/steps on how to do that. Also, after splitting the database, can I assign different platforms (AIX/Windows) to the two DBs. My db is about 200 GBs now and the server is version 5.2.6.0 >q db f=d Available Space (MB): 180,000 Assigned Capacity (MB): 180,000 Maximum Extension (MB): 0 Maximum Reduction (MB): 14,824 Page Size (bytes): 4,096 Total Usable Pages: 46,080,000 Used Pages: 34,660,427 Pct Util: 75.2 Max. Pct Util: 75.4 Physical Volumes: 9 Buffer Pool Pages: 272,144 Total Buffer Requests: 293,217,483 Cache Hit Pct.: 99.05 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 5,818.36 Percentage Changed: 4.30 Last Complete Backup Date/Time: 07/09/07 01:15:44 == tsm: BRDTSM01>q log f=d Available Space (MB): 12,000 Assigned Capacity (MB): 10,020 Maximum Extension (MB): 1,980 Maximum Reduction (MB): 10,000 Page Size (bytes): 4,096 Total Usable Pages: 2,564,608 Used Pages: 4,369 Pct Util: 0.2 Max. Pct Util: 68.3 Physical Volumes: 6 Log Pool Pages: 128 Log Pool Pct. Util: 8.54 Log Pool Pct. Wait: 0.00 Cumulative Consumption (MB): 4,768,612.50 Consumption Reset Date/Time: 12/07/05 14:37:35 Thanks as always. Daad - Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail
Simultaneous Write
Hello, I would like to know if someone has experience using the "Simultaneous Write" feature of TSM 5.4? We are thinking about creating a copy_pool on a remote site tape library and enable this feature to see if we can create the copy tapes at a remote site directly. Has anybody done this? Thanks! Ricardo Ribeiro Sr. Storage Administrator Charles Schwab & Co., Inc Phone 602-977-4629 Cell 623-217-4139 Pager 877-478-7623
Oracle RMAN issue
Hello, I am running this version of TDP under Linux and getting this error message, any ideas? Thanks! TIVsm-API-5.3.2-0 TIVsm-stagent-5.3.3-0 TIVsm-BA-5.3.2-0 TIVsm-tsmscsi-5.3.3-0 TIVsm-API64-5.3.2-0 [TDP-Oracle.Utility-5.2.4-0 TDP-Oracle-5.2.4-0 TDP Error 10/08/07 08:59:07 ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE) TDPO LinuxAMD64 ANU0599 TDP for Oracle: (28168): => (s0147bdc-oracle) ANS1301E (RC1)Server detected system error (SESSION: 1129697) Activity Log entries for this (TDPO LinuxAMD64) (Tcp/Ip 10.104.58.29(53869)). (SESSION: 1129697) 10/08/07 08:59:05 ANRD smnode.c(16241): ThreadId <111> Unexpected rc=19 from imGetNextBackup (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> issued message from: (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x000100025aec outDiagf (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001002d6b6c DoBackQry (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001002e9114 SmNodeSession (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001a620c HandleNodeSession (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001a9ed4 DoNodeGeneral (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001ab98c smExecuteSession (SESSION: 1129697) more... ( to continue, 'C' to cancel) 10/08/07 08:59:05 ANRD ThreadId <111> 0x00010036f578 SessionThread (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001fdfc StartThread (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x09411448 _pthread_body (SESSION: 1129697) 10/08/07 08:59:07 ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE) TDPO LinuxAMD64 ANU0599 TDP for Oracle: (28168): => (s0147bdc-oracle) ANS1301E (RC1)Server detected system error (SESSION: 1129697) 10/08/07 08:59:07 ANR0403I Session 1129697 ended for node S0147BDC-ORACLE (TDPO LinuxAMD64). (SESSION: 1129697) 10/08/07 09:10:44 (111) Context report (SESSION: 1129697) 10/08/07 09:11:05 (111) Thread AcceptorThread (59) is a parent thread related to: 111 (SESSION: 1129697) 10/08/07 09:11:36 (59) Failed attempt #1 to get TMV->mutex (SESSION: 1129697) 10/08/07 09:14:20 (59) Failed attempt #2 to get TMV->mutex (SESSION: 1129697) 10/08/07 09:17:12 (59) Generating TM Context Report: (struct=tmTxnDesc) (slots=256)(SESSION: 1129697) 10/08/07 09:17:15 (59) *** no transactions found *** (SESSION: 1129697) more... ( to continue, 'C' to cancel) 10/08/07 09:17:18 (59) Generating Database Transaction Table Context: (SESSION: 1129697) 10/08/07 09:17:19 (59) *** no transactions found *** (SESSION: 1129697) 10/08/07 09:17:20 (59) Generating SM Context Report: (SESSION: 1129697) 10/08/07 09:17:21 (59) *** no sessions found *** (SESSION: 1129697) 10/08/07 09:17:23 (59) Generating AS Vol Context Report: (SESSION: 1129697) 10/08/07 09:17:27 (59) No mounted (or mount in progress) volumes. (SESSION: 1129697) 10/08/07 09:17:31 (59) Generating ssSession Context Report: (SESSION: 1129697) 10/08/07 09:17:35 (59) No storage service sessions active. (SESSION: 1129697) 10/08/07 09:17:38 (59) Generating ssOpenSeg Context Report: (SESSION: 1129697) 10/08/07 09:17:44 (59) No storage service segments found. (SESSION: 1129697) 10/08/07 09:17:47 (59) Failed attempt #1 to get BFV->mutex (SESSION: 1129697) 10/08/07 09:19:14 (59) Generating BF Copy Control Context Report: (SESSION: 1129697) 10/08/07 09:19:19 (59) No global copy control blocks. (SESSION: 1129697) 10/08/07 09:19:23 (SESSION: 1129697) more... ( to continue, 'C' to cancel) 10/08/07 09:19:35 (111) SessionThread : ANRD calling thread (SESSION: 1129697) 10/08/07 09:19:42 (111) Generating TM Context Report: (struct=tmTxnDesc) (slots=256)(SESSION: 1129697) 10/08/07 09:19:49 (111) slot -> 145: (SESSION: 1129697) 10/08/07 09:19:52 (111) Tsn=0:1679522705, Resurrected=False, InFlight=True, Distributed=False (SESSION: 1129697) 10/08/07 09:19:57 (111) Participants=1, summaryVote=ReadOnly (SESSION: 1129697) 10/08/07 09:20:02 Pa
Re: Oracle RMAN issue
Not using Lan-Free... -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Wira Chinwong Sent: Monday, October 08, 2007 7:41 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Oracle RMAN issue Did you have used the Lan-free feature? If so, try to check your lan-free setting. Wira -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ribeiro, Ricardo Sent: Tuesday, October 09, 2007 12:46 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Oracle RMAN issue Hello, I am running this version of TDP under Linux and getting this error message, any ideas? Thanks! TIVsm-API-5.3.2-0 TIVsm-stagent-5.3.3-0 TIVsm-BA-5.3.2-0 TIVsm-tsmscsi-5.3.3-0 TIVsm-API64-5.3.2-0 [TDP-Oracle.Utility-5.2.4-0 TDP-Oracle-5.2.4-0 TDP Error 10/08/07 08:59:07 ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE) TDPO LinuxAMD64 ANU0599 TDP for Oracle: (28168): => (s0147bdc-oracle) ANS1301E (RC1)Server detected system error (SESSION: 1129697) Activity Log entries for this (TDPO LinuxAMD64) (Tcp/Ip 10.104.58.29(53869)). (SESSION: 1129697) 10/08/07 08:59:05 ANRD smnode.c(16241): ThreadId <111> Unexpected rc=19 from imGetNextBackup (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> issued message from: (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x000100025aec outDiagf (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001002d6b6c DoBackQry (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001002e9114 SmNodeSession (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001a620c HandleNodeSession (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001a9ed4 DoNodeGeneral (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001001ab98c smExecuteSession (SESSION: 1129697) more... ( to continue, 'C' to cancel) 10/08/07 08:59:05 ANRD ThreadId <111> 0x00010036f578 SessionThread (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x0001fdfc StartThread (SESSION: 1129697) 10/08/07 08:59:05 ANRD ThreadId <111> 0x09411448 _pthread_body (SESSION: 1129697) 10/08/07 08:59:07 ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE) TDPO LinuxAMD64 ANU0599 TDP for Oracle: (28168): => (s0147bdc-oracle) ANS1301E (RC1)Server detected system error (SESSION: 1129697) 10/08/07 08:59:07 ANR0403I Session 1129697 ended for node S0147BDC-ORACLE (TDPO LinuxAMD64). (SESSION: 1129697) 10/08/07 09:10:44 (111) Context report (SESSION: 1129697) 10/08/07 09:11:05 (111) Thread AcceptorThread (59) is a parent thread related to: 111 (SESSION: 1129697) 10/08/07 09:11:36 (59) Failed attempt #1 to get TMV->mutex (SESSION: 1129697) 10/08/07 09:14:20 (59) Failed attempt #2 to get TMV->mutex (SESSION: 1129697) 10/08/07 09:17:12 (59) Generating TM Context Report: (struct=tmTxnDesc) (slots=256)(SESSION: 1129697) 10/08/07 09:17:15 (59) *** no transactions found *** (SESSION: 1129697) more... ( to continue, 'C' to cancel) 10/08/07 09:17:18 (59) Generating Database Transaction Table Context: (SESSION: 1129697) 10/08/07 09:17:19 (59) *** no transactions found *** (SESSION: 1129697) 10/08/07 09:17:20 (59) Generating SM Context Report: (SESSION: 1129697) 10/08/07 09:17:21 (59) *** no sessions found *** (SESSION: 1129697) 10/08/07 09:17:23 (59) Generating AS Vol Context Report: (SESSION: 1129697) 10/08/07 09:17:27 (59) No mounted (or mount in progress) volumes. (SESSION: 1129697) 10/08/07 09:17:31 (59) Generating ssSession Context Report: (SESSION: 1129697) 10/08/07 09:17:35 (59) No storage service sessions active. (SESSION: 1129697) 10/08/07 09:17:38 (59) Generating ssOpenSeg Context Report: (SESSION: 1129697) 10/08/07 09:17:44 (59) No storage service segments found. (SESSION: 1129697) 10/08/07 09:17:47 (59) Failed attempt #1 to get BFV->mutex (SESSION: 1129697) 10/08/07 09:19:14 (59) Generating BF Copy Control Context Report: (SESSION: 1129697) 10/08/07 09:19:19 (59) No global copy control blocks. (SESSION: 1129697) 10/08/
Re: Mixing LTO2 LTO4 in 3584 libr
Yes... Do you have a specific question about the mix? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Michael Green Sent: Saturday, November 10, 2007 9:07 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Mixing LTO2 LTO4 in 3584 libr Curious to find out if anyone has a mix of LTO2 (or maybe LTO3) and LTO4 drives in the same virtual library (3584)? -- Warm regards, Michael Green
Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.
Just run this statement... SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of CAYE PIERRE Sent: Monday, November 12, 2007 8:23 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node. Sorry I miss a word... It is for backup only, not restore > -Message d'origine- > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part > de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : > ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out - > when was the last time a restore was performed for a TSM node. > > I am sure I must be missing something obvious, else I am going to > learn a new trick... how do you determine from QUERY FILESPACE F=D > when a node last performed a restore? > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development Level 3 Team Lead > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet > e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli > StorageManager.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" wrote on 11/12/2007 > 07:49:17 AM: > > > That did the trick. Thanks for the tip > > > > Regards, > > > > Kamran > > > > -Original Message- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf > > Of CAYE PIERRE > > Sent: Monday, November 12, 2007 4:07 AM > > To: ADSM-L@VM.MARIST.EDU > > Subject: Re: [ADSM-L] Is their a way to find out - when was > the last > > time a restore was performed for a TSM node. > > > > You can also query filespaces : q fi f=d > > > > > -Message d'origine- > > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À : > > > ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Is their a way to > find out - > > > when was the last time a restore was performed for a TSM node. > > > > > > Hello, > > > > > > > > > > > > Just curious to know if their a way to find out - when > was the last > > > time a restore was performed for a particular TSM node. > > > > > > > > > > > > Regards, > > > > > > > > > > > > Kamran H. Rao > > > >
Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.
Run this statement... SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kamran Rao Sent: Monday, November 12, 2007 8:25 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node. It is for a restore. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of CAYE PIERRE Sent: Monday, November 12, 2007 10:23 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node. Sorry I miss a word... It is for backup only, not restore > -Message d'origine- > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part > de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : > ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out - > when was the last time a restore was performed for a TSM node. > > I am sure I must be missing something obvious, else I am going to > learn a new trick... how do you determine from QUERY FILESPACE F=D > when a node last performed a restore? > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development Level 3 Team Lead > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet > e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli > StorageManager.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" wrote on 11/12/2007 > 07:49:17 AM: > > > That did the trick. Thanks for the tip > > > > Regards, > > > > Kamran > > > > -Original Message- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf > > Of CAYE PIERRE > > Sent: Monday, November 12, 2007 4:07 AM > > To: ADSM-L@VM.MARIST.EDU > > Subject: Re: [ADSM-L] Is their a way to find out - when was > the last > > time a restore was performed for a TSM node. > > > > You can also query filespaces : q fi f=d > > > > > -Message d'origine- > > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À : > > > ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Is their a way to > find out - > > > when was the last time a restore was performed for a TSM node. > > > > > > Hello, > > > > > > > > > > > > Just curious to know if their a way to find out - when > was the last > > > time a restore was performed for a particular TSM node. > > > > > > > > > > > > Regards, > > > > > > > > > > > > Kamran H. Rao > > > >
Select statement
Hello, Does anyone has a select statement I can use to find out how many tapes I used on a daily basis? Thanks!
Re: Select statement
No, I need one that tells me how many I used and not how many I have... Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Choudarapu, Ramakrishna (GTI) Sent: Friday, January 04, 2008 11:17 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement We use this to find out the scratch counts: select library_name, status, count(*) as VOL_COUNT from libvolumes group by library_name,status Is this the one, you are looking for? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ribeiro, Ricardo Sent: Friday, January 04, 2008 1:12 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select statement Hello, Does anyone has a select statement I can use to find out how many tapes I used on a daily basis? Thanks! This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing.
Re: Select statement
Thank you! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, January 04, 2008 12:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote: > Hello, > Does anyone has a select statement I can use to find out how many > tapes I used on a daily basis? > Thanks! Most commonly, tapes automatically come from the scratches collection and return to scratch when emptied (rather than being assigned to a storage pool via DEFine Volume). And, UPDate Volume is rarely performed on volumes such that the administrative change timestamp remains that of when the volume was taken from scratch to be used in a storage pool. For basic reporting you can thus employ a variant of a Select statement like: select * from volumes where DAYS(CURRENT_DATE)-DAYS(CHG_TIME)<2 and DATE(LAST_WRITE_DATE)=DATE(CURRENT_TIMESTAMP) From that point of departure you can play with timestamps for desired intervals, and further select on STATUS value as desired. Richard Sims http://people.bu.edu/rbs/
Re: Select statement
Good idea, thanks Ricardo Ribeiro Storage Administrator 623-217-4139 - Original Message - From: ADSM: Dist Stor Manager To: ADSM-L@VM.MARIST.EDU Sent: Fri Jan 04 16:38:41 2008 Subject: Re: [ADSM-L] Select statement You could also look at volhistory where use(?)='STGNEW' and date =desired range. From: ADSM: Dist Stor Manager on behalf of Ribeiro, Ricardo Sent: Fri 1/4/2008 2:51 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement Thank you! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, January 04, 2008 12:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote: > Hello, > Does anyone has a select statement I can use to find out how many > tapes I used on a daily basis? > Thanks! Most commonly, tapes automatically come from the scratches collection and return to scratch when emptied (rather than being assigned to a storage pool via DEFine Volume). And, UPDate Volume is rarely performed on volumes such that the administrative change timestamp remains that of when the volume was taken from scratch to be used in a storage pool. For basic reporting you can thus employ a variant of a Select statement like: select * from volumes where DAYS(CURRENT_DATE)-DAYS(CHG_TIME)<2 and DATE(LAST_WRITE_DATE)=DATE(CURRENT_TIMESTAMP) From that point of departure you can play with timestamps for desired intervals, and further select on STATUS value as desired. Richard Sims http://people.bu.edu/rbs/
Re: TDP Compression
Also, you can run ./tdpoconf showenv, this output will tell you if compression is enabled. Ricardo Ribeiro Charles Schwab & Co,. Inc. PHXDC-02-2178 PO Box 61863 Phoenix, AZ 85082-1863 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Hart, Charles A Sent: Monday, August 02, 2010 1:04 PM To: ADSM-L@vm.marist.edu Subject: Re: [ADSM-L] TDP Compression 1) Q node f=d see if Compression set to Yes ort Client if client then check dsm.sys options 2) Your act log TDP summary job will. Let uyou know it says compressed at the end 08/02/10 14:03:08 ANE4991I (Session: 8215330, Node: DBSS-ORACLUSTER) TDP Oracle SUN ANU0599 TDP for Oracle: (2645): =>() ANU2526I Backup details for backup piece /ora_db//c-611266183-20100802-1c (database "ancprr"). Total bytes sent: 53739520. Total processing time: 00:00:01. Throughput rate: 52480.00Kb/Sec. Compressed: No -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Monday, August 02, 2010 2:50 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP Compression Is there an easy way to see which TDP backups (SQL, Oracle) are using client compression? These jobs are all client initiated jobs through a batch process. I need to gather this information from the TSM side. I have searched the activity log and cannot find anything for TDP compression. Andy Huebner 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 in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Anybody using SANergy out there
I would like to know if you guys have ran into any problems, issues, etc Thanks! Ricardo Ribeiro TSM Architect (Distributed Storage Group) Charles Schwab & Co., Inc BlackBerry 623-217-4139 Phone 602-977-4629
Re: Restore performance puzzler
Shawn, Based on this information it appears that the VTL is only attached to the TSM server correct? So, the data to the client is not going to be as fast as restoring to the TSM server. Things to consider are... What is the LAN speed and duplex settings for the client? How is the LAN traffic when you are trying to restore? Is compression enabled on the TSM client side? How many channels/threads/mount points are you allowing the client to use? What type of data are you restoring, compress, database data, etc? Can you ping the TSM server from the client? Can you ping the Client from the TSM server? Anyway, I hope this helps! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Drew Sent: Wednesday, June 25, 2008 2:47 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore performance puzzler 5.4.1 AIX Server 5.3.4 AIX 5.1 Client Performing a 12 gB restore. (6x2gB files) The restore is performing at a rate of about 250-500 KB/s with bursts up to a whopping 750KB/s (Looking at the VTL drive monitor) If we perform the restore locally to the TSM server's file system, it is fast. (20-30 MB/sex) We can FTP the data to the client fast as well, 10-15MB/sec A restore of the same files performed at the client crawls. We are upgrading to 5.3.6, which looks to be the newest AIX 5.1 client we can use. Any ideas? Regards, Shawn 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 can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.
Re: Tricky conversion problem
One idea that you can try is to use the "GENERATE BACKUPSET" command and store this media for as long as you want. That way you can tell him that you have a saved copy of his data then move him to the new server and it should run a full backup of all his data anyway onto the new media. My two cents! :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Martha McConaghy Sent: Tuesday, July 08, 2008 11:09 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Tricky conversion problem We are moving to a new TSM server on a Pseries box with an IBM 3592 tape system from a very old mainframe based TSM server. We had not planned on moving any of the old data over to the new server as there was no requirement for it. However, we run into a single user who wants to have all of his previous backups moved to the new server, even though most are no longer usable (we are talking about old OS2 systems, etcevery PC he has ever used in the last 20 years). Since this user is our 2nd line manager, we have no choice to try and figure something out. The main problem is that the two servers are not compatible. The old server can only talk to 3590 tape drives, whose tapes are not usable in the new 3592s. So, I can't just export the data to tape and then import into the new server. (Ah if only life were that easy!). On a hunch, I've tried creating a server connection between old and new TSM server. Then, I exported a filespace to a virtual volume (devclass=server) on the new server. It sits on a 3592 tape right now. However, the new server will not allow me to import this tape, as it belongs to a pool and it thinks it is in use. Is there any way to make this work? I'm at a loss for ideas at this point. I could create a virtual volume on disk and move the old filespaces to it, but then I'll have to keep the old server running "forever" or at least until it will run no longer. Anyone have any ideas? Martha McConaghy Strategic Planner/Project Manager Marist College IT
Re: Deletion of onsite tape
Rich, My guess is that TSM expired some of the data that was on that volume, so when it restored it only restored non-expired data I guess if you have the database backup volume from when you would like to restore, you can try and do a point in time restore, that should work on your mini DR server. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Mochnaczewski Sent: Friday, July 18, 2008 7:19 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deletion of onsite tape Hi *, I have a scenario. We had an onsite tape that got mangeled by a drive. The tape showed 75% usage initially. When we did the restore from offsite tapes, TSM reported that it completed successfully but there was still 15% left on the tape. The user went ahead and did a del vol discarddata=yes ( yes , I already hear the groans ) and looking through the logs see the following message : 14.07.2008 10:28:05 ANR1256W Volume C60255 contains files that could not be restored. (SESSION: 130878) What we would like to do is setup TSM on a test server and perform a mini-DR. That is, restore the database prior to the del and do a query content on the volume and check against the current database to see what data is missing. My questions : 1) Why would TSM report the restore being successful when there was still data on it ? Could it be that running an audit vol would have fixed the volume against database and there was no data lost, just a volume messing up the TSM database pointers ? 2) We have the volumes that were used for the restore. Is there any way of restoring the data and then importing it back into the current environment ? TSM Server : TSM 5.3.6.3 ( being upgrading to TSM 5.4 shortly ) AIX5.3 Rich Standard Life : 175 ans au coeur de nos vies Standard Life: Part of our lives for 175 years
Re: Server looking for volume in wrong library
I wonder if you could have a label problem on that tape, you may want to re-label it. Also, when you run the command "q libvol TJULIB01_1120" what is the status of that one tape? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: Friday, October 17, 2008 12:59 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Server looking for volume in wrong library We have a 5.4.2.0 server running under mainframe Linux. We are seeing an annoying error approximately once per month. We have three libraries defined in the TSM database. All three are really a single 3494 physical library. Library TJULIB01_3592 contains 3592 media formatted for an uncompressed capacity of 300 GB. It is used for primary storage pools. Library TJULIB01_1120 contains 3592 media formatted for an uncompressed capacity of 500 GB. It is used for copy storage pools. Library TJULIB01 contains 3590 media for copy storage pools. We have stopped writing to this type of media and will delete this library once we have a complete set of copies on 3592 media. We run reclamation for our new offsite storage pool with five concurrent processes. Approximately once per month TSM tries to find an input tape in library TJULIB01_1120. When this happens TSM displays a long series of messages requesting that the input tape involved be inserted into library TJULIB01_1120 and then reports a mount failure. When we investigate these failures, 'q libvol' commands always show that the volume is in TJULIB01_3592, as it should be, and 'mtlib' commands issued from a shell prompt show that the volume is in the physical library and has the right category. Searches of the activity log have never turned up any sign of 'checkin' and 'checkout' commands being used to shift the volume between libraries between the failure and the investigation. Searches for some of the message numbers that show up when the problem occurs turned up APAR IC48313, which does cause TSM to look for volumes in the wrong libraries. However, that APAR is only supposed to apply to TSM 5.3, and the APAR description indicates that the problem occurs when two reclamation processes try to access the same volume. The activity log for the last occurance of the problem shows no sign of concurrent requests. The volume was used and dismounted almost 14 hours before the problem occured, and the volume was not mentioned in the activity log again until TSM started asking that it be inserted into the wrong library.
Re: Server looking for volume in wrong library
The only other suggestion I have is to query the volume history and see what library used it last. "q volhist" Good luck. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: Friday, October 17, 2008 1:34 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Server looking for volume in wrong library -Ricardo.Ribeiro wrote: - >I wonder if you could have a label problem on that tape, you may want >to re-label it. The tape involved in the latest occurance of the problem was loaded, read, and unloaded without incident about 14 hours before the problem occurred, and again about 10 hours after the problem occurred. In any case, TSM finds out which library a tape is in by consulting the TSM database, not by reading the tape label. >Also, when you run the command "q libvol TJULIB01_1120" what is the >status of that one tape? The tape does not appear in the output from such a query. This is what I would expect; the tape was never supposed to be in the TJULIB01_1120 library, and I have found no evidence that it was ever put into that library erroneously. A similary query for the TJULIB01_3592 library shows a status of 'Private' and last use of 'Data' for the volume. This is exactly the result I would expect.
Re: IBM TS3310 Checkin/Checkout Tape Operational Question
Use the web interface of the library and assign the tapes to the logical library, that should work. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Wanda Prather Sent: Wednesday, November 05, 2008 9:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] IBM TS3310 Checkin/Checkout Tape Operational Question NO that's not normal. Something is hosed up in the config. The TS3310 should work just like a 3584 responding to a CHECKIN. (Your SEARCH=BULK should NOT have worked after you manually moved the tapes to storage slots.) What you didn't say is which I/O slots you are using. The 3310 can be configured with 6 I/O slots in the base unit, or with the 6 slots plus the (12? don't remember) slots in the expansion unit. Which are you using? I've seen some flaky problems trying to use the lower slots if things weren't configured properly. Never seen any issues using the top 6. -If you have changed the config of the logical library, make sure you stop and restart TSM. It has to pick up the number of slots & I/O slots when it starts. -Also: this is really weird, but make sure your HBA drivers are current. I actually saw a 3310 that has a problem with the I/O slots until the HBA drivers were updated to a level that included the correct tape I/O support.. On Wed, Nov 5, 2008 at 10:43 AM, Lamb, Charles P. <[EMAIL PROTECTED]> wrote: > Hi. > > We have just installed a brand new TS3310 ==> IBM 3576-L5B ATL. Atape > version is 11.2.7.0 and ATL version is 500GS002 which appears to be > current. TSM version is 5.4.3.2 and IBM 7026-H70 AIX V5.3.8.3. We > have an IBM 3584-L32/D32 ATL which works differently concerning the > checkin/checkout tapes via I/O slots. Does the TS3310 I/O slots work > differently as oppose to the IBM 3584-L32/D32 ATL I/O slots. See > below for the TS3310 operational tasks. > > We have run tapeutil -f /dev/smc0 inventory which shows robot, I/O > slots, drives and library slots. > > Step one of this morning. > 1) Placed tapes into I/O slots > 2) IBM 3576 screen asked where the tapes should go system or cgoatl03 > - hit cgoatl03 button and OK button > 3) Ran label libv 3576lib checkin=scr overwrite=yes search=bulk > labelsource=barcode > 4) We found in activity log anr8386w messages -- slot xx of library > 3576lib is inaccessible, slot xx are the I/O slots > > Step two this morning. > 1) Placed tapes into I/O slots > 2) IBM 3576 screen asked where the tapes should go system or cgoatl03 > - hit cgoatl03 button and OK button > 3) We went into IBM 3576 web GUI and manually moved the tapes from I/O > slots to IBM 3576 library open slots > 4) Ran label libv 3576lib checkin=scr overwrite=yes search=bulk > labelsource=barcode > 5) Ran q libv and showed the tapes as scratch tapes > > Why do we need step #3 above?? Is this normal?? >
Re: NDMP restore
We use the regular TSM client GUI, it works pretty good so far... The other option is to use the command line, but you will need to know the path of the file(S) you are restoring. I have not try the ISC GUI yet. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Monday, November 10, 2008 2:50 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] NDMP restore We are new to the NDMP side of TSM. One of the things we found out was that ISC cannot load a TOC with 545K objects. This is an IBM confirmed limitation of the ISC and is based on the size of the TOC. For those with NDMP, how do you handle file restores if the user is unsure of a file's name or date from which to restores? Do you dump the TOC, or is there a command I have missed? It all works fine from the command line if we know the file name and date. TSM - AIX 5.4.2.0 NDMP - EMC Celerra ISC - 6.0.1 Frustration - 10.0 Andy Huebner 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 in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: TSM cmd after library has been defined again..
Here is an easier one... Syntax for a SCSI library >>-LABEl LIBVolume--library_name> more... ( to continue, 'C' to cancel) >+-volume_name+ '-SEARCH--=--+-Yes--| A |--+--LABELSource--=--+-Barcode+-' '-Bulk--| A |-' +-Prompt-+ '-Vollist--| B |-' .-OVERWRITE--=--No--. >--+-+--+---+---> '-CHECKIN--=--+-SCRatch-+-' '-OVERWRITE--=--+-No--+-' '-PRIvate-''-Yes-' -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Remco Post Sent: Tuesday, November 27, 2012 11:55 AM To: ADSM-L@vm.marist.edu Subject: Re: [ADSM-L] TSM cmd after library has been defined again.. checkin libv search=y stat=scr checkl=[bar|yes] checkin libv search=y stat=priv checkl=[bar|yes] in that order On 27 nov. 2012, at 19:37, "Swartz, Jerome" wrote: > Hi All, > > Haven't touched TSM in a while. Needed to delete the paths, drives and > library. > > I just defined those again and there is a command that I need to run so that > TSM can see the tapes in the library. > > Just can't get to it! Q libv doesn't return any results.. > > Thanks in advance! > > Jerome > > > > ** > COMPUTACENTER PLC is registered in England and Wales with the > registered number 03110569. Its registered office is at Hatfield > Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW > COMPUTACENTER (UK) Limited is registered in England and Wales with the > registered number 01584718. Its registered office is at Hatfield > Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW > COMPUTACENTER (Mid-Market) Limited is registered in England and Wales > with the registered number 3434654. Its registered office is at > Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 > 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales > with the registered number 3798091. Its registered office is at > Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 > 9TW > > The contents of this email are intended for the named addressee only. > It contains information which may be confidential and which may also be > privileged. > Unless you are the named addressee (or authorised to receive mail for the > addressee) you may not copy or use it, or disclose it to anyone else. > If you receive it in error please notify us immediately and then destroy it. > Computacenter information is available from: > http://www.computacenter.com > ** -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622