Re: help:sprectralogic library element

2003-06-23 Thread Hunny Kershaw
This link shows the formula for the drive addresses when the Queued Unloads (Boption is set to OFF. (B (Bhttp://www-1.ibm.com/support/entdocview.wss?rs=663&uid=swg21066478 (B (BYou can also use lbtest to find out the address of the drives - lbtest -d (B. Select 6 to open and 8 for element cou

Re: oops forgot the error message.

2003-06-23 Thread Anderson F. Nobre
That's curious!!! Now I'm in doubt. I think that you have to use the TSM SCSI Device Driver. What I'm not seeing is the library device. It's something like "lb0". If not first try to create through SMIT DEVICES -> Tivoli Storage Manager Devices -> SCSI Attached Devices -> Library/MediumChanger -> A

Re: Server Down - Urgent Request

2003-06-23 Thread Anderson F. Nobre
This is just one tip for the next time, if it happens again. I hope don't. Any way, you can create more than one device config and volume history in dsmserv.opt. And after a DB backup you can execute the backup of devconfig and volhistory without informing the file. When you don't inform the TSM Se

Re: Server Down - Urgent Request

2003-06-23 Thread Stapleton, Mark
From: Luke Dahl [mailto:[EMAIL PROTECTED] > Issue: We unfortunately lost two disks on a RAID 5 array > that contained > the database, recovery log, and primary diskpools. Compounding the > problem the volhist.bak and devconfig.bak files were stored > on the same > disk array (we had a nightly

Re: Yikes LTO2 problem!?!

2003-06-23 Thread Andrew Raibeck
> Tivoli support said to turn on CRCchecking. > I say, uh yeah, I already know my data is bad. > Looks like I gotta try and figure out which drive/disk/scsi > card is causing the problem myself. Is there any activity log data from the time the data was written to the problem volume(s) that shows

Re: Interesting LTO fault's symptom

2003-06-23 Thread David Longo
Interesting. I have had an IBM 3584 library with (8) LTO1 drives, FC attached for over a year with no problem. Cleaning tape was installed initially and autoclean turned on on the library. Tape has not been used yet!. I backup nearly 700GB of data a day and make offsite copies. Don't do a lot

Re: PCT Logical = 100%

2003-06-23 Thread Bill Boyer
DIRMCduh!!! I just updated the management class for thie Oracle backups and this client has not implemented a DIRMC dirpoolYET! That's on my todo list for this week. Looks like I need to move it up on my list for NOW! Thanks Dwight. And that noise you hear is me kicking my own BUTT for ove

Re: Interesting LTO fault's symptom

2003-06-23 Thread David Fosdike
Greeting TSMers, I have read this thread with great interest as we seem to have similar symptoms on the same kind of equipement. IBM are confounded at present but are starting to come to the same conclusion as me that the autoclean symptom on the library is not functioning as it should. We o

Yikes LTO2 problem!?!

2003-06-23 Thread Matthew Glanville
Problem: Lots and lots of tapes reporting errors when, auditing, copying, moving data from them... 06/23/03 10:52:37 ANRD pvrntp.c(4586): ThreadId<15> Invalid block header read from NTP drive DRIVE5 (/dev/rmt/10st).(magic=5A4D4E50, ver=5, Hdr blk=1450 , dbytes=262096 <262096>) (Thu

[no subject]

2003-06-23 Thread Alex Paschal
Hi, Shannon. You could try building a list of your nodes: node1 node2 node3 store it in a file, "nodes". Then create a shell script, something like the following. You may have to clean up some backslashes, I didn't check it. Oh, I'm assuming a Unix machine. If it's Windows, I'm sure you can f

Server Down - Urgent Request

2003-06-23 Thread Luke Dahl
Hi All, Server level: 5.1.5.1 Server OS: Solaris 2.8 Direct attached to a 3494 with SCSI attached 3590 Drives Issue: We unfortunately lost two disks on a RAID 5 array that contained the database, recovery log, and primary diskpools. Compounding the problem the volhist.bak and devconfig.bak file

sapr3 ess documentation

2003-06-23 Thread Koen Willems
Hello All, Can anybody tell me where I can find manual or redbooks on how to implement tdp for hardware in combination with TDP sap r/3 ? Best regards, Koen Willems _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://j

Re: Work arounds for files deleted in flight?

2003-06-23 Thread Mr. Lindsay Morris
Tony, doesn't the Unexpected events page in Servergraph let you click on each of the ANE messages, and see every individual filename that was missed / retried/ locked / etc? I initially responded because I was looking for advice about how we could better do this, but I think the way we do it n

Re: SELECT equivalent for QUERY EVENT

2003-06-23 Thread Mr. Lindsay Morris
Richard, thanks for the performance note re select vs. query. IMHO, a larger concern, if you're writing programs to analyze TSM's data, is that the layout of the queries may change when you upgrade TSM, but the field names in the database won't. So your programs won't break when you upgrade TSM.

Re: Work arounds for files deleted in flight?

2003-06-23 Thread Garrison, Tony
Sounds good to me also. Anthony A. Garrison Jr. Sr. Systems Programmer USAA (210 456-5755 -Original Message- From: Chuck Mattern [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 11:34 AM To: [EMAIL PROTECTED] Subject:Re: Work arounds for files deleted in flight? Li

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
Your summary is correct. >From a development perspective, the EVENTS table is a little tricky. Unlike BACKUPS, NODES, ACTLOG, etc., which have a finite number of records, the EVENTS table is unbounded. If you do a QUERY EVENT with date criteria beyond your event record retention setting, you'll ge

Re: SELECT equivalent for QUERY EVENT

2003-06-23 Thread Richard Sims
>as our VM mainframe is soon going to die I'm rewriting all my CMS REXX >programs using REGINA and REXXSQL on Windows XP. >As I have to rewrite the code I would like to brush it up and replace >those QUERYs with SELECTs. Thomas - A couple of observations... - I would caution avoiding going to Sel

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
In summary, by default this virtual table contains records for just the current date unless the WHERE clause is filtering on SCHEDULED_START and the clause is a literal value. OKit's not actually a populated table. >>> [EMAIL PROTECTED] 06/23/03 01:46PM >>> Larry, I again refer you to APAR IC

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
Larry, I again refer you to APAR IC34609, which discusses this. You can view the APAR by going to http://www.ibm.com and doing a search on the APAR number, which should come right up for you. In particular, look at the "Comments" section of the APAR. I think that will answer your questions. If not,

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
If access is returning all the rows when II look at the table, it is only returning the current date. Other tables return rows over a thousand, so it isn't a matter of limits. So I'm puzzled why, if it contains more than the current date, why the events table doesn't display it when I open the tabl

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
> I conclude this is much the same as enterint select * from EVENTS Not sure if you are asking a question, but yes. The important point is that no WHERE criteria for SCHEDULED_START is present. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Note

SELECT equivalent for QUERY EVENT

2003-06-23 Thread Thomas Rupp, Vorarlberger Illwerke AG
Hi *sm-gurus, as our VM mainframe is soon going to die I'm rewriting all my CMS REXX programs using REGINA and REXXSQL on Windows XP. As I have to rewrite the code I would like to brush it up and replace those QUERYs with SELECTs. I was playing around (and even reading the manuals ;-) but couldn'

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
SELECT [SCHEDULED_START], [ACTUAL_START], [DOMAIN_NAME], [SCHEDULE_NAME], [NODE_NAME], [STATUS], [RESULT], [REASON] FROM EVENTS; I conclude this is much the same as enterint select * from EVENTS >>> [EMAIL PROTECTED] 06/23/03 12:40PM >>> ... So you can conclude that Access does not send a query th

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
... So you can conclude that Access does not send a query that contains a WHERE clause specifying the date criteria. An example of how to get Access to work with this is as follows: 1) Create a link to the TSM server EVENTS table (I assume you already know how to do this). 2) Select the "View/Da

Re: Work arounds for files deleted in flight?

2003-06-23 Thread Chuck Mattern
Lindsay, This sounds great. We would need full path names to evaluate the consequences of the event. Is something like this already floating around? Chuck Mattern The Home Depot Phone: 770-433-8211 x11919 Email: [EMAIL PROTECTED] Pager: 770-201-1626 "Mr. Lindsay

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
Yes, but when I am looking at the actual EVENTS table via ACCESS and odbc, it appears to only contain data for the current day.. >>> [EMAIL PROTECTED] 06/23/03 11:28AM >>> You need to do something like this: select * from events where scheduled_start>'06/13/2003' Regards,

Re: INCR and INCRBYDATE

2003-06-23 Thread Andrew Raibeck
See the client manual chapter on "Backing up your data", section "Performing an incremental, selective, or incremental-by-date backup" for the information you seek. Also refer to the "Incrbydate" description in the "Using processing options" chapter of the client manual. Regards, Andy Andy Raibe

INCR and INCRBYDATE

2003-06-23 Thread Fc-Atm-Rck, Tivoli (UNKNOWN)
I am trying to find out the differences between an INCREMENTAL and INCRBYDATE. Please help. Thank you.

Navision backup and SQL error

2003-06-23 Thread Martin Jeppesen
Hi all Just joined the list and have 2 questions waiting! 1. We have quite a few SQL servers to backup and until now no problems, but I do have 2 sql servers that I just can't seem to get working like they should. I keep getting the error: ACO5422E Received the following from the MS SQL server

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
You need to do something like this: select * from events where scheduled_start>'06/13/2003' Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
Hi, I can get prior days info by issuing a: q event * * type=client begindate=06/13/2003 endd=today exceptions only=y but looking directly at the EVENTS table it contains no data prior to the current date. I assume the above command goes against the activity log, since it returns 'unc

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
You need to specify values for the SCHEDULED_START and/or ACTUAL_START columns in order to get older data from the EVENTS table. You could do this via a script that calculates today's date - n days, and plugs that into a SELECT statement. Or just go with QUERY EVENTS. The difficulties in getting t

Re: TSM DB Summary table

2003-06-23 Thread Lawrence Clark
OK. Thanks; the EVENTS table seems to only status dor the current day. >>> [EMAIL PROTECTED] 06/23/03 10:27AM >>> For client operations, the SUCCESSFUL column name is a bit of a misnomer. as it really just indicates whether the communications between server and client terminated successfully (I be

Re: TSM DB Summary table

2003-06-23 Thread Andrew Raibeck
For client operations, the SUCCESSFUL column name is a bit of a misnomer. as it really just indicates whether the communications between server and client terminated successfully (I believe that this maps to the "normal server termination indicator" field in the account log records). For monitorin

dsmc signal 11 - segment violation

2003-06-23 Thread Norman Bollinger
I run my script from a logged in terminal and it runs fine but when I try to run it from cron it gets segment violation. This is in a redhat linux box. RH6.5 and client 3.1 works but RH 7.3 and client 4.2 gets the segment violation. I stewed for days and thought the envioronment variables may mak

Re: Unable to Query/Delete a specific filespace

2003-06-23 Thread Andrew Raibeck
Have a look at the DELETE FILESPACE syntax. You need to tack on the NAMETYPE=UNICODE parameter. Alternatively you can specify the FSID instead of the file space name, and use the NAMETYPE=FSID parameter. delete filespace grbcap2 \\grbcap2\n$ nametype=unicode or delete filespace grbcap2 15 namety

Re: oops forgot the error message.

2003-06-23 Thread Stapleton, Mark
From: Scott Figgins [mailto:[EMAIL PROTECTED] # lsdev -Cc tape rmt0 Available 1P-08-00-0,0 4.0 GB 4mm Tape Drive rmt1 Available 1P-08-00-2,0 4.0 GB 4mm Tape Drive smc0 Available 1P-08-00-3,0 IBM 7336 Tape Medium Changer # lsdev -Cc adsmtape mt0 Available 1P-08-00-0,0 Tivoli Storage Manager Tape Dr

Unable to Query/Delete a specific filespace

2003-06-23 Thread David Browne
I can't seem to delete or display some of the filespaces associate to one of my node names. I can display the c, d, e filespaces specifically but not the f,h,i or n. (See below) Anyone have a suggestion? Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Na

Re: Lan-Free Backup

2003-06-23 Thread Thomas, Matthew
Pattie, I may be wrong, but i was under the impression that the TSM Server and BAclient versions must be the same for LANFree to function... Matt Thomas Storage Support LTSB -Original Message- From: LeBlanc, Patricia [mailto:[EMAIL PROTECTED] Sent: 23 June 2003 14:47 To: [EMAIL PROTECTED

Re: How to query if there is data to migrate for a primary storag e pool??

2003-06-23 Thread Coats, Jack
I have found on some large disk pools, that is say, 5x the size of a tape, we set migration to continue to yes, set the high level to 20, and low to something like 3 to 5 percent. Yes, I do daily 'flush' the pools by setting them to hi=0, lo=0 for a while before I do a db backup. Why 20% for hig

Re: TSM DB Summary table

2003-06-23 Thread Stapleton, Mark
From: Lawrence Clark [mailto:[EMAIL PROTECTED] I'm looking at the contents of the TSM Summary table and the SUCCESSFUL column for backups does not seem to relate to failed or missed nodes. Anyone know how to interpret this column correctly? As has been said many times in this list, the summary t

Lan-Free Backup

2003-06-23 Thread LeBlanc, Patricia
Morning, We're trying to get lan-free going in our shop. Tsm Server - aix 4.3.3, tsm ver 5.1.1.6 tape library - magstar 3590E TSM client - W2k, tsmver 4.2 HBA - Emulex 9802 DC Does anyone have lan-free working in a similar situation? Or maybe just using the same hba? Thanks! pattie liberty mu

Re: How to query if there is data to migrate for a primary storage pool??

2003-06-23 Thread Mr. Lindsay Morris
I think most people use server scripts (or the older way, admin schedules) to set migration up and down daily. Why are you using shell scripts? Typically you'll write a server script that does most of the daily housekeeping jobs, one after the other, and one admin schedule to fire it up at 6 AM.

Re: How to query if there is data to migrate for a primary storage pool??

2003-06-23 Thread Lawrence Clark
Not sure what your asking, but Select * from stgpools will give you stgpool data in total. >>> [EMAIL PROTECTED] 06/21/03 05:28PM >>> Hi, Is there a SQL query example, that shows how we can determine if a storagepool has qualifying data that can migrate We have a shell script the lowers t

TSM DB Summary table

2003-06-23 Thread Lawrence Clark
Hi: I'm looking at the contents of the TSM Summary table and the SUCCESSFUL column for backups does not seem to relate to failed or missed nodes. Anyone know how to interpret this column correctly?

Re: Work arounds for files deleted in flight?

2003-06-23 Thread Mr. Lindsay Morris
Chuck, would a missed-files report that grouped them by reason-missed help you? eg: Files Missed for Nodexxx Not found: 562 Changing: 2 Locked: 132 Then of course you'd want to be able to click each line, and drill down to see the actual file names. If y

Re: oops forgot the error message.

2003-06-23 Thread Scott Figgins
Anderson/Group - # lsdev -Cc tape rmt0 Available 1P-08-00-0,0 4.0 GB 4mm Tape Drive rmt1 Available 1P-08-00-2,0 4.0 GB 4mm Tape Drive smc0 Available 1P-08-00-3,0 IBM 7336 Tape Medium Changer # lsdev -Cc adsmtape mt0 Available 1P-08-00-0,0 Tivoli Storage Manager Tape Drive mt1 Available 1P-08-00-2,

Re: oops forgot the error message.

2003-06-23 Thread Scott Figgins
I do have the latest ATAPE 8.2.5.0. Yes you do need it for it to define the SMC0 media changer. I have loaded the AIX ML4 Maintenance Level. The drives work fine with sysback and at the normal AIX level. It's just when I try to setup the library. Thanks for your help for this Newbie at TSM :) Scot

Re: How to query if there is data to migrate for a primary storage pool??

2003-06-23 Thread Zlatko Krastev/ACIT
It depends on your definition of "qualifying storage pool" but it might be worth to look at STGPOOLS table and select from it. Zlatko Krastev IT Consultant "Steve, Taylor" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 22.06.2003 00:28 Please respond to "ADSM: Dis

Re: TCP/IP socket error

2003-06-23 Thread Joni Moyer
The clients that this is occurring on are Sun Solaris client OS level 5.8, client version 5.1.5.0. The idletimeout value is set to 60 and I'm not quite sure where to find the tcpwindowsize. I have looked through the server activity log and I have found nothing out of the ordinary. It appears tha

Re: Registered

2003-06-23 Thread Andrews, Bert A
I would like to tbe registered agaain. -

Work arounds for files deleted in flight?

2003-06-23 Thread Chuck Mattern
Ever since we transitioned from adsm v3 to adsm v4 we have encountered an extremely high "failure rate". Essentially when adsm went from backing up Unix filesystems like tar (see a file; get a file) to doing ti like dump (build a list of files; go back and backup the list) we began taking what I d

Re: TCP/IP socket error

2003-06-23 Thread Richard Sims
>Our TSM server was upgraded from 4.1.5 to 5.1.6.2 on os/390 and ever since >then I have been noticing the following errors on the clients. Has anyone >seen this? Is there a known fix? > >06/21/03 16:57:57 ANS1005E TCP/IP read error on socket = 5, errno = 131, >reason : 'Connection reset by pee

TCP/IP socket error

2003-06-23 Thread Joni Moyer
Hello! Our TSM server was upgraded from 4.1.5 to 5.1.6.2 on os/390 and ever since then I have been noticing the following errors on the clients. Has anyone seen this? Is there a known fix? 06/21/03 16:57:57 ANS1005E TCP/IP read error on socket = 5, errno = 131, reason : 'Connection reset by p

Re: Questions Regarding Backup Of UDB (DB/2) Databases

2003-06-23 Thread Lambelet,Rene,VEVEY,GL-CSC
Jeff, have you checked in the summary table about the statistics of DB2 backups ? Do you get the number of bytes tranferred, compression data ? René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center

Questions Regarding Backup Of UDB (DB/2) Databases

2003-06-23 Thread Jeff White
Hi, I have started testing backup of DB2 databases on one of our NT servers and as a result i have two small problems. Firstly, i can run an ONLINE backup via the DB2 Control Center GUI ok and when i run a 'show version' via the TSM server, i can see the object as having being backed up. However,

help:sprectralogic library element

2003-06-23 Thread 黎明
Hi all,I have a sprctralogic 12k with two logical library,the library 1 I want to manage it usr TSM,this library with only one SONY AIT-3 driver in slot 2.But when I want to define this driver ,the element 646,647 and 80,81 all inavailable.What element I shoule choose? Thanks. [EMAIL PROTECTED]

Re: oops forgot the error message.

2003-06-23 Thread Zlatko Krastev/ACIT
He does not need to use Atape for 7336, but `lsdev -Cc tape` output might reveal some other problems. So the Anderson's approach is better :-)) Zlatko Krastev IT Consultant Dan Foster <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 23.06.2003 07:02 Please respond t