selective backup with ANS1115W shows failed
Hi Experts, I will be glad to hear from somebody. My tsm client 5.3 always shows scheduled backup failed. However in logs it is completed with ANS1115W warning. In my script i am saying dsmc selective d:\notes\* and in .opt file exlude *.nsf exclude *.ntf While with same settings incremental backup is sucessfull Any clues. Regards S.K __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: selective backup with ANS1115W shows failed
An often asked question, most recently last month. See that message number in http://people.bu.edu/rbs/ADSM.QuickFacts for rationale. Richard Sims On Mar 28, 2005, at 6:31 AM, Tsm Lover wrote: Hi Experts, I will be glad to hear from somebody. My tsm client 5.3 always shows scheduled backup failed. However in logs it is completed with ANS1115W warning. In my script i am saying dsmc selective d:\notes\* and in .opt file exlude *.nsf exclude *.ntf While with same settings incremental backup is sucessfull Any clues. Regards S.K __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Backup expiration
On Mar 28, 2005, at 2:51 AM, Nicolas Savva wrote: ...If i am correct, based on the above mc an inactive file will be deleted after 33 days. What about the active backup? for example i am trying to restore a file that i took backup, and i can't see any of inactive/active backup versions of this file. Based on manuals, i know that the active backup version should be existed. (active backup version never expired). Nicolas - Your thinking is correct, so retention is not the issue. You may not be seeing the file for a number of reasons, including... - It had been deleted or renamed on the client, and expired in TSM. - It was excluded from backups. - You're using the GUI to seek the file and an intermediate directory expired from TSM storage some time ago. - The lookup is not being performed from either the file owner or superuser. I'd pursue a more encompassing CLI query and see if the file and its neighbors show up, to narrow in on that target. Richard Sims http://people.bu.edu/rbs
Re: Backup expiration
Nico, I have done it the other way. I define the number of versions I need and put NOLIMIT to the retention. This means that even if a file is deleted TSM keeps the last 3 versions forever. This may not be the best solution as the TSM DB grows larger and larger. But at least I'm sure that the files will be there even when deleted. Here's an example: Policy Domain Name BOC_DOMAIN_A Policy Set Name BOC_POLICYSET_A Mgmt Class Name BOC_MGC_A Copy Group Name STANDARD Versions Data Exists 5 Versions Data Deleted 3 Retain Extra Versions NOLIMIT Retain Only Version NOLIMIT Call me if you need anything, at 22-848523. Yiannakis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Nicolas Savva Sent: Monday, March 28, 2005 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Backup expiration Hi to all I have the following management class: Policy Domain NameSVCY185_POLICYDOMAIN Policy Set Name SVCY185_POLICYSET Mgmt Class Name CY185MGMT Copy Group Name STANDARD Versions Data Exists NOLIMIT Versions Data Deleted NOLIMIT Retain Extra Versions 31 Retain Only Version 2 Copy Mode MODIFIED Copy SerializationSHRSTATIC Copy Frequency0 Copy Destination DISKPOOL Last Update Date/Time 2004-09-07 13:58:56.00 Last Update byADMIN (administrator) Managing profile - If i am correct, based on the above mc an inactive file will be deleted after 33 days. What about the active backup? for example i am trying to restore a file that i took backup, and i can't see any of inactive/active backup versions of this file. Based on manuals, i know that the active backup version should be existed. (active backup version never expired). Do i need to change something? Tsm server: 5.1.5 Tsm client: 5.1.5 Thanks
DSMJ on my new AIX server
Hi All I want to run the DSMJ GUI on my new AIX server But I have that message error Java not found I kind of new with AIX ... can you help me Thanks Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254
Using multiple Ethernet adapters on AIX TSM server?
I am currently using one GigE adapter on my TSM server, and I have so much traffic coming into it during the night that I need to add another. The new adatper will have a different IP, but will be on the same subnet as the first one. I am not sure of the right / best way to configure it. It's my understanding that provided this second adapter has its own IP address, that I can specify that address in the dsm.opt file on certain clients that I want to come in over that adapter. Correct? From an AIX standpoint, do I set the default gateway for the new adapter to be the same as the other one? Or do I make the first adapter the default gateway for the second one? If anyone can offer some insight, I'd very much appreciate it. A screenshot of someone's routing table where this is currently set up would be fantastic. Thanks very much! This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended only for the use of the Individual(s) named above. If you are not the intended recipient of this E-mail, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this E-mail is strictly prohibited. If you have received this E-mail in error, please immediately notify us at (865)374-4900 or notify us by E-mail at [EMAIL PROTECTED]
Backing up a 150GB Oracle DB on a datawarehouse server
Hi all I have to take a new Oracle server (AIX), it's our new Datawarehouse server I know that I have to stop the Oracle DB before the backup and restart it after. .. My question is .. the DB has to be up and running as fast as it could ... so what should be the best way to take that Oracle DB in backup (incr, image, snapshot or ???) thanks Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254
Re: Backing up a 150GB Oracle DB on a datawarehouse server
Luc Beaudoin wrote: Hi all I have to take a new Oracle server (AIX), it's our new Datawarehouse server I know that I have to stop the Oracle DB before the backup and restart it after. .. Well, you really don't need to take if offline at all, depending on how much work you are willing to spend on configuring the backup. Most of the DWH systems I have worked on had to be up at all time, as they constantly processed new inputs from other systems, so you would probably need to do hot backups. Unless you can have a backup window that is. My question is .. the DB has to be up and running as fast as it could ... so what should be the best way to take that Oracle DB in backup (incr, image, snapshot or ???) If you have the TDP for Oracle, it is easy, use Oracle RMAN to do online incremental 0 and 1 backups, with archive logs. The database will never have to be taken offline. If you don't have TDP, well then you can do the good ole' Oracle backup using some shell scripting. Essentially you would use a prebackup script to put all tablespaces in backup mode, then backup all files and archive log files, and the postbackup script would put all tablespaces back in normal mode. Regardless of method you will not have to take the database offline. /A
select statement
Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date time? Thanks in advance! Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as File,archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: select statement
Is there a way that I can get all of the info. on 1 line This was just discussed a week or so ago. You can start dsmadmc with the -tabdelimited or -commadelimited option to get output on a single line, then load the resulting output into a spreadsheet or db for easy viewing. and also make the archive_date split into date time? Specify columns names like this for getting separate date time: select date(archive_date) as ARCHIVE DATE, time(archive_date) as ARCHIVE TIME, ... Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-03-28 09:14:24: Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date time? Thanks in advance! Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as File,archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Reserved tape drives
TSM server 4.1.3 on Windows 2K, 6 LTO-1 SCSI attached with IBM3583 library. We have occasionally some drives that show up as 'Reserved'. No particular drive either. Once I have seen it clear that status on its own, but a couple of times we have had to stop and restart the TSM server to get it to work again. Suggestions to explain what happens? Or, even better, how to keep it from happening? Thanks ... Jack
Re: Reserved tape drives
A drive state of Reserved most commonly occurs as TSM is engaged in mounting a tape on the drive. If that state persists, it could indicate drive problems where a tape load could not complete. Richard Sims On Mar 28, 2005, at 11:24 AM, Coats, Jack wrote: TSM server 4.1.3 on Windows 2K, 6 LTO-1 SCSI attached with IBM3583 library. We have occasionally some drives that show up as 'Reserved'. No particular drive either. Once I have seen it clear that status on its own, but a couple of times we have had to stop and restart the TSM server to get it to work again. Suggestions to explain what happens? Or, even better, how to keep it from happening? Thanks ... Jack
Re: DELETing a volume from a DB backup
We have different areas of responsibility here with TSM. The help desk people set up the save's of the clients and the servers. They also perform any restores, as needed. The operations gal and I are to make sure that we can recover the TSM server in case of drastic damage to it. We did have a consultant come in and spend a few days. Mostly with the operations gal and I. In the slack time he helped the help desk with some issues they had. Primary mission of this consultants visit was to help the operations gal and I with getting the TSM saves set up. First few hours were spent in front of a whiteboard with the consultant questioning us how we wanted to do this. We did NOT want to have any of the client and/or server data being rotated from disk storage pools to tape storage pools. No archival, etc. The help desk people would never have to ask us to get a tape or have one from some tape library automatically mounted to restore any data to a client or server. Repeat, the use of tape was just in case damage occurred to the TSM server itself. We have two weeks of tapes - week 1 and week 2. Week one starts the backup stg backuppool lto_3581_week# on Sunday afternoon on 'fresh' tapes. And then these are moved offsite. That takes 4.02 3581 tapes. Then Monday-Thursday night's backup (same command) take less than a tape each night. The next morning, each tape is moved to offsite storage. We also run the backup db devclass=3581dev type=full scratch=yes wait=no on a daily basis and send that tape offsite as well. Starting on Friday we blank out the previous weeks tapes and start over. As far as training here goes, it can be pretty good at times. For a year or two it was locked down tight but it's pretty much back to normal again. I manage to get offsite to a conference about every other year. My other duties, like many of you, are numerous. Domino/Notes administrator, iSeries administrator (we have four of them. Some of you may know them by other names: AS/400's, i5's, etc), and so on. And I cover for the operations gal who left for two weeks in Hawaii just a week after the consultant left. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
Re: Preparing a tape storage pool volume for reuse
Judging by one of your other emails, is reclaimation a process to merge partial tapes together? If so, that really doesn't interest us. It doesn't fit into our backup strategy. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com Mark D. Rodriguez [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/25/2005 03:56 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Preparing a tape storage pool volume for reuse Rob, Again this is a fundamental concept in TSM as I stated in my previous post I think you will need to develop your skill set in the TSM area. No, you do not want to do DELete VOLume! What you should be doing on some regular basis is running reclamation on that storage pool. Reclamation will then empty the partially used tapes. Please refer to the admin guide where you will find several sections discussing managing storage pools and volumes. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Rob Berendt wrote: Unlike my previous post regarding a BACKUP DB volume, now I have a question about a Copy Storage Pool tape volume. After I used a tape volume for backup stg backuppool lto_3581_week2 I want to reuse it. Do I just: delete volume 12wk2 discarddata=yes wait=no Are there any other steps I need? If I am running TSM 5.2.2 on OS/400 V5R3 under PASE, do I need to INZTAP also? Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
Re: DELETing a volume from a DB backup
What are the differences between the two courses? Again, I won't be handling the save/restores of individual clients or servers. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com Yiannakis Vakis [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/28/2005 01:58 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] DELETing a volume from a DB backup Mark, Iain (and Rob), I believe that we all found ourselves in Rob's situation one way or another. It is always difficult to persuade the management about trainning needs - especially if the training is abroad (management prefers to spent this money on themselves...). However, such a discussion helps the person needing training to realise it more and more. It sure helped me in similar situations when I just printed a reply from another list saying to my boss hey just see what these guys are telling me - you have to send me to a training course. So I don't consider what Mark wrote to Rob as an insult. Rob, you have to attend at least TM50 - the basic training course. And after working for 6 months on TSM ask them to send you a TM52. I'm trying to do the same just now. Good luck. Yiannakis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Iain Barnetson Sent: Saturday, March 26, 2005 12:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: DELETing a volume from a DB backup Mark, I like what I read about training being a major part of the consultancy services you provide. You are sooo right about enterprises getting consultants in to install systems and then dumping them onto the Admins without any trainig, etc. That's exactly what happened to me, not once (TSM) but twice when they had a SAN installed with a pair of Cisco SAN / iSCSI switches. Unfortunately once the consultants left the building so did any kinda support, it took 4 months to get a document out of them detailing the configuration!! Hey Ho, has given me many new challenges which as we all know is good ;) Iain -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark D. Rodriguez Sent: 26 March 2005 00:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DELETing a volume from a DB backup Iain, I agree with you. I don't think this is a place where we should just say RTFM. I hope my tone was not that at all. I was simply trying to encourage him to get the skills needed. The real problem is management doesn't always understand that tech people need training! I don't care what Backup/Restore solution you are using today, none of them just work right out of the box and they all need a degree of skill to effectively manage them. And you are right I am glad for this list as well. It is an excellent resource with many very talented people out here and for the most part they are all trying to help. While I am on my soap box, I'll mention another area that seems to be a problem lately. This isn't just TSM now it applies to a large degree to all enterprise level software. More and more companies are purchasing software and then hiring consulting services to come in and set it up. What I am finding is there are a number of consultants out there that do what I call hit and run services. They come in they set it up and then they are gone. They never did any training or even explanation of the entire environment with the customer. And the one who winds up looking the fool is the tech guy, because management says hey we just paid big bucks to have this set up and now you can't keep it running. I have come in behind a number of consultants and had to clean up after them. When I do services part of the contract is training both the administrators and the operators (if they are different). I provide written documentation about their specific environment. I give them an SLA describing the level of service they are providing their customers. I give them a manual that describes the day to day operation of their TSM environment and not only does it tell them what to do, but why they are doing it. It is a lot more work and it cost a bit more money, but in the long run I think I have happier customers as a result. OK, I am done patting myself on the back. The real point of this is that if your are going to administer a TSM environment you are going to have to acquire the skills to do it. Now, you can get those skills in a variety of ways, formal training, technology transfer from a consultant, even read the manual, or you can get it from the school of hard knocks. If you are forced into the latter choice it can be quite an expensive proposition! -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and
Re: select statement
Hello! Thanks for the suggestion! I am now getting another bizarre rc=3 when I enter the command: dsmadmc -id= -pass= -tabdelimited 'select statement' within single quotes. The node name is CS-NICE-STORAGE so I entered the following select statement: 'select node_name,filespace_name,hl_name || ll_name as File,date(archive_date) as Date,class_name from archives where node_name=CS-NICE-STORAGE' It doesn't seem to like double quotes or single quotes around the node_name. Are quotes not needed? Thanks again! == archives where node_name=CS-NICE-STORAGE' IBM Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 2, Level 0.0 (c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights Reserved. Session established with server TSMPROD: AIX-RS/6000 Server Version 5, Release 2, Level 2.5 Server date/time: 03/28/05 12:43:02 Last access: 03/28/05 12:31:12 ANS8000I Server command: 'select node_name,filespace_name,hl_name || ll_name as File ,date(archive_date) as Date from archives where node_name=CS-NICE-STOR AGE' ANR2940E The reference 'CS-NICE-STORAGE' is an unknown SQL column name. | ..V date) as Date from archives where node_name=CS-NICE-STORAGE ANS8001I Return code 3. ANS8002I Highest return code was 3. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Andrew Raibeck [EMAIL PROTECTED] OMTo Sent by: ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU Re: select statement 03/28/2005 11:22 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Is there a way that I can get all of the info. on 1 line This was just discussed a week or so ago. You can start dsmadmc with the -tabdelimited or -commadelimited option to get output on a single line, then load the resulting output into a spreadsheet or db for easy viewing. and also make the archive_date split into date time? Specify columns names like this for getting separate date time: select date(archive_date) as ARCHIVE DATE, time(archive_date) as ARCHIVE TIME, ... Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-03-28 09:14:24: Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date time? Thanks in advance! Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as File,archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: Using multiple Ethernet adapters on AIX TSM server?
Hi Kevin. I am currently using one GigE adapter on my TSM server, and I have so much traffic coming into it during the night that I need to add another. The new adatper will have a different IP, but will be on the same subnet as the first one. I am not sure of the right / best way to configure it. If you're maxing out your GigE connection, adding another line to it may just push the bottleneck upstream to the switch -- you'll want to work with your network folks to determine the best place to lay new pipes. It's my understanding that provided this second adapter has its own IP address, that I can specify that address in the dsm.opt file on certain clients that I want to come in over that adapter. Correct? You've got the right idea. Again, depending on your traffic patterns (lots of small clients vs. a few huge clients) it might make sense to associate more IP addresses with the host name on your DNS server, and have DNS provide load balancing (by passing out IPs for the same hostname in a round-robin fashion). This is especially useful if it's the GigE that's the bottleneck to the switch. This is a good general-purpose fix, but to truly optimize your connectivity, you have to dig into your usage patterns to develop the best solution. You'll want to remove the bottleneck, not just push it upstream. =) From an AIX standpoint, do I set the default gateway for the new adapter to be the same as the other one? Or do I make the first adapter the default gateway for the second one? Depends on how you set up subnets. To specifically answer your second question, NO. =) - If you add the second IP to the *same* subnet, then they have the same gateway (possibly a bottleneck). - If you add the second IP to a *different* subnet, it may or may not (but it SHOULD, really) have a different gateway associated with it. -JD.
Re: select statement
Hi Joni, You do not need to put the SELECT command in single quotes. dsmadmc -id=me -pa=xxx -tabdelimited select blah from blah where blah When comparing strings in the WHERE clause, use single, not double quotes around the string. ... where node_name='CS-NICE-STORAGE' Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-03-28 10:50:35: Hello! Thanks for the suggestion! I am now getting another bizarre rc=3 when I enter the command: dsmadmc -id= -pass= -tabdelimited 'select statement' within single quotes. The node name is CS-NICE-STORAGE so I entered the following select statement: 'select node_name,filespace_name,hl_name || ll_name as File,date(archive_date) as Date,class_name from archives where node_name=CS-NICE-STORAGE' It doesn't seem to like double quotes or single quotes around the node_name. Are quotes not needed? Thanks again! == archives where node_name=CS-NICE-STORAGE' IBM Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 2, Level 0.0 (c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights Reserved. Session established with server TSMPROD: AIX-RS/6000 Server Version 5, Release 2, Level 2.5 Server date/time: 03/28/05 12:43:02 Last access: 03/28/05 12:31:12 ANS8000I Server command: 'select node_name,filespace_name,hl_name || ll_name as File ,date(archive_date) as Date from archives where node_name=CS-NICE-STOR AGE' ANR2940E The reference 'CS-NICE-STORAGE' is an unknown SQL column name. | ..V date) as Date from archives where node_name=CS-NICE-STORAGE ANS8001I Return code 3. ANS8002I Highest return code was 3. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Andrew Raibeck [EMAIL PROTECTED] OM To Sent by: ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU Re: select statement 03/28/2005 11:22 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Is there a way that I can get all of the info. on 1 line This was just discussed a week or so ago. You can start dsmadmc with the -tabdelimited or -commadelimited option to get output on a single line, then load the resulting output into a spreadsheet or db for easy viewing. and also make the archive_date split into date time? Specify columns names like this for getting separate date time: select date(archive_date) as ARCHIVE DATE, time(archive_date) as ARCHIVE TIME, ... Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-03-28 09:14:24: Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date time? Thanks in advance! Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as File,archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: select statement
It's a quoting issue... SQL in general prefers single quotes around strings. =) 'You solve the problem by \'escaping\' quote characters with backslashes in most SQL implementations.' The same works for 'escaping' \double-quotes\. You can test your commands by prefixing them with the echo or print command, so you can see how your command actually gets passed to TSM. -JD. Hello! Thanks for the suggestion! I am now getting another bizarre rc=3 when I enter the command: dsmadmc -id= -pass= -tabdelimited 'select statement' within single quotes. The node name is CS-NICE-STORAGE so I entered the following select statement: 'select node_name,filespace_name,hl_name || ll_name as File,date(archive_date) as Date,class_name from archives where node_name=CS-NICE-STORAGE' It doesn't seem to like double quotes or single quotes around the node_name. Are quotes not needed? Thanks again! == archives where node_name=CS-NICE-STORAGE' IBM Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 2, Level 0.0 (c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights Reserved. Session established with server TSMPROD: AIX-RS/6000 Server Version 5, Release 2, Level 2.5 Server date/time: 03/28/05 12:43:02 Last access: 03/28/05 12:31:12 ANS8000I Server command: 'select node_name,filespace_name,hl_name || ll_name as File ,date(archive_date) as Date from archives where node_name=CS-NICE-STOR AGE' ANR2940E The reference 'CS-NICE-STORAGE' is an unknown SQL column name. | ..V date) as Date from archives where node_name=CS-NICE-STORAGE ANS8001I Return code 3. ANS8002I Highest return code was 3. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Andrew Raibeck [EMAIL PROTECTED] OMTo Sent by: ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU Re: select statement 03/28/2005 11:22 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Is there a way that I can get all of the info. on 1 line This was just discussed a week or so ago. You can start dsmadmc with the -tabdelimited or -commadelimited option to get output on a single line, then load the resulting output into a spreadsheet or db for easy viewing. and also make the archive_date split into date time? Specify columns names like this for getting separate date time: select date(archive_date) as ARCHIVE DATE, time(archive_date) as ARCHIVE TIME, ... Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-03-28 09:14:24: Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date time? Thanks in advance! Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as File,archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.00 CLASS_NAME: DEFAULT Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Large Linux clients
I am having issues backing up a large Linux server (client=5.2.3.0). The TSM server is also on a RH Linux box (5.2.2.5). This system has over 4.6M objects. A standard incremental WILL NOT complete successfully. It usually hangs/times-out/etc. The troubles seem to be related to one particular directory with 40-subdirs, comprising 1.4M objects (from the box owner). If I point to this directory as a whole (via the web ba-client), and try to back it up in one shot, it displays the inspecting objects message and then never comes back. If I drill down further and select the subdirs in groups of 10, it seems to back them up, with no problem. So, one question I have is, anyone out there backing up large Linux systems, similar to this ? Any suggestions on what the problem could be. Currently, I do not have access to the error-log files since this is a protected/firewalled system and I don't have the id/pw.
Re: Large Linux clients
Zoltan, I am not sure if this will fix the problem or not. I have seen in the past when trying to backup directories (including sub-directories) with a large number of files that the system runs out of memory and either fails or hangs for ever. The one thing that I have done and has worked in some cases is to use the MEMORYEFfecientbackup option. It is a client side option and can be placed in the option file or called from the command line. I would try it and see if it helps. BTW, there is a downside to this and that is that backups will be slow however slow is still faster than not at all! Let us know if that helps. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Zoltan Forray/AC/VCU wrote: I am having issues backing up a large Linux server (client=5.2.3.0). The TSM server is also on a RH Linux box (5.2.2.5). This system has over 4.6M objects. A standard incremental WILL NOT complete successfully. It usually hangs/times-out/etc. The troubles seem to be related to one particular directory with 40-subdirs, comprising 1.4M objects (from the box owner). If I point to this directory as a whole (via the web ba-client), and try to back it up in one shot, it displays the inspecting objects message and then never comes back. If I drill down further and select the subdirs in groups of 10, it seems to back them up, with no problem. So, one question I have is, anyone out there backing up large Linux systems, similar to this ? Any suggestions on what the problem could be. Currently, I do not have access to the error-log files since this is a protected/firewalled system and I don't have the id/pw.
Re: Large Linux clients
I would also definitely suggest Journaling after the first incremental backup completes, that would help negate the slower backups with memory efficient turned on. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark D. Rodriguez Sent: Monday, March 28, 2005 4:30 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Large Linux clients Zoltan, I am not sure if this will fix the problem or not. I have seen in the past when trying to backup directories (including sub-directories) with a large number of files that the system runs out of memory and either fails or hangs for ever. The one thing that I have done and has worked in some cases is to use the MEMORYEFfecientbackup option. It is a client side option and can be placed in the option file or called from the command line. I would try it and see if it helps. BTW, there is a downside to this and that is that backups will be slow however slow is still faster than not at all! Let us know if that helps. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Zoltan Forray/AC/VCU wrote: I am having issues backing up a large Linux server (client=5.2.3.0). The TSM server is also on a RH Linux box (5.2.2.5). This system has over 4.6M objects. A standard incremental WILL NOT complete successfully. It usually hangs/times-out/etc. The troubles seem to be related to one particular directory with 40-subdirs, comprising 1.4M objects (from the box owner). If I point to this directory as a whole (via the web ba-client), and try to back it up in one shot, it displays the inspecting objects message and then never comes back. If I drill down further and select the subdirs in groups of 10, it seems to back them up, with no problem. So, one question I have is, anyone out there backing up large Linux systems, similar to this ? Any suggestions on what the problem could be. Currently, I do not have access to the error-log files since this is a protected/firewalled system and I don't have the id/pw. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: Large Linux clients
Some things to consider with large file systems, and Unix ones in particular: 1. Use CLI type backups rather than GUI type, for speed. 2. Divide and conquer: Very large file systems are conspicuous candidates for Virtualmountpoint TSM subdivision, which will greatly improve things overall. For that matter, oversized file systems are conspicuous candidates for splitting into multiple physical file systems. In suspect areas of Unix file systems I would interactively run a 'find' command with the -ls option to test the speed with which sub-trees of the file system can be traversed, to point out ringers. A single directory with a huge number of files can induce a lot of overhead, and is ripe for re-architecting. The big problem in all file systems is that they are simply created and then ignored, and the users of those file systems fill them with whatever they want, organized at whim in most cases. The architecting of file systems for performance and organizational sanity is a greatly overlooked subject area. Richard Sims On Mar 28, 2005, at 5:22 PM, Zoltan Forray/AC/VCU wrote: I am having issues backing up a large Linux server (client=5.2.3.0). The TSM server is also on a RH Linux box (5.2.2.5). This system has over 4.6M objects. A standard incremental WILL NOT complete successfully. It usually hangs/times-out/etc. The troubles seem to be related to one particular directory with 40-subdirs, comprising 1.4M objects (from the box owner). If I point to this directory as a whole (via the web ba-client), and try to back it up in one shot, it displays the inspecting objects message and then never comes back. If I drill down further and select the subdirs in groups of 10, it seems to back them up, with no problem. So, one question I have is, anyone out there backing up large Linux systems, similar to this ? Any suggestions on what the problem could be. Currently, I do not have access to the error-log files since this is a protected/firewalled system and I don't have the id/pw.
Re: Large Linux clients
Andrew, This is a Linux client. I do not believe that journal backups are supported under Linux. As far as I know it is a windows only thing or at least thats what all the documentation says anyway. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Meadows, Andrew wrote: I would also definitely suggest Journaling after the first incremental backup completes, that would help negate the slower backups with memory efficient turned on. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark D. Rodriguez Sent: Monday, March 28, 2005 4:30 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Large Linux clients Zoltan, I am not sure if this will fix the problem or not. I have seen in the past when trying to backup directories (including sub-directories) with a large number of files that the system runs out of memory and either fails or hangs for ever. The one thing that I have done and has worked in some cases is to use the MEMORYEFfecientbackup option. It is a client side option and can be placed in the option file or called from the command line. I would try it and see if it helps. BTW, there is a downside to this and that is that backups will be slow however slow is still faster than not at all! Let us know if that helps. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Zoltan Forray/AC/VCU wrote: I am having issues backing up a large Linux server (client=5.2.3.0). The TSM server is also on a RH Linux box (5.2.2.5). This system has over 4.6M objects. A standard incremental WILL NOT complete successfully. It usually hangs/times-out/etc. The troubles seem to be related to one particular directory with 40-subdirs, comprising 1.4M objects (from the box owner). If I point to this directory as a whole (via the web ba-client), and try to back it up in one shot, it displays the inspecting objects message and then never comes back. If I drill down further and select the subdirs in groups of 10, it seems to back them up, with no problem. So, one question I have is, anyone out there backing up large Linux systems, similar to this ? Any suggestions on what the problem could be. Currently, I do not have access to the error-log files since this is a protected/firewalled system and I don't have the id/pw. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
3581 2U with Atape 9.2.6.0
Hi all, We're moving our Windows 2000 TSM server to an AIX 5.3 LPAR on a p520 (huzzah!). I'm running into some issues however with the Atape driver on TSM Version 5, Release 2, Level 2.0. The tape library is a 3623-2LX (aka. 3581 2U) I've installed the atape driver and rebooted the LPAR. According to everything I've read, I SHOULD have a /dev/smc0 device. I do not however. What I have is a /dev/rmt0.smc. I've attempted to open this with tapeutil and it kicks back an error. When I attempt to define a library path in TSM to it, I get the following errors: 03/28/05 20:32:11 ANR2017I Administrator ADMIN issued command: DEFINE PATH CORPTSM01 3581LIB SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE =/dev/rmt0.smc ONLINE=YES AUTODETECT=NO (SESSION: 180) 03/28/05 20:32:32 ANR8840E Unable to open device /dev/rmt0.smc with error 6. (SESSION: 180) 03/28/05 20:32:32 ANR8418E DEFINE PATH: An I/O error occurred while accessi ng library 3581LIB. (SESSION: 180) From what I can read online, the rmt0.smc is for the some higher end model libraries. Can anyone provide any info that might tell me what in the hell I'm doing wrong here? Here's a list of the devices created by Atape. FYI the install of the driver went fine and displayed no errors. Of course I get the following when I run cfgmgr: cfgmgr: 0514-621 WARNING: The following device packages are required for device support but are not currently installed. devices.scsi Configuration time: 1 seconds But I understand that this is an error that can be ignored. I verified that all the devices.scsi packages were installed. Here's that device list: # ls -al rmt* crw-rw-rwT 1 root system 38, 0 Mar 28 20:27 rmt0 crw-rw-rwT 1 root system 38, 1 Mar 28 20:27 rmt0.1 crw-rw-rwT 1 root system 38, 9 Mar 28 20:27 rmt0.10 crw-rw-rwT 1 root system 38, 4 Mar 28 20:27 rmt0.2 crw-rw-rwT 1 root system 38, 8 Mar 28 20:27 rmt0.20 crw-rw-rwT 1 root system 38, 5 Mar 28 20:27 rmt0.3 crw-rw-rwT 1 root system 38, 0 Mar 28 20:27 rmt0.4 crw-rw-rwT 1 root system 38, 32 Mar 28 20:27 rmt0.40 crw-rw-rwT 1 root system 38, 33 Mar 28 20:27 rmt0.41 crw-rw-rwT 1 root system 38, 1 Mar 28 20:27 rmt0.5 crw-rw-rwT 1 root system 38, 4 Mar 28 20:27 rmt0.6 crw-rw-rwT 1 root system 38, 40 Mar 28 20:27 rmt0.60 crw-rw-rwT 1 root system 38, 5 Mar 28 20:27 rmt0.7 crw-rw-rwT 1 root system 38, 64 Mar 28 20:27 rmt0.null crw-rw-rwT 1 root system 38, 2 Mar 28 20:27 rmt0.smc Thanks. John E. Vincent
help:Lan-free backup question
Hi all,somebody told me that for TSM lan-free backup client(store agent?) must need two separate fc adapters to transfer backup data and application data,is this ture?From store agent manual I couldn't find any subject about this.But for Veritas Netbackup a media server only need 1 fc adapter to do this.Who can help me?Thanks!
Re: Using multiple Ethernet adapters on AIX TSM server?
Hi, I don't know whether you can merge your two network adapter cards and associated ip into a logical channel called etherchannel might help you out. I know AIX supports etherchannel. Try smitty etherchannel to help you with the config. All the best -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Justin Derrick Sent: Monday, March 28, 2005 10:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Using multiple Ethernet adapters on AIX TSM server? Hi Kevin. I am currently using one GigE adapter on my TSM server, and I have so much traffic coming into it during the night that I need to add another. The new adatper will have a different IP, but will be on the same subnet as the first one. I am not sure of the right / best way to configure it. If you're maxing out your GigE connection, adding another line to it may just push the bottleneck upstream to the switch -- you'll want to work with your network folks to determine the best place to lay new pipes. It's my understanding that provided this second adapter has its own IP address, that I can specify that address in the dsm.opt file on certain clients that I want to come in over that adapter. Correct? You've got the right idea. Again, depending on your traffic patterns (lots of small clients vs. a few huge clients) it might make sense to associate more IP addresses with the host name on your DNS server, and have DNS provide load balancing (by passing out IPs for the same hostname in a round-robin fashion). This is especially useful if it's the GigE that's the bottleneck to the switch. This is a good general-purpose fix, but to truly optimize your connectivity, you have to dig into your usage patterns to develop the best solution. You'll want to remove the bottleneck, not just push it upstream. =) From an AIX standpoint, do I set the default gateway for the new adapter to be the same as the other one? Or do I make the first adapter the default gateway for the second one? Depends on how you set up subnets. To specifically answer your second question, NO. =) - If you add the second IP to the *same* subnet, then they have the same gateway (possibly a bottleneck). - If you add the second IP to a *different* subnet, it may or may not (but it SHOULD, really) have a different gateway associated with it. -JD. This mail has originated from the Internet. The State Bank of Mauritius disclaims all liability as regards to its content. Please verify its source and content before acting thereon. The information contained in this e-mail message, and any attachment thereto, is confidential and may be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Thank you. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.
TSM 5.3 new goody 03/28/2005
(from the Windows Administrator's Guide, page 134) IBM 3494 tape categories Typically, a software application that uses a 3494 library uses volumes in one or more categories that are reserved for that application. To avoid loss of data, each application sharing the library must have unique categories. When you define a 3494 library to the server, you can use the PRIVATECATEGORY and SCRATCHCATEGORY parameters to specify the category numbers for private and scratch Tivoli Storage Manager volumes in that library. If the volumes are IBM 3592 WORM (write once, read many) volumes, you can use the WORMSCRATCHCATEGORY parameter to specify category numbers for scratch WORM volumes in the library. See IBM Tivoli Storage Manager Volumes on page 79 for more information on private, scratch, and scratch WORM volumes. -- Mark Stapleton ([EMAIL PROTECTED]) Office 262.521.5627