Re: SQL querying

2008-07-30 Thread Loon, E.J. van - SPLXM
also do the trick. Regards. Norman Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 23/07/2008 16:35 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] SQL querying Hi *SM-ers! I'm

Re: SQL querying

2008-07-24 Thread Loon, E.J. van - SPLXM
:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL querying On Wednesday 23 July 2008, Loon, E.J. van - SPLXM wrote: Hi *SM-ers! I'm trying to create an SQL query to extract failed files from the activity log. When I do a select * from actlog all goes well, but as soon as I replace

Re: TSM upgrade to 5.5.1

2008-07-23 Thread Loon, E.J. van - SPLXM
Hi guys! I decided to open a PMR for the TSMOR bug and support told me there already is an open APAR for this problem: APAR= IC57290 SER= ANR2906E UNEXPECTED SQL LITERAL TOKEN - 'RUS' ERROR FROM OPERATIONAL REPORTING ERROR DESCRIPTION: The following select statement is issued for Operational

SQL querying

2008-07-23 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm trying to create an SQL query to extract failed files from the activity log. When I do a select * from actlog all goes well, but as soon as I replace the * with things like nodename, date_time, message to filter the output, the query becomes slower and slower. Is there a

Re: Snaopshot failure

2008-07-22 Thread Loon, E.J. van - SPLXM
Hi Tim! Could this Technote be related? http://www-1.ibm.com/support/docview.wss?uid=swg21306799 Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: dinsdag 22 juli 2008 15:13 To:

Re: TSM upgrade to 5.5.1

2008-07-18 Thread Loon, E.J. van - SPLXM
Hi Phil! Same here! It seems to be a bug in TSMOR 5.5.1. I didn't feel like reporting it to IBM (I know, I know, not very helpfull of me) so I went back to the 5.4 version. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager

Rebuilding a volume history file

2008-07-04 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! The filesystem which contains my volume history file was filled to 100% last night, so TSM reported I/O errors while writing to it. I have had the filesystem enlarged, but now I have a volume history file which is missing data. Is there a way to rebuild a volume history file? Thank you

Re: Rebuilding a volume history file

2008-07-04 Thread Loon, E.J. van - SPLXM
Of TSM User Sent: vrijdag 4 juli 2008 13:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: Rebuilding a volume history file BAckup VOLHistory On Fri, Jul 4, 2008 at 8:02 AM, Loon, E.J. van - SPLXM [EMAIL PROTECTED] wrote: Hi *SM-ers! The filesystem which contains my volume history file was filled

Re: Rebuilding a volume history file

2008-07-04 Thread Loon, E.J. van - SPLXM
Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: vrijdag 4 juli 2008 14:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: Rebuilding a volume history file On Jul 4, 2008, at 8:29 AM, Loon, E.J. van - SPLXM wrote: Hi! I don't

Linux BMR

2008-05-29 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! Our Linux guys are trying to find a way to do bare metal restores on Linux (Redhat) while using TSM. I was wondering how other companies have implemented this. I there a supported/documented way to do this? Thank you very much for any response in advance! Kindest regards, Eric van Loon

Speeding up my SQL query

2008-05-16 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message,

Re: Speeding up my SQL query

2008-05-16 Thread Loon, E.J. van - SPLXM
- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, May 16, 2008 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Speeding up my SQL query Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report

Re: Speeding up my SQL query

2008-05-16 Thread Loon, E.J. van - SPLXM
Hi Richard! Thank you very much for your reply! Since I'm not much of an SQL wizzard, could you please help met with rebuilding the query? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of

Re: Fantasy TSM

2008-05-06 Thread Loon, E.J. van - SPLXM
Amen, amen amen!!! I still use the good old GUI which still works as long as you don't click on the storagepools option. (a q stgpool format=gui returns an internal error). New TSM customers really should take a look at it (It's part of the Windows 3.1 client and can be installed separately).

Re: TSM being abandoned?

