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" wrote on 06/27/2014 04:04:20 PM: > From: Rick Adamson > To: ADSM-L@vm.marist.edu > Date: 06/27/2014 04:05 PM > Subject: Re: TSM SQL question > Sent by: "ADSM: Dist Stor Manager" > > 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" wrote on 06/13/2014 > 09:35:55 AM: > > > From: Michael P Hizny > > To: ADSM-L@vm.marist.edu > > Date: 06/13/2014 09:36 AM > > Subject: TSM SQL question > > Sent by: "ADSM: Dist Stor Manager" > > > > 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" wrote on 06/13/2014 09:35:55 AM: > From: Michael P Hizny > To: ADSM-L@vm.marist.edu > Date: 06/13/2014 09:36 AM > Subject: TSM SQL question > Sent by: "ADSM: Dist Stor Manager" > > 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" wrote on 06/13/2014 09:35:55 AM: > From: Michael P Hizny > To: ADSM-L@vm.marist.edu > Date: 06/13/2014 09:36 AM > Subject: TSM SQL question > Sent by: "ADSM: Dist Stor Manager" > > 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*
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
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_time>current_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..
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 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: SUMO>select 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: SUMO>select 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: SUMO>select 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: SUMO>select 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..
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: SUMO>select 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: SUMO>select 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..
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: SUMO>select 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: SUMO>select 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
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: SUMO>select 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: SUMO>select 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