Re: tape prob

2004-11-19 Thread John Naylor
Hashim, Shukrie asked how to move data from volume 002081 which had multiple read errors without impact on the database Well you can try cleaning the drive, you can try different drives with move data, but if there are real bad sectors on the tape then you will only be able to get any remaining

recovery log utilization is too high

2004-11-19 Thread Roland Scharlau
Hi all, since three days i get following message via : Server name: DESAETSM1, platform: Windows2000, version: 5.2.3.4, date/time: 11/19/2004 11:30:54 Issues and Recommendations -- The max recovery log utilization is too high. Condition (100.0 90) Recommendation:

Re: recovery log utilization is too high

2004-11-19 Thread goc
hi, i think you have to add another rec log volume or issue q log to see how large it is , and that issue extend log with smaller size goran - Original Message - From: Roland Scharlau [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 19, 2004 11:39 AM Subject: recovery log

Domino Transaction files

2004-11-19 Thread Bill Dourado
Hi , I have 59 transaction files in the Transaction Log directory that have creation dates ranging from 04-Nov-2004 to 17-Nov-2004. It's an unusually high amount. Transaction Log Archiving takes place every 4 hours, without any obvious error. I am aware that the Domino Administrator restored a

AW: recovery log utilization is too high

2004-11-19 Thread Roland Scharlau
the result of q log: Available Assigned Maximum MaximumPage Total Used Pct Max. Space Capacity Extension ReductionSizeUsable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util - -

Re: tape prob

2004-11-19 Thread Richard Sims
On Nov 18, 2004, at 9:38 PM, Hashim, Shukrie BSP-ISM/116 wrote: ...Obviously there's something wrong with this tape ... with the read error (495) can anyone tell me a way .. for me to copy or move the data from this tape ... to another .. tape ... Rather than looking at an error count value from

Re: TDP for Oracle

2004-11-19 Thread Loon, E.J. van - SPLXM
Hi Rainer! TDP 5.2 supports Oracle 9.2.0 and higher and I know 10g is supported as of 2nd quarter 2004. But I don't see any TDP (for Oracle) clients for Linux platforms. The only Linux Data Protection client I have seen is scheduled for next year and it will only support Linux390 with Oracle...

unsubscribe

2004-11-19 Thread Jason Couto
*** This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than

Antwort: Re: TDP for Oracle

2004-11-19 Thread Rainer Holzinger
Hi Eric, thank you for your response about my question. I'm having a CD here 'ITSM for Databases - Data Protection for Oracle Version 5.2'. IBM part number is LCD4-4086-04. There is TDPO for AIX, HPUX, Windows and Linux86 on it. I have attached the TDPO for Linux86 README file for you.

Re: TDP for Oracle

2004-11-19 Thread Jurjen Oskam
On Fri, Nov 19, 2004 at 02:19:15PM +0100, Loon, E.J. van - SPLXM wrote: 2nd quarter 2004. But I don't see any TDP (for Oracle) clients for Linux platforms. It does exist, we downloaded ours from the Passport Advantage-site. It's in the same archive as the other platforms. -- Jurjen Oskam

Re: linux restore problem

2004-11-19 Thread Otto Schakenbos
Richard, Mark, thnx for your answers. I tried what you both suggested. restore /daten/ -subdir=yes and restore '/daten/' -subdir=yes all with the same result. (filespace not found) What I also tried is copy the data (the orginal server is still up) using nfs to the new server and back it up from

AW: linux restore problem

2004-11-19 Thread Thomas Rupp
If you do a dsmc query filespace on the linux client what results do you get? Thomas Rupp

Re: select node summary

2004-11-19 Thread Andrew Raibeck
Off-hand, I am not sure why you don't see them. Try searching the table with less restrictive criteria and see what entries exist. For example, select * from summary where entity='BLAH' where BLAH is the name of one of your TDP nodes. Regards, Andy Andy Raibeck IBM Software Group Tivoli

select from actlog VS query actlog performance

2004-11-19 Thread Warren, Matthew (Retail)
Hello TSM'ers I'm doing some scripting that is using actlog queries fairly heavily, I have noticed that Select * from actlog where cast(date_time as date)=current_date and process=1234 Is a lot slower than Q actlog begint=-08:00 se=1234 (say, its 8am in the morning...) Although you need to

NDMP Backup Experiences

2004-11-19 Thread Curtis Stewart
Everyone, I'm about to implement NDMP backups of our NetApp filer and am looking for tips, gotchas etc... Currently, we backup the filer using CIFS and a mount point on a Windows 2000 server. The performance of this method is painfully slow. It takes about 22 hours to complete an incremental

Re: select from actlog VS query actlog performance

2004-11-19 Thread P Baines
Rather the other way round. The SQL is being converted to a native database call. I would presume most query commands would be quicker than their equivalent SQL queries. For tuning SQL queries you can look at the indexing of the columns in a table: select tabname, colname, colno, index_keyseq,

Re: NDMP Backup Experiences

2004-11-19 Thread TSM_User
NDMP was much faster for total throughput for us when compared to a full backup. Remember what is backed up via NDMP must be restored via NDMP. So for you DR plan you need to ensure you have a NetApp device to restore to at your DR site. Make sure you run some restore tests and see how you

Re: select from actlog VS query actlog performance

2004-11-19 Thread Andrew Raibeck
BEGINT=-08:00 starts searching the activity log as of 8 hours from the present time (as opposed to the default, which is 1 hour from the present time). Leave out the '-' if you really mean 08:00 (8:00 AM). The raw TSM server database tables are not row-column format, but more like a B-tree, and

TDP SQL - 'set backups' / out of sync TDP backups

2004-11-19 Thread David McClelland
Guys, To begin, a familiar story for many of you I'm sure - we have a customer who has MSSQL databases, and wants TDP backups going back a month or so. Easy, bread and butter stuff. Happy with this, they want their backups from every Friday to be retained for 4 weeks, and from every 4th Friday to

Re: AW: linux restore problem

2004-11-19 Thread Otto Schakenbos
it tells me tsm q files Num Last Incr Date TypeFile Space Name --- -- --- 1 19.11.2004 08:51:58 EXT3/ 2 19.11.2004 08:51:58 EXT3/boot 3 19.11.2004 08:55:19 EXT3/daten tsm Otto Schakenbos System Administrator TEL:

Re: NDMP Backup Experiences

2004-11-19 Thread Curtis Stewart
How are you managing the tapes? Since you can't use DRM to copy the volumes, I assume you are just ejecting them and manually tracking the tape retention/expiration. [EMAIL PROTECTED] TSM_User [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 11/19/2004 10:20 AM Please

FW: Win2K LANFREE

2004-11-19 Thread Thomas, Matthew
Folks, OPENTEST environment Server - TSM 5.2.3.0 on AIX 5.2 Client - Win2K with StorageAgent 5.2.3.0 and TDP for SQL 2.2 Library - 3494 ATL with two 3590 drives We're currently testing our upgrade process to 5.2.3.x. I've succesfully done an Oracle LANFree (TSM 5.2.3.0 on AIX 5.1) backup to our

ksh here documents for sql cmds

2004-11-19 Thread Richard Rhodes
Be kind . . . . don't laugh tooo hard . . . . I thought I'd share this. I got tired coding dsmadmc cmd line sql cmds like the following in ksh scripts . . . dsmadmc -id=admin -password=admin -tab \ select entity, count\(\*\) \ from summary \ where

Re: NDMP Backup Experiences

2004-11-19 Thread TSM_User
After all our testing it was determined that we were better off using Windows servers instead of a NetApp Filer for windows data. As a Curtis Stewart [EMAIL PROTECTED] wrote: How are you managing the tapes? Since you can't use DRM to copy the volumes, I assume you are just ejecting them and

Re: NDMP Backup Experiences

2004-11-19 Thread TSM_User
After all our testing it was determined that we were better off using Windows servers instead of a NetApp Filer for windows data. Curtis Stewart [EMAIL PROTECTED] wrote: How are you managing the tapes? Since you can't use DRM to copy the volumes, I assume you are just ejecting them and

Re: NDMP Backup Experiences

2004-11-19 Thread TSM_User
After all our testing it was determined that we were better off using Windows servers instead of a NetApp Filer for windows data. We did not complete our discussions on what we would do with the tapes themselves. Curtis Stewart [EMAIL PROTECTED] wrote: How are you managing the tapes? Since

Tape Volume States

2004-11-19 Thread Rob Hefty
Hello all How can a tape be listed in the volumes table as scratch and yet still have a value in the percent utilized column larger than zero? The tapes are old IBM 3575 format and the server is 5.1.6.5 on AIX 5.1. Thanks, Rob

Windows PASSWORD and Multiple TSM servers

2004-11-19 Thread Zoltan Forray/AC/VCU
I have a question about how/where the TSM client stores the PASSWORDACCESS GENERATE password on a W2K box. If a W2K box access multiple TSM servers (e.g. by switching/updating the DSM.OPT file), are the passwords to both TSM servers stored as seperate registry keys so as to not step on each other

Re: Tape Volume States

2004-11-19 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rob Hefty How can a tape be listed in the volumes table as scratch and yet still have a value in the percent utilized column larger than zero? The tapes are old IBM 3575 format and the server is 5.1.6.5 on AIX 5.1. Details,

Client behavior during image backup

2004-11-19 Thread Michael Short
We have a client that runs an AIX script to stop Oracle and Apache, do an image backup of a file space, an incrmental of everything else, and then restart Oracle and Apache. Everything usually works correctly except that sometimes when Oracle starts up the file system done by the image backup is

Re: Domino Transaction files

2004-11-19 Thread Eduardo Esteban
Domino deletes each individual transaction log extent file after it is done applying the transaction in it. If Domino could not delete these files, an error message was probably displayed by Domino's Recovery Manager. I believe you can delete these files since Domino will not reuse these files

Re: Tape Volume States

2004-11-19 Thread Richard Sims
On Nov 19, 2004, at 1:31 PM, Rob Hefty wrote: How can a tape be listed in the volumes table as scratch and yet still have a value in the percent utilized column larger than zero? ... The columns from Select output largely conform to the definitions in the Query commands. If you mean that the

Re: linux restore problem

2004-11-19 Thread Stef Coene
On Friday 19 November 2004 15:15, Otto Schakenbos wrote: Richard, Mark, thnx for your answers. I tried what you both suggested. restore /daten/ -subdir=yes and restore '/daten/' -subdir=yes all with the same result. (filespace not found) What I also tried is copy the data (the orginal

Re: Windows PASSWORD and Multiple TSM servers

2004-11-19 Thread Andrew Raibeck
See my post of 16 November on the Error writing registry password thread where I indicate the location of the registry password. As long as the TSM servers don't have duplicate server names, you can use the same node name to access more than one server without having encrypted passwords stepping

Re: Windows PASSWORD and Multiple TSM servers

2004-11-19 Thread Zoltan Forray/AC/VCU
Thank you. Just what I needed ! Andrew Raibeck [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 11/19/2004 02:27 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Re: Windows PASSWORD and Multiple TSM servers See my

Re: linux restore problem

2004-11-19 Thread Richard Sims
I think Stef has the idea of what's wrong... Are you attempting the restoral across different platforms? As in where the target system does not support the file system type that lived on the source system? (Also: re filespace not found - please supply the full message, including message number.)

Win2k and open file -- revisited

2004-11-19 Thread Sandra
Dear List, I know there was a discussion on this topic but i am not able to find exactly the one i am looking for. And Yes this exact topic was discussed, that I know. I m running TSM Server 5.2.2.5 and Client 5.2.2 both on windows 2000. I m using include.fs for snapshotcachelocation. First time

Re: ksh here documents for sql cmds

2004-11-19 Thread Riley, Craig
You might also like to try the perl module TSM.pm located on CPAN. The modules provides very easy access to TSM . -Craig Riley The Children's Hospital in Denver -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rhodes Sent: Friday,

TSM server start-up under Linux

2004-11-19 Thread Thomas Denier
We have installed a TSM 5.2.2 server under Suse Enterprise Server 8 running on zSeries hardware. The TSM code includes a script named dsmserv.rc which accepts 'start' and 'stop' as arguments in the same way as scripts Suse supplies to control built-in services. The dsmserv.rc script does not

Oracle TDP and RMAN

2004-11-19 Thread Hart, Charles
In working with our Oracle DBA's they feel TSM should manage the RMAN Oracle Retentions etc... Is there a Preferred method? If so why? Here's one of our DBA's response when I told them my understanding is that RMAN usually manages the Backup Retentions etc Note on page 85 of the RMAN

Re: linux restore problem

2004-11-19 Thread Stef Coene
On Friday 19 November 2004 20:39, Richard Sims wrote: I think Stef has the idea of what's wrong... Are you attempting the restoral across different platforms? As in where the target system does not support the file system type that lived on the source system? (Also: re filespace not found -

Re: Oracle TDP and RMAN

2004-11-19 Thread Stapleton, Mark
Please read the TDP for Oracle manual. It indicates that that you should have your TSM retention set at 1,0,0,0. Set your Oracle management class with those retentions, and Oracle will handle deletion of unneeded backups. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office

TSM client for Solaris x86

2004-11-19 Thread Lance Nakata
Has anyone heard if there are plans to release a TSM 5.x client for Solaris x86 to complement the SPARC version? If so, when might that occur? I've heard Sun say that many developers can take their SPARC source code (except perhaps device drivers) and compile a working Solaris app on Intel/AMD.