2008-04-18 Thread Loon, E.J. van - SPLXM
Yeehaw? Are you really waiting for an DB2 database? The TSM database is now very stable and hardly needs any attention. I'm running quite a few product over here which are using a pre-defined DB2 database, but although IBM sells them as install and forget I have never seen a DB2 database run for

Re: 5.4 performance issues

2008-03-20 Thread Loon, E.J. van - SPLXM
Hi Remco! What if you cannot restore a file? IBM will tell you to upgrade the client to a supported level, which you will do. Now you still cannot restore the file. Now IBM will tell you, well, the file was backed up with an unsupported client version. Bad luck... And also, most companies don't

Re: Upgrading TSM on an AIX server running multiple TSM instances

2008-01-22 Thread Loon, E.J. van - SPLXM
Hi Richard! In fact it does. Thank you very much! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: maandag 21 januari 2008 19:26 To: ADSM-L@VM.MARIST.EDU Subject: Re:

Upgrading TSM on an AIX server running multiple TSM instances

2008-01-21 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm running two TSM server instances on an AIX host. Upgrading them from 5.3 to 5.4.0.0 works fine. I installed the 5.4.0.0 code through smitty, changed the /usr/tivoli/tsm/server path to the second instance and install the 5.4.0.0 code here, using the force (-F) flag. Both instances

Re: TSM v5.5 feedback: problems? plusses?

2008-01-17 Thread Loon, E.J. van - SPLXM
Hi Timothy! The first 5.5 patch level has yet to be released, so my guess is we'll have to wait a while before seeing the first maintenance release... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On

TSM locked me out!!!!

2008-01-03 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! After a long time I tried logging on to my test TSM server, but I couldn't. I canceled the server (kill -9) and started it in the foreground. It seemed to be related to an unexpected system date, so here is what I did: accept date ANR2017I Administrator SERVER_CONSOLE issued command:

Re: TSM locked me out!!!!

2008-01-03 Thread Loon, E.J. van - SPLXM
januari 2008 16:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM locked me out Hi Eric Try 'enable sess admin' or 'enable sess all'. //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: den 3 januari 2008 16:14 To: ADSM

Re: TSM locked me out!!!!

2008-01-03 Thread Loon, E.J. van - SPLXM
, Loon, E.J. van - SPLXM wrote: Hi *SM-ers! After a long time I tried logging on to my test TSM server, but I couldn't. I canceled the server (kill -9) and started it in the foreground. General Unix advice: Always do a simple 'kill PID' on a process (which is equivalent to 'kill -TERM PID

Re: Strange difference between Primary and Copypool

2007-12-14 Thread Loon, E.J. van - SPLXM
114 LTOLIB7 DbBackupPrivate 3 Larry Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 12/12/2007 05:05 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re

Re: Strange difference between Primary and Copypool

2007-12-12 Thread Loon, E.J. van - SPLXM
copy than primary tapes? I would think the tape count could swing the other way. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, December 11, 2007 8:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L

Re: Strange difference between Primary and Copypool

2007-12-12 Thread Loon, E.J. van - SPLXM
Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, December 11, 2007 8:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Strange difference between Primary and Copypool Hi Jim! My copy pool is an online copy pool. Tapes

Re: Strange difference between Primary and Copypool

2007-12-12 Thread Loon, E.J. van - SPLXM
that there is a different number of tapes. Has there always been more copy than primary tapes? I would think the tape count could swing the other way. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday

Strange difference between Primary and Copypool

2007-12-11 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I found something very strange on one of my TSM servers. When I issue the following command: select stgpool_name as Storagepool,sum(physical_mb) as MB from occupancy group by stgpool_name I recieve the following output: Storagepool MB --

Re: Strange difference between Primary and Copypool

2007-12-11 Thread Loon, E.J. van - SPLXM
Hi Jim! My copy pool is an online copy pool. Tapes (in fact virtual tapes) are not checked out, nor removed from the (virtual) library. I didn't state that my copy pool is larger than the primary pool (hence my line although the copy pool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!!)

Re: Sizing virtual tapes

