Select & query

2004-07-11 Thread Robert Ouzen
Hi to all Try to run a select command to get events when I run: select date(Scheduled_start) as "Date", node_name , schedule_name , status from events where date(Scheduled_start)=current date and domain_name='DOWINDOWS' group by scheduled_start ,node_name , status , schedule_name Output:

Re: Return Code

2004-07-11 Thread Verhelst, Luc
Fred, I had this problem on a unix system and it turned out to be an error in the script. Regards Luc -Original Message- From: fred johanson [mailto:[EMAIL PROTECTED] Sent: vrijdag 9 juli 2004 19:00 To: [EMAIL PROTECTED] Subject: Return Code I know this came up in the last week or so bu

Re: Server restore question

2004-07-11 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remeta, Mark >Does anyone have experience in restoring a 5.2.2.4 database backup to a >server running 5.2.3.0? >Will it automatically convert the database the first time the server is >started? Is a db conversion even necessary?

Re: File device classes

2004-07-11 Thread Steve Harris
Thomas, Be aware that sequential pool to sequential pool migrates are single threaded. If you are used to running multiple disk-> tape pool processes at the same time, this could bite you when you are using a sequential disk pool, as your migrates to tape will take longer for your larger pools

Re: Log file filled up -- how to extend? -- URGENT!

2004-07-11 Thread Gordon Woodward
We had the exact same problem this morning with our TSM server, my heart is still pumping away in a nervous state despite the problem being fixed now. Our database backup ran over time due to issues with our secondary server, then expiration took place and our server decided enough was enough. I

Re: SQL Select Statement Question Please HELP!

2004-07-11 Thread Andrew Raibeck
If you are getting actual results (and better yet, correct results) then there is nothing "wrong" per se with your syntax. The tables presented by the SELECT statement do not really exist as such in the TSM server database. Rather, these tables are constructed "on the fly" during SELECT processing

Re: Select & query

2004-07-11 Thread Andrew Raibeck
See APARs IC34609 and IC28825 for general information about this issue (you can search for APARs at the IBM web site http://www.ibm.com). I think you can "trick" this command into producing the desired results by inserting the following after the word "WHERE" in your SQL statement: scheduled_s