Re: ANS1512E Scheduled event '1ST_NT_OFFSITE' failed. Return code = 12.
According to the client manual return code 12 means: The operation completed with at least one error message (except for error messages for skipped files). For scheduled events, the status will be Failed. Review the dsmerror.log file (and dsmsched.log file for scheduled events) to determine what error messages were issued and to assess their impact on the operation. As a general rule, this return code means that the error was severe enough to prevent the successful completion of the operation. For example, an error that prevents an entire file system from being processed yields return code 12. When a file is not found the operation yields return code 12. Alexander On Tue, 2008-01-22 at 16:29 +0100, Hari, Krishnaprasath wrote: Guys Any idea about the RC=12 and why backup shows has failed due to this 01/21/2008 18:51:46 --- SCHEDULEREC STATUS BEGIN 01/21/2008 18:51:46 Total number of objects inspected: 28,844 01/21/2008 18:51:46 Total number of objects backed up: 150 01/21/2008 18:51:46 Total number of objects updated: 0 01/21/2008 18:51:46 Total number of objects rebound: 0 01/21/2008 18:51:46 Total number of objects deleted: 0 01/21/2008 18:51:46 Total number of objects expired: 30 01/21/2008 18:51:46 Total number of objects failed: 13 01/21/2008 18:51:46 Total number of subfile objects: 0 01/21/2008 18:51:46 Total number of bytes transferred:176.91 MB 01/21/2008 18:51:46 Data transfer time:8.88 sec 01/21/2008 18:51:46 Network data transfer rate:20,382.13 KB/sec 01/21/2008 18:51:46 Aggregate data transfer rate: 1,514.54 KB/sec 01/21/2008 18:51:46 Objects compressed by:0% 01/21/2008 18:51:46 Subfile objects reduced by: 0% 01/21/2008 18:51:46 Elapsed processing time: 00:01:59 01/21/2008 18:51:46 --- SCHEDULEREC STATUS END 01/21/2008 18:51:46 --- SCHEDULEREC OBJECT END 1ST_NT_OFFSITE 01/21/2008 18:00:00 01/21/2008 18:51:46 ANS1512E Scheduled event '1ST_NT_OFFSITE' failed. Return code = 12. 01/21/2008 18:51:46 Sending results for scheduled event '1ST_NT_OFFSITE'.
An invalid path was used on Netware
Hi all, Sometimes the incremental backup of one of our customers Netware clients is aborted. There is a summary in the dsmsched.log of how many files are backed up etc. At exactly the same second an error is logged in dsmerror.log: 12/01/2007 16:20:02 (TSAFS.NLM 6.51.5 291) An invalid path was used. 12/01/2007 16:20:02 (TSAFS.NLM 6.51.5 291) An invalid path was used. I searched the list archive and the rest of the web but couldn't find any useful information. Anyone seen this before? (Client Netware 5.70.5, client version 5.4.1.4, Server on AIX 5.3, server version 5.3.4.1) Alexander
Re: DP for SQL Server full backup failure
Google-ing for rc=428 return a lot more results, including one from Del Hoober that might be interesting. Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, November 27, 2007 10:22 AM To: ADSM-L@VM.MARIST.EDU Subject: DP for SQL Server full backup failure Hi TSM-ers! One of our SQL Server 2005 (running DP for SQL Server 5.3.3.0) the full backup fails every time. In the tdpsql.log we see the following messages: 11/23/2007 02:26:44 ACO5436E A failure occurred on stripe number (0), rc = 428 11/23/2007 02:26:44 ACO5407E The SQL server aborted the operation. 11/23/2007 02:26:44 Backup of InTrust_Audit_DB failed. 11/23/2007 02:26:44 ACO5422E Received the following from the MS SQL server: 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file TDPSQL-026C-: 995(The I/O operation has been aborted because of either a thread exit or an application request.). 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040cc7) Does anyone know what could be the cause? Google-ing for 0x80040cc7 returns one hit. Someone posted the exact same error on a forum, but did not receive a solution... Thanks in advance for any reply!!! 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: TDP for Domino crashes
Hi, Sorry for the delay. I asked the sys admin - no answer yet. Is it nessecary for the windows server to run in console mode? Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: Tuesday, June 19, 2007 1:45 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for Domino crashes Hi, Any chance that you are not running your Windows server in console mode, mstsc /console? //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Verkooijen Sent: den 19 juni 2007 13:26 To: ADSM-L@VM.MARIST.EDU Subject: TDP for Domino crashes Hi, (TDP for Domino 5.3.0.0 on Windows Server 2003 R2 Enterprise Edition, TSM Server 5.3.4.1 on AIX 5.3.0.0) During a backup the client (both GUI and command line) crashes: 2007/06/07 13:41:42 IBM Tivoli Storage Manager Version: 5.3.0.0 Build date: Wed Dec 08 17:46:19 2004 domdsmc.exe caused exception C005 (EXCEPTION_ACCESS_VIOLATION) at 001B:7C342D6E Register dump: EAX= EBX= ECX=007A EDX=7C380D52 ESI= EDI= EBP=0011FC94 ESP=0011FC70 EIP=7C342D6E FLG=0246 CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS= Crash dump successfully written to file 'C:\Program Files\Tivoli\TSM\domino\dsmcrash.dmp' Stack Trace: 001B:7C342D6E (0x 0x7C380D50 0x 0x00979468) MSVCR71.dll, strpbrk()+39 bytes 001B:7C34BC33 (0x009727F8 0x 0x7C380D50 0x7C35771F) MSVCR71.dll, mbsdec()+105 bytes 001B:7C34BCB8 (0x 0x 0x 0x) MSVCR71.dll, mbspbrk()+35 bytes I couldn't find anything like this for the Domino TDP in the list archive, the APAR database or with Google. Does anyone here have an idea what is wrong? Thanks, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: TDP for Domino crashes
Thanks. Mr. Sims also pointed me in the direction of a newer release of the TDP. I'll advise the Domino admin to upgrade. Thanks again, ALexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Clark Sent: Wednesday, June 20, 2007 11:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for Domino crashes I was seeing the same EXCEPTION_ACCESS_VIOLATION error with the TSM client and scheduler. In our case we updated to a newer version of the client, and the problem went away. I suspect that one of the service packs, or third party security apps applied to the box tightened down some aspects of interprocess communication. I'm sorry to be so short on details. [RC] On Jun 19, 2007, at 4:25 AM, Alexander Verkooijen wrote: Hi, (TDP for Domino 5.3.0.0 on Windows Server 2003 R2 Enterprise Edition, TSM Server 5.3.4.1 on AIX 5.3.0.0) During a backup the client (both GUI and command line) crashes: 2007/06/07 13:41:42 IBM Tivoli Storage Manager Version: 5.3.0.0 Build date: Wed Dec 08 17:46:19 2004 domdsmc.exe caused exception C005 (EXCEPTION_ACCESS_VIOLATION) at 001B:7C342D6E Register dump: EAX= EBX= ECX=007A EDX=7C380D52 ESI= EDI= EBP=0011FC94 ESP=0011FC70 EIP=7C342D6E FLG=0246 CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS= Crash dump successfully written to file 'C:\Program Files\Tivoli\TSM\domino\dsmcrash.dmp' Stack Trace: 001B:7C342D6E (0x 0x7C380D50 0x 0x00979468) MSVCR71.dll, strpbrk()+39 bytes 001B:7C34BC33 (0x009727F8 0x 0x7C380D50 0x7C35771F) MSVCR71.dll, mbsdec()+105 bytes 001B:7C34BCB8 (0x 0x 0x 0x) MSVCR71.dll, mbspbrk()+35 bytes I couldn't find anything like this for the Domino TDP in the list archive, the APAR database or with Google. Does anyone here have an idea what is wrong? Thanks, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
TDP for Domino crashes
Hi, (TDP for Domino 5.3.0.0 on Windows Server 2003 R2 Enterprise Edition, TSM Server 5.3.4.1 on AIX 5.3.0.0) During a backup the client (both GUI and command line) crashes: 2007/06/07 13:41:42 IBM Tivoli Storage Manager Version: 5.3.0.0 Build date: Wed Dec 08 17:46:19 2004 domdsmc.exe caused exception C005 (EXCEPTION_ACCESS_VIOLATION) at 001B:7C342D6E Register dump: EAX= EBX= ECX=007A EDX=7C380D52 ESI= EDI= EBP=0011FC94 ESP=0011FC70 EIP=7C342D6E FLG=0246 CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS= Crash dump successfully written to file 'C:\Program Files\Tivoli\TSM\domino\dsmcrash.dmp' Stack Trace: 001B:7C342D6E (0x 0x7C380D50 0x 0x00979468) MSVCR71.dll, strpbrk()+39 bytes 001B:7C34BC33 (0x009727F8 0x 0x7C380D50 0x7C35771F) MSVCR71.dll, mbsdec()+105 bytes 001B:7C34BCB8 (0x 0x 0x 0x) MSVCR71.dll, mbspbrk()+35 bytes I couldn't find anything like this for the Domino TDP in the list archive, the APAR database or with Google. Does anyone here have an idea what is wrong? Thanks, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: contact ADSM-L admins?
On Friday 04 May 2007 10:15, Curtis Preston wrote: For the life of me, I can't figure out how to contact the admins of the adsm-l list at vm.marist.edu. I know it's something really stupid, but I just can't figure it out. Can anyone help? Please? According to mr. Sims excellent Quick Facts page the admin of the list is Martha McConaghy [EMAIL PROTECTED] Alexander
Re: RAC backups
I spent the last two months installing TSM on a two node RAC cluster (Linux, not AIX). It was a very unpleasant experience. There is very little documentation (at least that I could find). I can back up now and a few weeks ago I had to restore a corrupt datafile. For some reason it took RMAN hours and I had to copy archived logs manually from one node to another node but in the end the datafile was restored. There is one advise I can give you: Make sure your archived logs (if you're running your database in archive log mode) are on some kind of shared storage like ASM so all the nodes can access them. Regards, Alexander On Monday 23 April 2007 16:18, Thomas, Matthew wrote: Guys, Does anyone have any guidance on using TSM scheduled TDP backups with Oracle RAC multi-node grids? We're due to implement a 4-way RAC cluster (on AIX) and ultimately we'll need the database(s) to be backed up and restored via any of the 4 nodes in the grid. Any advice would be appreciated. TIA Matt Thomas This e-mail is only for the above addressees. It may contain confidential or privileged information. If you are not an addressee you must not copy, distribute, disclose or use any of the information in it or any attachments. If you have received it in error please notify the sender and delete it immediately. Lloyds TSB Bank plc. Registered office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales, number 2065. Telephone: 020 7626 1500. Lloyds TSB Scotland plc. Registered office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone: 0131 225 4555. Cheltenham Gloucester plc. Registered office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales, number 2299428. Telephone: 01452 372372. Lloyds TSB Bank plc, Lloyds TSB Scotland plc and Cheltenham Gloucester plc are authorised and regulated by the Financial Services Authority and are signatories to the Banking Codes. Lloyds TSB Bank plc and Lloyds TSB Scotland plc represent only the Scottish Widows and Lloyds TSB Marketing Group for life assurance, pensions and investment business. Cheltenham Gloucester plc acts as an introducer only for life assurance, pensions and investment business. Lloyds TSB Group plc. Registered office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95000. Telephone: 0131 225 4555.
Re: RMAN HANGS
Just guessing - but did you wait long enough? I've seen RMAN operations hang for hours (up to 5 hours on one occasion) for no apparent reason after which they suddenly continued again. Regards, Alexander On Thursday 19 April 2007 07:21, Feras Qadi wrote: I have Oracle 10.2 installed on AIX, I have also the RMAN Catalog installed on windows Oracle 10.2 When I take small backup every thing works fine, But when taking larg backup my RMAN hangs and the session never returns. Any help will be highly appreciated Feras Al Qadi Principal System analyst ITJ-Arab Bank Jordan *** *** This email/attachment(s) thereto are intended solely for the addressee (s). Any form of use or taking of any action in reliance on information contained therein by other than the addressee is unauthorised, prohibited and unlawful. If you receive this message in error, notify the sender immediately by e-mail and delete material from all your systems. The Arab Bank plc does not represent that any attachment is free from computer viruses or defects and the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of any attachment. The information contained in any email does not necessarily reflect the views of the Arab Bank plc or any other related entities or persons. *** ***
Re: How are tapes declared full
When a tape has still space on it left it's state is Filling. When there is no more space left it is set to Full. Then files stored on the tape will expire according to your policies. These expired files will cause 'gaps' and the % utilised will drop until it reaches the reclamation threshold. During this process the tape will remain Full until it gets reclaimed. The estimated capacity relflects how many data TSM was able to store on the tape. Your tape drives probably compress the data before it is written to tape. Some data can be more easily compressed than other data. That is why there is a difference. Regards, Alexander On Thursday 19 April 2007 11:52, Angus Macdonald wrote: Doing some maintenance, I notice that most of my LTO2 storage pool tapes are designated as full, although their % utilised is sometimes less that 60%. The estimated capacities also vary from 320GB to over 600GB. I'm not actually having any problems but how does TSM decide the estimated capacity of a tape and whether or not it is full?
Wrong number of minutes in ANR0482W?
Hi all, (5.3.4.1 server on AIX 5.3.0.0, 5.4.0.0 Mac client) I noticed something funny yesterday. The IdleTimeOut on one of our servers was set at 75 minutes. At 14:06 session 179021 started: 03/08/2007 14:06:12 ANR0406I Session 179021 started for node XXX (Mac) (Tcp/Ip xxx.xxx.xxx(xxx)). (SESSION: 179021) At 14:22 I increased the IdleTimeOut to 120 minutes: 03/08/2007 14:22:49 ANR2017I Administrator XXX issued command: SETOPT IdleTimeOut 120 (SESSION: 178563) The new IdleTimeOut had it's effect on session 179021 since it waited 120 minutes before it terminated as this 'query session' output shows: 179,021 Tcp/Ip IdleW 2.0 H 343 328 Node Mac XXX So far so good. But this is the accompanying activity log entry: Date/TimeMessage -- 03/08/2007 16:16:15 ANR0482W Session 179021 for node XXX (Mac) terminated - idle for more than 75 minutes. (SESSION: 179021) It still reports the old value, 75 minutes, despite the fact it waited for 120 minutes before it terminated the session. Sessions that were terminated later that evening report the new value: 03/08/2007 21:07:15 ANR0482W Session 179504 for node XXX (Mac) terminated - idle for more than 120 minutes. (SESSION: 179504) Am I missing something here? Regards, Alexander
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
-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
Re: ANR2579E backup fails
According to the manual this is the meaning of return code 4: The operation completed successfully, but some files were not processed. There were no other errors or warnings. This return code is very common. Files are not processed for various reasons. The most common reasons are: The file is in an exclude list. The file was in use by another application and could not be accessed by the client. The file changed during the operation to an extent prohibited by the copy serialization attribute. See Copy serialization. Maybe you should check dsmsched.log and/or dsmerror.log on your client to see which files aren't backed up and why. 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 Brian Wheeler Sent: Tuesday, December 12, 2006 3:40 PM To: ADSM-L@VM.MARIST.EDU Subject: ANR2579E backup fails Every night we have one machine which fails with return code 4, but I cannot figure out why. Its the only machine that does this, and we have several with the same configuration. The versions we're using are: Server version 5.1.6 Client version 4.2.1 Here's the activity log entries for last night for this node that fails. There's nothing obvious as to why it fails. Any other places I should look to try to diagnose this? Thanks! Brian Wheeler 12/12/06 02:11:43 ANR0406I Session 220 started for node ERATO (AIX) (Tcp/Ip 156.56.241.23(59710)). 12/12/06 02:11:54 ANR0406I Session 221 started for node ERATO (AIX) (Tcp/Ip 156.56.241.23(59712)). 12/12/06 04:57:14 ANR0403I Session 221 ended for node ERATO (AIX). 12/12/06 04:57:15 ANE4952I (Session: 220, Node: ERATO) Total number of objects inspected: 1,219,474 12/12/06 04:57:15 ANE4954I (Session: 220, Node: ERATO) Total number of objects backed up: 905 12/12/06 04:57:15 ANE4958I (Session: 220, Node: ERATO) Total number of objects updated: 0 12/12/06 04:57:15 ANE4960I (Session: 220, Node: ERATO) Total number of objects rebound: 0 12/12/06 04:57:15 ANE4957I (Session: 220, Node: ERATO) Total number of objects deleted: 0 12/12/06 04:57:15 ANE4970I (Session: 220, Node: ERATO) Total number of objects expired: 59 12/12/06 04:57:15 ANE4959I (Session: 220, Node: ERATO) Total number of objects failed: 0 12/12/06 04:57:15 ANE4961I (Session: 220, Node: ERATO) Total number of bytes transferred:11.66 GB 12/12/06 04:57:15 ANE4963I (Session: 220, Node: ERATO) Data transfer time: 5,484.59 sec 12/12/06 04:57:15 ANE4966I (Session: 220, Node: ERATO) Network data transfer rate:2,230.35 KB/sec 12/12/06 04:57:15 ANE4967I (Session: 220, Node: ERATO) Aggregate data transfer rate: 1,231.63 KB/sec 12/12/06 04:57:15 ANE4968I (Session: 220, Node: ERATO) Objects compressed by:0% 12/12/06 04:57:15 ANE4964I (Session: 220, Node: ERATO) Elapsed processing time:02:45:32 12/12/06 04:57:15 ANR2579E Schedule UNIX_NIGHTLY in domain SERVERS for node ERATO failed (return code 4). 12/12/06 04:57:16 ANR0403I Session 220 ended for node ERATO (AIX). 12/12/06 04:57:16 ANR0406I Session 303 started for node ERATO (AIX) (Tcp/Ip 156.56.241.23(59778)). 12/12/06 04:57:16 ANR0403I Session 303 ended for node ERATO (AIX).
Re: ANR8212W
It looks like your server can't resolve the node's IP address. Did you try a nslookup on the OS prompt of the server? nslookup insert computer name here (works on Windows and UNIX) 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 Gill, Geoffrey L. Sent: Thursday, November 16, 2006 1:52 AM To: ADSM-L@VM.MARIST.EDU Subject: ANR8212W I am wondering if anyone has seen these slamming their logs. I have 2 nodes that had DNS changes 2 nights ago and since then these have shown up in the logs for both of them. It looks like the messages are only showing up in the activity log while the session is active The computers have both been restarted since then and nothing shows up in the logs on the client nodes that I can tell. Both client and server are at 5.3.4. 11/14/2006 2:29:41 AM ANR8212W Unable to resolve address for computer name was here. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: missed backups oddity
Maybe you could try running a shell script that does a 'query session' every 5 minutes and redirects the output to a log file. That should tell you where all the sessions come from. Something like this should work: --- CUT HERE --- #!/usr/bin/ksh while true do /usr/bin/dsmadmc -id=xxx -pass=xxx q ses mylogfile sleep 300 done ---CUT HERE--- 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 Gill, Geoffrey L. Sent: Friday, September 01, 2006 6:01 PM To: ADSM-L@VM.MARIST.EDU Subject: missed backups oddity The background on this is that this server, AIX 5.3, TSM 5.2.6.1, has been running smoothly forever. Max Scheduled sessions is set to 64, total number of servers that back up to this guy is only 36. So needless to say I would never expect to see missed backups related to servers missing their backup window because all the scheduled sessions are in use, especially since resourceutilization is set to 1. Yet last night there was a dozen or so missed backups for just that. What I also see in the activity log are issues with servers as they complete their backups trying to reconnect to get the next schedule, no scheduled sessions are currently available. Is there anything I may have missed that would shed some light on this? Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: How to verify backup content??
Hi, If you really want TSM to read the tape you can try to restore the data to a different location. Regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Norita binti Hassan Sent: Tuesday, August 08, 2006 10:20 AM To: ADSM-L@VM.MARIST.EDU Subject: How to verify backup content?? Hi all, I need to know how to verify the backup content. Currently, I'm using the 'q content' command. What I want to do here is I need to verify it by reading the backup tape to know the backup content rather than using The query command. It's the user requirement to make sure the existing of data. Thanks NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communications Tech. Div 6th Floor,Pos Malaysia HQ 50670 Kuala Lumpur * : 03 - 22756638 *: 016 - 6090530 Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email. Email scanned and protected by POS Malaysia
Re: Output question
Hi, Maybe you could use the -tab (or the -comma) option of dsmadmc to get what you want. It gives you the output on one line although it may require some formatting to make it readable. dsmadmc -id=MyAdmin -pa=MyPassword -tab q ev * * bla.txt Regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Ouzen Sent: Monday, August 07, 2006 7:41 AM To: ADSM-L@VM.MARIST.EDU Subject: Output question Hi to all Running a query event to pick exception status as: q event * * ex=yes begind=-1 begint=17:00 endd=today endt=08:00 c:\tsm\exception.txt Sometimes I got for a long nodename two lines: 08/03/2006 22:45:00 SCHED3WEBLXN Missed 08/04/2006 04:00:00 DRM_HIGHLEAR- DRM_HIGHLEAR- Missed N_WEB N_WEB 08/04/2006 09:00:00 08/04/2006 09:00:06 DRM_MARVEL DRM_MARVELFailed I have a SQLDISPLAYMODE wide Column Date-Time Arithmetic Cursors Display Format ModeAllowed? Format - -- Wide ISO TruncateYes But still two lines I prefer to run the query event instead of a select command , did is possible to get only one line ?? Regards Robert
Journal backup hangs on Windows 2003
Hello, I've searched the list archives and the APARs and found several postings about problems with the journal based backups but none that I could find resembled my problem. So I humbly turn to this list for advise. One of our customers runs a 5.3.3.0 client on Windows 2003 Our server is 5.3.3.1 on AIX 5.2.0.0 We advised the customer to do journal based backups to decrease the time the backup takes. Unfortunately the client hangs when it tries to do a backup. dsmcad contacts the server and retrieves the time the backup is scheduled. It even starts dsmc at the appropriate time but dsmc just sits there and after 75 minutes the server severs the connection because it doesn't receive any traffic from the client. On the client however the scheduler keeps running until it is terminated by the customer. When the customer tries to stop the TSM Journal Service it hangs (does not stop) There is a strange error in the dsmerror.log that pops up several times per day: 07/18/2006 09:39:50 ANS5250E An unexpected error was encountered. TSM function name : VssRequestor::QueryStatus TSM function : pAsync-QueryStatus() for caller 'VssQuerySystemWriters()' returned VSS_E_WRITER_INFRASTRUCTURE TSM return code : -1 TSM file : vssreq.cpp (8270) My knowledge of Windows is virtually non existent so I have no idea what this is about. The dsmsched.log is silent. Any ideas anyone? Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Journal backup hangs on Windows 2003
Hello Richard, Thanks. I had found that one but my Windows-illiteracy prevented me to see any relevance to my problem. I'll have another look. Meanwhile we are beginning to suspect that the customer has OFS switched on which may be causing problems. Regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, July 18, 2006 2:56 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Journal backup hangs on Windows 2003 Alexander - A google search on VSS_E_WRITER_INFRASTRUCTURE yields http://msgs.adsm.org/cgi-bin/get/adsm0405/97.html and a few more, of interest. JBB has dependencies. Richard Sims On Jul 18, 2006, at 8:40 AM, Alexander Verkooijen wrote: ... 07/18/2006 09:39:50 ANS5250E An unexpected error was encountered. TSM function name : VssRequestor::QueryStatus TSM function : pAsync-QueryStatus() for caller 'VssQuerySystemWriters()' returned VSS_E_WRITER_INFRASTRUCTURE TSM return code : -1 TSM file : vssreq.cpp (8270) ...
Re: Help Configure Exclude Command
exclude.dir M:\Manam\2002* exclude.dir M:\Manam\2003* and so on. Kind 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 Gideon Brown Sent: Tuesday, July 04, 2006 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: Help Configure Exclude Command Hi All! I need to exclude thousands of directories starting :2002,2003,2004,2005 (Example:M:\Manam\20040505) in a win3k client, so that i'll state only to first 4 chars. Can anyone write me the correct syntax? Many Thanks! Gidi Gideon Brown Sytem Administrator 03-5319085,052-8395641 [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. **1**1***
Re: Réf. : Re: [ADSM-L] tape content wit h backup date
Hi Vincent, Sorry for the slow response. No, I don't know a way to access the real tables but I saw somebody else suggested using ODBC. Best regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vincent RATAJSZCZAK Sent: Monday, June 26, 2006 5:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Réf. : Re: [ADSM-L] tape content with backup date Thank's Alexander for your help Do you know a solution to have direct access to the TSM tables, or do I have to forget it ? Any IBM tech guy around here to confirm if it is or not possible to get the results ? Regards Vince Alexander Verkooijen [EMAIL PROTECTED] Envoyé par : ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 26/06/06 16:02 Veuillez répondre à ADSM: Dist Stor Manager Pour : ADSM-L@VM.MARIST.EDU cc :(ccc : Vincent RATAJSZCZAK/INFOGER/GRT/FR) Objet : Re: [ADSM-L] tape content with backup date If you had access to the *real* tables that reside in the TSM databse then, yes, it would be possible. Since the SQL interface only provides access to *pseudo* tables I don't think it's possible. Please correct me if I'm wrong. In the past there have been times when I could have used a list like this. 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 Vincent RATAJSZCZAK Sent: donderdag 22 juni 2006 18:07 To: ADSM-L@VM.MARIST.EDU Subject: tape content with backup date Dear lovely TSM World, I have a special request for you... I would like to list the content of a specific tape (destroyed) with a column with the backuped date of the objet. == Q content XXX is poor == select * from contents where volume_name= give me Node_name/File_name, but no backuped date == select * from backups give me Node_name/File_name and backuped date, but no tape affectation Between the 2nd and 3rd, I can't find a common field to join the tables Anyone could help me please ? Do you think it's possible ? The restore GUI show you the file name and backuped date, so I think YES, but Thank's Vince
Re: tape content with backup date
If you had access to the *real* tables that reside in the TSM databse then, yes, it would be possible. Since the SQL interface only provides access to *pseudo* tables I don't think it's possible. Please correct me if I'm wrong. In the past there have been times when I could have used a list like this. 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 Vincent RATAJSZCZAK Sent: donderdag 22 juni 2006 18:07 To: ADSM-L@VM.MARIST.EDU Subject: tape content with backup date Dear lovely TSM World, I have a special request for you... I would like to list the content of a specific tape (destroyed) with a column with the backuped date of the objet. == Q content XXX is poor == select * from contents where volume_name= give me Node_name/File_name, but no backuped date == select * from backups give me Node_name/File_name and backuped date, but no tape affectation Between the 2nd and 3rd, I can't find a common field to join the tables Anyone could help me please ? Do you think it's possible ? The restore GUI show you the file name and backuped date, so I think YES, but Thank's Vince
Re: Select and SQL literal token - 'S', 2:nd try...
The list also returned my message (it said something about sending the same message twice) but apparently both our messages appeared on the list anyway. Regards, Alexander -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: zondag 11 juni 2006 20:35 To: ADSM-L@VM.MARIST.EDU Subject: Select and SQL literal token - 'S', 2:nd try... Hi, ADSM-L returned my message even tough Alexander have answered it... And it isnt on the web so I resend it if some of you have any clue. //Henrik -Original Message- From: Henrik Wahlstedt Sent: 9. juni 2006 10:52 To: ADSM: Dist Stor Manager Subject: Select and SQL literal token - 'S' Hi, If I use this select which I thought was OK before I tested it... tsm:select s.schedule_name, s.STARTTIME, a.node_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedule_name=a.schedule_name ANR2906E Unexpected SQL literal token - 'S'. | ...V... ode_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedu ANS8001I Return code 3. Instead of using S i use SS, and it works.. select ss.schedule_name, ss.STARTTIME, a.node_name from CLIENT_SCHEDULES ss, ASSOCIATIONS a where ss.schedule_name=a.schedule_name What magic lies behind SQL literal token - 'S'. Are there more tokens that I should be aware of? Etc? Thanks Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: ANS2609S TCP/IP communications failure between the browser and the client machine
Maybe there is a (intermittent) network problem between the machine the browser runs on and the fileservers? 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 Schaub, Steve Sent: donderdag 8 juni 2006 17:22 To: ADSM-L@VM.MARIST.EDU Subject: ANS2609S TCP/IP communications failure between the browser and the client machine server 5.2.2.0 client 5.3.2.0 5.3.0.5 on Win2003 The web gui on our 3 main fileservers seems to keep going unavailable with this message: ANS2609S TCP/IP communications failure between the browser and the client machine since this is the only access our helpdesk is allowed on these servers to do file restores, it is quite frustrating for them. anyone seen this and have a solution? sometimes I can get it back by recycling the CAD remote agent services, but often it requires a reboot (something not easy to get permission for) Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: Select and SQL literal token - 'S'
Strange, the server seems to treat the s different than other characters. Please note the different error messages these two commands generate: tsm: BASKETselect * from s ANR2906E Unexpected SQL literal token - 'S'. | ..V select * from s ANS8001I Return code 3. tsm: BASKETselect * from a ANR2939E The reference 'A' is an unknown SQL table name. | ..V select * from a ANS8001I Return code 28. ANR2939E is the one I would expect, not ANR2906E. My postgres server doesn't display this behaviour. 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 Henrik Wahlstedt Sent: vrijdag 9 juni 2006 10:52 To: ADSM-L@VM.MARIST.EDU Subject: Select and SQL literal token - 'S' Hi, If I use this select which I thought was OK before I tested it... tsm:select s.schedule_name, s.STARTTIME, a.node_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedule_name=a.schedule_name ANR2906E Unexpected SQL literal token - 'S'. | ...V... ode_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedu ANS8001I Return code 3. Instead of using S i use SS, and it works.. select ss.schedule_name, ss.STARTTIME, a.node_name from CLIENT_SCHEDULES ss, ASSOCIATIONS a where ss.schedule_name=a.schedule_name What magic lies behind SQL literal token - 'S'. Are there more tokens that I should be aware of? Etc? Thanks Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: Slow Informix backups every 8 days?
I do not claim to have any knowledge of Informix but the behaviour you describe suggests that you use a backup schema of a full backup every 8 days and incrementals/differentials on the other 7 days. Just guessing... 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 Bell, Charles (Chip) Sent: maandag 17 april 2006 16:45 To: ADSM-L@VM.MARIST.EDU Subject: Slow Informix backups every 8 days? Client OS AIX 4.3.3 Informix Dynamic Server Version 7.31.UD4 TDP for Informix v4.1.3 TSM v5.1.5 Why would the client back up in a way that is considered normal (45 mins. to 1 hr), but every 8th day take well over 3 hrs? Has anyone seen this happen every 'x'th day at their site? God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL Office (205) 715-5106 Pager (205) 817-0357 Home (256) 739-0947 - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: Schedule start delayed
Did you have a look at the Schedule Randomization Percentage in the output of q stat ? 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 Gill, Geoffrey L. Sent: dinsdag 18 april 2006 7:13 To: ADSM-L@VM.MARIST.EDU Subject: Schedule start delayed I'm trying to remember what it is about a backup schedule that, even though scheduled for say 8PM, does not kick off right away, nodes show pending for some time. I've been comparing the 5.2 and 5.3 server settings but can't find any obvious differences, yet the 5.2 server kicks off each schedule right at the specific time whereas the 5.3 server I'm putting up does not. I have a clopt set that has schedmode as prompted, which is the same on both servers and scheduling modes is set to any, same on both servers. What am I missing that I thought I'd taken care of? I'd actually prefer to have these guys start right away. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: Journaling/Linux
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: woensdag 8 maart 2006 21:36 To: ADSM-L@VM.MARIST.EDU Subject: Journaling/Linux All indications from searching manuals seem to indicate Journaling is not available on anything except Windows clients. If this is true why hasn't IBM moved this utility into other platforms? It's not like came out this year. As I understand it journaling is based on Window's ability to keep a journal of which files are created, changed or deleted. Porting journaling to another platform would be difficult if that platform doesn't support the same feature. Best regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: removing client folders from filespaces
Hi Eric, I don't think you need a 5.3 server for that. I can delete individual files with my 5.3.0.15 client (XP) on a 5.2.6.3 server (AIX). Kind 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 Loon, E.J. van - SPLXM Sent: vrijdag 3 februari 2006 13:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: removing client folders from filespaces Hi Tim! If you are running a 5.3 server and if you are using the 5.3 client, you can delete backup data by just using the BA GUI (Utilities menu, option delete backup data) to remove the backup data. Kindest regards, Eric van Loon -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: donderdag 2 februari 2006 21:31 To: ADSM-L@VM.MARIST.EDU Subject: removing client folders from filespaces I know you can exclude certain folders from being backed up, but is it possible to remove certain folders from a clients filespace after they have been backed up Otherwise I would have to delete the entire filespace, set up my excludes and rebackup the servers drive that related to the filespace Tim Brown Systems Specialist Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921 ** 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. **
Re: Backup hangs the Windows 2000 server client
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: dinsdag 8 november 2005 17:07 To: ADSM-L@VM.MARIST.EDU Subject: Re: Backup hangs the Windows 2000 server client On Nov 8, 2005, at 10:26 AM, Alexander Verkooijen wrote: ...Encountered exception [C005] during copy-on-write operation. ... Alexander - Thanks for that additional info. It does indeed match the IC47248 APAR description, and thus seems the path to pursue. Hopefully, that APAR is actually closed by now, with a resolution for you. Richard, Unfortunately the APAR is still open so I guess I have to be patient :-) Regards, Alexander
Re: Backup hangs the Windows 2000 server client
Hi, We also have a number of Windows 2000 clients (5.3.2.0) that seem to hang the entire system during a backup. The client has to be rebooted to get it working again. I searched the web and found APAR IC47248 which suggested there is a problem with the TSM Logical Volume Snapshot Agent. Since the client was using Open File Support I asked the user to de-install the LVSA (thereby disabling OFS). I haven't heard from the user since then so I assume that solved the problem. Regards, Alexander (Server: 5.2.3.5 on AIX) 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 Sandra Sent: maandag 7 november 2005 16:58 To: ADSM-L@VM.MARIST.EDU Subject: Backup hangs the Windows 2000 server client Dear All, I m using TSM server 5.2.2 on Windows 2003 using Library LTO 3582. I take incremental backups daily for all the servers including another windows 2000 server. One of my servers which is IBM 346 running latest secutiy and OS patches hangs and hangs forever untill power button is pressed. the system always hangs and the process of backup restarts and hangs again and again. there is no specific point or file where it hangs. also the TSM server logs show that the session was idle and was terminated. Mount retention expires and tape is safely put back into its slot. I am using open file backup support with include.fs. I m stuck ! Please help. Sandra _ Sent via SUPERwebmail - Supernet web-based email service http://www.super.net.pk/mail
Re: Backup hangs the Windows 2000 server client
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: dinsdag 8 november 2005 13:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: Backup hangs the Windows 2000 server client On Nov 8, 2005, at 3:09 AM, Alexander Verkooijen wrote: We also have a number of Windows 2000 clients (5.3.2.0) that seem to hang the entire system during a backup. The client has to be rebooted to get it working again. ... The poster of the original question had a TSM server which was utilizing default timeout values - which are far too low for real world conditions, where clients have to spend a lot of time rummaging around in file systems seeking backup candidates before they next interact with the server. The server may deem such sessions hopeless and terminate them from its end, where sometimes the client doesn't get the message that the session was cut off. In all hang situations, you need to dig in and extract the details: most hang situations are not hangs at all, but peer situations where one side is busy and the other is waiting for it. Look for ANR messages in your TSM server activity log, any OS or dsmerror.log You are right. I forgot to include a message the user found in his OS log files (or whatever they are called under Windows). Please allow me to correct my mistake. This is the error the user found: Event Type:Error Event Source:tsmlvsa Event Category:None Event ID:29 Date:3-11-2005 Time:4:00:09 User:N/A Computer:BGS-242-20 Description: Encountered exception [C005] during copy-on-write operation. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: : 00 00 00 00 02 00 58 00 ..X. 0008: 00 00 00 00 1d 00 07 c0 ..À 0010: 00 00 00 00 00 00 00 00 0018: 00 00 00 00 00 00 00 00 0020: 00 00 00 00 00 00 00 00 The APAR I referred to describes the same symptons which led me to the conclusion that I was suffering from the LVSA problem the APAR describes. Regards, Alexander
Re: Antwort: query session command - for a specific session
Just nitpicking but show session {xxx} seems to ignore the session number. It displays information for all session regardless whether a sessions number is provided or not. (5.2.3.5 AIX server) 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 Christian Demnitz Sent: vrijdag 28 oktober 2005 13:33 To: ADSM-L@VM.MARIST.EDU Subject: Antwort: query session command - for a specific session Hi, try q se {xxx} f=d or show session {xxx} Christian Demnitz Peter Hitchman [EMAIL PROTECTED] Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 28.10.2005 13:28 Bitte antworten an ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU An ADSM-L@VM.MARIST.EDU Kopie Thema query session command - for a specific session Hi, Running Version 5, Release 2, Level 3.4. Something that has been bugging me for a while. The query session command shows all of the tsm sessions and according to the help you can narrow this down to a specific session using query session 'sesnum'. But I can never get this to work. The output I see looks like the example below and the session number column format is not what it looks like in the docs:- Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method StateTimeSent Recvd Type --- -- -- -- --- --- - --- 129,541 Tcp/Ip MediaW 4.1 M1.4 K 1.0 K Node TDP Ora- x How can I run a detailed query command for just this session? Regards Pete
GFS on RedHat anybody?
Hello, (Can't find this in the archives or on Richard's page.) One of customers is planning to use the Global File System (GFS) on RedHat and asked us wheter the TSM client supports this. I can't find GFS in the list of supported file systems but the manual states that the virtualmountpoint option can be used for all other file systems. I seem to remember that we used virtualmountpoint to back up EXT3 file systems back in the days it wasn't supported but does this line mean that this trick will also work for GFS? Does anybody have any expirience with the GFS/TSM combination? Best regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Script
Hi Eric, Since TSM scripting doesn't support user defined variables I don't think it is possible to do want you want in a server script. A very ugly way to do it would be to redirect the output of select 'cancel proc ',process_num from processes where process='Space Reclamation' to a file and then call that file as a macro. But then you would still need some kind of filter to strip the header from the output of the sql query. 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 Loon, E.J. van - SPLXM Sent: donderdag 16 september 2004 15:42 To: [EMAIL PROTECTED] Subject: Re: Script Hi Jonathan! Well, that's not what I was looking for, I want to do this in a TSM script, not in a UNIX script, since I have no access to the UNIX system. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 13:41 To: [EMAIL PROTECTED] Subject: Re: Script Loon, E.J. van - SPLXM wrote: Hi *SM-ers! I'm trying to create a script which does the following: 1) query the server for any running reclamation 2) retrieves the process id for this reclamation 3) cancels the reclamation 4) starts a backup storage pool Can this be done in one script? If so, how do I put the process id in a variable which I can parse to the cancel command? Thank you very much for any reply 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. ** dsmadmc -id=blah -pass=moreblah q pr | grep Space Reclaimation | awk ' { print $1 } ' | xargs -t -I {} dsmadmc -id=blah -pass=moreblah cancel pr {} ; dsmaadmc -id=blah -pass=moreblah backup stgpool importantstuff importantstuffcopy maxpr=10 -Jonathan
Re: Select to find what tape a single file is on
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM_User Sent: donderdag 9 september 2004 3:59 To: [EMAIL PROTECTED] Subject: Select to find what tape a single file is on I know that when I use the TSM GUI to select a single file for restore TSM determines what tape needs to be mounted in seconds. So, where is the table that helps link the file requested for restore to the tape volume it is on. The TSM client uses the real tables in the TSM database. As you say, these tables obviously contain the information that is needed to determine on which tape a specific version of a file resides otherwise the client wouldn't be able to do it's jobs. Unfortunately the SQL interface doesn't provide access to the real database tables but to 'pseudo tables' which don't contain the information you seek. Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: select statement - filespaces
Hi, Unless I misunderstand your question you are asking for three separate lists so I think the only way to do it is using three sql queries. Something like this perhaps: select node_name from nodes select node_name - as Node name, - filespace_name as File space name, - sum(physical_mb) as MB's - from occupancy - group by node_name,filespace_name select node_name - as Node name, - sum(physical_mb) as MB's - from occupancy - group by node_name Please note that these queries will list *all* your nodes. Depending on how many nodes you have registered the resulting lists may be quit long. And also note that the amount of data reported is the sum of all data on all storage pools for that node/filespace, including copy pools. You may or may not want this. We usually prefer to know only the amount of data that is stored in the primary pools because we use that number for creating invoices. I hope this helps. Kind 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 Joni Moyer Sent: donderdag 2 september 2004 13:55 To: [EMAIL PROTECTED] Subject: select statement - filespaces Hello all! I was just wondering if there is any way to list each node, each filespace/node, size amount used and then total each individual node's size (space used only). Is such a select statement possible? Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Linux restore hangs in IdleW
Hello, (Searched the list archives and mr. Sim's page, even read the manual) We are seeing weird behaviour of the 5.2.3.1 client on several Red Hat 7.3 systems. (yes, we know 7.3 is very old but we can't upgrade for political reasons). When we try to restore a file that resides on a tape that is not mounted in a drive the server starts to mount the tape. The restore session goes into MediaWait. The client reports that it is waiting for a media mount. After a minute or so the tape is mounted and the session goes into Run. This lasts for about another minute. I guess the tape is being positioned. Q ses doesn't show any data going to the client. The the session goes to IdleW and stays that way. The status of the tape is IN USE until after 13 minutes the session dismounts the tape and immediately terminates itself (connection severed). Our CommTimeOut is 15 minutes btw. At this point the client still reports it is waiting for a mediamount until. Of course no data has been restored. We have seen client hang for hours like this until we killed them manually. Because of the old RedHat level we can't go to IBM for support and we can't reproduce this problem on other systems with more up-to-date OS levels. And no, we really can't upgrade these systems. This is clearly some kind of timing problem because when the tape is in a drive (in IDLE state) before the restore is started or when the data is on a disk volume instead of a tape the restore completes without any problem. It looks like the 60 second wait for the mount is causing this behaviour. Has anybody seens this before? (5.2.3.0 server on AIX 5.2, 3494 library with 3590E drives) Thanks, Alexander
Re: Antwort: Linux restore hangs in IdleW
Hello Rainer, The value for sack is 0 Regards, Alexander On Tue, 17 Aug 2004 11:32:30 +0200 Rainer Holzinger [EMAIL PROTECTED] wrote: Hi Alexander, I had a similar problem. Could you please try on your AIX system where the ITSM sever is running the command 'no -a | grep sack'? What's the setting for sack? regards, Rainer Alexander Verkooijen An: [EMAIL PROTECTED] [EMAIL PROTECTED] Kopie: NL Thema: Linux restore hangs in IdleW Gesendet von: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 17.08.2004 11:23 Bitte antworten an ADSM: Dist Stor Manager Hello, (Searched the list archives and mr. Sim's page, even read the manual) We are seeing weird behaviour of the 5.2.3.1 client on several Red Hat 7.3 systems. (yes, we know 7.3 is very old but we can't upgrade for political reasons). When we try to restore a file that resides on a tape that is not mounted in a drive the server starts to mount the tape. The restore session goes into MediaWait. The client reports that it is waiting for a media mount. After a minute or so the tape is mounted and the session goes into Run. This lasts for about another minute. I guess the tape is being positioned. Q ses doesn't show any data going to the client. The the session goes to IdleW and stays that way. The status of the tape is IN USE until after 13 minutes the session dismounts the tape and immediately terminates itself (connection severed). Our CommTimeOut is 15 minutes btw. At this point the client still reports it is waiting for a mediamount until. Of course no data has been restored. We have seen client hang for hours like this until we killed them manually. Because of the old RedHat level we can't go to IBM for support and we can't reproduce this problem on other systems with more up-to-date OS levels. And no, we really can't upgrade these systems. This is clearly some kind of timing problem because when the tape is in a drive (in IDLE state) before the restore is started or when the data is on a disk volume instead of a tape the restore completes without any problem. It looks like the 60 second wait for the mount is causing this behaviour. Has anybody seens this before? (5.2.3.0 server on AIX 5.2, 3494 library with 3590E drives) Thanks, Alexander -- Met vriendelijke groet, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Antwort: Re: Antwort: Linux restore hangs in IdleW
Hi Rainer, Thanks for responding anyway. Regards, Alexander - Original Message - From: Rainer Holzinger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 11:55 AM Subject: Antwort: Re: Antwort: Linux restore hangs in IdleW Hi Alexander, then your problem is a different one that I had. Sorry, Rainer Alexander Verkooijen An: [EMAIL PROTECTED] [EMAIL PROTECTED] Kopie: NL Thema: Re: Antwort: Linux restore hangs in IdleW Gesendet von: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 17.08.2004 11:53 Bitte antworten an ADSM: Dist Stor Manager Hello Rainer, The value for sack is 0 Regards, Alexander On Tue, 17 Aug 2004 11:32:30 +0200 Rainer Holzinger [EMAIL PROTECTED] wrote: Hi Alexander, I had a similar problem. Could you please try on your AIX system where the ITSM sever is running the command 'no -a | grep sack'? What's the setting for sack? regards, Rainer Alexander Verkooijen An: [EMAIL PROTECTED] [EMAIL PROTECTED] Kopie: NL Thema: Linux restore hangs in IdleW Gesendet von: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 17.08.2004 11:23 Bitte antworten an ADSM: Dist Stor Manager Hello, (Searched the list archives and mr. Sim's page, even read the manual) We are seeing weird behaviour of the 5.2.3.1 client on several Red Hat 7.3 systems. (yes, we know 7.3 is very old but we can't upgrade for political reasons). When we try to restore a file that resides on a tape that is not mounted in a drive the server starts to mount the tape. The restore session goes into MediaWait. The client reports that it is waiting for a media mount. After a minute or so the tape is mounted and the session goes into Run. This lasts for about another minute. I guess the tape is being positioned. Q ses doesn't show any data going to the client. The the session goes to IdleW and stays that way. The status of the tape is IN USE until after 13 minutes the session dismounts the tape and immediately terminates itself (connection severed). Our CommTimeOut is 15 minutes btw. At this point the client still reports it is waiting for a mediamount until. Of course no data has been restored. We have seen client hang for hours like this until we killed them manually. Because of the old RedHat level we can't go to IBM for support and we can't reproduce this problem on other systems with more up-to-date OS levels. And no, we really can't upgrade these systems. This is clearly some kind of timing problem because when the tape is in a drive (in IDLE state) before the restore is started or when the data is on a disk volume instead of a tape the restore completes without any problem. It looks like the 60 second wait for the mount is causing this behaviour. Has anybody seens this before? (5.2.3.0 server on AIX 5.2, 3494 library with 3590E drives) Thanks, Alexander -- Met vriendelijke groet, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
search.adsm.org down ?
Hi all, search.adsm.org seems to be down. I tried the search engine at vm.marist.edu but it is rather slow, so it would be nice if search.adsm.org was up again. Does anybody know who manages this site? Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: search.adsm.org down ?
ADSM QuickFacts lists another log archive site you can use: http://www.mail-archive.com/[EMAIL PROTECTED]/ Thanks! That one works fine. I should have checked your QuickFacts before posting, I know Alexander
Re: stopping active backup sessions at a specified time
Here is a perl script that cancels sessions of specific nodes. You'll have to replace NODE1, NODE2 with your own node names, bla/blah with the correct admin id/password and if you're not on AIX you'll probably have to supply another path to the dsmadmc binary. Use this at your own risk!!! I have not fully tested it and I can't garantuee that it will work correctly in all circumstances. Regards, Alexander SCRIPT #!/usr/bin/perl @lines=(); @nodes=(NODE1,NODE2); for($nodecnt=0;$nodecnt=$#nodes;$nodecnt++){ $tsmcmd=/usr/bin/dsmadmc -id=blah -pa='blah' -dataonly=yes; $tsmcmd=$tsmcmd.' select session_id from sessions'; $tsmcmd=$tsmcmd. where client_name='; [EMAIL PROTECTED]; $tsmcmd=$tsmcmd.'; $tsmcmd=$tsmcmd.' |'; open(TSM,$tsmcmd); @lines=TSM; close TSM; for($linecnt=0;$linecnt=$#lines;$linecnt++){ if(@lines[$linecnt] =~ /^ +[0-9]*/ ){ [EMAIL PROTECTED]; chop $session; $cancelcmd=/usr/bin/dsmadmc -id=blah -pa='blah' ; $cancelcmd=$cancelcmd.'cancel ses '.$session.''; system($cancelcmd); } } } /SCRIPT -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Karla Ross Sent: dinsdag 15 juni 2004 22:01 To: [EMAIL PROTECTED] Subject: stopping active backup sessions at a specified time We have several applications that due to some performance issues have there backups running longer than normal on some nights. Does anyone have a good automated method to monitor backup sessions for a client and either stop them at a given time if they are still running or notify someone that they are still running? Karla Ross
Re: Querying What tapes you need for a restore?
Gerald, I recommend reading Richard Sim's Quick Facts on this subject. Point your browser at http://people.bu.edu/rbs/ADSM.QuickFacts and search for Restoral preview 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 Gerald Wichmann Sent: donderdag 19 februari 2004 23:27 To: [EMAIL PROTECTED] Subject: Querying What tapes you need for a restore? Is there a way to query a list of tapes needed for a given restore prior to doing the restore such that you can ensure all those tapes are in your library prior to kicking off the restore? I think the normal mode of operation is if you were to do a restore that involved several tapes and some tapes were in your library and some were not, it would move along fine with those tapes it has but the restore would halt and issue a mount request for those that aren't in the library. I'd like to avoid that mount request and just ensure all the tapes are in the library beforehand. Gerald This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the 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 telephone or directly reply to the original message(s) sent. Thank you.
Re: Client option syntax error
Douglas, Try dsmadmc -id=admin -password= 'def cliento winxpadm inclexcl exclude *:\...\* force=no' 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 Douglas Currell Sent: vrijdag 6 februari 2004 13:52 To: [EMAIL PROTECTED] Subject: Client option syntax error What is wromg with this scenario? In batch mode, when I enter: def cliento winxpadm inclexcl exclude *:\...\* force=no I get: ANR2050I DEFINE CLIENTOPT: Option INCLEXCL defined in optionset WINXPADM. When I use, from the unix prompt, dsmadmc -id=admin -password= def cliento winxpadm inclexcl exclude *:\...\* force=no I get ANR2023E DEFINE CLIENTOPT: Extraneous parameter - *:\...\*. Any ideas? My objective is to make a cloptset script unless someone knows of any other way to create multiple copies of a cloptset without as little keyboard/mouse work as possible...Thank you - Post your free ad now! Yahoo! Canada Personals
Re: Message number 2997 not available for language EN_US
ANR2997 seems to exist: blahhelp ANR2997 --- ANR2997W The server log is log full percentage percent full. The server will delay transactions by delay time milliseconds. Explanation: The server log utilization is dangerously high. In order to prevent the server log from becoming exhausted, the server will begin delaying transactions by the specified amount of time. User Response: Monitor server activity and log usage. If possible, delay adding new work to the server load. blahelp ANS2997 ANR2307E No help text could be found for this message: ANS2997. ANS8001I Return code 11. 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 Loon, E.J. van - SPLXM Sent: vrijdag 30 januari 2004 13:31 To: [EMAIL PROTECTED] Subject: Message number 2997 not available for language EN_US Hi *SM-ers! I encountered the message Message number 2997 not available for language EN_US in my actlog several times. Indeed the ANR2997 nor ANS2997 can be found in the Messages manual. Does anybody know hat it means? Thanks 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. **
Re: Another question about script
Hi Robert, Try the -quiet option of the dsmadmc command. It supresses the ANR2034E and the ANS8001I messages. Kind 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 Robert Ouzen Sent: dinsdag 20 januari 2004 9:36 To: [EMAIL PROTECTED] Subject: Another question about script Hi to all Did is a way to get nothing in the output from a script if is no data , I mean I used the options: -dataonly=yes and -itemcommit and it work fine but when my select as no output at all I got the line: ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. I need to use a clean output to run on it statistics . T.I.A Regards Robert Ouzen E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Another question about script
Oooops, you're absolutely right. I only tested it with a query that didn't produce output and not with one that did. Sorry about that. You may consider using OS commands to filter out the unwanted messages like grep -v on UNIX. 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 Robert Ouzen Sent: dinsdag 20 januari 2004 14:47 To: [EMAIL PROTECTED] Subject: Re: Another question about script Hi Alexander The option -quiet work to well Now I got in my output nothing it's suppress everything. My batch file look like: dsmadmc -id=robert -pass=x -tcpserveraddress=adsmnew.haifa.ac.il -itemcommit -quiet -dataonly=yes macro stat_unix.adsm c:\blat\stat_unix.txt My output was empty , without-quiet I got information with the ANR2034E and ANS8991I messages. Thanks Alexander maybe another option parameter Regards Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Verkooijen Sent: Tuesday, January 20, 2004 3:23 PM To: [EMAIL PROTECTED] Subject: Re: Another question about script Hi Robert, Try the -quiet option of the dsmadmc command. It supresses the ANR2034E and the ANS8001I messages. Kind 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 Robert Ouzen Sent: dinsdag 20 januari 2004 9:36 To: [EMAIL PROTECTED] Subject: Another question about script Hi to all Did is a way to get nothing in the output from a script if is no data , I mean I used the options: -dataonly=yes and -itemcommit and it work fine but when my select as no output at all I got the line: ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. I need to use a clean output to run on it statistics . T.I.A Regards Robert Ouzen E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Clean macro output
Hi, Did you try the -dataonly option? For example: dsmadmc -id=X -pa=X -dataonly=yes macro mymacro 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 Robert Ouzen Sent: dinsdag 13 januari 2004 9:59 To: [EMAIL PROTECTED] Subject: Clean macro output Hi To All Did is a way to get a clean output from a macro just the result for further programming (want just the data ) I think I saw once an answer about this. When running my macro I got in the output my select command and dash: ANS8000I Server command: 'select entity as , cast(sum(bytes/1024/1024) as decimal(10,3)) as , substr(cast(min(start_time) as char(26)),1,19) as , cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) asfrom summary where date(Start_time)=current date - 1 days and time(start_time)'18:00:00' and activity='BACKUP' group by entity' -- -- EXCHANGE1 57767.095 2004-01-12 22:07:18 01:37:19 HIGHLEARN2K2750.848 2004-01-12 22:30:05 00:13:38 My TSM server version is 5.1.8 on Windows. Regards Robert Ouzen E-mail: [EMAIL PROTECTED]
Re: Export / Import
I'm not sure but since the physical space occupied decreases could it be that the export/import process reconstruct the aggregates and thus removes any 'holes' you may have had in your aggregates on the OS/390 server? 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 Brian L. Nick Sent: maandag 12 januari 2004 16:05 To: [EMAIL PROTECTED] Subject: Export / Import Good morning everyone, We are in the process of migrating from TSM 4.2.1.9 running on OS/390 2.10 to TSM 5.2 on AIX 5.1. Due to incompatible media we are using the server to server export import process to move node data, however I am seeing discrepancies in the amounts of data to move. Here is an example from a 'Q OCC command: q occ PHLHR (os/390 2.10 TSM 4.2 ) Node Name Type FilespaceFSID Storage Number of Physical Logical Name Pool Name Files Space Space Occupied Occupied (MB) (MB) -- -- - -- - - - PHLHR Bkup \\phlhr\c$ 1 OFFSITE_- 14,214 1,950.01 1,870.58 STK9840 PHLHR Bkup \\phlhr\c$ 1 STD_BACK- 928 2.06 1.90 UP_DIRE- CTORIES PHLHR Bkup \\phlhr\c$ 1 STD_BACK- 13,286 1,949.20 1,869.93 UP_STK9- 840 PHLHR Bkup \\phlhr\d$ 2 OFFSITE_- 25,447 35,257.46 35,020.67 STK9840 PHLHR Bkup \\phlhr\d$ 2 STD_BACK- 336 0.82 0.77 UP_DIRE- CTORIES PHLHR Bkup \\phlhr\d$ 2 STD_BACK- 25,111 35,257.18 35,020.44 UP_STK9- 840 q occ (AIX 5.1 TSM 5.2) Node Name Type FilespaceFSID Storage P Number of Physical Logical Name ool NameFiles Space O Space Oc ccupied cupied ( (MB) MB) -- -- - -- - - - PHLHR Bkup \\phlhr\c$ 1 PRODCSP11,810 1,144.67 1,144.66 PHLHR Bkup \\phlhr\c$ 1 PRODOCP11,810 1,144.67 1,144.66 PHLHR Bkup \\phlhr\d$ 2 PRODCSP15,472 4,738.94 4,738.92 PHLHR Bkup \\phlhr\d$ 2 PRODOCP15,472 4,738.94 4,738.92 Is there a known issue with exporting data from 4.2 to 5.2? Any help is greatly appreciated. Thanks, Brian Brian L. Nick Systems Technician - Enterprise Storage Solutions The Phoenix Companies Inc. 100 Bright Meadow Blvd Enfield CT. 06082-1900 E-MAIL: [EMAIL PROTECTED] PHONE: (860)403-2281 ** * CONFIDENTIAL: This communication, including attachments, is intended only for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, you are hereby notified that you have received this document in error, and any use, review, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy any and all copies of this communication. ** *
Re: Export / Import
You're right, I hadn't noticed that. The number of files should have been the same. 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 Brian L. Nick Sent: maandag 12 januari 2004 16:35 To: [EMAIL PROTECTED] Subject: Re: Export / Import That was my original assumption but if you look at the 'q occ' results there is a discrepancy in the number of files as well. That is my main concern. Thanks, Brian Alexander Verkooijen To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: L Subject: Re: Export / Import Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 01/12/2004 10:30 AM Please respond to ADSM: Dist Stor Manager I'm not sure but since the physical space occupied decreases could it be that the export/import process reconstruct the aggregates and thus removes any 'holes' you may have had in your aggregates on the OS/390 server? 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 Brian L. Nick Sent: maandag 12 januari 2004 16:05 To: [EMAIL PROTECTED] Subject: Export / Import Good morning everyone, We are in the process of migrating from TSM 4.2.1.9 running on OS/390 2.10 to TSM 5.2 on AIX 5.1. Due to incompatible media we are using the server to server export import process to move node data, however I am seeing discrepancies in the amounts of data to move. Here is an example from a 'Q OCC command: q occ PHLHR (os/390 2.10 TSM 4.2 ) Node Name Type FilespaceFSID Storage Number of Physical Logical Name Pool Name Files Space Space Occupied Occupied (MB) (MB) -- -- - -- - - - PHLHR Bkup \\phlhr\c$ 1 OFFSITE_- 14,214 1,950.01 1,870.58 STK9840 PHLHR Bkup \\phlhr\c$ 1 STD_BACK- 928 2.06 1.90 UP_DIRE- CTORIES PHLHR Bkup \\phlhr\c$ 1 STD_BACK- 13,286 1,949.20 1,869.93 UP_STK9- 840 PHLHR Bkup \\phlhr\d$ 2 OFFSITE_- 25,447 35,257.46 35,020.67 STK9840 PHLHR Bkup \\phlhr\d$ 2 STD_BACK- 336 0.82 0.77 UP_DIRE- CTORIES PHLHR Bkup \\phlhr\d$ 2 STD_BACK- 25,111 35,257.18 35,020.44 UP_STK9- 840 q occ (AIX 5.1 TSM 5.2) Node Name Type FilespaceFSID Storage P Number of Physical Logical Name ool NameFiles Space O Space Oc ccupied cupied ( (MB) MB) -- -- - -- - - - PHLHR Bkup \\phlhr\c$ 1 PRODCSP11,810 1,144.67 1,144.66 PHLHR Bkup \\phlhr\c$ 1 PRODOCP11,810 1,144.67 1,144.66 PHLHR Bkup \\phlhr\d$ 2 PRODCSP15,472 4,738.94 4,738.92 PHLHR Bkup \\phlhr\d$ 2 PRODOCP15,472 4,738.94 4,738.92 Is there a known issue with exporting data from 4.2 to 5.2? Any help is greatly appreciated. Thanks, Brian Brian L. Nick Systems Technician - Enterprise Storage Solutions The Phoenix Companies Inc. 100 Bright Meadow Blvd Enfield CT. 06082-1900 E-MAIL: [EMAIL PROTECTED] PHONE: (860)403-2281 ** * CONFIDENTIAL: This communication, including attachments, is intended only
Re: last backup info
Have you tried the 'query occupancy' command to see if there is actual data stored for this node on the server? Kind 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 Gill, Geoffrey L. Sent: maandag 1 december 2003 16:55 To: [EMAIL PROTECTED] Subject: last backup info Can anyone explain why the last backup start date/time, last backup completion date/time, and deletion occurred in filespace date/time would have no information in them for filespaces reported on some nodes? The capacity and percent util register data. Yesterday we had a SAN controller firmware upgrade and it seems one of the nodes on the SAN lost the data and a recovery is necessary. I'm not the one restoring the data nor do I have access to the node. I'm just looking from the TSM server side to see what is hopefully in TSM. I don't want to say I have a bad feeling something hasn't been backed up but I do want to have an educated answer if in fact there is no data. I understand the inclexcl list tells TSM what to back up, and I have no control of it. I have not asked to see this one yet but have a feeling I might need to. This particular node reports it is at 5.1.5.0, it is on Tru64 platform. The server is on AIX 4.3.3, TSM 5.1.6.3. I see this same phenomenon for other filespaces on other nodes, although it has never struck me to ask why it is blank. Thanks for the help, Node Name CP-ITS-DWPROD Filespace Name /san2 FSID 49 Filespace Type ADVFS Capacity (MB) 416687.2 Pct Util 1.3 Last Backup Start Date/Time - Last Backup Completion Date/Time - Deletion occurred in Filespace Date/Time - Is Filespace Unicode? NO Hexadecimal Filespace Name - Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: Tape Volumes Needed for a Restore
According to Richard Sims wonderful Quick Facts page there is no preview option for the restore command. Go to http://people.bu.edu/rbs/ADSM.QuickFacts and search for Restoral preview All credit goes to mr. Sims. Kind 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 Gerald Wichmann Sent: maandag 1 december 2003 23:04 To: [EMAIL PROTECTED] Subject: Tape Volumes Needed for a Restore If I load the TSM GUI and select a few directories to restore, is there some way to determine which tapes will be required to satisfy that restore? A sort of preview=yes option for restores? Or how would you determine which tapes you need given a point in time restore of an entire server? Thanks, Gerald This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the 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 telephone or directly reply to the original message(s) sent. Thank you.
Hanging Windows clients
Hi all, One of our customers has a mix of Windows 2000 and Linux clients. The Windows clients run the scheduler service. The service on these clients has to be restarted every few days because the client hangs in the middle of a scheduled incremetal backup. The dsmsched.log gives no clue to what is wrong: 11/21/2003 02:24:51 Normal File--20,240 \\bla\c$\WINNT\VMMREG32.DLL [Sent] 11/21/2003 02:24:51 Normal File-- 256,192 \\bla\c$\WINNT\WINHELP.EXE [Sent] 11/21/2003 02:24:51 Normal File-- 269,584 \\bla\c$\WINNT\WINHLP32.EXE [Sent] 11/21/2003 02:24:51 Normal File-- 193,296 \\bla\c$\WINNT\WINREP.EXE [Sent] And then it stops. (The service is still running but it doesn't do anything until it is restarted) After an hour the session times out and the server terminates it. The activity log on the server also contains no messages about this client other than the time out message. The dsmerror.log contains no messages for the time period the client stopped backing up. Only the Windows clients have this problem, the Linux clients are unaffected. The clients are mainly 5.1.5.0 but I asked the customer to upgrade one of his clients to 5.2.0.6 He did, but this client shows the same behavior. The clients do not use the journal engine service or anti-virus software. Our server is at Version 5, Release 2, Level 1.2 on AIX 5.1 We have other customers running Windows clients, none of them has this problem. I'm probably going to call IBM support about this but I was wondering if anybody here has any idea what is going wrong. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Hanging Windows clients
Hi, Thanks for the suggestion. I will certainly try it as soon as I am certain that installing the latest client doesn't solve the problem. Yes, I know, in my original messsage I wrote that the 5.2.0.6 also hung during a backup but I just got a call from the customer. It turns out that he made a mistake and that his only 5.2.0.6 client doesn't have the problem (yet). Thanks again, 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 Thomas Rupp, Vorarlberger Illwerke AG Sent: donderdag 27 november 2003 14:27 To: [EMAIL PROTECTED] Subject: AW: Hanging Windows clients Hi, most of our scheduler problems went away when we moved to use DSMCAD to start the scheduler. Kind regards Thomas Rupp Vorarlberger Illwerke AG
Re: Hanging Windows clients
Thanks, upgrading might very well be the solution. Contrary to what I wrote in my original message the customer's only machine that is at the latest level doesn't have this problem. 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 Janice Lachapelle Sent: donderdag 27 november 2003 15:19 To: [EMAIL PROTECTED] Subject: Re: Hanging Windows clients We had the same problem here with the Windows Clients (5.1.0). There is a TSM client fix 5.1.6. that has been 100% successful with all of our servers. Alexander Verkooijen To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: L Subject: Hanging Windows clients Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 11/27/03 07:56 AM Please respond to ADSM: Dist Stor Manager Hi all, One of our customers has a mix of Windows 2000 and Linux clients. The Windows clients run the scheduler service. The service on these clients has to be restarted every few days because the client hangs in the middle of a scheduled incremetal backup. The dsmsched.log gives no clue to what is wrong: 11/21/2003 02:24:51 Normal File--20,240 \\bla\c$\WINNT\VMMREG32.DLL [Sent] 11/21/2003 02:24:51 Normal File-- 256,192 \\bla\c$\WINNT\WINHELP.EXE [Sent] 11/21/2003 02:24:51 Normal File-- 269,584 \\bla\c$\WINNT\WINHLP32.EXE [Sent] 11/21/2003 02:24:51 Normal File-- 193,296 \\bla\c$\WINNT\WINREP.EXE [Sent] And then it stops. (The service is still running but it doesn't do anything until it is restarted) After an hour the session times out and the server terminates it. The activity log on the server also contains no messages about this client other than the time out message. The dsmerror.log contains no messages for the time period the client stopped backing up. Only the Windows clients have this problem, the Linux clients are unaffected. The clients are mainly 5.1.5.0 but I asked the customer to upgrade one of his clients to 5.2.0.6 He did, but this client shows the same behavior. The clients do not use the journal engine service or anti-virus software. Our server is at Version 5, Release 2, Level 1.2 on AIX 5.1 We have other customers running Windows clients, none of them has this problem. I'm probably going to call IBM support about this but I was wondering if anybody here has any idea what is going wrong. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services Disclaimer Notice: If you are not the intended recipient of this transmission, you are hereby notified that any disclosure or other action taken in reliance on its contents is strictly prohibited. Please delete the information from your system and notify the sender immediately. We have taken precautions against viruses, but take no responsibility for loss or damage
Re: server out of data storage space
Jack, Do you have client side compression switched on on these clients? We sometimes get this message when compression is on but compressalways is yes (default). What happens is that a file grows during compression and doesn't fit in the space the server has reserved for it. Best reagards, 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 Coats, Jack Sent: dinsdag 7 oktober 2003 15:36 To: [EMAIL PROTECTED] Subject: server out of data storage space TSM server 4.2.3.1 on Win2K I get this message on some of my clients. I have plenty of scratches, and the storage pools are set to allow 'plenty' of time for data migration before the pool gets full. Where should I look for clues or what are some hints to set things up 'right'? My disk storage pools are: Storage Device Estimated Pct Pct High Low Next Pool Name Class Name CapacityUtilMigr Mig Mig Storage (MB) Pct Pct Pool --- -- -- - - --- --- API_DISKDISK40,000.083.90.0 50 5 TAPEDATA ARCHIVE LTOCLASS1 0.0 0.0 0.0 90 70 ARCHIVECOP- LTOCLASS1 0.0 0.0 YPOOL ARCHIVEPOOL DISK100.0 0.0 0.0 50 10 ARCHIVE COPYPOOLLTOCLASS1 17,171,523 22.7 .5 DISKDATADISK200,000.0 99.80.0 20 3 TAPEDATA DISKDIRSDISK2,048.0 4.7 0.0 90 5 TAPEDATA RECLAIM RECLAIM 0.0 0.0 0.0 0 0 TAPEDATA SPACEMGPOOL DISK0.0 0.0 0.0 90 70 TAPEDATA TAPEDATALTOCLASS1 12,807,596 30.548.0 100 0 .6 Where diskdata and diskdirs are my primary disk pools, tapedata is the onsite tape pool, and copypool is the offsite tape pool. TIA .. JC
Re: empting a read only tape.
We have read-only tapes going to pending and then scratch all the time. So I guess the answer to your question is Yes. 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 Bill Fitzgerald Sent: vrijdag 3 oktober 2003 18:51 To: [EMAIL PROTECTED] Subject: empting a read only tape. Does anyone know if a tape in read only status becomes a scratch tape when it is emptied by expiration or reclamation? William Fitzgerald Software Programmer Munson Medical Center [EMAIL PROTECTED]
Re: Tsm server thinks no drives available, there are
(5.1.6.4 on AIX 4.3.3, 3494 library with 3590's) I had exactly the same problem yesterday afternoon. I couldn't figure out what was wrong so I halted and restarted the TSM server. (The software, not the machine itself) Somehow it made the problem go away. 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 Lee, Gary D. Sent: woensdag 17 september 2003 19:22 To: [EMAIL PROTECTED] Subject: Tsm server thinks no drives available, there are Tsm server v5.1.6.2, running on Sun e3500 under solaris 2.8. Library is ibm 3494 ethernet ethernet connected. Drives are four 3590b. Many times this week during offsite reclamation, the process will end with the message anr8447e no drives are available in library atoz. Checking the activity log, there are nvever more than three drives in use, and q path and q drive shows all paths on-line, and all drives available. Stgpools offsite and bigtape, (onsite pool) are assigned to devclass 3590 which has a mountlimit of four. I'm confused. It looks like tsm doesn't see available drives all the time. Any idea where to start looking? TIA for the help. Gary Lee Senior Operating Systems Analyst Ball State University phone 765-285-1310 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 9/11/03
Re: Suppress header and footer lines of select statements
Hi, The 5.2 admin client has a new option: -dataonly=yes I think it does what you are looking for. There is an article from Andy Raibeck describing this option in the list archive: http://msgs.adsm.org/cgi-bin/get/adsm0307/149.html Kind 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 Bernd Schemmer Sent: woensdag 17 september 2003 1:12 To: [EMAIL PROTECTED] Subject: Suppress header and footer lines of select statements Hi, thanks to all that replied to my question regarding compression - the cause of the problem was the double-compression by TSM and the drive. Now I've another question: I'm writing some scripts using dsmadmc with the select command to retrieve data from the TSM database. At this time I've to use various grep commands to remove the headers and footers from the dsmadmc output. Is it possible to suppress those headers footers and get only the data returned by the select command? I did not find an option for this in the manuals. Thanks again Bernd
Select on contact field doesn't find results
Hello all, (I've searched the list archive and the server readme's to see if this a known problem but I can't find anything) Does anybody understand why the second select doesn't find the node BLAAT2 ? I must be missing something, but I've been staring at this for quite some time and I can't see what I'm doing wrong. tsm: XXselect node_name,contact from nodes where node_name like 'BLAAT%' NODE_NAME CONTACT -- -- BLAAT1 Alexander BLAAT2 tsm: XXselect node_name,contact from nodes where node_name like 'BLAAT%' \ cont and contact not like 'Alex%' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Select on contact field doesn't find results
Andy, Thanks for the explanation. I was totally unaware of this behaviour and I assumed that it was sufficient to test for the string. Thanks again. Kind regards, Alexander - Original Message - From: Andrew Raibeck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 5:04 PM Subject: Re: Select on contact field doesn't find results Yes, this is correct SQL behavior. If you examine the COLUMNS table for this column, you will see that the CONTACT field supports null values: tsm: STORMANselect * from columns where tabname='NODES' and colname='CONTACT' TABSCHEMA: ADSM TABNAME: NODES COLNAME: CONTACT COLNO: 6 INDEX_KEYSEQ: INDEX_ORDER: TYPENAME: VARCHAR LENGTH: 255 SCALE: 0 NULLS: TRUE REMARKS: Contact tsm: STORMAN It is important to note that nulls do NOT represent zero or empty strings; rather, they represent unknown data. Because the data is unknown, a comparison involving a null column evaluates to an unknown condition, which is treated as false. Thus the comparison of a null contact field to 'Alex%' results in unknown, so no rows are returned. To test for null columns, use the is null or is not null operators, like this: tsm: STORMANselect node_name,contact from nodes where node_name like 'BLAAT%' and (contact not like 'Alex%' or contact is null) NODE_NAME CONTACT -- -- BLAAT2 tsm: STORMAN 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. Alexander Verkooijen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/02/2003 05:35 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Select on contact field doesn't find results Hello all, (I've searched the list archive and the server readme's to see if this a known problem but I can't find anything) Does anybody understand why the second select doesn't find the node BLAAT2 ? I must be missing something, but I've been staring at this for quite some time and I can't see what I'm doing wrong. tsm: XXselect node_name,contact from nodes where node_name like 'BLAAT%' NODE_NAME CONTACT -- -- BLAAT1 Alexander BLAAT2 tsm: XXselect node_name,contact from nodes where node_name like 'BLAAT%' \ cont and contact not like 'Alex%' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services
Re: Bug in Win32 TSM 5.2.0.2?
Does anyone know if there is an APAR for this problem? I can't find one in the APAR database and 5.2.0.2 seems to be the latest patch level for Windows. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: Kenneth Susan Bury [mailto:[EMAIL PROTECTED] Sent: zondag 24 augustus 2003 12:31 To: [EMAIL PROTECTED] Subject: Re: Bug in Win32 TSM 5.2.0.2? We have also noticed that the MSSQL TDP stops working and complains about the API after 5.2.02 is installed. Ken -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christian Svensson Sent: Friday, August 22, 2003 10:00 To: [EMAIL PROTECTED] Subject: Bug in Win32 TSM 5.2.0.2? Hi *SMers! As many know I work for a company who made a 3rd part BMR software for TSM. And I was certify TSM 5.2.0.2 for our software today. But I got some problem with our software together with TSM 5.2.0.2. And after some debuging was we found some missing information in the registry under HKEY_LOCAL_MACHINE\Software\IBM\ADSM\CurrentVersion. There was no path data in there. Also when I look in to the API directory the Path data was only API. But when I look under BaClient directory in the registry I can found the all path. So way is the full path missing under CurrentVersion and API? Is this a bug in 5.2.0.2 installation process? Best Regard / Med vänlig hälsning Christian Svensson Tivoli Storage Manager Certified .. .. Cristie Nordic AB Box 2Phone : +46-(0)8-718 43 30 SE-131 06 Nacka Mobil : +46-(0)70-325 15 77 Sweden eMail : [EMAIL PROTECTED] Visit : Gamla Värmdövägen 4, Plan 2 web : www.cristie.com http://www.cristie.com/ .. ..
Re: Bug in Win32 TSM 5.2.0.2?
OK, thanks for the answer. For the time being I have asked our MSSQL and Exchange admins not to upgrade their TSM clients. Best regards, Alexander -Original Message- From: Christian Svensson [mailto:[EMAIL PROTECTED] Sent: donderdag 28 augustus 2003 14:50 To: [EMAIL PROTECTED] Subject: SV: Bug in Win32 TSM 5.2.0.2? Hi Alexander! I have only talk to our development team in UK. And they are going to talk to TSM Development team in US. And I have also talk to IBM i Norway. And one guy there is also going to talk to there Development team in US. So I hope someone reports in to IBM. /Christian -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Alexander Verkooijen Skickat: den 28 augusti 2003 14:27 Till: [EMAIL PROTECTED] Ämne: Re: Bug in Win32 TSM 5.2.0.2? Does anyone know if there is an APAR for this problem? I can't find one in the APAR database and 5.2.0.2 seems to be the latest patch level for Windows. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: Kenneth Susan Bury [mailto:[EMAIL PROTECTED] Sent: zondag 24 augustus 2003 12:31 To: [EMAIL PROTECTED] Subject: Re: Bug in Win32 TSM 5.2.0.2? We have also noticed that the MSSQL TDP stops working and complains about the API after 5.2.02 is installed. Ken -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christian Svensson Sent: Friday, August 22, 2003 10:00 To: [EMAIL PROTECTED] Subject: Bug in Win32 TSM 5.2.0.2? Hi *SMers! As many know I work for a company who made a 3rd part BMR software for TSM. And I was certify TSM 5.2.0.2 for our software today. But I got some problem with our software together with TSM 5.2.0.2. And after some debuging was we found some missing information in the registry under HKEY_LOCAL_MACHINE\Software\IBM\ADSM\CurrentVersion. There was no path data in there. Also when I look in to the API directory the Path data was only API. But when I look under BaClient directory in the registry I can found the all path. So way is the full path missing under CurrentVersion and API? Is this a bug in 5.2.0.2 installation process? Best Regard / Med vänlig hälsning Christian Svensson Tivoli Storage Manager Certified .. .. Cristie Nordic AB Box 2Phone : +46-(0)8-718 43 30 SE-131 06 Nacka Mobil : +46-(0)70-325 15 77 Sweden eMail : [EMAIL PROTECTED] Visit : Gamla Värmdövägen 4, Plan 2 web : www.cristie.com http://www.cristie.com/ .. ..
Re: Bug in Win32 TSM 5.2.0.2?
Thanks Andy! Regards, Alexander - Original Message - From: Andrew Raibeck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 5:30 PM Subject: Re: Bug in Win32 TSM 5.2.0.2? No APAR yet, but we are looking at this. 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. Alexander Verkooijen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 08/28/2003 05:26 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Bug in Win32 TSM 5.2.0.2? Does anyone know if there is an APAR for this problem? I can't find one in the APAR database and 5.2.0.2 seems to be the latest patch level for Windows. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: Kenneth Susan Bury [mailto:[EMAIL PROTECTED] Sent: zondag 24 augustus 2003 12:31 To: [EMAIL PROTECTED] Subject: Re: Bug in Win32 TSM 5.2.0.2? We have also noticed that the MSSQL TDP stops working and complains about the API after 5.2.02 is installed. Ken -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christian Svensson Sent: Friday, August 22, 2003 10:00 To: [EMAIL PROTECTED] Subject: Bug in Win32 TSM 5.2.0.2? Hi *SMers! As many know I work for a company who made a 3rd part BMR software for TSM. And I was certify TSM 5.2.0.2 for our software today. But I got some problem with our software together with TSM 5.2.0.2. And after some debuging was we found some missing information in the registry under HKEY_LOCAL_MACHINE\Software\IBM\ADSM\CurrentVersion. There was no path data in there. Also when I look in to the API directory the Path data was only API. But when I look under BaClient directory in the registry I can found the all path. So way is the full path missing under CurrentVersion and API? Is this a bug in 5.2.0.2 installation process? Best Regard / Med vänlig hälsning Christian Svensson Tivoli Storage Manager Certified .. .. Cristie Nordic AB Box 2Phone : +46-(0)8-718 43 30 SE-131 06 Nacka Mobil : +46-(0)70-325 15 77 Sweden eMail : [EMAIL PROTECTED] Visit : Gamla Värmdövägen 4, Plan 2 web : www.cristie.com http://www.cristie.com/ .. ..
Re: Polling or prompted?
-Original Message- From: Tim Smith [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juli 2003 13:32 To: [EMAIL PROTECTED] Subject: Polling or prompted? Hi Just wanted to check... I guess the best way of being sure that a schedule runs within a certain time window is to set the duration on the server and have the client set to prompted. Is there any way to do this with the polling method? Or if I use polling, does the client simply contact the server every XX hours? In polling mode the client contacts the server every X number of hours to get the start of it's backup window. You can define X with the QUERYSCHedperiod parameter in dsm.sys. Regards, Alexander
[no subject]
Michelle, Maybe I'm missing something, but according to the manual a backupset only contains the active data of a node: (From help generate backupset) The server creates copies of active versions of a client's backed up objects that are within the one or more file spaces specified with this command, and consolidates them onto sequential media. (end quote) So if you know how much data resides on the disks of your node and you know the capacity of your tapes you should be able to determine how many tapes you need. Somebody please correct me if I'm wrong. Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing Networking Services -Original Message- From: Michelle Wiedeman [mailto:[EMAIL PROTECTED] Sent: donderdag 3 april 2003 13:43 To: [EMAIL PROTECTED] Subject: Hi all, A costumer of us requires a backupset they which to sent to their disaster recovery location. I want to determine how many tapes I'll need for this operation how can I determine the size of a potential backupset ? is there an option which only shows the output but does not actually create backupsets? thnx! michelle Plaats hier een Engelse quote die duidelijk maakt dat je een miskende intellectueel bent met een boeiende en diepgaande gedachtengang
Re: Events table
You might want to read this article on this subject: http://msgs.adsm.org/cgi-bin/get/adsm0111/816.html -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 maart 2003 14:03 To: [EMAIL PROTECTED] Subject: Events table If I do a SELECT * FROM EVENTS I only get events for the current day. Are the events from previous days (like those available from q event * * begind=-1) available in another table? David
Re: Where are the manuals today?
On Thu, 20 Feb 2003 14:52:17 -0500 David E Ehresman [EMAIL PROTECTED] wrote: http://publib.boulder.ibm.com/tividd/td/StorageManagerforAIX5.1.html does not work today to find the TSM Server 5.1 manuals. Where are we suppose to find them today? http://publib.boulder.ibm.com/tividd/td/tdprodlist.html#S Reagrds, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Password storage
On Mon, 10 Feb 2003 13:28:12 + [EMAIL PROTECTED] wrote: I understand that the TSM client on NT stores the password in the registry, when the autogenerate option is used. But can anyone tell me when the password is stored on an AIX client when the autogenerate option is used In /etc/security/adsm HTH, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Client doesn't ask for password when IP address changes?
Hello, I'm using TSM (5.1.1.0 client) on Windows XP (SP 1) to backup my PC at home. This weekend I switched from one ISP (cable) to another ISP (ADSL). This of course changed the IP address and hostname of my PC completely. The change of IP adress is clearly visible in the activity log on the server when I search for the Session started for node BLAHBLA message. When I started the backup client after the change it never asked me for the node's password, it just logged on to the server and allowed me to start a backup. I'm absolutely sure of this because I've forgotten the password so when it *had* asked me for I wouldn't have known it. I can't explain this behaviour. Shouldn't the client prompt for a password when I change to IP address or hostname? Our server is 4.2.3.2 (4.2.3.3 in a few hours) on AIX 4.3.3.0 Kind regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Client doesn't ask for password when IP address changes?
Hi, Our server doesn't allow open registration. My dsm.opt contains the nodename option and the nodename hasn't changed. So that must be why the client didn't ask for the password. I always thought that changing the IP address/hostname would cause the client to prompt for the password again regardless whether the nodename had changed or not. Thanks for explaining this to me. Best regards, Alexander If you had no nodename option in dsm.opt your hostname acts as nodename. Thus on hostname (not IP address) change you have to be authenticated as new node. If nodename option is defined it is used for password matching not the hostname. Either you have nodename option (and nodename/generated password pair is still valid) or your server is on open registration. Also you might changed you Internet address but your VPN address is the same. Please, please, do not tell me your TSM is open to Internet and your nodename/password is going without VPN! Zlatko Krastev IT Consultant Alexander Verkooijen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 27.01.2003 12:45 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Client doesn't ask for password when IP address changes? Hello, I'm using TSM (5.1.1.0 client) on Windows XP (SP 1) to backup my PC at home. This weekend I switched from one ISP (cable) to another ISP (ADSL). This of course changed the IP address and hostname of my PC completely. The change of IP adress is clearly visible in the activity log on the server when I search for the Session started for node BLAHBLA message. When I started the backup client after the change it never asked me for the node's password, it just logged on to the server and allowed me to start a backup. I'm absolutely sure of this because I've forgotten the password so when it *had* asked me for I wouldn't have known it. I can't explain this behaviour. Shouldn't the client prompt for a password when I change to IP address or hostname? Our server is 4.2.3.2 (4.2.3.3 in a few hours) on AIX 4.3.3.0 Kind regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: /VAR skipped during incremental
On Mon, 13 Jan 2003 15:36:06 +0100 Loon, E.J. van - SPLXM [EMAIL PROTECTED] wrote: Hi *SM-ers! I have got one TSM client (4.2.1.0) which skips /VAR during an incremental. dsmc i /var works fine, there are no errors in the dsmerror.log. Does anybody know what could be the cause of this? Thanks in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines You probably have already thought of this, but just to be sure: You haven't specified a domain in your dsm.sys ? Kind regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Where did the online manuals go?
Thanks to all who responded to my question. The manuals are back now. Apparently it was a temporary problem. Thanks again, Alexander On 12-Nov-02 bbullock wrote: Hmm, that link still works for me... http://www.tivoli.com/support/public/Prodman/public_manuals/td/TD_PROD_LIST. html Perhaps a hiccup in a proxy server or some other internet anomaly? Ben -Original Message- From: Alexander Verkooijen [mailto:alexander;sara.nl] Sent: Tuesday, November 12, 2002 8:40 AM To: [EMAIL PROTECTED] Subject: Where did the online manuals go? Hello, Does anybody know where the online manuals are? They used to be at http://www.tivoli.com/support/public/Prodman/public_manuals/td/TD_PROD_LIST. html #S but that link is dead now. There is a notice on the Tivoli site telling me that the manuals have been moved: http://www.tivoli.com/support/public/Prodman/public_manuals/info_center/redi rect _info.html And after a few seconds it re-directs me to the dead link above! I've tried the new (IBM) support site, but it seems that registration is required to access it. We used to give our customers the URL to the manuals so they could solve most of their own problems. Since we can't expect our customers to register on the IBM site our only alternative would be to maintain a repository of manuals on our own website. Keeping such a repository up to date would be very time consuming. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Where did the online manuals go?
Hello, Does anybody know where the online manuals are? They used to be at http://www.tivoli.com/support/public/Prodman/public_manuals/td/TD_PROD_LIST.html #S but that link is dead now. There is a notice on the Tivoli site telling me that the manuals have been moved: http://www.tivoli.com/support/public/Prodman/public_manuals/info_center/redirect _info.html And after a few seconds it re-directs me to the dead link above! I've tried the new (IBM) support site, but it seems that registration is required to access it. We used to give our customers the URL to the manuals so they could solve most of their own problems. Since we can't expect our customers to register on the IBM site our only alternative would be to maintain a repository of manuals on our own website. Keeping such a repository up to date would be very time consuming. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: restore to other server
True, as long as you don't try to restore data from a Windows server to a UNIX server or vice versa. Regards, Alexander On 29-Oct-02 PAC Brion Arnaud wrote: Hi Michelle, Just use normal command line with -virtualnodename=server_A. It should do the job ! Cheers. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Michelle Wiedeman [mailto:michelle.wiedeman;MULTRIX.COM] Sent: Tuesday, 29 October, 2002 16:18 To: [EMAIL PROTECTED] Subject: restore to other server Hi guru's if data was backupped on server A, is it possible to do a restore to server B? Ive searched the books, but they al speak of restoring to different directories and not servers or locations. If this is possible, how would this be done on the commandline interface (no X available) thnx! mi(c)helle --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: dsmc Manual
Have a look at the client manuals: http://www.tivoli.com/support/public/Prodman/public_manuals/td/StorageManagerCli ent5.1.html On 27-Sep-02 Tani wrote: Hi all, Can anybody tell me where is a manual of the dsmc and it's options? Thanks -- -- Estanislao Sanmartín Rejo [EMAIL PROTECTED] --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: 4.2.x selects from DRIVE table
Hi, I can reproduce this on our 4.2.2.10 (AIX) server. Hardly WAD or a new feature, I think you found a bug. Regards, Alexander On 19-Sep-02 Jolliff, Dale wrote: Something odd I noticed this morning about 4.2.x servers on AIX and Solaris - query drive f=d and select * from drives Displays values in the Device field, whereas a select device from drives displays a blank device field. This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX. I went back to an older server (3.x) on AIX, and a select device from drives shows the devices, as I expected. Anyone else able to reproduce this? Is this WAD or a new 'feature'? --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Select command to q client name and version
On 19-Sep-02 Karla Ross wrote: Does anyone have a select command that will show me the clients and what version of TSM they are running? My TSM servers are running TSM v4.1, 4.2, and 5.1. select node_name,client_version,client_release,client_sublevel from nodes --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Volumes inaccessible after upgrade
Hello, I've already submitted a PMR for this but I was curious if anyone has seen this before. On monday we upgraded our TSM server (AIX 4.3.3) to 4.2.2.10 and the TSM client (on the same system) to 4.2.2.7 Since that time we get bursts of these messages in our activity log: 09/13/02 12:08:05 ANR0406I Session 13735 started for node BASKET-C (AIX) (Tcp/Ip 127.0.0.1(62905)). 09/13/02 12:08:05 ANR0542W Retrieve or restore failed for session 13735 for node BASKET-C (AIX) - storage media inaccessible. 09/13/02 12:08:06 ANR0403I Session 13735 ended for node BASKET-C (AIX). The help text for ANR0542W suggests to vary an off-line volume on-line but we don't have any off-line volumes. Tivoli already suggested to look for unavailable volumes but we don't have those either. The work-around for this problem is to kill dsmrecalld and start it again. Sometimes the error message stays away for a whole day, sometimes for only a few minutes. If we don't kill and restart dsmrecalld the messages just keep coming at a speed of 16 per minute. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: How to list files backed up
On 30-Aug-02 Cahill, Ricky wrote: I must be missed something really obvious as all I want to do is list all the files that were backed up by a node in it's last backup, but can't seem to find any simple way to do this. If it is a scheduled backup you can check dsmsched.log on the client. If it is not, you'll have to redirect the output of the dsmc command to a file. Or you can try this on the server: select filespace_name,hl_name,ll_name - from backups - where node_name='MYNODE' - and days(current_date)-1 days(backup_date) You'll may have to change the '-1' in the last line if the interval between your backups is more than 1 day. This query can take a long time to complete depending on the number of files on the client. Hope this helps, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Cross platform restores?
On 30-Aug-02 Copper, Steve wrote: Quick question: Is it possible to do a cross platform restore? If so, how? AFAIK it isn't supported, but sometimes it works anyway. I've restored files between different UNIX flavours. I recently tried to restore Windows98 data to an AIX box but the GUI didn't even show the file list. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: 2 Questions
On 12-Aug-02 Copper, Steve wrote: I have 2 different problems that maybe someone can help with. Firstly when doing expiration I receive the following error message ANR0871E Cannot find file space name for node 86, file space 1073741823. I've seen this in 4.1.4 (on AIX 4.3.3) Tivoli support said it was a known problem and they advised us to install 4.1.4.1 That solved the problem. Secondly, I have a tape volume that will not be reclaimed. When I do a q vol command on it, it says that the pct utilised is 0.0. When I try and q the contents of the tape it says that there is nothing on the tape. However I can not reclaim it, delete it or move data (it says there is no data to move). When I start reclamation the activity log says that it will be reclaimed but then nothing ever happens with it. Have you tried an 'audit volume' on this tape? Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: TSM Macros
On 12-Aug-02 David E Ehresman wrote: I have a TSM macro that issued a BACKUP STG for each of my five storage pools. If a BACKUP STG command is issued by the macro for a storage pool that does not have any data, I get the message ANR2111W BACKUP STGPOOL: No data to process. AND THE REMAINING COMMANDS IN THE MACRO ARE NOT ISSUED. Is this a feature or a bug? The TSM server is TSM 5.1.1.0 running on AIX 5. The admin command line client is v 3.1.0.8. Hi, When you start dsmadmc with the -itemcommit option the macro will continue after the failed command. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: delete specific data.
Leijnse, Finn F SITI-ITDSES31 wrote: Someone has decided to archive 1.5 TB (oracle DB) to a management class with 5 years retention period. Some ** idea of a manager. What has happened is that that archive has abended halfway. Is there a way to delete that data? I have not got an idea of what TSM does with that failed archive. Is the archive visible in the retrieve window of the GUI? If not I would assume that the server has discarded the data. If it is visible there you can use the GUI to delete that specific archive. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Linux Backup
Crawford, Lindy wrote: Good Day, Please help me...How can I do a backup of say 2 filesystems (but you want to specify these two filesystems when you do the backup) on Linux from the dsmc command line What command can one use For an incremental backup use: dsmc incremental /filesystem1 /filesystem2 Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Canceling a reclamation process
I would set the Reclamation Threshold of the storage pool in question to 100%, halt the server and restart it again. Regards, Alexander Rick Harderwijk wrote: Hi *SM-collegues, Just before the weekend we had a hardware error on our library. The problem was fixed, the services restarted. Ofcourse, I need to do an audit on the library; however, there's a space reclamation process running, waiting for a tape to mount - which it can't mount because there's an audit to run first :). I tried to cancel the process, but nothing happens. How do I stop this process, because my backups won't run either Kind regards, Rick Harderwijk Systems Administrator Factotum Media BV Oosterengweg 44 1212 CN Hilversum P.O. Box 335 1200 AH Hilversum The Netherlands Tel: +31-35-6881166 Fax: +31-35-6881199 E: [EMAIL PROTECTED] -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: TSM 5.1 Mac OS X and encrption
Eliza Lau wrote: Does anyone know if the new Mac OS X client in TSM 5.1 supports encrption since it is UNIX based? It is not mentioned in the product announcement. I don't know anything about the OS X client, but the other UNIX clients do support encryption. Kind regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Sql problem
I tried the same thing on an Oracle database: select count(*) from sometable group by hour(sometimestampfield) I get an 'invalid column name' error. Functions that operate on fields that have a type other than 'timestamp' work as one would expect: select count(*) from sometable group by lower(somecharfield) I don't understand this either but it seems to be a general SQL restriction and not a problem with the TSM SQL interface. Alexander Steve Harris wrote: Hi All, I just realized I can use the summary table to get tape mount stats. However I can't get my sql to work I'm trying select hour(end_time) as Hour, count(*) from summary where activity= 'TAPE MOUNT' and date(end_time) = current date - 1 day group by hour(end_time) and TSM is complaining about the group by clause. ANR2904E Unexpected SQL key word token - 'HOUR'. | .V. nd date(end_time) =current date - 1 day group by hour(end_time) I've also tried 'group by 1' and 'group by Hour' but that doesn't work either. This is fairly standard SQL, anyone know what I'm doing wrong? Steve Harris AIX and TSM Administrator Queensland Health, Brisbane Australia ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. ** -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Many files updated every night
Hello, Server 4.2.1.8 on AIX 4.3.3 Client 4.2.1.0 on Linux86 Every night almost every file on the machine is updated according to TSM: 02/18/02 13:05:26 ANE4952I (Session: 8234, Node: SI_GIULIA) Total number of objects inspected: 24,410 02/18/02 13:05:26 ANE4954I (Session: 8234, Node: SI_GIULIA) Total number of objects backed up: 302 02/18/02 13:05:26 ANE4958I (Session: 8234, Node: SI_GIULIA) Total number of objects updated: 22,861 02/19/02 13:02:32 ANE4952I (Session: 10891, Node: SI_GIULIA) Total number of objects inspected: 24,392 02/19/02 13:02:32 ANE4954I (Session: 10891, Node: SI_GIULIA) Total number of objects backed up: 0 02/19/02 13:02:32 ANE4958I (Session: 10891, Node: SI_GIULIA) Total number of objects updated: 23,161 This is just a laptop and not much ever changes on it. Certainly no one is changing the permissions and/or ownership of 23,000 files every night. First I thought it was a bug in the Linux client, but we have more clients on this level and this is the only one that behaves like this. Has anyone seen this before? Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Missing filespace-TIMESTAMPs on nodes created in 2002
Peter Duempert wrote: 4. I'd like to know if any of You experienced that behaviour too, or could try to run the above sequence. I registered a WIN98 node, 4.2.1.0 client, 6 days ago. Our server is 4.2.1.8 on AIX 4.3.3, just like yours. I didn't see the behaviour you describe. Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Installing TSM 3.7 packaged Scripts
There is a file with useful scripts that can be installed: /usr/tivoli/tsm/server/webimages/scripts.smp (We're running a 4.2 server on AIX, maybe the file has a different location for 3.7) Regards, Alexander Tony Sinclair wrote: Some time back I took a TSM class and during this class it was mentioned that TSM had several canned scripts that can/could be installed on the server and used via the GUI TSM ADMIN interface. Does anyone have these scripts installed, and the main question is how can I Install them so I can start using them. I am currently running Storage Management Server for AIX-RS/6000 4.3 - Version 3, Release 7, Level 4.0 What I do remember about installing these scripts is that I need to be in the AIX file system/directory where the executable is located, then just execute it. So if anyone can help it would be greatly appreciated. Thanks Tony Sinclair [EMAIL PROTECTED] === IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: Version 4.2.1.7
Rafael Mendez wrote: Hi all, Does anyone have installed the 4.2.1.7 patch for TSM server? We are planning to install this patch but we want to know if the problems on 4.2.1.6 version are fixed. Yes, we installed 4.2.1.7 today and it fixed the license problem. Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Events table vs Query events
Hello, Is there anybody out there who can tell me why a 'select * from events' only gives me today's events and a 'q ev * * begind=-1' also gives me yesterday's events? Where does 'q ev' gets it's information? I can't find this particular problem in the list archive, but I feel I am overlooking something obvious. Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: AW: Events table vs Query events
Baines, Paul wrote: I asked this question in the past on the list, the answer was basically that the select for events doesn't function like a select, but just like a query. If you add dates in where clauses it works like a query event with dates. Not very chic. Thanks. Using a date in the where clause does work. This is a rather strange implementation of the select command... Thanks again, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Client doesn't discard file after a failed restore
Hello, (AIX 4.3.3, 4.2.0.0 client, 4.2.1.2 server) I just noticed something funny. I'm restoring several file systems from node A on node B. Node A has a unlimited maximum file size. Node B has a maximum file size of 1 GB. The file systems I'm restoring contain several files 1 GB When the client on node B tries to restore such a file it produces an error message: ANS4025E Error processing '/blah/blah/blah': file exceeds user or system file limit At this point I would expect the client to discard the part of the file it has already restored. But it doesn't! It just leaves the first 1 GB on the file on disk. So when I had adjusted the maximum file size on node B and did a new restore with the -replace and -ifnewer flags it skipped those incomplete files because they already existed. I had to go through the activity log to search for the ANS4025E's and manually restore every file 1 GB. I don't understand why the client doesn't discard incomplete files... Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: TSM 4.1.4 - getting maintenance
Tom Melton wrote: I am trying to get the latest TSM 4.1 maintenance, and the links on the Tivoli pages seem to not work. I tried a regular ftp session, and get disconnected whenever I attempt to access the /storage/tivoli-storage-management/maintenance/server/v4r1/AIX/LATEST/ directory. Can anyone get to the latest maintenance level for TSM 4.1? Yes, I can download it from the Tivoli pages. No problem here. Regards, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: AIX 4.2 client
Zoltan Forray/AC/VCU wrote: Can someone tell me what the *ABSOLUTE LATEST* version of the TSM (ADSM ?) client can be used on AIX 4.2 ? I think you need U468051 from http://www.tivoli.com/support/storage_mgr/tivolieoc.html#tadsmc Hope this helps, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: AIX 4.2 client
Remove the ADSM software from the client with smitty (save the dsm.opt and dsm.sys) and install U468051. Maybe you'll have to install a base-level client first, I don't know. Alexander - Original Message - From: Zoltan Forray/AC/VCU [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:18 PM Subject: Re: AIX 4.2 client Thanks. That is pretty much what I thought. Problem is, how do I determine if the 3.1.0.8 client on the AIX system is at PTF U468051 ? That info does not appear in the logs ! === Zoltan Forray Virginia Commonwealth University University Computing Center e-mail: [EMAIL PROTECTED] voice: 804-828-4807 Alexander Verkooijen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 07/17/2001 11:05 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: AIX 4.2 client Zoltan Forray/AC/VCU wrote: Can someone tell me what the *ABSOLUTE LATEST* version of the TSM (ADSM ?) client can be used on AIX 4.2 ? I think you need U468051 from http://www.tivoli.com/support/storage_mgr/tivolieoc.html#tadsmc Hope this helps, Alexander -- --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing