Re: corrupted db on test system

Hi David! Sql code 1117 means SQLE_RC_ROLLFWD_PEND ( -1117 ). From the message manual: SQLE_RC_ROLLFWD_PEND ( -1117 ) indicates a database Roll Forward operation is pending and must complete before activating the database. After the Roll Forward recovery step is complete, the database can be acti

Cristie BMR vs Tivoli Fastback for BMR

Fellow TSM-ers, We are looking for a bare machine recovery, primarily for Windows and Linux servers. There seem to be two main products on the market when using TSM: Tivoli's own Fastback for Bare Machine Recovery and the third party product Cristie Bare Machine Recovery which seems to be tightl

Re: corrupted db on test system

ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: Monday, November 17, 2014 10:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] corrupted db on test system Hi David! Sql code 1117 means SQLE_RC_ROLLFWD_PEND ( -1117 ). From the message m

Re: Cristie BMR vs Tivoli Fastback for BMR

hitect, IT, Ahli United Bank > Kuwait, www.ahliunited.com.kw > > > -Original Message----- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of Loon, EJ van (ITOPT3) - KLM > Sent: 18 11 2014 11:30 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Cr

Re: Cristie BMR vs Tivoli Fastback for BMR

Hi TSM-ers! Thank you all for your helpful replies to my question. It saved me a of research! Kind regards, Eric van Loon AF/KLM Storage Engineering For information, services and offers, please visit our web site: http://www.klm.com. This

Weird SQL output

Hi guys! I have some weird output from one of my SQL statements. Here it's is: select count(*) from libvolumes where status='Private' Unnamed[1] 3698 Ok, so 3698 private volumes on this server. Now, how many contain data: select count(*) from libvolumes where status='Priva

Re: Weird SQL output

en checkin tapes the parameter last_use can be lost. If you want to check private tapes without the data, try to use select like this: select volume_name from libvolumes where status='Private' and last_use is NULL and volume_name not in (select volume_name from volumes) Efim 2014

Re: Weird SQL output

kupset (select volume_name from volhistory where type='BACKUPSET') Efim 2014-11-21 16:02 GMT+03:00 Loon, EJ van (ITOPT3) - KLM : > Hi Efim! > Since we don't checkout tapes it won't be an issue for us. Apart from that, > it still doesn't explain why the total of

SQL for highest volume label in library

Hi TSM-ers! Does anybody know a SQL statement to retrieve the highest volume label of all tapes in a library? Is it possible with one single SQL query? Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering F

Re: SQL for highest volume label in library

