Re: Comment about the TSM gui from a IBM conference

2011-09-07 Thread Roger Deschner
I've been ranting about that here for a while now. Yes, it sucks! And removing the dsmmfc native GUI client in 6.2 just added insult to injury. I did a benchmark of the Windows v6.1 java client versus the v6.1 native dsmmfc client on the same computer, and the java client took 10 times longer to in

Re: confused about deduprequiresbackup

2011-09-07 Thread Strand, Neil B.
See page 286 in the AIX admin guide Quote: Attention: By default, the Tivoli Storage Manager server requires that you back up deduplication-enabled primary storage pools before volumes in the storage pool are reclaimed and before duplicate data is discarded. The copy storage pools and active-d

Re: confused about deduprequiresbackup

2011-09-07 Thread Ian Smith
Alex, I can't find the precise reference at the moment, but I think the copy backup must be to a non-deduplicated pool for this flag to be satisfied. Accordingly, I suspect reclamation, which is the process that deconstructs the duplicate data, is disabled until the flag setting is properly honou

confused about deduprequiresbackup

2011-09-07 Thread Alexander Heindl
Hi, I'm a bit confused about this option. when I set it to no, reclamation on my primary dedup filepool works when set to yes, not. although all data is copied to a copypool. reclamaion on copypool works in both situations... could it have to do with the fact that the copypool is also file device

Comment about the TSM gui from a IBM conference

2011-09-07 Thread Richard Rhodes
Interesting question/comment on the IBM Storage blog by Tony Pearsonat https://www.ibm.com/developerworks/mydeveloperworks/blogs/InsideSystemStorage/?lang=en In talking about events on Day 4 of the IBM Storage University, he describes a Question/Answer event with this Q+A . . . Q) The TSM GU

Re: Antwort: [ADSM-L] Sql query problem in tsm 6.2

2011-09-07 Thread Lee, Gary D.
Thanks all. Adding the alias names fixed it. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Thorsten Burghardt Sent: Wednesday, September 07, 2011 9:36

Re: Sql query problem in tsm 6.2

2011-09-07 Thread Fiske, Daniel
For some reason 6.2 does not like linking tables in the old way. You need to use aliases. Try this select statement: select ev.node_name, ev.status, nd.email_address from events ev, nodes nd where ev.node_name = nd.node_name and ev.status != 'Completed' and ev.scheduled_start> '2011-09-06 08:

Re: Sql query problem in tsm 6.2

2011-09-07 Thread Lee, Gary D.
Well, column name is still node_name. listed as column 0. Next to lookup the apar. Thanks for the help. This is disconcerting. Sure effects my reporting and error tracking. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- From: ADSM:

Antwort: [ADSM-L] Sql query problem in tsm 6.2

2011-09-07 Thread Thorsten Burghardt
Hi, use following Syntax: select ev.node_name, ev.status, no.email_address from events ev, - nodes no where ev.node_name = no.node_name and - ev.status != 'Completed' and - ev.scheduled_start> '2011-09-06 08:00:00' and - ev.scheduled_start< '2011-09-07 07:00:00' Thorsten Von:"Lee, Gary D.

Re: Sql query problem in tsm 6.2

2011-09-07 Thread Richard Sims
Do select * from syscat.columns where tabname='NODES' and see if the column name is still NODE_NAME, or perhaps changed to NODENAME. Beyond that: There were a bunch of APARs involving TSM tables, such as IC70346, which may be impacting your attempted Select. Unfortunately, TSM version 6 has be

Sql query problem in tsm 6.2

2011-09-07 Thread Lee, Gary D.
TSM folks, tsm server 6.2.2 on redhat enterprise linux 6.0 I submit the following file as a macro and recieve the errors below. This query works in tsm 5.5 file c:\tsmscripts\pl3 - select events.node_name, events.status, nodes.email_address from events, - nodes where events.node_na

Re: [adsm] Re: TSM v6.2 Diaster Recovery Restore

2011-09-07 Thread Ehresman,David E.
Thanks. The underlying problem turned out to be that I was trying to run the db restore as root instead of as the instance owner. That in turn created a log file in the instance directory that was owned by root that had to be corrected before the instance owner could do the restore. The V6 DR

Backupset encryption - quick question

2011-09-07 Thread Steven Langdale
Hi all I need to transport a backup set and need at least some basic encryption. Before I do a load of testing, I thought I'd ask the group Does anyone know if client side encryption "include.encrypt" works with backup sets, or rather, can you restore the stuff! I'll be restoring via a loca

Re: Deduplication question

2011-09-07 Thread Ian Smith
On 06/09/11 22:40, Richard van Denzel wrote: Hi All, Just a question aboutn the internal dedup of TSM. When I dedup a storage pool and then backup the pool to a dedup copy pool, will the data in the storage pool backup be transferred deduped or will it get undeduped first, then transferred and t