Re: RoadMap?
I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4.
SQL TDP error message
TSM server running 5.3.2 on a Win2k box. We have put in a new server in running Windows 2003R2 Standard Edition and SQL 2005. I installed TSM client 5.3.2 and got it configured with no problem. I then installed the TDP for SQL 5.2.1.0. When try to do a SQL backup using either the GUI or the command line I get the same error, ACO5423E The following string is too long: CSqlApi::CopyUToN:566:1908 strlen(139 9...):74. I looked up ACO5423E in the archives here and got nowhere. Any ideas before I call support? David Tyree Enterprise Backup Administrator South Georgia Medical Center 229.333.1155 txt pager [EMAIL PROTECTED] Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: SQL TDP error message
I believe 5.2.1.3 of the TDP is the lowest version that has SQL2005 toleration. Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-535-6574 (desk) 423-785-7347 (cell) ***public*** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tyree, David Sent: Thursday, January 04, 2007 8:38 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL TDP error message TSM server running 5.3.2 on a Win2k box. We have put in a new server in running Windows 2003R2 Standard Edition and SQL 2005. I installed TSM client 5.3.2 and got it configured with no problem. I then installed the TDP for SQL 5.2.1.0. When try to do a SQL backup using either the GUI or the command line I get the same error, ACO5423E The following string is too long: CSqlApi::CopyUToN:566:1908 strlen(139 9...):74. I looked up ACO5423E in the archives here and got nowhere. Any ideas before I call support? David Tyree Enterprise Backup Administrator South Georgia Medical Center 229.333.1155 txt pager [EMAIL PROTECTED] Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: Off-topic post related to DST changes.
Windows and I think many other OS's base their time off of GMT with an off-set, so as long as the systems in affected areas have the correct off-set other systems will not be affected. An example would be I save a file at 08:00 GMT, my system then adds -06:00 for my time zone. Then someone east of me reads the file date, their system will see a time of 08:00 GMT and their local computer will add -05:00 for the local time zone offset. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Wednesday, January 03, 2007 7:27 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Off-topic post related to DST changes. Daylight saving in Australia is a dog's breakfast (ie a disgusting mess) It is controlled by the various states, and so each lot of regional politicians has its own barrow to push. The easternmost states are all stacked north/south, Tasmania starts a month early but finishes with the rest, NSW and Victoria go first Sunday in October to last Sunday in March and Queensland doesn't do DST at all. South Australia and Northern Territory are also stacked north/south in the middle of the country normally 30 minutes behind NSW, SA does DST, on the same timetable as NSW, but NT doesn't. Western Australia takes up the whole of the western third of the continent, and despite there having been three referendums, all soundly defeated, some local idiot recently pushed through legislation that started daylight saving this year on 3 December, with about 6 week's notice of the change. So at the moment it is 12:23 in Tas, NSW and Vic, 11:53 in SA, 11:23 in Qld, 10:53 in NT and 10:23 in WA. Are we all clear on that? Fortunately I live in Queensland and am therefore above it all :) Its not as bad as Arizona though... I saw this on a site a couple of weeks back, but haven't been able to find it again to cite it. US has DST, Arizona does not have DST, Navaho Nation (entirely within Arizona) does use DST, Hopi nation (entirely within Navaho area) does not. Regards Steve Chronically confused in Brisbane Ben Bullock wrote: re: Daylight Savings Times. This is off topic, but I know there are folks on this list in Australia that might have been through this already. The US Govt is changing the times that we will change to Daylight Savings Times from April to March. Most all OS's will require a patch, an update or a change to compensate for this change. We have been working on all our US sites to get this accomplished before March 11th 2007, but we are wondering about our other world-wide sites. They (Italy, Singapore, Japan, etc) are not changing DST for their countries, but when we change ours, and our computers transfer data between each other, might there be some confusion over the time stamps of the data if the foreign-site hosts have a different understanding of when DST for our zone (MST) is? Any help, opinions or links would be appreciated. Thanks, Ben This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: SQL TDP error message
All fixed, thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Thursday, January 04, 2007 8:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL TDP error message David, Go to: http://www.ibm.com/us/ and search for: ACO5423E You will find your answer. Bascially, it says you need to obtain Data Protection for SQL 5.2.1.03 or later for SQL Server 2005 support. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 08:37:40 AM: TSM server running 5.3.2 on a Win2k box. We have put in a new server in running Windows 2003R2 Standard Edition and SQL 2005. I installed TSM client 5.3.2 and got it configured with no problem. I then installed the TDP for SQL 5.2.1.0. When try to do a SQL backup using either the GUI or the command line I get the same error, ACO5423E The following string is too long: CSqlApi::CopyUToN:566:1908 strlen(139 9...):74. I looked up ACO5423E in the archives here and got nowhere. Any ideas before I call support?
Re: RoadMap? (Offtopic: Executive Briefings)
Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
List of archives
Hi, I was wondering if there exists a tsm command to get a list of all existing archives by description, node, ... Intention is to get a list of all the archives that have been taken. Not to get the full file list. If found some SQL examples, but they take incredibly long to process. When, from the client GUI, one asks the existing archives (via Delete Archives), the list pops up immediately. Can we get the list from the server? Thanks, Geert
Re: RoadMap? (Offtopic: Executive Briefings)
Hi Troy, Can this presentation be viewed on-line? Thanks Barnhart, Troy wrote: Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
Re: TSM DB2 API Backup Question
Charles, DB2 backup to TSM is owned by the DB2 product team. I did pass this question on to them, this was the response: There is a potential for a hang if the online backup had to retrieve a log file from the TSM tape pool, but backup is using all of the tape drives. IBM DB2 is currently trying to decide how to handle this case, but do not have a good solution yet. This does not occur very often but is a pain when it does. Some recommendations to avoid this problem include: 1) Archive log files to a TSM Disk Pool (this is a best practice that all customers should be following) 2) Increase the LOGPRIMARY parameter on the DB so that all of the log files required by the backup remain on disk. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/02/2007 10:56:00 AM: One of our TSM environments that is Backing up Unix and DB2 data is a bit overrun at this point (lots of MediaW'). I was talking to our DB2 DBA and he states that the final step to a On-line DB2 backup is to include the transaction logs that occurred since the backup began. The DB2 log files are archived to tape from the TSM DB2 API, so the full backup now requires a tape mount to validate those logs files are complete. unfortunately these DB2 Full backups sit and wait for tape Our question is there anyway to cfg these DB2 On-line Full Backups to just Query TSM to validate the log files recvd? Or does it always have to mount a tape. I was looking in the TSM DB2 manual but really haven't found such an option. Thanks Again for any help!! Charles Hart
Re: RoadMap? (Offtopic: Executive Briefings)
Sorry, no. It was more of an off-the-cuff discussion with representatives from the development team. We were technicians there to learn, not the usual company executives or using it as a complaint session. So we asked to dig in with tivoli technicians on our needs. It was great. We've been able to really fix some past problems, suggest some ideas to the team, and get a better idea of where we want to go with IBM-Tivoli hardware/software. Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Timothy Hughes [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 8:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? (Offtopic: Executive Briefings) Hi Troy, Can this presentation be viewed on-line? Thanks Barnhart, Troy wrote: Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
Re: List of archives
Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. Or bring down your server. (I've seen that happen with heavy sql queries in TSM). It seems that the client has a far more efficient way of querying the server than the sql interface has. You might consider to leave out the 'group by' clause and redirect the output to a text file. Then import this file into a database like Oracle or DB2 and do your query there. The text file can get pretty big though (depending on how many files have been archived). Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Geert De Pecker Sent: Thursday, January 04, 2007 4:27 PM To: ADSM-L@VM.MARIST.EDU Subject: List of archives Hi, I was wondering if there exists a tsm command to get a list of all existing archives by description, node, ... Intention is to get a list of all the archives that have been taken. Not to get the full file list. If found some SQL examples, but they take incredibly long to process. When, from the client GUI, one asks the existing archives (via Delete Archives), the list pops up immediately. Can we get the list from the server? Thanks, Geert
Re: List of archives
Given this SELECT statement: select node_name,description from archives group by node_name,description The following is simpler: select distinct node_name, description from archives Best 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 09:30:48 AM: Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. Or bring down your server. (I've seen that happen with heavy sql queries in TSM). It seems that the client has a far more efficient way of querying the server than the sql interface has. You might consider to leave out the 'group by' clause and redirect the output to a text file. Then import this file into a database like Oracle or DB2 and do your query there. The text file can get pretty big though (depending on how many files have been archived). Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Geert De Pecker Sent: Thursday, January 04, 2007 4:27 PM To: ADSM-L@VM.MARIST.EDU Subject: List of archives Hi, I was wondering if there exists a tsm command to get a list of all existing archives by description, node, ... Intention is to get a list of all the archives that have been taken. Not to get the full file list. If found some SQL examples, but they take incredibly long to process. When, from the client GUI, one asks the existing archives (via Delete Archives), the list pops up immediately. Can we get the list from the server? Thanks, Geert
Re: List of archives
On Jan 4, 2007, at 11:30 AM, Alexander Verkooijen wrote: Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. ... Listing all Archives (or Backups) is a *very* expensive fishing expedition. If you *must* do this from the server (rather than more efficiently, from the client), then try to limit it to subsets that you really need, where taking advantage of Keyed columns should substantially speed the query. Doselect * from syscat.columns where TABNAME='ARCHIVES' to see the table column definitions, where columns having INDEX_KEYSEQ entries are keyed, and render more efficient searches in a Select. Richard Sims
Re: Off-topic post related to DST changes.
Thanks, that made my day! I thought we were the only country where the politicians are insane! W -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Wednesday, January 03, 2007 8:27 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Off-topic post related to DST changes. Daylight saving in Australia is a dog's breakfast (ie a disgusting mess) It is controlled by the various states, and so each lot of regional politicians has its own barrow to push. The easternmost states are all stacked north/south, Tasmania starts a month early but finishes with the rest, NSW and Victoria go first Sunday in October to last Sunday in March and Queensland doesn't do DST at all. South Australia and Northern Territory are also stacked north/south in the middle of the country normally 30 minutes behind NSW, SA does DST, on the same timetable as NSW, but NT doesn't. Western Australia takes up the whole of the western third of the continent, and despite there having been three referendums, all soundly defeated, some local idiot recently pushed through legislation that started daylight saving this year on 3 December, with about 6 week's notice of the change. So at the moment it is 12:23 in Tas, NSW and Vic, 11:53 in SA, 11:23 in Qld, 10:53 in NT and 10:23 in WA. Are we all clear on that? Fortunately I live in Queensland and am therefore above it all :) Its not as bad as Arizona though... I saw this on a site a couple of weeks back, but haven't been able to find it again to cite it. US has DST, Arizona does not have DST, Navaho Nation (entirely within Arizona) does use DST, Hopi nation (entirely within Navaho area) does not. Regards Steve Chronically confused in Brisbane Ben Bullock wrote: re: Daylight Savings Times. This is off topic, but I know there are folks on this list in Australia that might have been through this already. The US Govt is changing the times that we will change to Daylight Savings Times from April to March. Most all OS's will require a patch, an update or a change to compensate for this change. We have been working on all our US sites to get this accomplished before March 11th 2007, but we are wondering about our other world-wide sites. They (Italy, Singapore, Japan, etc) are not changing DST for their countries, but when we change ours, and our computers transfer data between each other, might there be some confusion over the time stamps of the data if the foreign-site hosts have a different understanding of when DST for our zone (MST) is? Any help, opinions or links would be appreciated. Thanks, Ben
Re: Off-topic post related to DST changes.
And I was recently discussing DST with a Canadian from Nova Scotia and thought that these were the half hour guys as well. No, he informs me, that would be the folks in New Foundland (newfies as he called them). When asked the genesis of a half hour difference (I didn't know the Ozzies had a similar thing at the time) he couldn't explain but did say hey, it works for them. Have you ever met a Newfie? I guess he thought that explained it all. Perhaps it's a United Kingdom thing... Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Thursday, January 04, 2007 9:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Off-topic post related to DST changes. Thanks, that made my day! I thought we were the only country where the politicians are insane! W -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Wednesday, January 03, 2007 8:27 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Off-topic post related to DST changes. Daylight saving in Australia is a dog's breakfast (ie a disgusting mess) It is controlled by the various states, and so each lot of regional politicians has its own barrow to push. The easternmost states are all stacked north/south, Tasmania starts a month early but finishes with the rest, NSW and Victoria go first Sunday in October to last Sunday in March and Queensland doesn't do DST at all. South Australia and Northern Territory are also stacked north/south in the middle of the country normally 30 minutes behind NSW, SA does DST, on the same timetable as NSW, but NT doesn't. Western Australia takes up the whole of the western third of the continent, and despite there having been three referendums, all soundly defeated, some local idiot recently pushed through legislation that started daylight saving this year on 3 December, with about 6 week's notice of the change. So at the moment it is 12:23 in Tas, NSW and Vic, 11:53 in SA, 11:23 in Qld, 10:53 in NT and 10:23 in WA. Are we all clear on that? Fortunately I live in Queensland and am therefore above it all :) Its not as bad as Arizona though... I saw this on a site a couple of weeks back, but haven't been able to find it again to cite it. US has DST, Arizona does not have DST, Navaho Nation (entirely within Arizona) does use DST, Hopi nation (entirely within Navaho area) does not. Regards Steve Chronically confused in Brisbane Ben Bullock wrote: re: Daylight Savings Times. This is off topic, but I know there are folks on this list in Australia that might have been through this already. The US Govt is changing the times that we will change to Daylight Savings Times from April to March. Most all OS's will require a patch, an update or a change to compensate for this change. We have been working on all our US sites to get this accomplished before March 11th 2007, but we are wondering about our other world-wide sites. They (Italy, Singapore, Japan, etc) are not changing DST for their countries, but when we change ours, and our computers transfer data between each other, might there be some confusion over the time stamps of the data if the foreign-site hosts have a different understanding of when DST for our zone (MST) is? Any help, opinions or links would be appreciated. Thanks, Ben
Re: Off-topic post related to DST changes.
On Thu, 4 Jan 2007 11:52:57 -0500, Prather, Wanda [EMAIL PROTECTED] said: I thought we were the only country where the politicians are insane! Have you found one in which they are rational? - Allen S. Rout
Re: RoadMap? (Offtopic: Executive Briefings)
Timothy, I can't find any official literature on the IBM website, but I googled for it and found an IBM presentation at the URL below; Also, note the disclaimer. http://www.moregroupinc.com/TSM%205.4%20Highlights%20101606.pdf Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: 04 January 2007 15:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? (Offtopic: Executive Briefings) Hi Troy, Can this presentation be viewed on-line? Thanks Barnhart, Troy wrote: Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
Re: List of archives
Hi, Thanks for the replies. Just tested and it takes approx 20 minutes for the SQL to complete (approx 5.2 million files). Workable, but I do not understand why the client just lists the archives directly. Maybe the archive info is also stored on the client side which makes is fast. Kind regards, Geert ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 04/01/2007 17:45:50: On Jan 4, 2007, at 11:30 AM, Alexander Verkooijen wrote: Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. ... Listing all Archives (or Backups) is a *very* expensive fishing expedition. If you *must* do this from the server (rather than more efficiently, from the client), then try to limit it to subsets that you really need, where taking advantage of Keyed columns should substantially speed the query. Doselect * from syscat.columns where TABNAME='ARCHIVES' to see the table column definitions, where columns having INDEX_KEYSEQ entries are keyed, and render more efficient searches in a Select. Richard Sims
Re: RoadMap? (Offtopic: Executive Briefings)
Leigh, Thanks...For the URL link. Tim Leigh Reed wrote: Timothy, I can't find any official literature on the IBM website, but I googled for it and found an IBM presentation at the URL below; Also, note the disclaimer. http://www.moregroupinc.com/TSM%205.4%20Highlights%20101606.pdf Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: 04 January 2007 15:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? (Offtopic: Executive Briefings) Hi Troy, Can this presentation be viewed on-line? Thanks Barnhart, Troy wrote: Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
Re: List of archives
No, the client does not store archive info locally. The table data shown by SELECT statements do not come directly from the internal structures. The table data are virtual, constructed on the fly when you run SELECT. Due to the nature of how SELECT works, we will not claim that it is a high-speed query engine (also see http://msgs.adsm.org/cgi-bin/get/adsm0411/387/1.html). However, under the covers, the client/server interactions are optimized to display the description info fairly quickly. 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 10:33:20 AM: Hi, Thanks for the replies. Just tested and it takes approx 20 minutes for the SQL to complete (approx 5.2 million files). Workable, but I do not understand why the client just lists the archives directly. Maybe the archive info is also stored on the client side which makes is fast. Kind regards, Geert ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 04/01/2007 17:45:50: On Jan 4, 2007, at 11:30 AM, Alexander Verkooijen wrote: Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. ... Listing all Archives (or Backups) is a *very* expensive fishing expedition. If you *must* do this from the server (rather than more efficiently, from the client), then try to limit it to subsets that you really need, where taking advantage of Keyed columns should substantially speed the query. Doselect * from syscat.columns where TABNAME='ARCHIVES' to see the table column definitions, where columns having INDEX_KEYSEQ entries are keyed, and render more efficient searches in a Select. Richard Sims
[no subject]
Is there a way to create a list of all files that are using a particular management class? 5.3.3 windows server
[no subject]
It's in the BACKUPS table. You can do a SELECT on the backups table, but it's the slowest query you can do. The BACKUPS table is indexed by nodename, so you will generally do better running the query 1 nodename at a time. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Whitlock, Brett Sent: Thursday, January 04, 2007 2:34 PM To: ADSM-L@VM.MARIST.EDU Subject: Is there a way to create a list of all files that are using a particular management class? 5.3.3 windows server
windows - backup different set of directories on different days
I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard
Re: windows - backup different set of directories on different days
Well, if you are doing an incremental backup, it will ignore the previous day's directory without you having to do anything special. It will want to scan that directory to see if there is anything to move, but it won't move anything. If you don't want that scan behavior, consider installing the journal engine. Thanks, Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Hammersley Sent: Thursday, January 04, 2007 2:38 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] windows - backup different set of directories on different days I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard
Re: windows - backup different set of directories on different days
One way to do this would be to have management classes that have a backup frequency of 7 seven days. You could: 1. Create Management Class Monday, and associate all files in the Monday directory to it. Run the backup on Monday. 2. On Tuesday, create a Management Class Tuesday, and associate all files in the Tuesday directory to it. Run the backup on Tuesday. 3. etc.. After you have done this for the first week, all the files would then be looked at every 7 days. (It still is going to examine the directories, but not back up any of the data in them.) Another way to do this would be just to do scheduled incremental backups on the particular directories and not look at the other ones for that particular day. At 04:38 PM 1/4/2007 -0500, you wrote: I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED]
Re: windows - backup different set of directories on different days
Don't use include/exclude. Create a new schedule that runs every Monday. Put the Monday directory in the schedule's OBJECTS parameter, and -SUBDIR=YES in the OPTIONS parameter (assuming you want to process any subdirectories of the Monday directory). Repeat for each day of the week you want to back up. If the idea is that you want the schedule backup to back up *more* than just the Monday or Tuesday, etc., directory (i.e., back up all local drives, except for the Monday directory if today is not Monday) then that gets trickier. In that case, use two nodes: - One node to back up everything *but* the Monday, Tuesday, etc., directories. In this case, use EXCLUDE statements to exclude the daily directories. This would be on a separate schedule that runs daily. - Another node that backs up *only* the Monday, Tuesday, etc., directories, using the scheduling scheme described above. Make sure to use a *separate* include/exclude list (or just a separate options file). 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 02:38:26 PM: I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard
Re: windows - backup different set of directories on different days
Kelly, good point about incremental my post assumes the scan behavior is what is undesirable, or *only* the day directories should be processed. 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 02:44:00 PM: Well, if you are doing an incremental backup, it will ignore the previous day's directory without you having to do anything special. It will want to scan that directory to see if there is anything to move, but it won't move anything. If you don't want that scan behavior, consider installing the journal engine. Thanks, Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Hammersley Sent: Thursday, January 04, 2007 2:38 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] windows - backup different set of directories on different days I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard
Re: windows - backup different set of directories on different days
The real big dogs always have the best answers. Guys like me choose the simplest answers! That way I can understand what I'm doing! If ever in doubt, always listen to Dave and Andy. In case that hasn't become obvious... Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Canan Sent: Thursday, January 04, 2007 2:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] windows - backup different set of directories on different days One way to do this would be to have management classes that have a backup frequency of 7 seven days. You could: 1. Create Management Class Monday, and associate all files in the Monday directory to it. Run the backup on Monday. 2. On Tuesday, create a Management Class Tuesday, and associate all files in the Tuesday directory to it. Run the backup on Tuesday. 3. etc.. After you have done this for the first week, all the files would then be looked at every 7 days. (It still is going to examine the directories, but not back up any of the data in them.) Another way to do this would be just to do scheduled incremental backups on the particular directories and not look at the other ones for that particular day. At 04:38 PM 1/4/2007 -0500, you wrote: I have a process on a windows system that creates about 400gig of data each day. It dumps this data each day to a different directory. Monday's to monday, Tuesday's to tuesday etc. I only want tsm to backup the data in that day's directory and not any of the other days. I'm currently using the TSM scheduler and TSM acceptor on the client to trigger the nightly backups. Anyone have any ideas / suggestions how I might go about that ? Is there a way to do it in the include/exclude file ? Thank you. Richard Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED]
Re: List of archives
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Thursday, January 04, 2007 5:40 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: List of archives Given this SELECT statement: select node_name,description from archives group by node_name,description The following is simpler: select distinct node_name, description from archives You're absolutely right Andy. I should have thought of that. Kind regards, Alexander Best 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli StorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/04/2007 09:30:48 AM: Hi, Something like this should provide a list of all archives: select node_name,description from archives group by node_name,description But like you said it will probably take a very long time to complete. Or bring down your server. (I've seen that happen with heavy sql queries in TSM). It seems that the client has a far more efficient way of querying the server than the sql interface has. You might consider to leave out the 'group by' clause and redirect the output to a text file. Then import this file into a database like Oracle or DB2 and do your query there. The text file can get pretty big though (depending on how many files have been archived). Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Geert De Pecker Sent: Thursday, January 04, 2007 4:27 PM To: ADSM-L@VM.MARIST.EDU Subject: List of archives Hi, I was wondering if there exists a tsm command to get a list of all existing archives by description, node, ... Intention is to get a list of all the archives that have been taken. Not to get the full file list. If found some SQL examples, but they take incredibly long to process. When, from the client GUI, one asks the existing archives (via Delete Archives), the list pops up immediately. Can we get the list from the server? Thanks, Geert