Library failure

2003-07-21 Thread Sebastien Bigand
Hi, I've got a problem with my library (STK9740) : I cannot use anymore my drives. My server version is 5.1 Level 7.0 This is the error when starting TSM : ANR8470W Initialization failure on drive 98401 in library STK9740. ANR8470W Initialization failure on drive 98402 in library STK9740. AN

TSM Manager V2.5

2003-07-21 Thread Nicolas Savva
Hi to all, Anyone use TSM Manager V2.5, what are your comments about it? I am considering buying it. Thanks in advance Nick Privileged/Confidential information may be contained in this message and may be subject

Re: TSM Manager V2.5

2003-07-21 Thread Karel Bos
Using it. Currently monitoring 3 TSM servers with it. Reporting, status checking etc. works good. Before buying, use the demo first. PS. TSM5.2 has monitoring stuff deliverd with it. Have a look at it before buying TSM manager. Regard, Karel > -Oorspronkelijk bericht- > Van: Nicolas Savv

Re: TSM 5.1.6.3 on AIX 5.1 ML4 or ML3

2003-07-21 Thread Remco Post
On Fri, 18 Jul 2003 16:33:59 -0700 J M <[EMAIL PROTECTED]> wrote: > The continued case for why TSM and AIX should be jointly administered > > Our AIX admins are claiming that TSM has a memory leak. We are claiming we > need adequate paging space (ie. 6 GB of memory, not 100 MB of paging > spac

Help on select syntax

2003-07-21 Thread Robert Ouzen
Hi to all Try to run a select query on the actlog table for certain msgno in certain period but got wrong result. Here my select command: select nodename , msgno , substr(message,44,14) as "Message" from actlog where (msgno=4961 or msgno=4964) and date_time=CURRENT_TIMESTAMP - 1 days

Re: Help on select syntax

2003-07-21 Thread Coyle, Jack
Robert, In place of your listed date computation, try cast ((current_timestamp-date_time)hours as integer)<=24 Regards, Jack Coyle Rex Healthcare (919) 784-3792 [EMAIL PROTECTED] > -- > From: Robert Ouzen[SMTP:[EMAIL PROTECTED] > Reply To: ADSM: Dist Stor Manager > Sent:

TSM 5.2 AIX client - DB2/SAP R3 Direct Archiving

2003-07-21 Thread Crawford, Lindy
Hi TSMers, DB2 direct archiving to tsm does not work it comes up with the following error messages, it show target as disk even although I have changed it to ADSM:DISKPOOL after I upgraded to tsm 52 aix 64bit 5.2:- Time Started: Mon Jul 21 12:03:40 2003 (20030721120340) Parameters Passed:

Learning SQL-queries

2003-07-21 Thread brian welsh
Hello, On the list I see on a regular base sql-queries with something like this: - CAST(SUM(BYTES/1024/1024) or - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME or - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length The basic sql I understand now,

Re: Library failure

2003-07-21 Thread Leonard Lauria
Query your drives...are they online? If so then query your paths to those drives. If you find the path to the library or paths to the drives offline, vary them on and try things again. -Original Message- From: Sebastien Bigand <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Mon, 21 Jul

Timo Kilchenmann, Bechtle Data AG ist abwesend.

2003-07-21 Thread Kilchenmann Timo
Ich werde ab 21.07.2003 nicht im Büro sein. Ich kehre zurück am 01.08.2003. Die E-Mail wurde nicht weitergeleitet!

Re: SQL Server: RESTORE VERIFYONLY

2003-07-21 Thread Del Hoobler
Chris, Data Protection for SQL does not have a VERIFYONLY function. You will have to restore the database in order to verify it. You could restore it to an alternate name or stand-by server if you do not want to interrupt your live database. Thanks, Del -

Re: Library failure

2003-07-21 Thread Sebastien Bigand
Thanks Richard, my problems where due to the drive state in the path. Leonard Lauria <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/21/2003 02:10:02 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To:[EMAIL PROTECTE

Re: TSM Manager V2.5

2003-07-21 Thread Zoltan Forray/AC/VCU
We use it. Love it. Live in it daily. Using it against 2-TSM serversz/OS and AIX. Just implemented the vaulting feature for AIX. Our operations staff would be helpless without this feature, when it comes to handling the AIX system tapes. The support is great. Very responsive.even to some

Re: TSM 5.1.6.3 on AIX 5.1 ML4 or ML3

2003-07-21 Thread Paul Ripke
On Fri, 18 Jul 2003 16:33:59 -0700 J M <[EMAIL PROTECTED]> wrote: The continued case for why TSM and AIX should be jointly administered Our AIX admins are claiming that TSM has a memory leak. We are claiming we need adequate paging space (ie. 6 GB of memory, not 100 MB of paging space) and that

Re: 5.2 bug?

2003-07-21 Thread Dan Goodman
Remeta, Mark wrote: Search within: United States Worldwide Advanced searchTips No results found Maybe your going to a different www.ibm.com... Or maybe it's case-sensitive? Worked for me. This is the noisiest list I have ever been on. Has anyone given any thought to splitting this into

Re: TSM 5.1.6.3 on AIX 5.1 ML4 or ML3

2003-07-21 Thread Rick Saylor
I too had a memory leak problem with my TSM server. After working with AIX support for several weeks it was their opinion that DSMSERV had a memory leak. I've since upgraded to 5.1.6.4 and my TSM server has been up for 58 days now. So, it seems that the memory leak problem has gone away. You might

Re: 5.2 bug?

2003-07-21 Thread Tom Kauffman
FWIW -- "invalid format code" in the top right search box at www.ibm.com (which, in my case, resolves to www.ibm.com/us) returns what Richard describes. Note double quotes and all lower case. Tom Kauffman NIBCO, Inc PS -- Mozilla 1.4 on MS-Win2K -Original Message- From: Jolliff, Dale [ma

Strange query output, using ODBC interface with M$ Access ...

2003-07-21 Thread PAC Brion Arnaud
Hi list, I'm currently using TSM ODBC (V 5.1.6.0) interface with an Access 2002 database (V 10.4302.4219 sp-2), and built a query looking like : SELECT SUMMARY.START_TIME, SUMMARY.END_TIME, SUMMARY.ACTIVITY, SUMMARY.ENTITY, SUMMARY.BYTES, DateDiff("w",[START_TIME],Now()) AS timediff FROM SUMMA

Re: Stats

2003-07-21 Thread William Rosette
Hi TSMer's, I am looking for a way to figure a total Gb of active files on a particular node. We had a mini-DR with 9 out of 14 hard drives (raided) go bad. We had to restore 400 Gb of data but never was able to figure what was the total active files that TSM was going to restore. All the highe

Re: Stats

2003-07-21 Thread Richard Sims
>I am looking for a way to figure a total Gb of active files on a particular >node. ... Hello, Bill - This question came up a few weeks ago, and the excellent suggestion was the expedient: Active files, number and bytes Do 'EXPort Node NodeName

Re: Stats

2003-07-21 Thread William Rosette
Thanks, Good one, Bill Rosette Data Center/IS/Papa Johns International WWJD Richard Sims <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: "ADSM: cc: Dist StorSubje

Space reclamation

2003-07-21 Thread RAMNAWAZ NAVEEN
Hi, I am quite new to TSM and trying to configure some setups by myself & currebntly facing some problems. My setup is as follows: I run a daily backup for around 200 GB on LTO tapes. I permanently have 3 tapes in a 3590 library defined to a stgpool (UATPOOL). I want to keep the last 3 copies.

Re: Learning SQL-queries

2003-07-21 Thread Alex Paschal
Hi, Brian. There's tons of stuff out there. http://www.google.com/search?hl=en&ie=ISO-8859-1&q=SQL+tutorial+cast http://www.firstsql.com/tutor3.htm#special http://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=SQL+tutorial+substr http://abdi.isse.tripod.com/sql/calc.html Alex P

Can anyone help?

2003-07-21 Thread Bartel, Heather
Hello. I don't know much about this list, other than I'm told those who utilize Tivoli are subscribed to it. I'm wondering if there is anyone out there who may be seeking Tivoli work and may be interested in a contract-to-hire situation for our premier client in Auburn Hills, MI. We are seeking

Re: UPGRADE TSM 3.7 TO 5.1

2003-07-21 Thread Keith Munro
Hi, we went from 3.7.3 on Solaris 2.6 to 5.1.0.0, with some minor problems. There were some issues with Archives after the upgrade, due to changes to table structures in TSM, we were also advised to got 5.1.something, not to stay on 5.1.0.0. Email me if you want more details Regards,

move nodedata

2003-07-21 Thread bizzorg
What happened to the move Nodedata function? We're running on z/OS 1.2 TSM server at 5.1.6.4. I read that there would be a move nodedata funtion startingat V5.1.5.

Re: Space reclamation

2003-07-21 Thread Nicolas Savva
In my environment i have only one tape drive. To enable tape reclamation for a storage pool that has only one mount point, you can define a sequential reclamation storage pool with a file device class. (read " Reclaiming volumes in a storage pools with one drive " from Administrator guide.pdf) N