Re: Client priority?
hi, maybe something with SET RANDOMIZE ? On Thu, May 15, 2008 at 11:44 AM, Matthew Large [EMAIL PROTECTED] wrote: Hi, I'm doing some client testing and have discovered a strange quirk, if it's not WAD: Scheduled backup session is in pending 'MediaW' state waiting to acquire a drive from the library manager A manually started backup on the same machine, while the scheduled session is still open, from the GUI quickly acquires the drive and immediately starts transferring data. It seems the manually started backup had no problem getting a drive from the library manager but the scheduled backup seemed to be waiting for nothing - there were plenty of drives available. Can any one explain this behaviour? Cheers, Matthew -- Matthew Large TSM Consultant Storage Services Barclays Wealth Technology Desk: +44 (0) 207 977 3262 Mobile: +44 (0) 7736 44 8808 Alpha Room, Ground Floor Murray House 1 Royal Mint Court London EC3N 4HH Barclays Wealth is the wealth management division of Barclays Bank PLC. This email may relate to or be sent from other members of the Barclays Group. The availability of products and services may be limited by the applicable laws and regulations in certain jurisdictions. The Barclays Group does not normally accept or offer business instructions via internet email. Any action that you might take upon this message might be at your own risk. This email and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this email in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this email or its attachments. Internet communications are not guaranteed to be secure or virus-free. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this email may be monitored by the Barclays Group for operational or business reasons. Any opinion or other information in this email or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group. Barclays Bank PLC. Registered in England and Wales (registered no. 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. Barclays Bank PLC is authorised and regulated by the Financial Services Authority.
Speeding up my SQL query
Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? Thank you VERY much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Speeding up my SQL query
Eric - One thing you can do is use the SQL clause IN rather than a succession of OR conditions to improve the query performance of testing for multiple values. Richard Sims
Re: Speeding up my SQL query
Eric, Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME and ENDTIME parameters, which may be faster than the select, but the resluts may not be as straight and detailed as your select... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, May 16, 2008 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Speeding up my SQL query Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? Thank you VERY much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing.
Re: Speeding up my SQL query
Hi Rama! TSM Operational Reporter only supports SQL queries... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Choudarapu, Ramakrishna (GTS) Sent: vrijdag 16 mei 2008 15:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: Speeding up my SQL query Eric, Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME and ENDTIME parameters, which may be faster than the select, but the resluts may not be as straight and detailed as your select... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, May 16, 2008 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Speeding up my SQL query Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? Thank you VERY much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Speeding up my SQL query
Hi Richard! Thank you very much for your reply! Since I'm not much of an SQL wizzard, could you please help met with rebuilding the query? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: vrijdag 16 mei 2008 15:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: Speeding up my SQL query Eric - One thing you can do is use the SQL clause IN rather than a succession of OR conditions to improve the query performance of testing for multiple values. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Speeding up my SQL query
-Eric van Loon wrote: - Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? In my experience, sub-queries perform better than joins. With this approach, you would select appropriate fields from the ACTLOG table, and one of the criteria in the WHERE clause would be: nodename in (select node_name from nodes where contact like 'Windows%')
Re: Speeding up my SQL query
Richard meant to say to update ur query to: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and actlog.msgno in (4005,4007,4018,4037,4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename Am I right Richard? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, May 16, 2008 9:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Speeding up my SQL query Hi Richard! Thank you very much for your reply! Since I'm not much of an SQL wizzard, could you please help met with rebuilding the query? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: vrijdag 16 mei 2008 15:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: Speeding up my SQL query Eric - One thing you can do is use the SQL clause IN rather than a succession of OR conditions to improve the query performance of testing for multiple values. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing.
Re: Speeding up my SQL query
On May 16, 2008, at 10:02 AM, Choudarapu, Ramakrishna (GTS) wrote: ... Am I right Richard? Looks good. Thanks for posting that - I had to run to a meeting. Richard
Long Term Data Retention
Wanted to get some thoughts on what people are doing for Long Term Data Retention - specifically on obsolete applications. Say we have an NT 4.0 system that is no longer used. Business owner says we need to keep for 25 years. I know not practical/possible for a number of reasons. Even if we Vmware it, will they support NT 4.0 for 25 years? (Will ANYBODY support Windows 2008 in 25 years?) I know even if they take a DB dump and I Archive it for 25 years, if we retrieve the file 20 years from now, who can decipher it? There are several systems here that people are giving hints that they want to do this. I have hinted that they need to take whatever data and dump it to a text or pdf file and then I archive that. I realize that this may not be that simple for some applications as probably involves more than a simple data dump or whatever. Plus some applications are spread across multiple servers. So, before we have big meeting and I push the text or pdf file idea, what are people doing for retention of data on obsolete servers/applications? Thanks, David Longo # This message is for the named person's use only. It may contain private, proprietary, or legally privileged information. No 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: Deleting old RMAN backups ... probably again
That worked. Thanks! Respectfully, Lisa Seay -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Wednesday, April 30, 2008 11:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Deleting old RMAN backups ... probably again If you have trouble getting to that server, try another mailing list repostitory, as in: http://adsm.org/lists/html/ADSM-L/2008-04/msg00109.html Richard On Apr 30, 2008, at 11:38 AM, Seay, Lisa wrote: Do you have a more current link? This one is broken. Respectfully, Lisa Seay -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, April 29, 2008 10:48 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Deleting old RMAN backups ... probably again See http://www.mail-archive.com/adsm-l@vm.marist.edu/msg76436.html for recent similar question.
Re: Long Term Data Retention - off topic
Hi David, A few years ago I was working for a state health department that had similar sorts of retention issues and was about to retire their main patient admin system as they moved to a new one. In this case, even keeping existing data was not sufficient because different rules applied to different data. Some of it was supposed to be kept literally forever so that historians could get at it, some was required for 80 years so that epidemiological studies could be made, and some had retention lengths that depended on the life of the patient. In opposition to that, privacy legislation required that some data be deleted when there was no longer an operational need for it. After convincing them that TSM was not an appropriate vehicle, using a reducio ad absurdum argument, I researched a little further. The best method for long term data retention is probably flat XML files. These are well understood and self describing, require no specialist software to read, yet can be searched by machine when this is necessary, There are a number of specialized XML dialects developed for different purposes so a complete re-invention of the wheel is not necessary. I did not persue this to completion. It turned out that there was a section in the organization whose primary job was data retention : mostly paper based, but recognizably moving into data - just think of all those word documents and spreadsheets that also are subject to legal retention requirements, and the problem was passed to them. It did occur to me that there is a business opportunity for consulting on such problems. Just understanding the web of retention standards, which tend to refer to other standards nested three or four levels deep is a huge job, then applying those standards to the data at hand is another in order to write some code to produce the final XML. It would however take the sort of analytical accountant/actuary mindset to successfully do this and that is not my style. I hope that has given you some insight Regards Steve Steven Harris TSM Admin, Sydney Australia David Longo [EMAIL PROTECTED] TH-FIRST.ORG To Sent by: ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU [ADSM-L] Long Term Data Retention 17/05/2008 01:35 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Wanted to get some thoughts on what people are doing for Long Term Data Retention - specifically on obsolete applications. Say we have an NT 4.0 system that is no longer used. Business owner says we need to keep for 25 years. I know not practical/possible for a number of reasons. Even if we Vmware it, will they support NT 4.0 for 25 years? (Will ANYBODY support Windows 2008 in 25 years?) I know even if they take a DB dump and I Archive it for 25 years, if we retrieve the file 20 years from now, who can decipher it? There are several systems here that people are giving hints that they want to do this. I have hinted that they need to take whatever data and dump it to a text or pdf file and then I archive that. I realize that this may not be that simple for some applications as probably involves more than a simple data dump or whatever. Plus some applications are spread across multiple servers. So, before we have big meeting and I push the text or pdf file idea, what are people doing for retention of data on obsolete servers/applications? Thanks, David Longo # This message is for the named person's use only. It may contain private, proprietary, or legally privileged information. No 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. #