at 03:41:23PM +, Loon, EJ van (ITOPT3) - KLM wrote: > Hi TSM-ers! > Does anybody know a SQL statement to retrieve the highest volume label of all > tapes in a library? Is it possible with one single SQL query? > Thanks for any help in advance! -- -- Skylar Thompson (skyl...@u.wa

archive and directory management class

Hi guys! I have hardly used the archive command myself but one of my customers now tries to archive some data for 5 years. He specifies the -archmc= commandline parameter and all files are correctly bound to the 5 years management class. The directories however are bound to the default managemen

[pvrAcquireSharedMountPoint]:rc=15 from libmanager=QVIP2

Hi guys! I have an ancient Linux node (RHEL4) running an unsupported (but latest) lin_tape 1.66 and an also unsupported (but latest) TSM 5.5.4. LANfree backup doesn't work anymore, but I can't find the reason why. Since the whole stack is out of support there is no sense in opening a PMR... I st

Re: [pvrAcquireSharedMountPoint]:rc=15 from libmanager=QVIP2

Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ryder, Michael S Sent: vrijdag 20 februari 2015 15:44 To: ADSM-L@VM.MARIST.EDU Subject: Re: [pvrAcquireSharedMountPoint]:rc=15 from libmanager=QVIP2 Hi Eric: On Fri, Feb 20, 2015 at 9:34 AM, Loon, EJ van (ITOPT3

Re: [pvrAcquireSharedMountPoint]:rc=15 from libmanager=QVIP2

ag 20 februari 2015 15:51 To: ADSM-L@VM.MARIST.EDU Subject: Re: [pvrAcquireSharedMountPoint]:rc=15 from libmanager=QVIP2 This might be of help as well. www.urz.uni-heidelberg.de/UnixCluster/Hinweise/Hilfe/.../anrcms50.pdf >>> "Loon, EJ van (ITOPT3) - KLM" 2015-02-20 9:3

re-adding (virtual) tape drives in Linux

Hi TSM-ers! I'm still struggling with a few LANFree clients on Linux which cannot mount tapes. I would like to remove the drives on them and re-add them afterwards. I know how to do this in AIX (rmdev followed by a cfgmgr) but I cannot find instructions on how to do this on Linux. All manuals ta

5.5 LANfree together with a 7.1 server

Hi guys! We have several RedHat 4.x LANfree clients (TSM StorageAgent 5.5.4.0 and lin_tape 1.66), currently using a TSM 6.2.6 server for the mounts. Since 6.2 will be out of support very soon we need to upgrade to 7.1. Is anybody successfully using the 5.5 Linux StorageAgent in combination with a

Re: 5.5 LANfree together with a 7.1 server

upgraded to the same lvl if needed. Kind regards, Karel Op 3 mrt. 2015 15:09 schreef "Loon, EJ van (ITOPT3) - KLM" < eric-van.l...@klm.com>: > Hi guys! > We have several RedHat 4.x LANfree clients (TSM StorageAgent 5.5.4.0 > and lin_tape 1.66), currently using a TSM 6.2.6

Linux permissions not restored

Hi guys! Yesterday someone accidentally changed permissions on one of our Lotus Notes servers. A new backup was made yesterday evening, but we cannot restore the file with the old permissions. The client shows only one active file in TSM (backup date 05/17/2013) and when this one is restored the

Re: Linux permissions not restored

Tivoli%20Storage%20Manager "ADSM: Dist Stor Manager" wrote on 2015-03-12 10:25:47: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2015-03-12 10:26 > Subject: Linux permissions not restored Sent by: "ADSM: Dist Stor > Manager" >

Delete object

Hi guys! In the TSM 5.x days I used the delete object command to remove individual files from a TSM server. I used this in case I could not delete all data for a client, for instance where a database was removed from a client without deleting the data from TSM first. In this case tdposync won't

Data Protection for Microsoft SQL Server 7.1.2

Hi TSM-ers! On the IBM page http://www-01.ibm.com/support/docview.wss?uid=swg21882505 I find information about "Hardware and Software Requirements: Version 4.1.2 FlashCopy(r) Manager for SQL Server & 7.1.2 Data Protection for Microsoft SQL Server". However, I cannot find any TDP for SQL Server 7

Re: Data Protection for Microsoft SQL Server 7.1.2

data protection Durham, NC 27703 aprob...@us.ibm.com "ADSM: Dist Stor Manager" wrote on 04/16/2015 10:31:41 AM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 04/16/2015

Re: Data Protection for Microsoft SQL Server 7.1.2

2 SU1 Redistributable (both x86 and x64 versions). I told it to continue eventhough both C++ installs failed and it seems to be running ok. On Fri, Apr 17, 2015 at 3:50 AM, Loon, EJ van (ITOPT3) - KLM < eric-van.l...@klm.com> wrote: > Hi Angela! > I found it on Passport Advantage today, t

Re: Data Protection for Microsoft SQL Server 7.1.2

ADSM: Dist Stor Manager" wrote on 04/17/2015 03:50:55 AM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 04/17/2015 03:53 AM > Subject: Re: [ADSM-L] Data Protection for Microsoft SQL Server 7.1.2 > Sent by: "ADSM: Dist Stor Manager"

Re: Data Protection for Microsoft SQL Server 7.1.2

most directory (perhaps that is the problem since it kept > talking about a Demo?). The installer attempts (and fails) to install > Microsoft Visual > C++ 2012 SU1 Redistributable (both x86 and x64 versions). I told it > C++ to > continue eventhough both C++ installs failed and

Error when upgrading the 7.1 Linux client

Hi TSM-ers! Has anybody been able to upgrade their 7.1 Linux client to 7.1.2.0 on RedHat 5? When I try to upgrade it I receive the following error: error: Failed dependencies: rpmlib(FileDigests) <= 4.6.0-1 is needed by TIVsm-filepath-7.1.2-0.x86_64 rpmlib(PayloadIsXz) <= 5.2-1 i

Re: Error when upgrading the 7.1 Linux client

Hi Erwann! I received the same error even when I selected only the API for installation! Anyway, I managed to upgrade 7.1.1.0 to 7.1.2.0 by using yum instead of rpm. It's working now. Thanks for your reply! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: AD

Removing obsolete TDP for MySAP files from TSM

Hi TSM-ers! (or should I say ISP-ers since the product will be renamed in the near future?)! We are using TDP for MySAP to back-up our SAP databases. For several clients I see that files are left behind in TSM which no longer exist in the SAP repository. When you backup Oracle by using TDP for O

Re: Removing obsolete TDP for MySAP files from TSM

es as backup which will not become inactive since every filename is unique. TDP MySAP is doing archive, so files should expire corresponding to the policy you defined. Cheers, Karsten Am 22.05.2015 um 10:54 schrieb Loon, EJ van (ITOPT3) - KLM: > Hi TSM-ers! (or should I say ISP-ers since the

Re: Domino TDP client support on Solaris SPARC

Hi Zoltan! I take it you are talking about TSM for Mail 6.1.3 which contains the Data Protection for Lotus Domino 5.5.3 client? The readme: contains the following requirements: Any Tivoli Storage Manager Server version still in support A Tivoli Storage Manager API V5.5.1, or later So the 6.3 API i

Re: Domino TDP client support on Solaris SPARC

upgrade the Solaris SPARC client on this machine to a higher, patched level but not effect/impact the TSM TDP for Domino, which can not be upgraded. On Thu, Jun 18, 2015 at 10:21 AM, Loon, EJ van (ITOPT3) - KLM < eric-van.l...@klm.com> wrote: > Hi Zoltan! > I take it you are talking a

SQL statement not working

Hi guys! I'm trying to select all ANE4987E messages for all nodes with the text 'Component Team Windows' in the contact field. For some reason I cannot get the SQL statement to work. What am I doing wrong? select actlog.date_time, actlog.nodename, actlog.message, nodes.node_name, nodes.contact

Re: SQL statement not working

@VM.MARIST.EDU Subject: Re: SQL statement not working you’re missing the from clause of your sql statement. > Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM > het volgende geschreven: > > Hi guys! > I'm trying to select all ANE4987E messages for all nodes with the tex

Trailing .000000

Hi guys! Now that I have my SQL statement working I noticed that a select date_time from actlog returns the following format: 2015-06-29 23:27:04.00 What is the proper way to remove the trailing .00? Again, thanks for your help!!! Kind regards, Eric van Loon AF/KLM Storage Engineering *

Re: Trailing .000000

s, Kurt -Oorspronkelijk bericht----- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Loon, EJ van (ITOPT3) - KLM Verzonden: woensdag 1 juli 2015 15:17 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] Trailing .00 Hi guys! Now that I have my SQL statement working I noticed that a se

Re: Remove the Trailing .000000 in date_time

From: Loon, EJ van (ITOPT3) - KLM Sent: woensdag 1 juli 2015 17:08 To: ADSM-L@VM.MARIST.EDU Subject: RE: Trailing .00 Hi Kurt! Your SQL does indeed return the output I'm looking for, but how dow I embed it in the following SQL statement? select actlog.date_time, actlog.nodename as

Re: Trailing .000000

nodes.node_name, nodes.contact order by actlog.nodename On 02/07/15 01:08, Loon, EJ van (ITOPT3) - KLM wrote: > Hi Kurt! > Your SQL does indeed return the output I'm looking for, but how dow I embed > it in the following SQL statement? > > select actlog.date_time, actl

Virtualmountpoint not working

Hi guys! I have a Linux client with Cristie TBMR installed on it. TBRM requires that /dev is backed up which is normally excluded by the Linux BA client. To force this backup I need to add the virtualmountpoint parameter to the dsm.sys file which I did: servernameKL1241M3_client tcp

Re: Virtualmountpoint not working

point not working Try " dsmc q opt|less" or just " dsmc q opt|". On my Linux TBMR systems the /dev is on the line following " VIRTUALMOUNTPOINT:" in the q opt output. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Beh

Re: Virtualmountpoint not working

a backup. I'm pretty sure it is just weird formatting of the q opt output. Yours looks like mine and it is working fine. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: Tuesday, July 14, 2015 10

Re: Virtualmountpoint not working

/www.ibm.com/support/knowledgecenter/SSGSG7/welcome Product Wiki: https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager "ADSM: Dist Stor Manager" wrote on 2015-07-15 07:15:28: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MAR

Re: Virtualmountpoint not working

Hi Stef! Our Linux guys tell me that /dev is not a filesystem but a directory. That's why it's not in the output from the mount command, nor in the output from the df command. The content is indeed dynamically build up during boot, but the TBMR manual specifically states that it should be backed

Re: Virtualmountpoint not working

M clinet and what level of Linux? David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: Wednesday, July 15, 2015 8:48 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Virtualmountpoint not working Hi Andy! /dev

Re: Virtualmountpoint not working

bm.com/support/knowledgecenter/SSGSG7/welcome Product Wiki: https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager "ADSM: Dist Stor Manager" wrote on 2015-07-15 09:24:34: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU >

Journal Based Backup on RHEL5

Hi TSM-ers! I'm trying to install the 7.1 TSM client on one of our RHEL5 servers but I receive an error during the dependency check for one of the rpm's: rpmlib(FileDigests) is needed by TIVsm-filepath-7.1.2-0.x86_64 rpmlib(PayloadIsXz) is needed by TIVsm-filepath-7.1.2-0.x86_64 This message seems

Re: Journal Based Backup on RHEL5

/SSGSG7_7.1.0/com.ibm.itsm.client.doc/t_inst_linuxx86client.html> build you own TIVsm-filepath-7.1.2-0-*.rpm by following the instructions given under point 6. -- Mit freundlichen Grüßen / Kind regards Michael Prix Am 07/17/2015 um 03:57 PM schrieb Loon, EJ van (ITOPT3) - KLM: > Hi TSM-e

Drive serial

Hi guys! I haven't had much experience with physical tape drives (we are using DD VTL's only) but recently I installed a few stand-alone IBM LTO5 drives to be able to externalize TSM data on request. I need the serial numbers of the drives for administrational purposes. I know TSM reports a seri

Re: Drive serial

14 03592E06078A3C78 qla2xxx 5:0:14:0NA 15 03592E0607857440 qla2xxx 5:0:15:0NA 16 03592E0607868729 qla2xxx 5:0:16:0NA On Mon, Jul 20, 2015 at 8:09 AM, Loon, EJ van (ITOPT3) - KLM < eric-va

Re: Journal Based Backup on RHEL5

Hi guys! Just to let you know and so it's documented in the ADSM-L archives: I received an answer from IBM Support that there is no RHEL5 package for JBB out of the box. If you want it you have to compile it yourself... I still find it very strange that IBM creates a distribution for RHEL 5 and 6

Enhancement request

Hi guys! I would like to submit an enhancement request for the TSM Windows Admin Commandline interface (add the connected servername to the title bar), but I can't find how to submit one. IBM has a site called IBM RFE Community for these requests, but TSM is not listed on that site... Thanks for

Re: Enhancement request

ww.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=75293 Kind regards, Eric van Loon AF/KLM Storage Engineering From: Loon, EJ van (ITOPT3) - KLM Sent: dinsdag 11 augustus 2015 14:42 To: ADSM-L Subject: Enhancement request Hi guys! I would like to submit an enhancement request for t

Re: Enhancement request

request The server name is quite visibly shown in the CLI part of OC. I’d rather see the OC be enhanced than a developer spend time on the CLI. > Op 11 aug. 2015, om 14:54 heeft Loon, EJ van (ITOPT3) - KLM > het volgende geschreven: > > Never mind, I wasn't looking correctly, T

Data Protection for IBM Domino

Hi guys! One of my customers uses Data Protection for IBM Domino for a few years now. All mail instances are backed up daily with the domdsmc selective command. I recently discovered that old deleted databases were never removed from TSM, which seems to be caused by the fact that we do selective

Re: Data Protection for IBM Domino

e backup and specify /applylogs. All the necessary archived transaction log files are restored so that updates for the database can be applied From: "Loon, EJ van (ITOPT3) - KLM" To: ADSM-L@VM.MARIST.EDU Date: 08/21/2015 09:00 AM Subject:Data Protection for IBM Domino Sen

Re: going to all random disk pool for tsm for ve

There is no reclamation on a diskpool. Over time the deletion of (very) small data blocks will make it heavily fragmented which will definitely impact you performance... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L

Re: Data Protection for IBM Domino

27;s DBIID changes (a rare occurrence).  Selective backups to backup the changes along with occasional incremental, to inactivate deleted databases is the right way to go. "ADSM: Dist Stor Manager" wrote on 08/21/2015 10:30:05 AM: > From: "Loon, EJ van (ITOPT3) - KLM" >

Re: Data Protection for IBM Domino

th occasional incremental, to inactivate deleted databases is the right way to go. "ADSM: Dist Stor Manager" wrote on 08/21/2015 10:30:05 AM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 08/21/2015 10:33 AM > Subject: Re: Data Protec

Re: nfs mounted tsm storage becoming unavailable

Hi Rick! Formatting the whole volume was the case in the TSM 5.5 era, but not anymore. Formatting a diskpool or filepool volume took ages back then because it was filed with a text string (my name backwards :-), but with version 6 this has changed and it just pre-allocates the requested space wi

Re: nfs mounted tsm storage becoming unavailable

LM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 9 september 2015 14:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: nfs mounted tsm storage becoming unavailable Op 9 sep. 2015, om 09:11 heeft "Loon, EJ van

Re: nfs mounted tsm storage becoming unavailable

m the volume is created on. Ext4 and JFS support sparse file creation and TSM takes advantage of it. NFS does not. Search the admin guide for "preallocated" for info. On Wed, Sep 9, 2015 at 10:51 AM, Loon, EJ van (ITOPT3) - KLM wrote: Smarter way of formatting? Either it fills the files

Re: 7.1.3 Decomm changes

Hi Steve! I agree things are a bit unclear here. On her presentation on YouTube Tricia Jiang explicitly states that the decommission command locks the node and that it cannot be unlocked (https://www.youtube.com/watch?v=QZVyVp0QEIs at 35:16). One of the IBM-ers on the TSM Symposium in Germany la

Re: 7.1.3 Decomm changes

3 Decomm changes > > Sent by: "ADSM: Dist Stor Manager" > > > > Hi all, > > > > a decomm with a countdown without options to reverse te decomm seems > > quite useless indeed. So either development sort of missed the point > > or the com

Re: TSM 7.1.3 and Directory-container storage pools

Hi Mike! On the TSM Symposium in Dresden last month IBM stated that the MOVE DATA option to a container pool is a high priority for IBM and it's a candidate for the first half of 2016. If it's a priority for you, you should tell your IBM contact. If more people find this important, it will get a

Re: Missing support for ISP 7.1.3 for SAP and Oracle 12c

Hi guys! For those of you interested: DP for SAP 7.1.3 is now supporting Oracle 12c. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 16 september 2015 13:22 To: AD

Re: TSM Expired Objects List...

If I remember correctly quiet=no only tells you which filespace expiration is currently processing, not which file... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: di

Re: Does a DB2 db ever shrink?

Hi Rick! Here is the procedure to release space to the operating system on a 6.3 server: http://www-01.ibm.com/support/docview.wss?uid=swg21452146#Release_spaceDB297 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.M

Re: Does a DB2 db ever shrink?

DbGB 11/01/2015504786214701785 11/08/2015436723183701676 <= -65m files gone! 11/17/2015436456172702185 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: Tuesday, November 17, 201

Client-side dedup and (very) large databases

Hi all! I'm currently working on a new TSM/SP server design based on SP 7.1.3. I have one question about client-side deduplication which we currently do not use at all. All our data is deduplicated by the backend hardware (Data Domain). The manuals all talk about client-side dedup to be an option

TDP for SAP issue

Hi guys! One of my customers has an issue on his TDP for SAP clients. They are using TDP for SAP 6.2 and recently we upgraded all TSM clients to 7.1. This caused the TDP clients to fail with the following error: ANS1463E (RC5801) Unexpected error in cryptography library. In the API error log:

Re: TDP for SAP issue

.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.client.develop.doc/c_encryp_transp.html Martin J. "ADSM: Dist Stor Manager" wrote on 12/09/2015 03:00:36 PM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 12/09/2015 03:02 PM

Re: TDP for SAP issue

this case you need to fallback to DES56 encryption library (even if you do not intent to use them). Bye Martin J. "ADSM: Dist Stor Manager" wrote on 12/10/2015 09:05:05 AM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 12/10/2015 09:06

Re: TDP for SAP issue

t Stor Manager" wrote on 12/10/2015 11:28:27 AM: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 12/10/2015 11:29 AM > Subject: Re: [ADSM-L] TDP for SAP issue Sent by: "ADSM: Dist Stor > Manager" > > Hi Martin! > You stated

Re: Bring back TSM Administrator's Guide

One speaker from IBM on the TSM Symposium in Germany last September told us that this was a money driven decision. Apparently creating an Admin Guide is a very expensive process. He also stated that if we customers still feel this manual should return, we should request for it through our IBM co

SQL statement

Hi guys! I'm trying to join the filespaces and occupancy tables in one SQL statement, but I get stuck on the point where I want to calculate with the amount of days... I would like to create a list of filespaces (node_name, filespace_name,backup_end) which are not backed up for more than 30 days

Re: SQL statement

.node_name - AND o.filespace_name=f.filespace_name - AND days(f.backup_end)<(days(current_date)-30) - ORDER BY o.physical_mb DESC On Thu, Jan 28, 2016 at 02:43:54PM +0000, Loon, EJ van (ITOPT3) - KLM wrote: > Hi guys! > I'm trying to join the filespaces and occupancy tables in o

Re: SQL statement

espaces f, - > occupancy o - > WHERE - > o.node_name=f.node_name - > AND o.filespace_name=f.filespace_name - > AND days(f.backup_end)<(days(current_date)-30) - ORDER BY > o.physical_mb DESC > > On Thu, Jan 28, 2016 at 02:43:54PM +, Loon, EJ van (ITOPT3

Re: SQL statement

- occupancy o - WHERE - o.node_name=f.node_name - AND o.filespace_name=f.filespace_name - AND days(f.backup_end)<(days(current_date)-30) - ORDER BY o.physical_mb DESC On Thu, Jan 28, 2016 at 02:43:54PM +0000, Loon, EJ van (ITOPT3) - KLM wrote: > Hi guys! > I'm trying to join the

Re: SQL statement

CAST(ROUND(o.physical_mb/1024) as int) as "GB Stored" - FROM - filespaces f, - occupancy o - WHERE - o.node_name=f.node_name - AND o.filespace_name=f.filespace_name - AND days(f.backup_end)<(days(current_date)-30) - ORDER BY o.physical_mb DESC On Thu, Jan 28, 2016 at

Identifying empty nodes

Hi guys! I'm trying to query the occupancy table to identify nodes with no more data store, but I can't find the proper syntax. I thought of this one: select node_name from occupancy where physical_mb is null But it returns no nodes, while I know for sure there are several of them... Thanks for an

Re: Identifying empty nodes

ckup & Restore) [mailto:neil.schofi...@lloydsbanking.com] Sent: maandag 29 februari 2016 15:16 To: ADSM-L@vm.marist.edu Cc: Loon, EJ van (ITOPT3) - KLM Subject: Re: [ADSM-L] Identifying empty nodes Eric It was my understanding that there was only an entry for a file space in the occupancy tab

Data protection for SAP HANA

Hi guys! In the list of system requirements for Data protection for SAP HANA I see: SAP HANA support package stack SPS 08 up to SPS 10 SPS11 seems to be out at this moment, does anybody know if it is supported (so the requirements page needs updating) or will I have to wait for 7.1.4? Thanks for

Data Protection for Oracle 5.5.2 + 7.1.4 API

Hi guys! I have an issue with one of my Oracle customers. They have several RedHat 5.8 servers (with Oracle 10) which had TSM 5.5 running, along with TDP for Oracle 5.5.2. Since the OS support the new 7.1.4 client, they upgraded the BA and API client to 7.1.4. Since that moment they can no longe

Re: cloud pools, directory containers, dedup etc.

Hi Gary! As far as I know Amazon cloud is not (yet) supported... Only Cleversafe, Softlayer and Swift are. Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: dinsdag 2

Re: Deduplication and database backups

Hi Arni! Just a thought: could it be that Oracle compression is turned on? Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stefan Folkerts Sent: donderdag 31 maart 2016 17:55 To: ADS

SQL statement

Hi guys! I'm trying to create a SQL statement which should list all filespaces, along with their occupancy, with a backup date longer than 2 days ago, but only for nodes with an last access date of today or yesterday. If the node hasn't contacted the server for two days or more it's reported in

Re: SQL statement

AM, Loon, EJ van (ITOPT3) - KLM > wrote: > > Hi guys! > I'm trying to create a SQL statement which should list all filespaces, along > with their occupancy, with a backup date longer than 2 days ago, but only for > nodes with an last access date of today or yesterday. If t

TSM for VE (DP for VMware on Linux)

Hi guys! We would like to start testing with Data Protection for WMware on Linux. The problem is that most procedures are based on the GUI and we don't have that available in or VMware environment. So I'm looking for a step-by-step procedure on how to install and configure DP for VMware through

Re: TSM for VE (DP for VMware on Linux)

ce the installation part with the commandline option, but I will manage. Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: Bas van Kampen [mailto:b.vankam...@interconnect.nl] Sent: woensdag 13 april 2016 16:34 To: ADSM: Dist Stor Manager ; Loon, EJ

SP for VE (VMware on Linux)

Hi guys! We were able to install TSM for VE 7.1.4 only after first installing the base (7.1.3) version first, because of the required license file. I extracted the license file tdp4vmw.lic from the 7.1.3 package and placed it into the correct location and then tried to install 7.1.4, but that do

DP for SAP HANA with SPS12

Hi guys! One of my customers wants to implement Data Protection for SAP HANA on their SAP HANA appliance. On the IBM support pages I read one of the following supported stacks: SAP HANA support package stack SPS 08 up to SPS 11 They are however running SPS12. Does anybody from IBM know if there a

Re: DP for SAP HANA with SPS12

7;t have a specific date to share yet. The development team is looking into this. Have you tried it yet? Did you run into problems? Del "ADSM: Dist Stor Manager" wrote on 05/25/2016 08:39:17 AM: > From: "Loon, EJ van (

ANR3619W

Hi guys! I'm setting up a 7.1.5 server on Linux. I followed all specs and I have raised the hard and soft limits for open files to the recommended value of 65536 for both the instance user as root. However, I keep on receiving the following message: ANR3619W The user limit for open files is belo

Re: ANR3619W

c van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: woensdag 1 juni 2016 12:53 To: ADSM-L@VM.MARIST.EDU Subject: ANR3619W Hi guys! I'm setting up a 7.1.5 server o

Re: ANR3619W

pport/knowledgecenter/SSATMW_7.1.0/com.ibm.itsm.srv.install.doc/t_srv_startsrv_set_access_ulimit-linux.html On Wed, Jun 1, 2016 at 7:16 AM, Loon, EJ van (ITOPT3) - KLM < eric-van.l...@klm.com> wrote: > Some additional analysis: a cat /proc//limits indeed shows a Max > open files 4096... I don&

File affected in case of a damaged dcf

Hi guys! I'm doing some testing with a directory container storagepool. I deliberately damaged a dcf file and tested the audit function, everything seems to work as expected. When a tape is corrupted, the activity log shows which user file is affected by the detected corruption, however in case

Re: File affected in case of a damaged dcf

DSM-L@VM.MARIST.EDU Subject: Re: File affected in case of a damaged dcf Haven't tried it but can you use the "REPLICATE NODE" with PREVIEW and LIST options ? -Rick Adamson -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, E

Re: File affected in case of a damaged dcf

with PREVIEW and LIST options ? -Rick Adamson -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van (ITOPT3) - KLM Sent: Wednesday, June 08, 2016 9:27 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] File affected in case of a damage

Blueprint performance script

Hi guys! I would like to use the tsmdiskperf.pl script which is part of the Blueprints. We however install TSM on a cluster, so our file systems are all Veritas filesystems, where the Blueprint uses the standard Linux driver. So to trick the script I would like to create a small bash script whic

Size of stored backupsets

Hi guys! Does anybody know a way to retrieve the amount of TSM storage occupied by backupsets? I checked the backupsets table, but their sizes are not stored in there... Thanks for any help in advance! Kind regards, Eric van Loon Air France/KLM Storage Engineering

Re: Size of stored backupsets

: Size of stored backupsets What pool are you using to store yours backupsets??? El 4 jul. 2016 3:12 a. m., "Loon, EJ van (ITOPT3) - KLM" < eric-van.l...@klm.com> escribió: > Hi guys! > Does anybody know a way to retrieve the amount of TSM storage occupied > by backupsets?

  1   2   >