Re: URGENT: TSM database problem

2003-12-31 Thread Coats, Jack
Thanks to all, Wanda, Richards, Andrew and Mitch! This list is the best! The guy at IBM support was sympathetic but of course, no support due to long time out of date software. (It is not his fault, and he was really nice about it) Well I didn't use mirroring - but will soon ... just after this

Re: URGENT: TSM database problem

2003-12-31 Thread Mitch Sako
It's not the end of the world, but sometimes it feels that way... My Linux server decide to hang a few days ago. I tried both sides of the mirror to no avail. Lots of ugly stuff in the dumpdb like: ANR4013I DUMPDB: Dumped 344244433 database entries (cumulative). ANR0207E Page address mismatch de

Re: URGENT: TSM database problem

2003-12-31 Thread Andrew Raibeck
Jack, it sounds like you are running an unsupported server version, so getting formal support may be difficult. Are your database volumes mirrored? If so, TSM tries to read the correct page from a mirror. The wisdom of other posts on this subject is worthwhile. Barring that, you are probably look

Re: URGENT: TSM database problem

2003-12-31 Thread Prather, Wanda
I believe when this happened to me once on TSM 4, I got around it by shutting down the primary copy of the DB and coming up with just the mirror copies. If you don't have a mirror, the sev1 is the way to go.. -Original Message- From: Coats, Jack [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: URGENT: TSM database problem

2003-12-31 Thread Richard Sims
>ANR0207E Page address mismatch detected on database volume... Your database is corrupted. (Was TSM mirroring in effect, as recommended in the Admin Guide?) You may have to restore the db, per http://www-1.ibm.com/support/entdocview.wss?uid=swg21155009 Richard Sims, BU

Re: URGENT: TSM database problem

2003-12-31 Thread Coats, Jack
Thanks Brian. The volume it is on is a RAID5 volume and yes, it is till accessable. No changes were made to the database. Earlier today I got some messages indicating that the 'server is out of space'. The recovery log was at 103% of its available size. I added

Re: SQL statement

2003-12-31 Thread Andrew Raibeck
Hi Eric, There is no such table that gives you detailed information on which files were restored. The SUMMARY table will give you basic statistics about restores (SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE') but that's about it. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Ma

Re: URGENT: TSM database problem

2003-12-31 Thread ZENG Brian (800043)
1. Check hw status of DB4.DBV and see if the hard disk still visible to the TSM Server 2. Any recent change to your TSM DB in terms of the disk pool configuration? 3. If HW OK and no recent change, try to re-boot your TSM Server Good luck, Brian -Original Message- From: Coats, Jack [mailt

URGENT: TSM database problem

2003-12-31 Thread Coats, Jack
12/31/2003 10:45:58 ANR0207E Page address mismatch detected on database volume D:\TSMDATA\SERVER1\DB4.DBV, logical page 2980223 (physical page 160383); actual: 2973949. 12/31/2003 10:45:58 ANRD iccopy.c(1586): ThreadId<28> Unable to read from

Re: SQL statement

2003-12-31 Thread John Monahan
Operational Reporting gives you information on restore and retrieve operations, but I'm not sure how it pulls that information. __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.co

Re: SQL statement

2003-12-31 Thread Richard Sims
'>Do you really think storing this information will have such a large impact >on the database? Storing restore information shouldn't use more database >space than storing backup information? Yes...because restorals can be performed over and over again on the same data, and because of the nature of

Re: SQL statement

2003-12-31 Thread Loon, E.J. van - SPLXM
Hi Richard! Do you really think storing this information will have such a large impact on the database? Storing restore information shouldn't use more database space than storing backup information? If the accounting records are the only source to obtain this information, I'm out of luck, because I

Re: 3584 LTO1 new firmware installed : 36UC

2003-12-31 Thread Dan Foster
Hot Diggety! Lambelet,Rene,VEVEY,GL-CSC was rumored to have written: > > we just upgraded the firmware for our LTO1 drives in the 3584. Version in > now 36UC instead of 36U7. The bad bug (ask your CE about it please, if > you are using 36U7) should be fixed now!! (Library is still at firmware > lev

Re: SQL statement

2003-12-31 Thread Richard Sims
>I'm looking for an SQL statement which returns all restores (nodes and >filenames) done by my clients. >I'm not much of an SQL wizard, so maybe someone is willing to help me or >give me a hint? Eric - I don't believe that such capability exists. Certainly, storing minutiae like that would

Re: 3592 Media Availability

2003-12-31 Thread Hart, Charles
We are in the midst of converting from 3590 to 3592's. We purchased 22 3592's and 900 3592 Carts via our IBM reseller. According to our IBM partner 3592 tapes are available through IBM till Feb/March 04. From then on they should be available from Fuji and Imation. (The tape media developed by

Re: SQL statement

2003-12-31 Thread Loon, E.J. van - SPLXM
Hi Kurt! That's what I thought too (in fact I issued a select * from restores) but it returns a "No match found using this criteria" while I performed a restore myself this morning... Thanks! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Kurt Beyers [mail

Re: SQL statement

2003-12-31 Thread Kurt Beyers
Eric, 'select node_name, filespace_name, filespec from restores' should give the wanted information. best regards, Kurt >- Oorspronkelijk bericht - >Van : Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] >Verzonden : woensdag , december 31, 2003 12:33 PM >Aan : [EMAIL PROTECTED] >Onde

SQL statement

2003-12-31 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm looking for an SQL statement which returns all restores (nodes and filenames) done by my clients. I'm not much of an SQL wizard, so maybe someone is willing to help me or give me a hint? Thank you very much in advance Kindest regards, Eric van Loon KLM Royal Dutch Airlines ***

AW: Backing up DBs around the globe

2003-12-31 Thread Bleicher, Thomas
Hello and sorry for my late reply. Steven Pemberton wrote: > > Have you considered saving the DB backup to a local file > device class, then > later simply copy the DB backup file to Oz? > > You could also compress the DB backup file before sending it > around the world. Indeed, I thought alo

SPECTRA LOGIC 12k

2003-12-31 Thread Ray Baughman
I'm woundering if anyone is using TSM with a SPECTRA LOGIC 12k, or 20k library, and if so are there any problems associated with it? Thanks in advance Ray Baughman TSM & Engineering Systems Administrator National Machinery LLC Phone 419-443-2257 Fax 419-443-2376 Email [EMAIL PROTECTED]