Re: TSM client on Ubuntu...

2012-12-18 Thread Stefan Folkerts
I too would like to express my gratitude for your fine work. On Mon, Dec 17, 2012 at 10:12 PM, Stackwick, Stephen < stephen.stackw...@icfi.com> wrote: > ...and as someone who uses your work every day on Pangolin, I thank you! > > Steve Stackwick > > -Original Message- > From: ADSM: Dist

Re: SnapMirrorToTape stats?

2012-12-18 Thread Schaub, Steve
Peter, SM2T is strictly used as a volume-level fallback for DR or onsite, no TOC since we don't want to use it to recover individual files. Our first line of defense is snapshots, then SnapDiff. -steve -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Beh

Reclamation of Virtual Tapes

2012-12-18 Thread Welton, Charles
Hello: We have a TSM instance that uses virtual tapes as our primary backup data pool. The data on the virtual tapes are eventually migrated to tape. We are currently down to 3 virtual scratch tapes and 6 physical scratch tapes. I noticed that we are not running any reclamation processes on

Re: tsm scripts time of day

2012-12-18 Thread Jeannie Bruno
Is there a 'current_day' column on the status table? just curious, it's giving me invalid column name, so I thought I had the wrong name. When I do select * from status, I don't even see column current_time.(I'm wearing my glasses too!) -Original Message- From: ADSM: Dist Stor Mana

Re: tsm scripts time of day

2012-12-18 Thread Sims, Richard B
Do SELECT * FROM SYSCAT.TABLES WHERE TABNAME='___' on a given table name to see what columns it has. (Table schema can change over time.) Richard Sims On Dec 18, 2012, at 11:32 AM, Jeannie Bruno wrote: > Is there a 'current_day' column on the status table? just curious, it's > giving me

VE 6.4 Testing - think & thin

2012-12-18 Thread jmayhew
Wanda, The following testflag should help: TESTFLAG VMRESTORE_DONT_FORCE_THICK The following two IBM technotes discuss briefly discuss this test flag: http://www-01.ibm.com/support/docview.wss?uid=swg21508174 http://www-01.ibm.com/support/docview.wss?uid=swg21508259 Thanks, James Mayhew H

Re: tsm scripts time of day

2012-12-18 Thread Alex Paschal
Hi, Jeannie. No, actually, there isn't. CURRENT_TIMESTAMP is a built in function that returns the timestamp of the current time. DB2 has DATE and TIME functions for getting pieces of the timestamp. Here is a good URL for basic DB2 time functions. Some subset of these apply to TSM's selects. h

Re: tsm scripts time of day

2012-12-18 Thread Jeannie Bruno
Thanks. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Sims, Richard B Sent: Tuesday, December 18, 2012 12:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] tsm scripts time of day Do SELECT * FROM SYSCAT.TABLES WHERE TABNAME='___' on a g

Re: Reclamation of Virtual Tapes

2012-12-18 Thread Lee, Gary
Sounds like someone set the reclaim storage pool on the virtual tape pool to the physical tape pool. I know of no reason why not to reclaim virtual tapes. Wish I had one to play with. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- Fro

Re: SnapMirrorToTape stats?

2012-12-18 Thread Schaub, Steve
Took me awhile to find how it was recorded in the summary, but that is what I needed. Thanks, Wanda! -steve -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Monday, December 17, 2012 5:28 PM To: ADSM-L@VM.MARIST.EDU Subject:

Re: Reclamation of Virtual Tapes

2012-12-18 Thread Ehresman,David E.
We reclaim our virtual tapes. They have the same waste patterns as physical tape and are certainly as expensive. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, December 18, 2012 2:10 PM To: ADSM-L@VM.MARIST.EDU

Re: tsm scripts time of day

2012-12-18 Thread Bob Levad
Jeannie, Current_date, Current_timestamp, and Current_time are not part of any table, they are SQL variables that can be derived as needed by referencing them in an SQL statement. The STATUS table in TSM is useful as it only contains 1 record, other tables will work, but may return many lines

LTFS user ?

2012-12-18 Thread ritchi64
Hello, I want to know if some of you use LTFS for tiering storage (like tier3). Are you able to share the libairy with TSM backup? any gotcha? We already got a solution for tier1 and tier2 but wondering for tier3, we should look at 4TB sata drive or go with tape and LTFS? +-

Re: tsm scripts time of day

2012-12-18 Thread Jeannie Bruno
Hello. I can use a combo of these from the link you sent for what I need to do. SELECT current date FROM sysibm.sysdummy1 SELECT current time FROM sysibm.sysdummy1 SELECT current timestamp FROM sysibm.sysdummy1 Thanks so much. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADS

Re: LTFS user ?

2012-12-18 Thread Grant Street
I haven't used it, but have a look at crossroad's strongbox. It looks to be very good in the LTFS tiered storage and presents as a NAS. It has a caching NAS head, multiple copies etc.. http://www.crossroads.com/products/strongbox/ Grant On 19/12/12 08:27, ritchi64 wrote: Hello, I want to know