Backup performance
Hi there, first of all sorry for the long append but I need to explain my problem in detail. I was trying to optimize our backup performance for a particular node, so I got a look at INSTR_CLIENT_DETAIL trace output. Server is ADSM 3.1.2.50 on OS/390 V2R6 Client is USS 3.1.0.5 Commethod is TCPIP using a CTC (Channel To Channel) connection Client and Server are on two separate LPAR on the same 2064 machine Here is our starting point: Total number of objects inspected: 52,041 Total number of objects backed up:1,554 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 72 Total number of objects failed: 0 Total number of bytes transferred: 8.10 GB Data transfer time: 256.23 sec Network data transfer rate:33,168.89 KB/sec Aggregate data transfer rate: 1,396.01 KB/sec Objects compressed by: 55% Elapsed processing time: 01:41:28 and trace output: Elapsed time: 6088.402 sec Section Total Time(sec) Average Time(msec) Frequency used - Client Setup0.063 62.9 1 Process Dirs 108.029 47.1 2292 Solve Tree 0.0000.0 0 Compute 2.0030.0 768476 Transaction46.2260.02312991 BeginTxn Verb 0.0070.0 1181 File I/O 2659.2234.6 580646 Compression 2964.9744.3 692721 Data Verb 255.7221.0 266454 Confirm Verb0.2024.9 41 EndTxn Verb51.560 43.7 1181 Client Cleanup 0.392 392.2 1 So,according to common tuning consideration, I decide to turn client compression off. The results weer not as expected: Total number of objects inspected: 57,067 Total number of objects backed up:1,450 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted:507 Total number of objects failed: 1 Total number of bytes transferred:18.53 GB Data transfer time:6,941.87 sec Network data transfer rate:2,799.28 KB/sec Aggregate data transfer rate: 1,858.10 KB/sec Objects compressed by:0% Elapsed processing time: 02:54:18 and trace output: Elapsed time: 10458.494 sec Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.766 765.9 1 Process Dirs 123.954 47.2 2625 Solve Tree 0.0000.0 0 Compute 1.9750.0 608333 Transaction53.1180.01831471 BeginTxn Verb 0.0090.0 1179 File I/O 3239.4955.3 609776 Compression 0.0000.0 0 Data Verb6940.654 11.4 608333 Confirm Verb 38.818 825.9 47 EndTxn Verb59.321 50.3 1179 Client Cleanup 0.385 384.6 1 My question is; why Data Verb is so increased while data to be transferred are only doubled? From dsmsched.log analisys, I found this time gap in sending data from client: 02/22/2001 02:28:57 Retry 1 Normal File-- 204,832,768 /ciadata/Mail_Trace.nsf Sent 02/22/2001 03:52:59 Normal File-- 338,083,840 /ciadata/StatisticheUOW.nsf Sent No errors detected, neither on client nor on server side. The only thing I found is that, at 02:24, two migrationprocesses started moving data from the dasd stg where the client is sending its data; at 03:50 the last process terminated its migration. Maybe this was only a coincidence but ... I decide to add some volumes to the stg trying to accomodate the new data and to avoid the dasd_to_tape migration processes. Again, these are the results: Total number of objects inspected: 56,890 Total number of objects backed up:1,446 Total number of objects updated: 2 Total number of objects rebound: 0 Total number of objects deleted: 22 Total number of objects failed: 1 Total number of bytes transferred:18.08 GB Data transfer time:2,091.27 sec Network data transfer rate:9,068.03 KB/sec Aggregate data transfer rate: 3,619.54 KB/sec Objects compressed by:0% Elapsed processing time: 01:27:19 and trace output: Elapsed time: 5239.620 sec Section Total Time(sec) Average Time(msec) Frequency used
Re: ARCHIVE command - length restrictions
I don't know the real restriction. But i have a suggestion to avoid it. Check if you can use this dsmc archive -archmc=ORACLE_DIARIO -desc="TST11 OFFLINE ORACLE_DIARIO 20010216.153447" /oracle/rdbms/8.0.5/dbs/initTST11.ora '/TST11/*/*.dbf' The single quotes inhibits the shell to interpret the wildcards. So you can archive a lot of files in a single dsmc-command. You must check if my specification meets your requirements: are all files includet you want to back up, but not any other file? Sergio Cherchyk schrieb: Hi everybody! I'm trying to backup ORACLE databases using a script that uses an ARCHIVE command to which a list of files to back up is given, so that the final command is something like this: dsmc archive -archmc=ORACLE_DIARIO -desc="TST11 OFFLINE ORACLE_DIARIO 20010216.153447" /oracle/rdbms/8.0.5/dbs/initTST11.ora /TST11/dbs/system01.dbf /TST11/data/ajes_data.dbf /TST11/data/amul_data.dbf /TST11/index/amul_ind.dbf /TST11/rollback/rbs.dbf /TST11/temporary/temporary.dbf /TST11/dbs/user.dbf /TST11/index/ajes_ind.dbf /TST11/data/eul_data.dbf /TST11/data/eft_data.dbf /TST11/index/eft_ind.dbf /TST11/data/cheques_data.dbf /TST11/index/cheques_ind.dbf /TST11/redologs1/log3a.dbf /TST11/redologs2/log2b.dbf /TST11/redologs1/log1a.dbf /TST11/redologs1/ctrl1.dbf /TST11/redologs2/ctrl2.dbf /TST11/redologs1/ctrl3.dbf /TST11/dbs/cfstby.dbf The error message that I get after this command is issued is: ANS1102E Excessive number of command line arguments passed to the program! ANS1133W An expression might contain a wildcard not enclosed in quotes Not seeing any wildcards and not finding a limit in the number of parameters to be passed to an ARCHIVE command, I thought that it should have failed because an exesive number of characters in the command line. TSM specifies 256 character as a maximun limit, so it appeared natural to me that this command doesn't work. However this, the following comman DOES work, even if it is largely superior to 256 characters in length: dsmc archive -archmc=ORACLE_DIARIO -desc="TST1 OFFLINE ORACLE_DIARIO 20010216.152135" /oracle/rdbms/7.3.4/dbs/initTST1.ora /TST1/dbs/system01.dbf /TST1/dbs/user.dbf /TST1/data/data.dbf /TST1/rollback/rbs.dbf /TST1/temporary/temporary.dbf /TST1/index/ind.dbf /TST1/redologs1/log1a.dbf /TST1/redologs2/log1b.dbf /TST1/redologs2/log2b.dbf /TST1/redologs2/log2a.dbf /TST1/redologs1/log3a.dbf /TST1/redologs2/log3b.dbf /TST1/redologs2/log4b.dbf /TST1/redologs2/log4a.dbf /TST1/dbs/ctrl1.dbf /TST1/redologs1/ctrl2.dbf /TST1/redologs2/ctrl3.dbf /TST1/dbs/cfstby.dbf /TST1/archivelog Does anyone know which is the real restriction that I'm not respecting in the first example? The client is TSM 3.7.2 in an AIX 4.3.2 Thanks in advance -- Sergio R. Cherchyk Arquitectura Tecnolgica - Midrange Banco Ro de la Plata S.A. - Grupo BSCH Mire 480, 2do piso - 1036 Cap. Fed. Argentina Tel. (054)-11-4341-1643 Fax. (054)-11-4341-1264 -- Mit freundlichen Gren Bernhard Unold begin:vcard n:Unold;Bernhard tel;work:+49 7071/29-80130 x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Bernhard Unold end:vcard
Re: ARCHIVE command - length restrictions
dsmc archive -archmc=ORACLE_DIARIO -desc="TST11 OFFLINE ORACLE_DIARIO 20010216.153447" /oracle/rdbms/8.0.5/dbs/initTST11.ora /TST11/dbs/system01.dbf /TST11/data/ajes_data.dbf /TST11/data/amul_data.dbf /TST11/index/amul_ind.dbf /TST11/rollback/rbs.dbf /TST11/temporary/temporary.dbf /TST11/dbs/user.dbf /TST11/index/ajes_ind.dbf /TST11/data/eul_data.dbf /TST11/data/eft_data.dbf /TST11/index/eft_ind.dbf /TST11/data/cheques_data.dbf /TST11/index/cheques_ind.dbf /TST11/redologs1/log3a.dbf /TST11/redologs2/log2b.dbf /TST11/redologs1/log1a.dbf /TST11/redologs1/ctrl1.dbf /TST11/redologs2/ctrl2.dbf /TST11/redologs1/ctrl3.dbf /TST11/dbs/cfstby.dbf The error message that I get after this command is issued is: ANS1102E Excessive number of command line arguments passed to the program! ANS1133W An expression might contain a wildcard not enclosed in quotes Not seeing any wildcards and not finding a limit in the number of parameters to be passed to an ARCHIVE command... You're ignoring that Messages manual that the Tivoli folks labored so long to put together for our reference. The description of the ANS1102E messages says: Archive, Delete, and Selective can contain a maximum of 20 file specifications. I count 21 filenames in your command line. As an addendum I have to say that I don't think much of this arbitrary limit of 20: one should be able to have as many operands as are supported by the command line length or operands count in your individual operating system, which in the Unix case is far more than a measly 20. Richard Sims, BU
SAP and SQL Server
Hello !!! I have a SAP with Windows NT 4.0 (Service Pack 5) SQL Server version 7.0 (Service Pack 1) My question is: I need de service pack 1 in the SQL Server to get a backup ? and wich is the agent for TSM to work with SAP ? I have a Tivoli Data Protection for SAP R/3 Versin 2.7. Is this OK ? Christian Astuni IBM Gobal Services [EMAIL PROTECTED] Tel. # 4898-4621 - Cel. # 15 4494-2315 Hipolito Yrigoyen 2149 - Martnez (1640) Bs. As. - Argentina
SAN, 3494, library shared HP-UX AIX
Hi colleagues, my environment is the following: I have a TSM server running in AIX and another TSM server running in HP-UX. Both have a fc connection to SAN Data Gateway besides a LAN connection. On the other hand, I have connected to SAN a 3494 library via SCSI. Is it possible to configure the Library like shared with the Tape library manager ( AIX ) and Tape library client ( HP-UX ). Could someone help me to resolve this question? Thanks in advance. In addition any info about SAN TSM experiences will be well received. __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/
tivoli storage manager and irix 6.5
We run the Tivoli Storage Manager (4.1.1 IP22094) on two SGI Computers with IRIX 6.5.10 or 6.5.11. On both CPU we have to restart the dsm client frequently. The reasons are: On the ORIGIN2000 (Irix 6.5.10) the dsm client aborts after 2 days with the following error message: B/A Txn Producer thread, fatal error, signal 11 on the OCTANE (Irix 6.5.11) the dsm client needs all the memory after 2 weeks runtime Has someone else seen these problems? Has someone an idea what I have done wrong? Thanks for any help Ulrich Bernhard -- +--+ | U. Bernhard | | Zentrum Informatikdienste Tel: (+41-1) 635 67 73| | Universitaet Zuerich Fax: (+41-1) 635 45 05| | Winterthurerstr. 190 | | CH-8057 ZuerichEmail: [EMAIL PROTECTED] | | Switzerland | +--+
SAP and SQL Server
Christian We too use SQL Server 7.0 on NT 4.0 as our SAP platform. I believe that TDP for R/3 is only for Oracle platforms, not SQL Server. We rely on TDP for SQL Server v1.1 to perform backups of our SAP databases. Version 2.2 was released last month. I have been desperately trying to get hold of it but have been unsuccessful. Although the code is not available for download, the documentation can be found at http://www.tivoli.com/support/storage_mgr/pubs/v1_pdf/mssql/v2/ab5m1mst.pdf. This states the minimum requirements are NT 4 SP4 and SQL Server 7 SP2, so you should be OK. Neil The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House Halifax Road Bradford BD6 2SZ Registered in England and Wales No 2366682
ADSM Compatibility w/AS/400
Hello ADSM'ers! Can anyone tell me if ADSM Version 3, Release 1, Level 0.3 is compatible with AS/400 Version 4 Release 5? We currently run that ADSM version on an AS/400 V3, R1, L1.7. Thank you! Laura Huffman Information Services 716-888-3652 [EMAIL PROTECTED]
No future for buta ?
I recently saw, in TSM AFS/DFS Backup Clients, p 1, that buta is supported on AFS 3.5 AFS 3.6a only, but not not on AFS 3.6 and higher. Does anyone have information about this? -- --- Daniel GERLIC --- CCIN2P3,27 Bd du 11 Novembre, F69622 VILLEURBANNE Cedex,FRANCE
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windo ws)
Maybe if we have disk left on the shark we want to do this. -Original Message- From: Carl Makin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 5:46 PM To: [EMAIL PROTECTED] Subject: Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windows) On Thu, 22 Feb 2001, Caffey, Jeff L. wrote: We are in the process of implementing TSM, an IBM Shark, and a SAN all at the same time (I'm swamped)! We are replacing EMC's Data Manager, an EMC Symmetrix, and Veritas' Backup Exec with one brand new TSM server running on an IBM RS/6000 (H80, 1GB RAM, 500GB Internal SSA Disk for storage pools, Gigabit Ethernet to LAN, Fibre Channel to SAN, 5 LTO tape drives, and as much additional 'shark' disk as necessary) performing backups on the following server platforms: We moved our 120Gb disk backup pool from a SSA D40 drawer (RAID5) to the Shark and got an order of magnitude improvement in backup times. 40Gb NOTES backups went from 20 hours to 4 hours. The shark outperforms the SSA disk by a significant amount. If you start having performance problems then I'd recommend moving all your TSM data to the shark and using the SSA somewhere else. (That's what we're doing now) We have 83 nodes (mixed AIX, Solaris, NT and FreeBSD) and the ADSM server is a H70. Carl.
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windows)
4. Is there a MAC agent that allows for the "illegal characters" associated with Apple/Macintosh naming conventions? EXAMPLE: We have an NT server that the MAC clients connect to. This NT server contains the home directories for all the MAC clients. Veritas' Backup Exec handles these files (and their "illegal characters") correctly, but TSM has problems. I believe this is controlled by the USEUNICODEFILENAMES parameter. I am not certain, (test it yourself), but you would need to set up two clients on your server, one DSM.OPT containing USEUNICODEFILENAMES YES; LANG AMENG; and EXCLUDE.DIR all the NT directories. And one DSM.OPT containing USEUNICODEFILENAMES NO; and EXCLUDE.DIR all Mac directories. This means, of course, 2 client licenses per box. -- Sent through GMX FreeMail - http://www.gmx.net
TDP for R/3 loops on BKI0400I when using brbackup -d util_file_online
I have following instalation of TSM: TSM 4.1.2 on dedicated server (AIX 4.3.3) Tivoli Data Protection for R/3 ver. 3.1.0.1 on AIX 4.3.3. SAP version is 4.5B, Oracle 8.0.5 I have tried to backup R/3 using individual tablespace locking (brbackup option -d util_file_online) but the only effect is the message BKI0400I (TDP is waiting for BRBACKUP). It doesn't matter if I try make full backup (option -m all) or to backup single tablespace. The only workaround is to use brbackup -d util_file but in this case a lot of redologs are generated. Can anybody help me? Best regards, Marek
Re: Onbar API versus Informix Data Protection?
Hagen... I use BMC SQL-BackTrack for Informix 2.1 and am currently testing 3.0. Ontape is used with 2.1 and Onbar is used with 3.0 plus 3.0 is supposed to allow you to expire stuff but haven't had luck yet making expiration work. 2.1 has no facility for expiration and thus you can't reclaim any backups done by the 2.1 API except by actually going in an manually deleting filespaces. This is a particular pain, as each dbspace (hope I am using the terminology correctly) gets a unique date time appended and thus you get a zillion unique filespace names The TDP for Informix tool is supposed to integrate better with TSM and handle expiration better according to what I have been told. I am trying to get in touch with my Tivoli rep... I think I am already actually licesnced to use this product... when the server boots, it says something to the effect "this server is licensed to use TDP for Informix"... I inherited tons of old CDs with this job but haven't had any luck find one for TDP for Informix... George Lesho Storage/System Admin AFC Enterprises Hagen Finley [EMAIL PROTECTED] on 02/22/2001 12:53:33 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Onbar API versus Informix Data Protection? Is there a distinction between utilizing the ADSM/TSM API to run onbar for informix databases and the TSM Informix Data Protection product (TDP)? I can't quite get clear whether the TDP and the API are synonymous, or whether the TDP is either a wholly different product or an enhancement of the API. Thanks for your comments. Hagen Finley Longs Drugs hfinley.vcf
Query Scratch Volumes
What would the syntax be for a query to only show scratch volumes?
How to restore partitioning info on WindowsNT
Is there a way to recover the partitioning information on Windows? We had a case where one of our NT servers went down and failed to boot. The technicians were unable to repair the system, so they reloaded NT 4.0. The disk drives were raid 5 (at the hardware level) and partitioned at the OS level. When they brought up the new operating system, all partitioning information was lost. They reformatted and repartitioned the drives, and then had me restore the data.
TDP Lotus errors running from scheduler
Windows NT 4 SP3 TSM Client 3.7.2.16 TDP Lotus Notes 2.9 TSM Server 3.7.2 on OS/390 I have installed the TDP Notes agent now on a couple dozen servers, but this one has started to give me problems. I used the LNSCHED.CMD sample in the TDP manual to run the incremental nightly. I redirect the output to a LNSCHED.LOG file. When I run the DSMNOTES INCR command manually, it runs just fine, but when it runs from the scheduler service I setup this is the output to the LNSCHED.LOG file I get: The ID file being used is: e:\notes\data\Rgateway.id Enter password (press the Esc key to abort): and the backup doesn't happen. There are no error messages other than this, and nothing about it in the LOG.DSM file. Can someone help? TIA, Bill Boyer DSS, Inc. "Growing old is mandatory, growing up is optional." - ???
Re: libstdc++-libc6.1-1.so.2 dependency in RedHat7.0 ?
I am not working on a 7.0 system - so I may be slightly off, but I am pretty sure that libstdc++-libc6.1-1.so.2 is included in an rpm labeled: compat-libstdc++-6.2-2.9.0.9.i386.rpm which is available at: ftp://ftp.redhat.com/pub/redhat/redhat-7.0/i386/en/RedHat/RPMS/ -john On Fri, 23 Feb 2001, Michael Jung wrote: I took a few days to search around but didn't come up with a solution. I'm able to install the Tivoli client on a 6.1 RedHat system. This system is installed as server WITH gui. The so called E-Smith-server isn't running a gui and I also don't need any gui. (1)--- Joerg Nouvertne wrote: cannot open shared object file: No such file or directory ^^ This indicates, that the library running on your system has been found, but does not contain the expected object file. I know that RedHat 7.0 has a special version of the glibc and gcc installed, which is not binary compatible to non-RedHat binaries. Is this client compiled for RedHat 7.0? -- I have not compiled it because it is an .rpm and specified to run with RedHat 7.0 (2)--- Richard Sims wrote: Subject: Re: libstdc++-libc6.1-1.so.2 dependency in RedHat7.0 ? dsmc: error while loading shared libraries: = libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory Michael - You seem to not have the appropriate libraries as specified in the Tivoli requirements page http://www.tivoli.com/support/storage_mgr/adcllin.htm . Check your Linux system via the 'rpm' command to see if it has the pre-reqs that TSM calls for. I know the webpages, they say its specified for RedHat 7.0, my server is a kickinstall based on RedHat 7.0. The comment from E-Smith dev list was: Question: There are any differences between standard installed libaries on RedHat 7.0 to E-Smith 4.1rc4 ? No. (and please upgrade from 4.1rc4 to 4.1 or 4.1.1) When I do: [root@SONNE Tivoli]# rpm -i TIVsm-BA.i386.rpm error: failed dependencies: libICE.so.6 is needed by TIVsm-BA-4.1.2-1 libSM.so.6 is needed by TIVsm-BA-4.1.2-1 libX11.so.6 is needed by TIVsm-BA-4.1.2-1 libXext.so.6 is needed by TIVsm-BA-4.1.2-1 libXp.so.6 is needed by TIVsm-BA-4.1.2-1 libXpm.so.4 is needed by TIVsm-BA-4.1.2-1 libXt.so.6 is needed by TIVsm-BA-4.1.2-1 libstdc++-libc6.1-1.so.2 is needed by TIVsm-BA-4.1.2-1 As I understand all libs except the last one only required for a GUI which I would not use. On my server I found: # rpm -qa | grep libst libstdc++-2.96-69 where the files are in: /usr/lib/libstdc++-3-libc6.2-2-2.10.0.a /usr/lib/libstdc++-libc6.2-2.a.3 It seems that this lib don't fullfill the requierements. A suggestion was: You can hope that the non-GUI bit does not need C++ libraries, you can downgrade the C++ libraries to RH6.2 versions and hope that it doesn't break anything, or you can try to get Tivoli to issue a new version and/or correct their release notes. C++ library compatibility has been a big issue with Rh7. Kind regards, Michael Jung John "Jamie" Marquart | This message posted 100% MS free. Digital Library SysAdmin| Work: 812-856-5174 Pager: 812-334-6018 Indiana University Libraries| ICQ: 1131494 D'net Team: 6265
Re: Query Scratch Volumes
select volume_name,status from libvolumes where status='Scratch' Or you can do select * from ... and get all info or decide on parameters you want. Note carefully case of 'Scratch'. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5525 [EMAIL PROTECTED] [EMAIL PROTECTED] 02/23/01 11:13AM What would the syntax be for a query to only show scratch volumes? "MMS health-first.org" made the following annotations on 02/23/01 11:35:11 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. Ý==
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windo ws)
REALLY...? Are you using SAN connection agents or is that performance increase still going across your network? Thank you, Jeff Caffey Enterprise Systems Programmer Pier 1 imports, Inc. - Information Services [EMAIL PROTECTED] Voice: (817) 252-6222 Fax: (817) 252-7299 -Original Message- From: Carl Makin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 5:46 PM To: [EMAIL PROTECTED] Subject:Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windows) On Thu, 22 Feb 2001, Caffey, Jeff L. wrote: We are in the process of implementing TSM, an IBM Shark, and a SAN all at the same time (I'm swamped)! We are replacing EMC's Data Manager, an EMC Symmetrix, and Veritas' Backup Exec with one brand new TSM server running on an IBM RS/6000 (H80, 1GB RAM, 500GB Internal SSA Disk for storage pools, Gigabit Ethernet to LAN, Fibre Channel to SAN, 5 LTO tape drives, and as much additional 'shark' disk as necessary) performing backups on the following server platforms: We moved our 120Gb disk backup pool from a SSA D40 drawer (RAID5) to the Shark and got an order of magnitude improvement in backup times. 40Gb NOTES backups went from 20 hours to 4 hours. The shark outperforms the SSA disk by a significant amount. If you start having performance problems then I'd recommend moving all your TSM data to the shark and using the SSA somewhere else. (That's what we're doing now) We have 83 nodes (mixed AIX, Solaris, NT and FreeBSD) and the ADSM server is a H70. Carl.
Re: Query Scratch Volumes
select volume_name from libvolumes where status = 'Scratch' will list all scratch volumes We use select count(*) from libvolumes where status = 'Scratch' to get the number of scratch tape [EMAIL PROTECTED] [EMAIL PROTECTED] 02/23/01 10:13AM What would the syntax be for a query to only show scratch volumes?
Re: Query Scratch Volumes
select volume_name, status from libvolumes where (status='Scratch') -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 8:13 AM To: [EMAIL PROTECTED] Subject: Query Scratch Volumes What would the syntax be for a query to only show scratch volumes?
Re: Query Scratch Volumes
Steve, Try this, select * from libvolumes where status='Scratch' If you need to see only the volume names select volume_names, status from libvolumes where status='Scratch' -Original Message- From: Steve Hicks [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 11:13 AM To: [EMAIL PROTECTED] Subject: Query Scratch Volumes What would the syntax be for a query to only show scratch volumes?
DB backup series expiration.
With DB Backup Series Expiration Days: 7 Day(s), within DRM, I'm only getting 5 to show up with q volhist type=dbb. Has anyone seen this problem before? It seemed to be working fine until a week ago when I had the dbbackup fail due to a tape error. Now it doesn't want to climb back up to 7. Thanks, Geoff Gill NT Systems Support Engineer SAIC Computer Systems Group E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: Query Scratch Volumes
It may be worth your while to setup a server command script. We defined one as Q_TAPE that runs the following commands. Now we get a fairly detailed look into our tape situation by simply entering RUN Q_TAPE select access as "Access (All Tapes)", count(*) as "# Tapes" from volumes where devclass_name='3590' group by access select status as "Status (Tapes in 3494)", count(*) as "# Tapes" from libvolumes group by status select stgpool_name as "StgPool Name", status as "Status", count(*) as "# Tapes" from volumes where devclass_name='3590' group by stgpool_name, status select stgpool_name as "Private StgPools", count(*) as "# Empty Tapes" from volumes where status='EMPTY' and devclass_name='3590' group by stgpool_name select volume_name as "Empty Tapes", stgpool_name as "StgPool" from volumes where status='EMPTY' and devclass_name='3590' select volume_name as "Scratch Tapes" from libvolumes where status='Scratch' q vol dev=3590 Sample output: Access (All Tapes) # Tapes -- --- OFFSITE 62 READONLY 1 READWRITE 187 Status (Tapes in 3494) # Tapes -- --- Private193 Scratch 13 StgPool Name Status # Tapes -- -- --- 3590COLEMPTY 19 3590COLFILLING 86 3590COLFULL52 DRMFILLING 12 DRMFULL49 DRMPENDING 1 MAILTAPE FILLING 2 MAILTAPE FULL20 ORATAPEAPPSFILLING 1 ORATAPEAPPSFULL 1 ORATAPEDB FILLING 1 ORATAPEDB FULL 1 ORATAPELOGSFILLING 1 WEEKLYTAPEDB FILLING 2 WEEKLYTAPEDB FULL 2 Private StgPools # Empty Tapes -- - 3590COL 19 Empty TapesStgPool -- -- 39 3590COL 300149 3590COL 300155 3590COL 300156 3590COL 300168 3590COL 300169 3590COL 300187 3590COL 300189 3590COL 300191 3590COL 300193 3590COL 300194 3590COL 300195 3590COL 300201 3590COL 300202 3590COL 300203 3590COL 300205 3590COL 300207 3590COL 300208 3590COL 300209 3590COL Scratch Tapes -- 310010 310013 310016 310017 310018 310033 310037 310040 310042 310046 310093 310100 310154 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 303590COL 3590 29,337.8 100.0Full 313590COL 3590 25,280.2 58.0Full 333590COL 3590 21,974.7 95.4 Filling 343590COL 3590 61,919.1 68.3Full 353590COL 3590 26,768.9 80.9Full 363590COL 3590 10,000.0 37.4 Filling 373590COL 3590 10,000.0 13.0 Filling 383590COL 3590 26,142.4 89.2Full 393590COL 3590 0.00.0 Empty 3000113590COL 3590 20,000.0 26.1 Filling 3000123590COL 3590 27,162.4 73.4Full 3000133590COL 3590143,697.2 100.0 Filling etc, etc. Steve Schaub Haworth, Inc email: [EMAIL PROTECTED] [EMAIL PROTECTED] 02/23 11:13 AM What would the syntax be for a query to only show scratch volumes?
Re: Query Scratch Volumes
Steve This command may help you. select count(*) from libvolumes where status='Scratch'
ANS1304W on 4.1
Folks, i searched the archives and found several threads about ANS1304W, but non of them seem to be related to Version 4. We migrated a week ago from 3.1 to 4.1.2 and now see _ANS1304W Active object not found_ in a client's error log. In the archives i learned that it's a problem with national language characters and this could be true in this case also. Our Environment: Server: TSM 4.1.2.0, AIX 4.3.3 Client: TSM 4.1.2.0, Solaris 7 'couse it's 18:29 here and we don't have a support contract which covers this time I'll try my luck here. TIA Reinhold Wagner, Zeuna Staerker GmbH Co. KG
Re: ANS1304W on 4.1
i searched the archives and found several threads about ANS1304W, but non of them seem to be related to Version 4. We migrated a week ago from 3.1 to 4.1.2 and now see _ANS1304W Active object not found_ in a client's error log. Yes, this was covered in Andy Raibeck's http://msgs.adsm.org/cgi-bin/get/adsm0102/655.html posting Wednesday.
Re: Query Scratch Volumes
You may have scratch tapes in multiple locations, depending on your TSM set up... select location, stgpool_name, volume_name from volumes where scratch='Yes' George Lesho Storage/System Admin AFC Enterprises Ron Pavan [EMAIL PROTECTED] on 02/23/2001 10:34:21 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: Query Scratch Volumes select volume_name, status from libvolumes where (status='Scratch') -Original Message- From: Steve Hicks [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 8:13 AM To: [EMAIL PROTECTED] Subject: Query Scratch Volumes What would the syntax be for a query to only show scratch volumes?
Re: No future for buta ?
That's a good question. The new version of DFS isn't supported by BUTA either. The TSM client install fails says you should uninstall any previous version of buta. In capital letters. With lots of asterisks. It's very impressive. Is buta going to be updated? Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: daniel gerlic [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 6:22 AM To: [EMAIL PROTECTED] Subject: No future for buta ? I recently saw, in TSM AFS/DFS Backup Clients, p 1, that buta is supported on AFS 3.5 AFS 3.6a only, but not not on AFS 3.6 and higher. Does anyone have information about this? -- --- Daniel GERLIC --- CCIN2P3,27 Bd du 11 Novembre, F69622 VILLEURBANNE Cedex,FRANCE
Statically linked adsm executables
Hello All, Is anyone aware of statically linked adsm executables for Solaris 2.6 and higher? It appears that the adsm client on solaris requires a libC.so.5. We are trying to work out a bare metal disaster recovery using adsm. Any helpful insights are appreciated. Thanks, Marc Taylor === Marc D. Taylor Research Programmer Beckman Institute Systems Services Room 1714 Office: 217-244-7373, Fax: 217-333-8206 [EMAIL PROTECTED] www.beckman.uiuc.edu/groups/biss
Re: ANS1304W on 4.1
Richard, thanks for the quick answer. Andy's message is related to Windows. Our client 4.1 is installed on a Solaris machine. On a UNIX machine the filenames are case sensitive and so there's no need to convert file names to all upper case. How comes, that we have ANS1304 on a UNIX box? Reinhold Wagner, Zeuna Staerker GmbH Co. KG Richard Sims [EMAIL PROTECTED] am 23.02.2001 18:50:18 Bitte antworten an "ADSM: Dist Stor Manager" [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Reinhold Wagner/A/DE/ZEUNA) Thema:Re: ANS1304W on 4.1 i searched the archives and found several threads about ANS1304W, but non of them seem to be related to Version 4. We migrated a week ago from 3.1 to 4.1.2 and now see _ANS1304W Active object not found_ in a client's error log. Yes, this was covered in Andy Raibeck's http://msgs.adsm.org/cgi-bin/get/adsm0102/655.html posting Wednesday.
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windo ws)
1. When TSM performs incremental backups, does it backup the ENTIRE file (at a file level) or does it only backup the CHANGES to the file (at a binary level)? EXAMPLE: When backing up our primary file server that contains users' home directories with MS Exchange *.pst and *.pab files that may be quite large, will it only backup the small changes to those large files? 2. When backing up MS Exchange files such as *.pst and *.pab, does it require them to be closed so that it can have access, or will it back them up while they are opened? EXAMPLE: When (using the above example) TSM runs it's backups, will the "Access Denied" message appear when it tries to backup "user123.pst" because the user stayed logged in over night. We have lots of large .pst files. I mean REALLY large. And yes, Microsoft locks them while in use, and TSM can't back them up. TSM can back up files that are OPEN, but Microsoft has two kinds of locks, OPEN and OPEN EXCLUSIVE, and TSM can't get past an OPEN EXCLUSIVE. Neither can anything else, short of some 3rd party open file manager. If a Windows application can't copy the file, TSM can't copy it, period. However, we have found that with Outlook, Outlook does release the locks periodically. You can have Outlook open, and your .pst files won't stay always locked if they are not actively in use. (The .pab file is always in use.) We even experiemented with a C program invoked from PRESCHEDCMD to try and force Exchange to shut down before the TSM backup, but never got one that would work reliably. The only guarantee is to set up your backup schedules for overnight and tell your users to LOG OFF (or at least shutdown Exchange) before they leave. Or another thing you could do, if you really wanted to, is to create an autoexec.bat (or whatever that equivalent thing is on Win2K, I don't recall) that would run a dsmc selective backup on your .pst files when the user starts up, then open EXCHANGE for them after the backup is done. Or something like that. FWIW, At least with the old Exchange client (as opposed to the new OUTLOOK), Exchange used to compress the .pst files regularly while you weren't looking. So I think even if you used the TSM 4.x feature to back up only at the byte level, it wouldn't help because more of the file would change than you expect. I had thought about trying it because we have people backing up .pst files that are 1GB plus (yep, GIGABYTES of old mail...). But I but have never gotten further than musing about it. Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert
TSM Server Scripts
Does anyone have a script that claculates the Daily backed up data with other statistics like total time taken for the Backup Schedule etc. If not then what would be the best way to get these statistics or Reports. Thanks in advance. Rajesh Oak Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html
Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windo ws)
TSM can back up files that are OPEN, but Microsoft has two kinds of locks, OPEN and OPEN EXCLUSIVE, and TSM can't get past an OPEN EXCLUSIVE. Neither can anything else, short of some 3rd party open file manager. We had a presentation from the company LiveVault[.com], which takes the fascinating approach of using an NT OS I/O system API to continuously capture and save all updated bytes, in real time, allowing you to restore to any moment in time. A very different approach, which may solve backup problems that traditional "batch" backup schemes can't. If anyone out there has had experience with them, I'd be interested in hearing about the realities of using such a product. Richard Sims, BU (TSM bigot, but with an open mind)
Re: ANS1304W on 4.1
Andy's message is related to Windows. Our client 4.1 is installed on a Solaris machine. Now, what makes you think all the clients are not generated from the same metacode, Reinhold? An interesting speculation, not that I actually know. It makes sense in terms of cutting development costs, with architecture-specific modules linked in. Beyond that, I would contact Tivoli about the error, as you may have encountered a problem area in 4.1 that they are are not yet aware of. Richard Sims, BU
Re: ANS1304W on 4.1
We had so many problems with TSM Client 4.1.2 that we back levelled to 3.7.2 We run AIX Server 4.1.2 and AIX CLient 3.7.2 and API 3.7.2 Aside from our Atape.bin problems (which give useless error messages until we update our Atape driver) everything's running smoothly. - Tom Walker -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 2:44 PM To: [EMAIL PROTECTED] Subject: Re: ANS1304W on 4.1 Andy's message is related to Windows. Our client 4.1 is installed on a Solaris machine. Now, what makes you think all the clients are not generated from the same metacode, Reinhold? An interesting speculation, not that I actually know. It makes sense in terms of cutting development costs, with architecture-specific modules linked in. Beyond that, I would contact Tivoli about the error, as you may have encountered a problem area in 4.1 that they are are not yet aware of. Richard Sims, BU This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: Query Scratch Volumes
Call me a Unix junkie, but I prefer this little Unix Command from a prompt
# dsmadmc -id=admin -pass=*** 'q libv' | grep Scratch | awk '{print
$3,$2}' | cat -n
Output looks like this.
1 Scratch 021814
2 Scratch 021817
3 Scratch 021837
4 Scratch 021852
5 Scratch 021871
6 Scratch 021912
7 Scratch 021922
8 Scratch 021926
9 Scratch 021938
10 Scratch 021943
11 Scratch 021954
12 Scratch 021962
13 Scratch 021974
14 Scratch 021977
15 Scratch 021980
16 Scratch 021984
17 Scratch 021987
18 Scratch 021988
19 Scratch 030232
20 Scratch 030240
21 Scratch 030268
22 Scratch 030269
23 Scratch 030270
24 Scratch 030275
25 Scratch 030293
26 Scratch 030299
27 Scratch 030301
Make that an alias and you're golden. :-)
-
Tom Walker
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: Query Scratch Volumes
What would the syntax be for a query to only show scratch volumes?
This e-mail including any attachments is confidential and may be legally privileged.
If you have received it in error please advise the sender immediately by return email
and then delete it from your system. The unauthorized use, distribution, copying or
alteration of this email is strictly forbidden.
This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: Query Scratch Volumes
Call me a Unix junkie, but I prefer this little Unix Command from a prompt You're a Unix junkie. If you run a 3494, you can do: mtlib -l /dev/lmcp0 -qC -s ___ where the scratch category must be supplied, in hex. Richard Sims, BU old, but not that junky yet
IBM/Tivoli Hardware Announcement 101-020 and Software Announcemen t 201-021
On January 30, 2001 an announcement dealing with 3466-C00 server upgrade to 4.1 came to my desktop. You can check out the announcement at: _ 101020 IBM 3466 Network Storage Manager Software Upgrade Feature for Models C00 and C10 (7.4KB) http://isource.ibm.com/cgi-bin/goto?it=usa_annredon=101-020 I believe I need this upgrade to provide Windows 2000 support as well as shared 3494 library support. So, I contact my IBM business partner and find that the $0 upgrade will cost me $27,225.00. Not liking this reply, I contact IBM at 1-800-IBM-CALL, as announced, and find that I MUST go through the IBM business partner that provided this solution. (The same one that wishes to bill me $27,225.00 for this free upgrade.) Do I sense a gun at my head? I have a valid IBM maintenance agreement, payable monthly, and find that to upgrade my software base, I must pay an IBM business partner a substantial sum? What am I missing? Has anyone else run into this concept? Is this the downside of the 3466? Feeling a substantial budget drain, John G. Talafous IS Technical Principal The Timken CompanyGlobal Software Support P.O. Box 6927 Data Management 1835 Dueber Ave. S.W. Phone: (330)-471-3390 Canton, Ohio USA 44706-0927 Fax : (330)-471-4034 [EMAIL PROTECTED] http://www.timken.com
Re: SAN, 3494, library shared HP-UX AIX
TSM 3.7/4.1 can share SAN connected libraries (including libraries connected via a SCSI/FC gateway). If you have the drivers and able to see(use) the tape and library devices from the HP, sharing is possible. Have a look in the Admin Guide under the section "Configuring TSM servers to Share SAN-Connected Devices", it gives you a play-by-play. I don't run a HP server or a 3494, I am going by published blurb and experimenting in my own environment. Once you have set up the SAN, it's just like dealing with SCSI devices. The difference is the ability to reallocate/share devices. We haven't bought into full-blown SAN management yet as our needs are simple for the moment. Cheers, Suad -- On Fri, Feb 23, 2001 at 04:54:10AM -0800, Francisco Molero wrote: Hi colleagues, my environment is the following: I have a TSM server running in AIX and another TSM server running in HP-UX. Both have a fc connection to SAN Data Gateway besides a LAN connection. On the other hand, I have connected to SAN a 3494 library via SCSI. Is it possible to configure the Library like shared with the Tape library manager ( AIX ) and Tape library client ( HP-UX ). Could someone help me to resolve this question? Thanks in advance. In addition any info about SAN TSM experiences will be well received. __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/
Re: libstdc++-libc6.1-1.so.2 dependency in RedHat7.0 ?
More generally, you can go to rpmfind and search via distro or filename. http://rpmfind.net/linux/RPM/ Cheers, Suad -- On Fri, Feb 23, 2001 at 11:30:56AM -0500, John Marquart wrote: I am not working on a 7.0 system - so I may be slightly off, but I am pretty sure that libstdc++-libc6.1-1.so.2 is included in an rpm labeled: compat-libstdc++-6.2-2.9.0.9.i386.rpm which is available at: ftp://ftp.redhat.com/pub/redhat/redhat-7.0/i386/en/RedHat/RPMS/ -john On Fri, 23 Feb 2001, Michael Jung wrote: I took a few days to search around but didn't come up with a solution. I'm able to install the Tivoli client on a 6.1 RedHat system. This system is installed as server WITH gui. The so called E-Smith-server isn't running a gui and I also don't need any gui. (1)--- Joerg Nouvertne wrote: cannot open shared object file: No such file or directory ^^ This indicates, that the library running on your system has been found, but does not contain the expected object file. I know that RedHat 7.0 has a special version of the glibc and gcc installed, which is not binary compatible to non-RedHat binaries. Is this client compiled for RedHat 7.0? -- I have not compiled it because it is an .rpm and specified to run with RedHat 7.0 (2)--- Richard Sims wrote: Subject: Re: libstdc++-libc6.1-1.so.2 dependency in RedHat7.0 ? dsmc: error while loading shared libraries: = libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory Michael - You seem to not have the appropriate libraries as specified in the Tivoli requirements page http://www.tivoli.com/support/storage_mgr/adcllin.htm . Check your Linux system via the 'rpm' command to see if it has the pre-reqs that TSM calls for. I know the webpages, they say its specified for RedHat 7.0, my server is a kickinstall based on RedHat 7.0. The comment from E-Smith dev list was: Question: There are any differences between standard installed libaries on RedHat 7.0 to E-Smith 4.1rc4 ? No. (and please upgrade from 4.1rc4 to 4.1 or 4.1.1) When I do: [root@SONNE Tivoli]# rpm -i TIVsm-BA.i386.rpm error: failed dependencies: libICE.so.6 is needed by TIVsm-BA-4.1.2-1 libSM.so.6 is needed by TIVsm-BA-4.1.2-1 libX11.so.6 is needed by TIVsm-BA-4.1.2-1 libXext.so.6 is needed by TIVsm-BA-4.1.2-1 libXp.so.6 is needed by TIVsm-BA-4.1.2-1 libXpm.so.4 is needed by TIVsm-BA-4.1.2-1 libXt.so.6 is needed by TIVsm-BA-4.1.2-1 libstdc++-libc6.1-1.so.2 is needed by TIVsm-BA-4.1.2-1 As I understand all libs except the last one only required for a GUI which I would not use. On my server I found: # rpm -qa | grep libst libstdc++-2.96-69 where the files are in: /usr/lib/libstdc++-3-libc6.2-2-2.10.0.a /usr/lib/libstdc++-libc6.2-2.a.3 It seems that this lib don't fullfill the requierements. A suggestion was: You can hope that the non-GUI bit does not need C++ libraries, you can downgrade the C++ libraries to RH6.2 versions and hope that it doesn't break anything, or you can try to get Tivoli to issue a new version and/or correct their release notes. C++ library compatibility has been a big issue with Rh7. Kind regards, Michael Jung John "Jamie" Marquart | This message posted 100% MS free. Digital Library SysAdmin| Work: 812-856-5174 Pager: 812-334-6018 Indiana University Libraries| ICQ: 1131494 D'net Team: 6265
Hung Admin Sessions
Gentle Greetings, Has anyone noticed any situations where Admin sessions on the server get hung and become "ghost" sessions that will not go away? Cancelling has no effect. Opening a separate Admin session and cancelling from there has no effect. In some cases, subsequent sessions get hung and a reboot is necessary. And in other cases, there seems to be no adverse side effects. In this case, I was doing some SQL queries on the database, and two user Admin sessions hung and two Query Admin sessions hung. (Fortunately, everything else is continuing to run smoothly.) Below is the output from "show threads" related to these 4 sessions. We are running 4.1.2 Server on an IBM M80 running AIX 4.3.3. Thank you in advance for any help and/or suggestions. Jennifer Thread 68: SessionThread tid=4437, ktid=34577, ptid=52, det=1, zomb=0, join=0, result=0, sess=31636 Awaiting cond 5c355b04 (mutex 301a65b0) at 10009b38 (outGetNext) Thread 101: SessionThread tid=653d, ktid=69811, ptid=52, det=1, zomb=0, join=0, result=0, sess=31768 Awaiting cond 5c33a484 (mutex 301a65b0) at 10009b38 (outGetNext) Thread 105: SessionThread tid=6963, ktid=72547, ptid=52, det=1, zomb=0, join=0, result=0, sess=30446 Awaiting cond 5c286354 (mutex 301a65b0) at 10009b38 (outGetNext) Thread 108: SessionThread tid=6acf, ktid=52079, ptid=52, det=1, zomb=0, join=0, result=0, sess=31704 Awaiting cond 5c1c69d4 (mutex 301a65b0) at 10009b38 (outGetNext)