2007-11-29 Thread Loon, E.J. van - SPLXM
I agree with John. We are currently using 100Gb. volumes in out DL700, but I'm frequently called by user who's restore seems to hang. In most cases the tape is in use by another restore or in use by a backup storagepool/reclamation which first has to finish the file it's backing up or reclaiming.

Re: DP for SQL Server full backup failure

2007-11-28 Thread Loon, E.J. van - SPLXM
Hi Del! I asked our SQL guy to send me his tdpsql.cfg file. It contains the following: BUFFers 3 BUFFERSIze 1024 FROMSQLserver KL109FLE SQLAUTHentication INTegrated SQLBUFFers 0 SQLBUFFERSIze 1024 SQLSERVer KL109FLE STRIPes 1 LOGFile tdpsql.log

DP for SQL Server full backup failure

2007-11-27 Thread Loon, E.J. van - SPLXM
Hi TSM-ers! One of our SQL Server 2005 (running DP for SQL Server 5.3.3.0) the full backup fails every time. In the tdpsql.log we see the following messages: 11/23/2007 02:26:44 ACO5436E A failure occurred on stripe number (0), rc = 428 11/23/2007 02:26:44 ACO5407E The SQL server aborted the

Re: DP for SQL Server full backup failure

2007-11-27 Thread Loon, E.J. van - SPLXM
Hi Del! Thank you very much for your reply!!! I assume these paramaters all have to be specified in the TDP option file? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent:

Re: DP for SQL Server mirroring

2007-11-15 Thread Loon, E.J. van - SPLXM
Hoi Del! I understand that using the same TSM node for backing up the Principal and the new Principal after a take-over is a solution. So: if ServerA is the principal, one has to execute the backup script on this server. After a take-over, ServerB becomes the principal and one has to execute the

Re: DP for SQL Server mirroring

2007-11-15 Thread Loon, E.J. van - SPLXM
Hi Del! I think our SQL guys will go for the second solution. We use a third-party scheduling tool (Control-M) and failing backups will create a problem report. I will forward your suggestion to them. Again, thank you very much for your reply! Kindest regards, Eric van Loon KLM Royal Dutch

Re: DP for SQL Server mirroring

2007-11-14 Thread Loon, E.J. van - SPLXM
Hi Del! Let's say ServerA is the Principal and ServerB is the Mirror. Normally you would schedule a DP backup on ServerA. The (mirror-)database on ServerB is running in a state which doesn't allow backing up (restore mode?) Now there is a take-over and ServerB becomes the new Principal. Now you

DP for SQL Server mirroring

2007-11-13 Thread Loon, E.J. van - SPLXM
Hi TSM-ers! One of my SQL colleagues asks me whether DP for SQL Server supports the SQL Server 2005 Database Mirroring feature. My first thought was to check the manual Data Protection for Microsoft SQL Server Installation and User's Guide Version 5 release 2, but the word mirroring isn't

Re: DP for SQL Server mirroring

