Re: Improving TSM performance - memory related setting

2008-04-04 Thread Ibán Bernaldo de Quirós Márquez
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 bufpolsiz

Re: Multiple Backup Streams with exchange.

2008-04-04 Thread Schaub, Steve
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 no

Re: Multiple Backup Streams with exchange.

2008-04-04 Thread Hart, Charles A
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: R

Re: Problem is still there with a LTO volume

2008-04-04 Thread Jacquelin Bouchard
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] B

Re: Improving TSM performance - memory related setting

2008-04-04 Thread Howard Coles
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

Re: Multiple Backup Streams with exchange.

2008-04-04 Thread Howard Coles
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 H

Re: Problem is still there with a LTO volume

2008-04-04 Thread Richard Sims
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 i

delete volhist

2008-04-04 Thread Howard Coles
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 an

Re: delete volhist

2008-04-04 Thread Wanda Prather
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 t

Re: Problem is still there with a LTO volume

2008-04-04 Thread Jacquelin Bouchard
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:

Re: Date/Time different between AIX and TSM problem

2008-04-04 Thread Kinder, Kevin P
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

Re: Problem is still there with a LTO volume

2008-04-04 Thread Thorneycroft, Doug
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 mo

Re: Date/Time different between AIX and TSM problem

2008-04-04 Thread Richard Sims
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 I

Re: backup windows 2008 server?

2008-04-04 Thread TSM
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 w

SQL command

2008-04-04 Thread Mario Behring
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

Don't embed tabs in script commands

2008-04-04 Thread Keith Arbogast
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

Re: SQL command

2008-04-04 Thread Andrew Raibeck
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

TSM - PEM integration

2008-04-04 Thread Mario Behring
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

Re: Don't embed tabs in script commands

2008-04-04 Thread Strand, Neil B.
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 M

Re: SQL command

2008-04-04 Thread Mario Behring
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:

Re: SQL command

2008-04-04 Thread Andrew Raibeck
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 Rai

USS support

2008-04-04 Thread Dominique Laflamme
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 document

Re: USS support

2008-04-04 Thread Len Boyle
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 w

PROBLEM: HSM For Windows Recalling ALL Migrated Data During B/A Client Restore

2008-04-04 Thread Robin Lowe
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 actu

Which TSM tables contain

2008-04-04 Thread James Hunt
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

2008-04-04 Thread Alex Paschal
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- F

Re: Which TSM tables contain

2008-04-04 Thread James Hunt
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-

Re: Which TSM tables contain

2008-04-04 Thread Andrew Raibeck
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

Re: Which TSM tables contain

2008-04-04 Thread James Hunt
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,

Re: Which TSM tables contain

2008-04-04 Thread Orville Lantto
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 Messa