Re: TSM SQL question

2014-06-28 Thread Del Hoobler
: From: Rick Adamson rickadam...@biloholdings.com To: ADSM-L@vm.marist.edu Date: 06/27/2014 04:05 PM Subject: Re: TSM SQL question Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Del, Is it just me or does the restore command in step two of this article run off the page rather than

Re: TSM SQL question

2014-06-27 Thread Rick Adamson
Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Monday, June 16, 2014 6:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM SQL question Hi Mike, Yes. This is possible. There are a number of customers doing it. This might help you: http://www-01.ibm.com/support

Re: TSM SQL question

2014-06-16 Thread Del Hoobler
/2014 09:35:55 AM: From: Michael P Hizny mhi...@binghamton.edu To: ADSM-L@vm.marist.edu Date: 06/13/2014 09:36 AM Subject: TSM SQL question Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi, We are trying to set up an automated refresh of our test system databases (Microsoft SQL

TSM SQL question

2014-06-13 Thread Michael P Hizny
Hi, We are trying to set up an automated refresh of our test system databases (Microsoft SQL) using the TSM SQL client. Does anyone know if it is possible to automatically do an SQL backup of a production server database and then restore this to a test system server via a command line script?

tsm sql question

2009-05-04 Thread eric wonderley
i run: SELECT activity, count(entity) as SESSIONS, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as GB FROM summary where end_timecurrent_timestamp-48 hours GROUP BY activity why is it that tape mount and expiration sessions are 0? -- eric.wonder...@vt.edu Systems Engineering and Admin

Re: tsm sql question

2009-05-04 Thread Richard Sims
In working with table fields, you have to watch out for values which can be null. Change your count(entity) to count(*). Richard Sims

TSM-SQL-question..

2000-12-01 Thread Tom Tann{s
Hello! Any SQL-experts out there? I have no experience with sql except from the few things I have learned from the tsm-implementation. I want to query the events-table for avents for, lets say the last 24 hours. Just like with the q events, only entries since today 00:00 are displayed as

Re: TSM-SQL-question..

2000-12-01 Thread Tom Tann{s
scheduled_start'08/01/2000' and scheduled_start'08/31/2000' James Thompson From: Tom Tann{s [EMAIL PROTECTED] Reply-To: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: TSM-SQL-question.. Date: Fri, 1 Dec 2000 17:59:17 +0100 Hello! Any SQL-experts out t

Re: TSM-SQL-question..

2000-12-01 Thread Alex Paschal
interface at the web site? Thanks, Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Tom Tann{s [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 10:09 AM To: [EMAIL PROTECTED] Subject: Re: TSM-SQL-question.. Yes, I know. T

Re: TSM-SQL-question..

2000-12-01 Thread Tom Tann{s
ann{s [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 10:09 AM To: [EMAIL PROTECTED] Subject: Re: TSM-SQL-question.. Yes, I know. This is similar to my example. However, I want to something similar to q event begint=now-24, which is a generic thing, rather than using the actual d