2007-11-13 Thread Loon, E.J. van - SPLXM
Hi Del! Thank you very much for your reply! I thought this was a feature which the backup software should be aware of, but apparently not (I'm the TSM Server guru ;-) and definitely not the TDP guru, you know). I will forward your answer to our SQL guys. Thanks again! Kindest regards, Eric van

Re: DP for SQL Server mirroring

2007-11-13 Thread Loon, E.J. van - SPLXM
Hi Del! I just spoke with the SQL guy and his question is a little bit more clear to me now. The database is running on the Principal and a copy is running on the Mirror. The database is backed up on the Principal. After a take-over the Mirror becomes the new Principal, so the backup should be

Cannot add server to TSMReporter

2007-07-12 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm trying to add a new TSM server to the TSM Operational Reporter, but when I right-click the tree, the Add a New TSM Server option is grayed out... Does anybody know what could be causing this? Thank you very much in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines

DP for SQL Server manual

2007-07-10 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! When I visit the IBM Information Center website and select the Tivoli Storage Manager for Database 5.4 set, I only see a Data Protection for SQL Server manual, version 5.2. DP for SQL Server 5.3 has been around for a while, hasn't it? Does anybody know where to find a more recent DP

Re: DP for SQL Server manual

2007-07-10 Thread Loon, E.J. van - SPLXM
Hi Del! Hmm... This manual is dated September 2003 and doesn't mention a word about how to handle SQL Server 2005 database mirroring. Is there a white paper about how to backup a SQL Server 2005 with database mirroring? Thank you very much for your reply Kindest regards, Eric van Loon KLM

Re: DP for SQL Server manual

2007-07-10 Thread Loon, E.J. van - SPLXM
Hi Del! I will forward this information to our SQL guys. Thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 10 juli 2007 15:43 To:

SQL 2005 Database mirroring

2007-07-06 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! One of our SQL guys asked me whether TDP for Databases supports SQL 2005 Database Mirroring. I don't know any technical details about this feature (I'm 'just' a TSM admin;-) but he says it's a SQL Server 2005 (64-bit) with a principal and a passive mirror server, which is running in a

Re: How to change the default idle timeout for dismounting volumes

2007-06-15 Thread Loon, E.J. van - SPLXM
Hi William! UPDate DEVclass deviceclassname MOUNTRetention=amount of minutes Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Kyndt Sent: vrijdag 15 juni 2007 15:20 To:

Re: TSM DB Restore

2007-04-04 Thread Loon, E.J. van - SPLXM
Hi! You probbably have no mount points available. Checkout technote 1083695: http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7uid=swg21 083695loc=en_UScs=utf-8lang=en Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager

Re: Ramifications of delete vol xxxxxx discardd=y

2007-03-09 Thread Loon, E.J. van - SPLXM
Well... Only if the tape contains data from a BA client. If the tape contains TOP data, you will have to reschedule a full database backup for that client. If you have a read-only tape you should check the tape by moving it's data to a new tape, using the MOVE DATA command. If it fails, you can

Re: Determining What tapes files are on

2007-03-05 Thread Loon, E.J. van - SPLXM
Well, not using documented commands that is... If you issue the following SQL statement to retrieve the file's object id: select * from backups where node_name='your nodename' and filespace_name='\\your nodename\driveletter$' and hl_name='\directory path\' and ll_name='filename' you can use the

Re: Error restoring SQL database

2007-02-14 Thread Loon, E.J. van - SPLXM
Hi Andy! No, the log isn't showing more detail. Together with support, I have identified the tapes on which the backup resides. I'm currently running an audit on these tapes. Let's wait for the results... Thanks for now! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original

Error restoring SQL database

2007-02-13 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! Our SQL guys are trying to restore a SQL database. They receive the following error: ANS1314E File data currently unavailable on server In the TSM activity log I see the following message: ANR0548W Retrieve or restore failed for session 2337961 for node KL1007W9-SQL (TDP MSSQL

Re: TSM Server password expired

2007-02-02 Thread Loon, E.J. van - SPLXM
Hi Pablo! You will have to kill the TSM server and start it in the foreground (dsmserv). Then you will be able to reset your password by issuing the upd admin command. Then switch the server to the background, if your OS allows you top do so. Otherwise, halt your server and restart it again in the

Re: Interesting...

2007-01-22 Thread Loon, E.J. van - SPLXM
Hi Nick! The error occurred on several files on multiple filesystems. The audits didn't fix the problem since they seemed to crash somewhere. The audit process started, but there was never a process completed message and a q proc, a few seconds after the started, showed no running processes...

FW: Return code 650?

2007-01-19 Thread Loon, E.J. van - SPLXM
Hi Andy! You're right, I should be more specific. I'm running the 5.3.4.0 client on a Windows XP Pro SP2 workstation. I don't have a dsmsched.log, since I backup my pc manually every now and then. You will find the dsmerror.log and my dsm.opt below this message. I'm performing an incremental

Re: FW: Return code 650?

2007-01-19 Thread Loon, E.J. van - SPLXM
Hi Andy! Scenario 1: no error messages. Scenario 2: no error messages. Scenario 3: The ANS1376W re-occurred, but only once. Please let me know if I can help you further with this. Thanks! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor

Interesting...

2007-01-19 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I have got an interesting situation here. Please have a look at the following entries and TSM's response. DELETE VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2406E DELETE VOLUME: Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 still contains data. Ok, so the volume isn't

Re: Interesting...

2007-01-19 Thread Loon, E.J. van - SPLXM
] On Behalf Of David E Ehresman Sent: vrijdag 19 januari 2007 18:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: Interesting... Try Audit Volume The problem seems to go away with current code levels. Loon, E.J. van - SPLXM [EMAIL PROTECTED] 1/19/2007 12:02 PM Hi *SM-ers! I have got an interesting

