Re: TSM SQL question
Hi Rick, There are two commands in the second step. I can see the entire commands in Firefox and IE, although the text wraps at different places in both browsers. Here is the first command (I wrapped on each option): tdpsqlc restore Northwind FULL /relocate=Northwind,Northwind_log /to=g:\MSSQL\DATA\northwnd.mdf,g:\MSSQL\DATA\northwnd.ldf /fromsqlserver=TSMCRASH /sqlserver=TSMBURN /tsmnode=crash /tsmpassword=pwd /mountwait=yes Here is the second command: tdpsqlc restore Northwind FULL /RELOCATEDIR=g:\MSSQL\DATA\ /fromsqlserver=TSMCRASH /sqlserver=TSMBURN /tsmnode=crash /tsmpassword=pwd /mountwait=yes I hope this helps. Thank you, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/27/2014 04:04:20 PM: 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 wrapping to the next line? I did submit the issue in the comment section, but as it is will leave many hanging Thanks ~Rick -Original Message- From: ADSM: Dist Stor 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/docview.wss?uid=swg21253263 Thank you, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/13/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) 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? Thanks, Mike
Re: TSM SQL question
Del, Is it just me or does the restore command in step two of this article run off the page rather than wrapping to the next line? I did submit the issue in the comment section, but as it is will leave many hanging Thanks ~Rick -Original Message- From: ADSM: Dist Stor 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/docview.wss?uid=swg21253263 Thank you, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/13/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) 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? Thanks, Mike
Re: 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/docview.wss?uid=swg21253263 Thank you, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/13/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) 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? Thanks, Mike
TSM SQL question
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? Thanks, Mike *Michael Hizny* *Director of Networking* *Binghamton University*
tsm sql question
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 Virginia Tech 1700 Pratt Drive Blacksburg, VA 24061 Ph: 540-231-4385 Fx: 540-231-7413
Re: tsm sql question
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..
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 default. in the q events you can add begind=today-1, begint=now-24 and similar. Is it possible to do the same in a sql-statement? I have been playing around a little, but the only way I have come up with so far is to enter the fromdate explicitely like tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events where SCHED ULED_START \ '2000-11-30 12:13:14' works, and I thought also the following wold works, but only returns entries from after today 00:00: tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events where cast((current_timestamp-SCHEDULED_START)hours as decimal) 24 What am I missing here? Any suggestions/comments on this wold be appreciated.. Tom
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 date/time as input.
On Fri, 1 Dec 2000, James Thompson wrote:
Here is an example that might help.
'select * from EVENTS where 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 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 default.
in the q events you can add begind=today-1, begint=now-24 and similar.
Is it possible to do the same in a sql-statement?
I have been playing around a little, but the only way I have come up with
so far is to enter the fromdate explicitely like
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events where
SCHED ULED_START \ '2000-11-30 12:13:14'
works, and I thought also the following wold works, but only returns
entries from after today 00:00:
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events where
cast((current_timestamp-SCHEDULED_START)hours as decimal) 24
What am I missing here?
Any suggestions/comments on this wold be appreciated..
Tom
_
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: TSM-SQL-question..
Hello, Tom. The searchable archive (www.adsm.org) has a few examples of how
to answer this question. I used "sql select time date event actlog" as my
search string, and I came up with a bunch of messages. Here are just a few;
I would recommend going to the archive yourself and searching for something
that might be more specifically suited to your needs.
http://msgs.adsm.org/cgi-bin/get/adsm9811/988.html
http://msgs.adsm.org/cgi-bin/get/adsm0010/191.html
http://msgs.adsm.org/cgi-bin/get/adsm0008/487.html
By the way, has anyone else noticed they have a "spiffy" new 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. 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 date/time as input.
On Fri, 1 Dec 2000, James Thompson wrote:
Here is an example that might help.
'select * from EVENTS where 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 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 default.
in the q events you can add begind=today-1, begint=now-24 and similar.
Is it possible to do the same in a sql-statement?
I have been playing around a little, but the only way I have come up with
so far is to enter the fromdate explicitely like
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events
where
SCHED ULED_START \ '2000-11-30 12:13:14'
works, and I thought also the following wold works, but only returns
entries from after today 00:00:
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events
where
cast((current_timestamp-SCHEDULED_START)hours as decimal) 24
What am I missing here?
Any suggestions/comments on this wold be appreciated..
Tom
_
Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com
Re: TSM-SQL-question..
OK, thanks.
I thought I hade been through the list, but to quick.
Took a new round, and this entry from Andy Raybeck was what I missed
before I posted my message.
Sorry. I should have studied the list more carefully before I posted..
You are correct. the design of the SELECT * FROM EVENTS was intended
to present only events for today (just like QUERY EVENTS). However,
I agree that the design ought to be changed to reflect the SQL
standard: that is, SELECT * FROM anytable presents *all* records
in that table, not just certain ones. In the case of QUERY EVENTS,
you can query events as far back as you want, but the status may
be "uncertain" if the events go back further than your event record
retention setting. So in my opinion, SELECT * FROM EVENTS should
show you all events that are available within the event record
retention timeframe.
This is a change I am lobbying for with the server developers.
Regards,
Andy
I hope your lobbying will work!
On Fri, 1 Dec 2000, Alex Paschal wrote:
Hello, Tom. The searchable archive (www.adsm.org) has a few examples of how
to answer this question. I used "sql select time date event actlog" as my
search string, and I came up with a bunch of messages. Here are just a few;
I would recommend going to the archive yourself and searching for something
that might be more specifically suited to your needs.
http://msgs.adsm.org/cgi-bin/get/adsm9811/988.html
http://msgs.adsm.org/cgi-bin/get/adsm0010/191.html
http://msgs.adsm.org/cgi-bin/get/adsm0008/487.html
By the way, has anyone else noticed they have a "spiffy" new 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. 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 date/time as input.
On Fri, 1 Dec 2000, James Thompson wrote:
Here is an example that might help.
'select * from EVENTS where 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 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 default.
in the q events you can add begind=today-1, begint=now-24 and similar.
Is it possible to do the same in a sql-statement?
I have been playing around a little, but the only way I have come up with
so far is to enter the fromdate explicitely like
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events
where
SCHED ULED_START \ '2000-11-30 12:13:14'
works, and I thought also the following wold works, but only returns
entries from after today 00:00:
tsm: SUMOselect SCHEDULED_START,NODE_NAME,SCHEDULE_NAME from events
where
cast((current_timestamp-SCHEDULED_START)hours as decimal) 24
What am I missing here?
Any suggestions/comments on this wold be appreciated..
Tom
_
Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com
