Re: Improving TSM performance - memory related setting
Bufpoolsize should be set between 1/2 and 1/8 of the among of the total physical memory, if I remember well, that is, what best practices recommend. Also if you modify this parameter you will have to take a look at the percentage hit cache (q db f=d) that can be increase (modifying the bufpolsize), or perhaps decrease if the setting is incorrect. Percentage hit cache must be above 99 %. I will also recommend to take a look at the performance tuning guide, that will let you know more about many settings that can increase the performance of your TSM server. Regards, Bernaldo. - Mensaje original De: Paul Dudley <[EMAIL PROTECTED]> Para: ADSM-L@VM.MARIST.EDU Enviado: viernes, 4 de abril, 2008 5:44:02 Asunto: Re: [ADSM-L] Improving TSM performance - memory related setting Currently the BUFPOOLSIZE is set to: BufPoolSize: 122,880 K The server has 3 Gb of memory. Is this something I can increase? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of Skylar Thompson > Sent: Friday, 4 April 2008 1:05 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Improving TSM performance - memory related setting > > Paul Dudley wrote: > > If I recall correctly there is a TSM system setting that relates to the > > memory available on the server, and you can check and adjust this > > setting to improve performance of your TSM server. > > > > > > > > Can anyone remind me which setting it is? > > > > > > Are you thinking of BUFPOOLSIZE and LOGPOOLSIZE? The former controls > the > size of the database buffer pool (bounded only by the physical memory of > the machine), and the latter the size of the temporary transaction space > in the recovery log (up to 8192 pages IIRC). > > -- > -- Skylar Thompson ([EMAIL PROTECTED]) > -- Genome Sciences Department, System Administrator > -- Foege Building S048, (206)-685-7354 > -- University of Washington School of Medicine ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. __ ¿Con Mascota por primera vez? Sé un mejor Amigo. Entra en Yahoo! Respuestas http://es.answers.yahoo.com/info/welcome
Re: Multiple Backup Streams with exchange.
There is no method of creating parallel backup streams in the TDP for Exchange product (unlike it's SQL counterpart). The only way to accomplish something similar is to break your backup script into multiple jobs, each backing up a specific storage group. Of course, that also requires multiple node names, schedulers, etc. Steve Schaub Systems Engineer, Windows Blue Cross Blue Shield of Tennessee -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Friday, April 04, 2008 1:21 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Multiple Backup Streams with exchange. I continue to find new corners of this product to explore - or maybe its grope blindly in the dark ! I have a customer with an exchange cluster TDP 5.3.3.1 backing up to a Win 2k3 server running tsm 5.3.4. Storage agents are installed on both sides of the cluster at 5.3.4. Exchange backups work fine, but the mail store has grown and they are spilling into the online day - there are 4 drives available, but backups only use one. Maxnummp for the node is set to 4. I've been through the TDP for Exchange and Storage Agent manuals and can see nothing that addresses a number of parallel streams. I've tried searching but obviously haven't come up with the right set of keywords. Can someone point me in the right direction? Thanks Steve Steven Harris TSM Admin, Sydney Australia. Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: Multiple Backup Streams with exchange.
You can run a TDP Backup Stream per Message store... You just have to do tdpexe backup cmmds for each. Works well -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schaub, Steve Sent: Friday, April 04, 2008 4:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Multiple Backup Streams with exchange. There is no method of creating parallel backup streams in the TDP for Exchange product (unlike it's SQL counterpart). The only way to accomplish something similar is to break your backup script into multiple jobs, each backing up a specific storage group. Of course, that also requires multiple node names, schedulers, etc. Steve Schaub Systems Engineer, Windows Blue Cross Blue Shield of Tennessee -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Friday, April 04, 2008 1:21 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Multiple Backup Streams with exchange. I continue to find new corners of this product to explore - or maybe its grope blindly in the dark ! I have a customer with an exchange cluster TDP 5.3.3.1 backing up to a Win 2k3 server running tsm 5.3.4. Storage agents are installed on both sides of the cluster at 5.3.4. Exchange backups work fine, but the mail store has grown and they are spilling into the online day - there are 4 drives available, but backups only use one. Maxnummp for the node is set to 4. I've been through the TDP for Exchange and Storage Agent manuals and can see nothing that addresses a number of parallel streams. I've tried searching but obviously haven't come up with the right set of keywords. Can someone point me in the right direction? Thanks Steve Steven Harris TSM Admin, Sydney Australia. Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Re: Problem is still there with a LTO volume
Hi, Is the audit process read the tape, because the volume is really "offsite" in vault ? Jacquelin Bouchard At 14:16 2008-04-03 -0700, you wrote: Update vol to access=readwrite and try the audit again. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Jacquelin Bouchard Sent: Thursday, April 03, 2008 1:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Problem is still there with a LTO volume Hi Richard, I have tried to audit the volume: audit volume a00043 fix=yes Output: ANR2425E AUDIT VOLUME: Unable to access volume A00043 - access mode is set to "offsite". Jacquelin Bouchard At 15:35 2008-04-03 -0400, you wrote: >This volume is probably the victim of a TSM database inconsistency, >where an AUDit Volume will likely be needed to clear its problem. > >Richard Sims
Re: Improving TSM performance - memory related setting
Check your "SELFTUNEBUFpoolsize" setting. If its set to no, change it to yes. Then the BUFPOOLSIZE just becomes an "initial" size setting that the TSM server can adjust upward as it needs to. Our BUFPOOLSIZE is set to 262144 right now which I think for 5.2.9 is close to the max, if not so. I'll have to go back and dig that up again. See Ya' Howard > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Dudley > Sent: Thursday, April 03, 2008 10:44 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Improving TSM performance - memory related > setting > > Currently the BUFPOOLSIZE is set to: > > BufPoolSize: 122,880 K > > The server has 3 Gb of memory. Is this something I can increase? > > Regards > Paul Dudley > > Senior IT Systems Administrator > ANL IT Operations Dept. > ANL Container Line > [EMAIL PROTECTED] > 03-9257-0603 > http://www.anl.com.au > > > > > -Original Message- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > > Behalf Of Skylar Thompson > > Sent: Friday, 4 April 2008 1:05 PM > > To: ADSM-L@VM.MARIST.EDU > > Subject: Re: [ADSM-L] Improving TSM performance - memory related > setting > > > > Paul Dudley wrote: > > > If I recall correctly there is a TSM system setting that relates to > the > > > memory available on the server, and you can check and adjust this > > > setting to improve performance of your TSM server. > > > > > > > > > > > > Can anyone remind me which setting it is? > > > > > > > > > > Are you thinking of BUFPOOLSIZE and LOGPOOLSIZE? The former controls > > the > > size of the database buffer pool (bounded only by the physical memory > of > > the machine), and the latter the size of the temporary transaction > space > > in the recovery log (up to 8192 pages IIRC). > > > > -- > > -- Skylar Thompson ([EMAIL PROTECTED]) > > -- Genome Sciences Department, System Administrator > > -- Foege Building S048, (206)-685-7354 > > -- University of Washington School of Medicine > > > > > > ANL DISCLAIMER > This e-mail and any file attached is confidential, and intended solely > to the named addressees. Any unauthorised dissemination or use is > strictly prohibited. If you received this e-mail in error, please > immediately notify the sender by return e-mail from your system. Please > do not copy, use or make reference to it for any purpose, or disclose > its contents to any person.
Re: Multiple Backup Streams with exchange.
Another way we've solved this is to do full backups on the weekends and then just do incr or diffs through the week. (breaking backups into separate mailstores as stated below) See Ya' Howard > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Hart, Charles A > Sent: Friday, April 04, 2008 7:05 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Multiple Backup Streams with exchange. > > You can run a TDP Backup Stream per Message store... You just have to > do tdpexe backup cmmds for each. Works well > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of > Schaub, Steve > Sent: Friday, April 04, 2008 4:50 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Multiple Backup Streams with exchange. > > There is no method of creating parallel backup streams in the TDP for > Exchange product (unlike it's SQL counterpart). The only way to > accomplish something similar is to break your backup script into > multiple jobs, each backing up a specific storage group. Of course, > that also requires multiple node names, schedulers, etc. > > Steve Schaub > Systems Engineer, Windows > Blue Cross Blue Shield of Tennessee > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of > Steven Harris > Sent: Friday, April 04, 2008 1:21 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Multiple Backup Streams with exchange. > > I continue to find new corners of this product to explore - or maybe > its > grope blindly in the dark ! > > I have a customer with an exchange cluster TDP 5.3.3.1 backing up to a > Win > 2k3 server running tsm 5.3.4. Storage agents are installed on both > sides of the cluster at 5.3.4. > > Exchange backups work fine, but the mail store has grown and they are > spilling into the online day - there are 4 drives available, but > backups > only use one. Maxnummp for the node is set to 4. > > I've been through the TDP for Exchange and Storage Agent manuals and > can > see nothing that addresses a number of parallel streams. I've tried > searching but obviously haven't come up with the right set of keywords. > > Can someone point me in the right direction? > > Thanks > > Steve > > Steven Harris > TSM Admin, Sydney Australia. > Please see the following link for the BlueCross BlueShield of Tennessee > E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm > > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to > which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify > the > sender by replying to this message and delete this e-mail immediately.
Re: Problem is still there with a LTO volume
On Apr 4, 2008, at 8:12 AM, Jacquelin Bouchard wrote: Hi, Is the audit process read the tape, because the volume is really "offsite" in vault ? Have you tried changing the access mode of the tape to readwrite (or even readonly) as Doug recommended yesterday? In the case of a database inconsistency such as this, it is our historic experience that TSM realizes during the audit that the tape is devoid of data, and will not seek mounting of the tape. This is a problem which has been discussed many times on the mailing list. See http://www.mail-archive.com/adsm-l@vm.marist.edu/ msg67788.html for one such case. Richard Sims
delete volhist
I have a question about a schedule that has been running on a TSM server in our system. Each day at about 12:30 it runs this command: "del volhistory todate=-90 type=all" My question is, would anyone know of a reason to be doing this? I haven't historically set anything like this up on any TSM server I put into production, but I don't want to get rid of this if it's a good thing to be doing. See Ya' Howard Coles Jr. Sr. Systems Engineer Ardent Health Services John 3:16!
Re: delete volhist
If you don't delete the volhistory, it grows forever. If you do a PREPARE command, or send your volhistory file offsite for DR, an enormously large volhistory becomes a nuisance. OTOH, if you create backupsets or EXPORT tapes, you don't want to do the delete volhist with TYPE=ALL; that will get the export and backupset tapes as well. If the current size of your volhist doesn't bother you, it's fine. W On 4/4/08, Howard Coles <[EMAIL PROTECTED]> wrote: > > I have a question about a schedule that has been running on a TSM server > in our system. > > Each day at about 12:30 it runs this command: > > > > "del volhistory todate=-90 type=all" > > > > My question is, would anyone know of a reason to be doing this? I > haven't historically set anything like this up on any TSM server I put > into production, but I don't want to get rid of this if it's a good > thing to be doing. > > > > See Ya' > > Howard Coles Jr. > > Sr. Systems Engineer > > Ardent Health Services > > John 3:16! > > >
Re: Problem is still there with a LTO volume
Hi, Thanks for your help, the problem is solved now; as recommended by Doug and Richard, i run these commands: update vol A00043 access=readw audit volume a00043 fix=yes and now the volume status is "empty". Jacquelin Bouchard At 08:34 2008-04-04 -0400, you wrote: On Apr 4, 2008, at 8:12 AM, Jacquelin Bouchard wrote: Hi, Is the audit process read the tape, because the volume is really "offsite" in vault ? Have you tried changing the access mode of the tape to readwrite (or even readonly) as Doug recommended yesterday? In the case of a database inconsistency such as this, it is our historic experience that TSM realizes during the audit that the tape is devoid of data, and will not seek mounting of the tape. This is a problem which has been discussed many times on the mailing list. See http://www.mail-archive.com/adsm-l@vm.marist.edu/ msg67788.html for one such case. Richard Sims
Re: Date/Time different between AIX and TSM problem
Yes, I did. And it doesn't help this particular problem. As noted in the syntax, you have to enter the start date and end date for DST. That's a manual change, since the actual start and end dates for DST are different every year. Unless I'm missing something, there's no way to tell it to switch to DST on the second Sunday in March and switch back on the first Sunday in November. Kevin Kinder State of West Virginia 304-558-5914 x58281 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Thursday, April 03, 2008 12:03 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Date/Time different between AIX and TSM problem On Apr 3, 2008, at 11:44 AM, Kinder, Kevin P wrote: > Bill, > > Different platform, but we exhibited the same problem when we moved to > 5.5 on z/OS. The time zone setting on the version we are running (we > aren't running the base code, having had several different APARs > applied > [AK59448] is the latest) doesn't work, so on spring forward Sunday our > time was an hour off. We had to manually adjust the time zone setting > and stop/restart TSM. > Kevin - You don't mention that you observed IBM document number 7011066 on this topic, so be sure you reviewed that. Richard Sims
Re: Problem is still there with a LTO volume
Give it a try, Ive done this in the past, and on an empty volume, the audit process never requested a mount, but wouldn't start until the tape was updated to readw. If the audit does request a mount, just cancel it. (The cancel process might hang for awhile, because the system is waiting for a mount, but it should eventually time out.) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Jacquelin Bouchard Sent: Friday, April 04, 2008 5:13 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Problem is still there with a LTO volume Hi, Is the audit process read the tape, because the volume is really "offsite" in vault ? Jacquelin Bouchard At 14:16 2008-04-03 -0700, you wrote: >Update vol to access=readwrite and try the audit again. > >-Original Message- >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of >Jacquelin Bouchard >Sent: Thursday, April 03, 2008 1:20 PM >To: ADSM-L@VM.MARIST.EDU >Subject: Re: Problem is still there with a LTO volume > > >Hi Richard, > > I have tried to audit the volume: > > audit volume a00043 fix=yes > >Output: > >ANR2425E AUDIT VOLUME: Unable to access volume A00043 - access mode >is set to "offsite". > >Jacquelin Bouchard > >At 15:35 2008-04-03 -0400, you wrote: > >This volume is probably the victim of a TSM database inconsistency, > >where an AUDit Volume will likely be needed to clear its problem. > > > >Richard Sims
Re: Date/Time different between AIX and TSM problem
On Apr 4, 2008, at 10:08 AM, Kinder, Kevin P wrote: Unless I'm missing something, there's no way to tell it to switch to DST on the second Sunday in March and switch back on the first Sunday in November. You mean, like: EST5EDT,M3.2.0,M11.1.0 ? Take a closer look at the last box in that IBM document. The spec is based upon relative week numbering. Once you've coded it, its good ... until the next whimsical change by Congress. Richard Sims
Re: backup windows 2008 server?
Richard, this windows 2008 server is only a test server for preparing tsm installs in future i am not sure, if i forgot to install some of the needed windows components, i only installed the windows backup feature the bahaviour of backup was - if i backup only some files or some directories it works - i i backup omplete systempartition c: or systemstate, backup ends with errors and no restore of any file was possible installed OS is windows 2008 EE, all windows patches installed, TSM client 5.5.0.4, vssadmin list writers ok windows backup ok backup fails regardless of using vss or tsmlvsa as snapshot provider with best regards stefan savoric * dsmerror.log 03/29/2008 22:22:17 ANS5279E Error processing '\\2008x64\c$\windows\nvtmpinst\nvcpl.chm': file not found. 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : VssRequestor::VssBackupComplete TSM function : BackupComplete() returned VSS_E_BAD_STATE TSM return code : 4345 TSM file : vssreq.cpp (1958) 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : CompleteVssSnapshot TSM function : psVssBackupComplete() failed TSM return code : 4345 TSM file : txncon.cpp (6389) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackQry: Received rc: -50 trying to send BackQry verb 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssCloseGroups TSM function : baCloseGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\TSM\FULL\00\Top\SystemState\System State\0\SystemState' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2220) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackUpd: Received rc: -50 trying to send BackUpd verb 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssUpdateGroups TSM function : baUpdateGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\BACKUP_STATE\TSM\00' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2633) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackUpd: Received rc: -50 trying to send BackUpd verb 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssUpdateGroups TSM function : baUpdateGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\TSM\FULL\00\Top\SystemState\Bootable\Bootable System State\0\Bootable' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2633) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackUpd: Received rc: -50 trying to send BackUpd verb 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssUpdateGroups TSM function : baUpdateGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\TSM\FULL\20080329221011\Top\SystemState\Bootable\COM+ REGDB\COM+ REGDB\1\COM+ REGDB Writer' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2633) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackUpd: Received rc: -50 trying to send BackUpd verb 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssUpdateGroups TSM function : baUpdateGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\TSM\FULL\20080329221011\Top\SystemState\Bootable\Registry \Registry\1\Registry Writer' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2633) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 cuBackUpd: Received rc: -50 trying to send BackUpd verb 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 ANS5250E An unexpected error was encountered. TSM function name : vssUpdateGroups TSM function : baUpdateGroupLeader() for file '2008X64\SystemState\NULL\System State\SystemState\TSM\FULL\20080329221011\Top\SystemState\Bootable\System Files\System Files\1\System Writer' returned rc=-50 TSM return code : -50 TSM file : vssback.cpp (2633) 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50 03/29/2008 22:22:19 sessSendVerb: Error sending Verb, rc: -50
SQL command
Hi list, Which SQL command or function returns the difference, in hours, from two date-time fields when issued against the TSM database? I need to issue this command or function inside a SELECT statement. I´ve tried some functions from DB2 and SQL Server (like datediff) but it does not work at the dsmadmc command line. Any help is appreciated. Mario You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
Don't embed tabs in script commands
I have been debugging an admin script all morning that executes 'activate policyset' commands, among others. Seemingly identical commands succeeded from the command line, but failed when run from a script, with "ANR2022E One or more paramters are missing". After checking everything else I removed the embedded tabs between the commands and their parameters, replacing them with spaces. That was the solution. Is that in the book? With best wishes, Keith Arbogast Indiana University
Re: SQL command
Try this: (datetime1 - datetime2)hours For example: select lastacc_time, \ reg_time, \ (lastacc_time - reg_time)hours as "HOURS" \ from nodes LASTACC_TIME REG_TIME HOURS -- -- -- 2008-04-03 2008-02-28837 16:44:40.0019:37:20.00 2008-03-28 2008-03-27 26 08:21:10.0005:24:17.00 tsm: BABYLON_4> Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2008-04-04 10:39:39: > Hi list, > > Which SQL command or function returns the difference, in hours, from > two date-time fields when issued against the TSM database? > > I need to issue this command or function inside a SELECT statement. > I´ve tried some functions from DB2 and SQL Server (like datediff) > but it does not work at the dsmadmc command line. > > Any help is appreciated. > > Mario > > > > > You rock. That's why Blockbuster's offering you one month of > Blockbuster Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.com
TSM - PEM integration
Hi list, I have to send TSM events to Patrol Enterprise Manager (PEM). Anybody did that already? PEM guys does not want to use SNMP... Is there a way to tell TSM to record events on a text file, kind of a log? I mean, appending events to the file instead of overwriting it. Thanks Mario You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
Re: Don't embed tabs in script commands
It is well documented. See page 42 of the TSM Programers Guide to the Galaxy Cheers, Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Keith Arbogast Sent: Friday, April 04, 2008 1:53 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Don't embed tabs in script commands I have been debugging an admin script all morning that executes 'activate policyset' commands, among others. Seemingly identical commands succeeded from the command line, but failed when run from a script, with "ANR2022E One or more paramters are missing". After checking everything else I removed the embedded tabs between the commands and their parameters, replacing them with spaces. That was the solution. Is that in the book? With best wishes, Keith Arbogast Indiana University IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: SQL command
Andrew, Is there an option to get this result in HH:MM format? Thank you. Mario - Original Message From: Andrew Raibeck <[EMAIL PROTECTED]> To: ADSM-L@VM.MARIST.EDU Sent: Friday, April 4, 2008 3:19:52 PM Subject: Re: SQL command Try this: (datetime1 - datetime2)hours For example: select lastacc_time, \ reg_time, \ (lastacc_time - reg_time)hours as "HOURS" \ from nodes LASTACC_TIME REG_TIME HOURS -- -- -- 2008-04-03 2008-02-28837 16:44:40.0019:37:20.00 2008-03-28 2008-03-27 26 08:21:10.0005:24:17.00 tsm: BABYLON_4> Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2008-04-04 10:39:39: > Hi list, > > Which SQL command or function returns the difference, in hours, from > two date-time fields when issued against the TSM database? > > I need to issue this command or function inside a SELECT statement. > I´ve tried some functions from DB2 and SQL Server (like datediff) > but it does not work at the dsmadmc command line. > > Any help is appreciated. > > Mario > > > > > You rock. That's why Blockbuster's offering you one month of > Blockbuster Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.com You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
Re: SQL command
Well, just do the subtraction with out any function, e.g., datetime1 - datetime2 and you'll get days, hours, minutes, seconds, and subseconds. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2008-04-04 12:49:20: > Andrew, > > Is there an option to get this result in HH:MM format? > > Thank you. > > Mario > > > > > - Original Message > From: Andrew Raibeck <[EMAIL PROTECTED]> > To: ADSM-L@VM.MARIST.EDU > Sent: Friday, April 4, 2008 3:19:52 PM > Subject: Re: SQL command > > Try this: > > (datetime1 - datetime2)hours > > For example: > > select lastacc_time, \ >reg_time, \ >(lastacc_time - reg_time)hours as "HOURS" \ >from nodes > > LASTACC_TIME REG_TIME HOURS > -- -- -- > 2008-04-03 2008-02-28837 >16:44:40.0019:37:20.00 > 2008-03-28 2008-03-27 26 >08:21:10.0005:24:17.00 > > tsm: BABYLON_4> > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development > Level 3 Team Lead > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] > Internet e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www.ibm. > com/software/sysmgmt/products/support/IBMTivoliStorageManager.html > > The only dumb question is the one that goes unasked. > The command line is your friend. > "Good enough" is the enemy of excellence. > > "ADSM: Dist Stor Manager" wrote on 2008-04-04 > 10:39:39: > > > Hi list, > > > > Which SQL command or function returns the difference, in hours, from > > two date-time fields when issued against the TSM database? > > > > I need to issue this command or function inside a SELECT statement. > > I´ve tried some functions from DB2 and SQL Server (like datediff) > > but it does not work at the dsmadmc command line. > > > > Any help is appreciated. > > > > Mario > > > > > > > > > > > You rock. That's why Blockbuster's offering you one month of > > Blockbuster Total Access, No Cost. > > http://tc.deals.yahoo.com/tc/blockbuster/text5.com > > > > > > You rock. That's why Blockbuster's offering you one month of > Blockbuster Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.com
USS support
An internal customer has issued an RFI to several internal support groups about how various components, including TSM, support Unix System Services on z/OS. The questionnaire has two questions about the history and market penetration of supporting USS that aren't answered in the product documentation directly, so I will ask the list: When did ADSM (year? release?) first support USS? (And how does that compare to the availability of USS?) Also, have there been comments at the Symposium, SHARE, or other public venues where IBM has alluded to the number of sites using TSM to support USS clients? I know IBM considers data about product licensing to be sensitive, but we'd love orders-of-magnitude sorts of numbers even. Testimonials (or warnings) about actual experiences with TSM supporting USS are welcome, but those two questions are what I'm really hoping for. :-) Thanks, Nick
Re: USS support
It goes back at least this far. http://www-01.ibm.com/common/ssi/rep_ca/1/897/ENUS296-261/index.html we ordered the oe client against our vm adsm server way back in the 90's. It was not too hard to get the bits as we could order the feature code for a 3480 cart. Since that time we moved to an windows tsm server and it does not have feature codes for 3480 carts. All the other clients can be ftp'ed over the internet. But with the oe client we could not do this. len -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dominique Laflamme Sent: Friday, April 04, 2008 4:14 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] USS support An internal customer has issued an RFI to several internal support groups about how various components, including TSM, support Unix System Services on z/OS. The questionnaire has two questions about the history and market penetration of supporting USS that aren't answered in the product documentation directly, so I will ask the list: When did ADSM (year? release?) first support USS? (And how does that compare to the availability of USS?) Also, have there been comments at the Symposium, SHARE, or other public venues where IBM has alluded to the number of sites using TSM to support USS clients? I know IBM considers data about product licensing to be sensitive, but we'd love orders-of-magnitude sorts of numbers even. Testimonials (or warnings) about actual experiences with TSM supporting USS are welcome, but those two questions are what I'm really hoping for. :-) Thanks, Nick
PROBLEM: HSM For Windows Recalling ALL Migrated Data During B/A Client Restore
Hi TSMers I am testing HSM For Windows, using this environment: TSM AIX Server 5.4.0.1 TSM For Windows B/A Client 5.4.1.2 TSM HSM For Windows 5.4.0.3 My problem, which I am puzzled about, is that during a Restore of a deleted share, which has most of the data migrated (the size is 1.5Gb but actual size on NTFS is 17Mb), the TSM B/A client restores 2000 objects and 9Mb of data - which is about what I would expect. However, when the restore starts bringing back the stub files, I see the HSM client (different nodename) starting to Recall the data, so I end up with the share back at the original size before I ran the HSM Migration job! The restore is carried out after deleting the share, using the Web Client GUI, and restoring the latest backup copy, and to the original location. In a very busy Clustered File environment, which I want to target HSM at, this may have severe consequences! Has anyone with experience of the 5.4 HSM client seen this before, or give me any clues as to where I am going wrong with my configuration? 5.5 may be my way forward, but I would not anticipate being able to get this version into my client's Production environment for at least another 3 months. Thanks Robin Lowe Storage Consultant
Which TSM tables contain
Which TSM table contains this information? I'm looking for a select statement to reproduce the same results. q event * t=a begind=today-1 Jim Hunt Senior Consultant IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2
Re: Which TSM tables contain
Hi, Jim. This should do it for you. select tabname from syscat.tables where tabname like '%EVENT%' Have fun. Alex Paschal Storage Solutions Engineer MSI Systems Integrators Your Business. Better. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Hunt Sent: Friday, April 04, 2008 3:12 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Which TSM tables contain Which TSM table contains this information? I'm looking for a select statement to reproduce the same results. q event * t=a begind=today-1 Jim Hunt Senior Consultant IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2 This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.
Re: Which TSM tables contain
That just lists the events table. I'm looking for the past events from the previous day. Jim Hunt Senior Consultant IBM Tivoli Storage Manager Certified ___ GlassHouse Technologies, Inc. Parkville, MO 64152 816.547.4165 cell 816.505.2169 fax [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alex Paschal Sent: Friday, April 04, 2008 5:45 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Which TSM tables contain Hi, Jim. This should do it for you. select tabname from syscat.tables where tabname like '%EVENT%' Have fun. Alex Paschal Storage Solutions Engineer MSI Systems Integrators Your Business. Better. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Hunt Sent: Friday, April 04, 2008 3:12 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Which TSM tables contain Which TSM table contains this information? I'm looking for a select statement to reproduce the same results. q event * t=a begind=today-1 Jim Hunt Senior Consultant IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2 This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.
Re: Which TSM tables contain
This one is an "old chestnut", check out this link: http://www.mail-archive.com/adsm-l@vm.marist.edu/msg61871.html Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2008-04-04 17:20:34: > That just lists the events table. I'm looking for the past events from > the previous day. > > Jim Hunt > Senior Consultant > IBM Tivoli Storage Manager Certified > ___ > GlassHouse Technologies, Inc. > Parkville, MO 64152 > 816.547.4165 cell > 816.505.2169 fax > [EMAIL PROTECTED] > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Alex Paschal > Sent: Friday, April 04, 2008 5:45 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Which TSM tables contain > > Hi, Jim. > > This should do it for you. > > select tabname from syscat.tables where tabname like '%EVENT%' > > Have fun. > > > Alex Paschal > Storage Solutions Engineer > MSI Systems Integrators > > > Your Business. Better. > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > James Hunt > Sent: Friday, April 04, 2008 3:12 PM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Which TSM tables contain > > Which TSM table contains this information? I'm looking for a select > statement to reproduce the same results. > > > > q event * t=a begind=today-1 > > > > Jim Hunt > > Senior Consultant > > IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2 > > > > This message (including any attachments) is intended only for > the use of the individual or entity to which it is addressed and > may contain information that is non-public, proprietary, > privileged, confidential, and exempt from disclosure under > applicable law or may constitute as attorney work product. > If you are not the intended recipient, you are hereby notified > that any use, dissemination, distribution, or copying of this > communication is strictly prohibited. If you have received this > communication in error, notify us immediately by telephone and > (i) destroy this message if a facsimile or (ii) delete this message > immediately if this is an electronic communication. > > Thank you.
Re: Which TSM tables contain
Thanks, That is what I was looking for. select schedule_name, status, result, reason from events where - SCHEDULED_START>='2005-01-01' and - SCHEDULED_START>=current_timestamp - 1 days Jim Hunt Senior Consultant IBM Tivoli Storage Manager Certified ___ GlassHouse Technologies, Inc. Parkville, MO 64152 816.547.4165 cell 816.505.2169 fax [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Friday, April 04, 2008 7:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Which TSM tables contain This one is an "old chestnut", check out this link: http://www.mail-archive.com/adsm-l@vm.marist.edu/msg61871.html Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead 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/IBMTivoliStorageMan ager.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" wrote on 2008-04-04 17:20:34: > That just lists the events table. I'm looking for the past events from > the previous day. > > Jim Hunt > Senior Consultant > IBM Tivoli Storage Manager Certified > ___ > GlassHouse Technologies, Inc. > Parkville, MO 64152 > 816.547.4165 cell > 816.505.2169 fax > [EMAIL PROTECTED] > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Alex Paschal > Sent: Friday, April 04, 2008 5:45 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Which TSM tables contain > > Hi, Jim. > > This should do it for you. > > select tabname from syscat.tables where tabname like '%EVENT%' > > Have fun. > > > Alex Paschal > Storage Solutions Engineer > MSI Systems Integrators > > > Your Business. Better. > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > James Hunt > Sent: Friday, April 04, 2008 3:12 PM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Which TSM tables contain > > Which TSM table contains this information? I'm looking for a select > statement to reproduce the same results. > > > > q event * t=a begind=today-1 > > > > Jim Hunt > > Senior Consultant > > IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2 > > > > This message (including any attachments) is intended only for > the use of the individual or entity to which it is addressed and > may contain information that is non-public, proprietary, > privileged, confidential, and exempt from disclosure under > applicable law or may constitute as attorney work product. > If you are not the intended recipient, you are hereby notified > that any use, dissemination, distribution, or copying of this > communication is strictly prohibited. If you have received this > communication in error, notify us immediately by telephone and > (i) destroy this message if a facsimile or (ii) delete this message > immediately if this is an electronic communication. > > Thank you.
Re: Which TSM tables contain
The events table is a temporary table that is recalculated as needed. The default is to do only the current day. Try adding a "where" clause like: Select * from events where scheduled_start>'2008-04-01 00:00' This will bring up old data. Orville L. Lantto Storage Consultant -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Hunt Sent: Friday, April 04, 2008 5:12 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Which TSM tables contain Which TSM table contains this information? I'm looking for a select statement to reproduce the same results. q event * t=a begind=today-1 Jim Hunt Senior Consultant IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2