Return code 650?

2007-01-18 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! Today I encountered some warnings during the backup of my pc. For several files and directories I see the following messages in the dsmerror.log: ANS1327W The snapshot operation for 'C:\AUTOEXEC.BAT' failed with error code: 650. The client was unable to obtain a snapshot of the file

Re: Return code 650?

2007-01-18 Thread Loon, E.J. van - SPLXM
Hi Andy! Can you explain what's causing the message you are reffering to (The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support)? If TSM wasn't able to obtain a snapshot, a user would like to know why... Also, it's only issued for a few

Re: Cross system restore problems

2007-01-08 Thread Loon, E.J. van - SPLXM
Hi Thomas! Cross-client restore is not supported. That's probably why these messages are not to be found in the messages manual. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier

[no subject]

2006-12-18 Thread Loon, E.J. van - SPLXM
Hi Kerry! This means that the volume is not a scratch volume, probably because it's still in TSM's volume inventory. Check the volume's current status by issuing a q vol 00022 f=d. If you are using DRM, you should use the DRM commands to return the volume. Kindest regards, Eric van Loon KLM Royal

Re: Survey Question for Virtual Tape Users: What Vendors are you using for Virtual Tape?

2006-12-07 Thread Loon, E.J. van - SPLXM
My 2 cents: There is on big advantage for using a VTL over a disk subsystem: compression. We are also using a EMC DL700 which uses in-the-box LTO compatible compression. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager

Dutch TSM User Group day November 23rd

2006-10-27 Thread Loon, E.J. van - SPLXM
To all Dutch TSM users, On November 23rd. We will organize a Dutch TSM User Group event with the following subjects: - TSM 5.4 - Update TSM products (roadmap) - Virtual Tape Library or devclass=file? - HSM Windows demo (Caminosoft) - Reporting, compliance and TSM (Sox etc.) Location is not yet

Re: TDP for Oracle filesets

2006-10-17 Thread Loon, E.J. van - SPLXM
Hi Charles! The missing bos.rte v5 message means that you are trying to install AIX 5.x software on an older AIX OS. What level of AIX are you running and what is the Oracle level? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager

Dsmc output on AIX sometimes contains a crlf

2006-10-12 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! On our AIX clients, the output from the dsmc i command is send to a logfile for further processing. Every now and then, the output from the backup of a file contains a crlf. Instead of: Normal File-- 87,042 /mount/appl00399/lido_apps/lido/etc/0008704600 [Sent] The output looks like

Re: Backup Retention Period

2006-09-27 Thread Loon, E.J. van - SPLXM
Hi Norita! For backups: yes. Backup objects are rebound to the new managementclass during the next backup, so all inactive versions older than 30 days will be removed. Archives are not rebound, so changing retention for archives will not change retention for previously made archives. Kindest

Re: TSM 5.3.0 with SAN

2006-09-19 Thread Loon, E.J. van - SPLXM
Hi Murugan! 1) Yes, you can install it on all clients. I would use the latest version though: 5.3.4.0. 2) Yes, this is possible and documented in the IBM Redbook Backing Up DB2 Using IBM Tivoli Storage Manager (http://www.redbooks.ibm.com/abstracts/sg246247.html?Open) Kindest regards, Eric van

How to upgrade a multiple instance TSM server on AIX

2006-09-08 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! We have an AIX 5.2 server with two TSM instances running on the same AIX partition. We have upgraded the first instance, changed the link to the second instance's install path and rerun SMIT INSTALL to upgrade this instance. The first upgrade runs fine, but I cannot find a way to

Making TSM twin-center compliant

2006-09-01 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! We are about to implement a second (fallback) IT center on another location. The idea is to create a hot standby environment for TSM. We are already using a separate copypool which will be moved to the new remote location, so if the primary pool gets lost, we have all data (up until

Re: Making TSM twin-center compliant

2006-09-01 Thread Loon, E.J. van - SPLXM
Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: vrijdag 1 september 2006 16:00 To: ADSM-L@VM.MARIST.EDU Subject: Re: Making TSM twin-center compliant On Fri, 1 Sep 2006 13:17:17 +0200, Loon, E.J. van

Time format Web admin interface

2006-08-21 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! When I use the 5.2 web admin on one of my TSM servers, the time format is not what I expect it to be. For instance, when I query client events, time is shown as 8:00 PM instead of 20:00. When I query through dsmadmc it is shown as 20:00. Does anybody know where to set the date and time

Re: del filesp with +10Mio files

2006-08-21 Thread Loon, E.J. van - SPLXM
Hi Peter! A delete volume runs as fast (or as slow) as a delete filespace. Actually, it does the very same thing: delete every single object from the database one by one. If the node had it's own tapes, you could mark all it's tapes in both the primary pool and the copy pool destroyed and let

Re: SQL Server 2005 support?

2006-08-08 Thread Loon, E.J. van - SPLXM
Hi Del! Your statement Customer always have the option of not installing a fix release, and waiting for the next PTF or release of that Data Protection client may be true in most cases, but not when new platform support is added. You don't have the option to wait for a new release because you

SQL Server 2005 support?

2006-08-07 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! As far as I can find, DP for SQL Server 5.2.1 is the most recent version for backing up SQL Server databases. It support SQL Server 7.0 and 2000. Does anybody know when SQL Server 2005 will be supported by DP for SQL? Thank you very much for any reply! Kindest regards, Eric van Loon

Re: SQL Server 2005 support?

2006-08-07 Thread Loon, E.J. van - SPLXM
Hi Del! Thank you very much for your quick reply! I wasn't expecting new support in a fix release... Wouldn't it be more logical to create a 5.2.2.0 version containing 2005 support? Now we have to backup production nodes by using a fix release, which I normally would not recommend... Kindest

TDP for SQL configuration error...

2006-06-28 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! We have got one TDP for SQL (5.2.1) client which refuses to cooperate. It's configured like all other TDP clients with a standard dsm.opt file which contains the correct TCPServeraddress. However, as soon as we start the TDP GUI, it returns: ANS1033E (RC-53) An invalid TCP/IP address

Re: TDP for SQL configuration error...

2006-06-28 Thread Loon, E.J. van - SPLXM
[mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Wednesday, June 28, 2006 10:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for SQL configuration error... Hi *SM-ers! We have got one TDP for SQL (5.2.1) client which refuses to cooperate. It's configured like all

Re: actlog errors since upgrade to 5.3.3

2006-05-24 Thread Loon, E.J. van - SPLXM
Hi Lawrence The message is quite self-explanatory: Session 1807 client is down-level - apply IC34693. This APAR can be found at: http://www-1.ibm.com/support/docview.wss?uid=swg1IC34693 Just like Brian suggested, you should upgrade the client to a higher level than 5.1.5.0. The error was fixed in

TDP for SQL tracing

2006-05-02 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I added the trace parameters to the dsm.opt on a client running the DP for SQL Server client. I added the following lines: Tracefile d:\tdptrace\tdptrace.txt Traceflags stats, options, compress Tracemax 100 The tracefile confirmed this: 05/01/2006 21:30:47.745 : Current trace

Re: Installing the Linux client

2006-05-02 Thread Loon, E.J. van - SPLXM
Core 5 and all went well. So if the above is not the case I'd rather suspect a problem in SuSe. Regards, Richard van Denzel. Van: ADSM: Dist Stor Manager namens Loon, E.J. van - SPLXM Verzonden: wo 26-4-2006 10:13 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: Re: [ADSM-L

Trying to tun on tracing in the Windows 5.3 client.

2006-05-01 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm trying to create a trace, using the Windows 5.3.3.0 client. The most recent Trace Facility Guide I could find was SH26-4121-01 for TSM 4.2. I added the following lines to the dsm.opt file: Tracefile c:\temp\trace.txt Traceflags instr When I start dsm.exe, it complains about the

Re: Trying to tun on tracing in the Windows 5.3 client.

2006-05-01 Thread Loon, E.J. van - SPLXM
: Re: Trying to tun on tracing in the Windows 5.3 client. On May 1, 2006, at 8:31 AM, Loon, E.J. van - SPLXM wrote: I'm trying to create a trace, using the Windows 5.3.3.0 client. The most recent Trace Facility Guide I could find was SH26-4121-01 for TSM 4.2. ... Eric - Use the TSM Problem

Re: Installing the Linux client

2006-04-26 Thread Loon, E.J. van - SPLXM
. -Mensaje original- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] En nombre de Loon, E.J. van - SPLXM Enviado el: martes, 25 de abril de 2006 15:40 Para: ADSM-L@VM.MARIST.EDU Asunto: [ADSM-L] Installing the Linux client Hi *SM-ers! One of my Unix colleagues is trying to install the TSM

Re: Installing the Linux client

2006-04-26 Thread Loon, E.J. van - SPLXM
Hi David! He receives the error during the installation of the API package... Guess I will have to open a PMR for this. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent:

Installing the Linux client

2006-04-25 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! One of my Unix colleagues is trying to install the TSM 5.3.3.0 client on a SLES9 distribution. I downloaded the client from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/client/v5r3/Linux/Linux86/v533/ and I delivered him the two packages

Re: Atape 8.4.9.0 and LTO3 tsm 5.1.5

2006-04-24 Thread Loon, E.J. van - SPLXM
Hi Otto! Checkout ftp://ftp.storsys.ibm.com/devdrvr/AIX/Atape.fixlist Ultrium 3 support was added in level 9.0.1.0. Kindest regards, Eric van Loon -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Otto Schakenbos Sent: vrijdag 21 april 2006 19:57 To:

Performance tracing

2006-04-12 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! One of my customers is complaining about the backup performance of the daily DP for SQL Server. The tdpsql.log shows that performance is 15 Mb/sec. which looks very fine to me for a host which is connected to a 100 MB LAN, but the customer showed me the TDP log from December last year

Re: Cleaning Slots on NEO 4000

2006-04-07 Thread Loon, E.J. van - SPLXM
Hi Bill! I don't know the answer, but I can maybe point you in the right direction. You can download the NEO 2000/4000 User Installation Guide from Overland Storage: http://support.overlandstorage.com/jive/entry.jspa?externalID=3518categ oryID=9 Kindest regards, Eric van Loon KLM Royal Dutch

Re: how to define msl 6060 (or neo 4000)

2006-04-06 Thread Loon, E.J. van - SPLXM
Hi Nigel! I haven't got any experience with non-IBM devices, but as far as I know, you will have to use the TSM Device Support driver for non-IBM tape devices. Did you check the IBM technote for the MSL 6000 series? Here it is: http://www-1.ibm.com/support/docview.wss?rs=663uid=swg21116751 Kindest

Re: Random Access Disk Pools

2006-04-06 Thread Loon, E.J. van - SPLXM
Hi Rod! TSM stores backups as aggregates. An aggregate can contain multiple client backup files. The client files within an aggregate will expire over time and thus occupy space within the aggregate. When you use a file device class or a tape, you can reclaim the wasted space these expired files

Re: Impact of APAR IC47731

2006-04-03 Thread Loon, E.J. van - SPLXM
Hi Thomas! For your information: IBM just released all 5.3.3.0 servers on their FTP sites. I checked for you: it contains the fix for APAR IC47731. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On

5.3.3.0 clients available

2006-03-27 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I noticed that the 5.3.3.0 client code has been made available on the FTP server! Request to Andy Raibeck: could you ask the FTP owner to update the /LATEST subdirectories too? They all still contain the 5.3.2.0 code... Kindest regards, Eric van Loon KLM Royal Dutch Airlines

Re: Prognosis for APAR IC45931

2006-03-27 Thread Loon, E.J. van - SPLXM
Hi Thomas! APAR IC47731 was fixed in patch level 5.3.2.3 and IC45931 was fixed in 5.3.2.1. The most recent patch level is 5.3.2.4 and your version can be downloaded from ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/ser ver/Linux/5.3.2.4/s390x/ IBM just released a new client

Re: Unable to archive files when there is no backup copygroup

2006-03-20 Thread Loon, E.J. van - SPLXM
Hi Andy! I was being hit by APAR IC45627. I had a hard time recreating the problem too, because I was using the 5.3.2.0 client, which already contains the fix for this APAR. The customer experiencing the problem was using the 5.3.0.0 base code. I will have him upgrade his version. Thank you very

Re: TDP for Exchange: 0xc7fe1f42

2006-03-16 Thread Loon, E.J. van - SPLXM
Hi Del! Thank you very much for your reply! Yes, they did add the database to the Recovery Storage Group before performing the restore and they did select the this database can be overwritten by a restore option. The Exchange people also checked the storage group name and database name and cannot

Re: TSM 5.3 client release for Netware

2006-03-16 Thread Loon, E.J. van - SPLXM
Hi Jim! The 5.3.3.0 client maintenance release is scheduled to be released somewhere this month. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bollard Sent: woensdag 15 maart 2006 14:11

Unable to archive files when there is no backup copygroup

2006-03-16 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! We have just implemented an archiving server. We only want archives on this TSM server, so we created policies without a backup copy group. This however causes the BA GUI to see all files as excluded. I checked the TSM website and found Technote 1209666

TDP for Exchange: 0xc7fe1f42

2006-03-14 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! A restore of a Exchange 2003 server to a Recovery Storage Group on a recovery server fails with the following message is the tdpexc.log: 03/14/2006 15:25:15 Restore of KL1010WF-SG1 failed. 03/14/2006 15:25:15 ACN5798E MS Exchange API HRESERESTORECOMPLETE() failed with HRESULT:

Re: TSM client API upgrade and TDP for oracle

2006-03-13 Thread Loon, E.J. van - SPLXM
Hi Tae! Not, this is not nessesary. The API client is only used during a backup, so if no backup is running, you can replace all files during installation and no restart is required. However, I would wait a few days before starting the upgrade. The 5.3.3.0 client will be released this month.

Re: Client versions and TSM 5.2.6.4/5.3

2006-03-08 Thread Loon, E.J. van - SPLXM
Hi Wanda! Where did you find a 5.1.8 client for Windows NT? The newest I can find is 5.1.7.0... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: dinsdag 7 maart 2006 19:51

Re: Undo archconversion

2006-03-07 Thread Loon, E.J. van - SPLXM
Hi Chris! What server and client level are you using? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christoph Pilgram Sent: dinsdag 7 maart 2006 7:39 To: ADSM-L@VM.MARIST.EDU Subject: Undo

Re: TSM 5.3 web gui

2006-03-07 Thread Loon, E.J. van - SPLXM
Hi! I totally agree with Richard. I myself was participating in the TSM 5.3 beta program. During this beta a lot (and I really mean a lot) of the people in the beta forum where complaining about ISC and the ISC concept. It wasn't even working in the beginning, it required a powerful server with at

  1   2   3   4   5   6   7   8   >