Windows Server 2019 client

2019-01-31 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys! Does anybody know when Windows Server 2019 will be supported by TSM as backup client? Thanks for any reply in advance! Kind regards, Eric van Loon Air France/KLM Storage & Backup For information, services and offers, please visit ou

Re: Windows Server 2019 client

2019-01-31 Thread Loon, Eric van (ITOP NS) - KLM
Venu -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Thursday, January 31, 2019 2:25 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Windows Server 2019 client Hi guys! Does anybody know when Windows Server 2019 will be supported by

Re: Windows Server 2019 client

2019-01-31 Thread Loon, Eric van (ITOP NS) - KLM
st Spectrum Protect client available, but > make sure to test both backup & restore capabilities before get this > onto Production Environment. > > Suggest you open a support case with IBM. > > Best Regards, > _____ > Venu > -

Re: container with damaged extents

2019-01-31 Thread Loon, Eric van (ITOP NS) - KLM
Hi Eric! Checkout the repair stgpool command at https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.6/srv.reference/r_cmd_stgpool_repair.html Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On B

Encrypt all data on a Windows client

2019-02-22 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, What would be the best include.encrypt statement(s) to be added to the dsm.opt when I want everything to be encrypted on a Windows client? So all data, including system state and no matter how many drives it has. Thanks for your help in advance! Kind regards, Eric van Loon Air France/KLM

Re: Encrypt all data on a Windows client

2019-02-22 Thread Loon, Eric van (ITOP NS) - KLM
| stor...@us.ibm.com "ADSM: Dist Stor Manager" wrote on 2019-02-22 03:00:50: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2019-02-22 03:02 > Subject: Encrypt all data on a Windows client Sent by: "ADSM: Dist > Stor M

Re: Encrypt all data on a Windows client

2019-02-22 Thread Loon, Eric van (ITOP NS) - KLM
ibm.com "ADSM: Dist Stor Manager" wrote on 2019-02-22 03:00:50: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2019-02-22 03:02 > Subject: Encrypt all data on a Windows client Sent by: "ADSM: Dist > Stor Manager" > &g

Re: best way to avoid long rollback

2019-03-12 Thread Loon, Eric van (ITOP NS) - KLM
Hi Eric, Just like Zoltan said, you really need to prevent a kill of TSM. This will leave the DB2 database in an inconsistent state and thus result in a DB2 crash recovery which can indeed be a lengthy process. Just use a halt to stop TSM and the DB2 database will be closed properly. Kind regard

Running TSM/SP in a cluster?

2019-04-18 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm wondering if more people are running TSM in a cluster configuration. We always used Linux clusters based on Veritas Cluster Service (VCS). Ever since we were switched to IBM hardware we also had to switch to a different multipath driver and that is where the problems started. We alw

Using same cert.kdb on multiple servers

2019-07-05 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, Does somebody know if it is possible to use the same cert.kdb on all servers? So I create one on one server with the certificate of all other servers in it and then copy it to all other servers? Thanks for your help in advance! Kind regards, Eric van Loon Air France/KLM Storage & Backu

Re: Using same cert.kdb on multiple servers

2019-07-08 Thread Loon, Eric van (ITOP NS) - KLM
Hi Erwann, Out of simplicity. If you install a new TSM server and use an existing key database, you won't have to add the certificates from all other servers. Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.M

Number of volumes per client

2019-07-11 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm looking for a SQL statement to count the amount of volumes used per client. Can anybody help me out here? Thank you very much in advance! Kind regards, Eric van Loon Air France/KLM Storage & Backup For information, services an

Re: Number of volumes per client

2019-07-12 Thread Loon, Eric van (ITOP NS) - KLM
NJPB6-7WBTG96C-LFZSJeY_p5sCXJARzBE&s=1i1fKfzAmWtRtt_3kdvSRz48l_g0KoSdNZV97yLWULY&e= Spectrum Protect Blueprint: https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm.biz_IBMSpectrumProtectBlueprints&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=hLJKqiq5uZKR2bRDOYSNbd0R_g8juynSkOjr_umT9g4&m=vEW1Kb5

How to make dsmc recognize drives

2019-07-18 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, For some tests I want to create separate drives in Windows and back them up with SP. I create these drives with the subst command (subst D: c:\). The drives created are visible in the Windows GUI and accessible through the Windows command line, but the Spectrum Protect client does not

Re: How to make dsmc recognize drives

2019-07-18 Thread Loon, Eric van (ITOP NS) - KLM
Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com "ADSM: Dist Stor Manager" wrote on 2019-07-18 05:36:36: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2019-07-

deletion performance of large deduplicated files

2019-07-19 Thread Loon, Eric van (ITOP NS) - KLM
Hi TSM/SP-ers, We are struggling with the performance of our TSM servers for months now. We are running several servers with hardware (Data Domain) dedup for years without any problems, but on our new servers with directory container pools performance is really, really bad. The servers and stor

Re: deletion performance of large deduplicated files

2019-07-19 Thread Loon, Eric van (ITOP NS) - KLM
p db. Unbelievable, but true. Yes, I'm using SSD. And SVC. And multiple storage systems. Performance isn't the problem, we are measuring 2ms respone time for write AND read. - stripeset for each fileset -- Michael Prix On Fri, 2019-07-19 at 07:29 +, Loon, Eric van (ITO

Re: deletion performance of large deduplicated files

2019-07-22 Thread Loon, Eric van (ITOP NS) - KLM
ing: > > - More LUNS and filesystems for the TSM-DB > > - smaller disks, but more of them, for each filesystem. > > changing the disks from 100GB to 2 x 50GB for each DB-filesystem got me a > > performance boost of 200% in expiration and backup db. Unbelievable,but true. > &

Re: deletion performance of large deduplicated files

2019-07-22 Thread Loon, Eric van (ITOP NS) - KLM
shoes. -- Michael Prix On Fri, 2019-07-19 at 13:35 +0000, Loon, Eric van (ITOP NS) - KLM wrote: > Hi Rick and others! > > I replicated the data of the test TDP client to multiple servers, > running 7.1.7, 7.1.9 and even 8.1.8: the performance sucks on all servers. > We do not use c

Re: deletion performance of large deduplicated files

2019-07-22 Thread Loon, Eric van (ITOP NS) - KLM
ng of lowering the parameters involved to smaller values, pending the results of the first complete expiration without any bigger objects which will be in 2 weeks due to retention rules. -- Michael Prix On Mon, 2019-07-22 at 08:42 +, Loon, Eric van (ITOP NS) - KLM wrote: > Hi Michael, &g

Blueprints updated

2019-08-08 Thread Loon, Eric van (ITOP NS) - KLM
For those of you interested: IBM updated the Blueprints to 4.1 recently: http://ibm.biz/IBMSpectrumProtectBlueprints Kind regards, Eric van Loon Air France/KLM Storage & Backup For information, services and offers, please visit our web site

TSM server performance continuing

2019-08-21 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, A few weeks ago I already wrote about the severe performance issues we have with our TSM 7.1 servers. In the 'old days' we used to back up our clients to TSM 6.3 servers with Data Domains attached. Smaller clients backed up through the LAN, large ones through the SAN. Our newer servers

Re: TSM server performance continuing

2019-08-22 Thread Loon, Eric van (ITOP NS) - KLM
6608 kernel.msgmax = 65536 kernel.msgmnb = 65536 kernel.randomize_va_space = 0 vm.swappiness = 0 vm.overcommit_memory = 0 ERic 540-392-1742 (Cell) On Wed, Aug 21, 2019 at 11:44 AM Loon, Eric van (ITOP NS) - KLM < eric-van.l...@klm.com> wrote: > Hi guys, > > A few weeks ago I alre

Re: TSM server performance continuing

2019-08-22 Thread Loon, Eric van (ITOP NS) - KLM
you. www.panalpina.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Wednesday, August 21, 2019 5:39 PM To: ADSM-L@VM.MARIST.EDU Subject: TSM se

Re: TSM server performance continuing

2019-08-27 Thread Loon, Eric van (ITOP NS) - KLM
> www.panalpina.com > > > > -----Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of Loon, Eric van (ITOP NS) - KLM > Sent: Thursday, August 22, 2019 2:31 PM > To: ADSM-L@VM.MARIST.EDU > Subject:

Re: TSM server performance continuing

2019-09-04 Thread Loon, Eric van (ITOP NS) - KLM
server code in the environment? On Tue, Aug 27, 2019 at 1:01 PM Loon, Eric van (ITOP NS) - KLM < eric-van.l...@klm.com> wrote: > Hi Stefan, > > There is no noticable impact on the TSM performance when we use the > tsmdiskperf tool on the database volumes. > We recently dis

Re: ISP server as a VM

2019-09-04 Thread Loon, Eric van (ITOP NS) - KLM
Hi Zoltan, I don't know if it's supported by IBM, but I think it's all related to load. A VM will not provide the same I/O performance as dedicated hardware does. So if you are planning to install a server with inbound deduplication with container pools, I would stay away from virtualization.

systemd.service file example

2019-11-19 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, I'm currently creating a new server setup based on the Blueprints. The SP manuals explain how to use dsmserv.rc script in init.d to start the server at system startup. However, I would rather use a systemd.service file to start (and stop) SP during startup and shutdown. Does anybo

Re: systemd.service file example

2019-11-19 Thread Loon, Eric van (ITOP NS) - KLM
Hi Arnaud, > You should not worry too much about this : the installer should do it all for > you ! Well, not really. The installer just adds the dsmserv.rc script to the /etc/rc.d/init.d/ directory. It doesn't create a systemd.service file. Thanks for your reply! Kind regards, Eric van Loon Air

Kernel parameters

2019-12-05 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, Our TSM 7.1 servers (with directory containers) were suffering from a very slow response for a long time. We already applied the kernel parameters specified in the installation guide and the SP Blueprints, but since we recently changed several other kernel parameters in one go, thing i

Kernel parameters

2019-12-08 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I received no response on my question down below. I know it's just a matter of cut-and-paste, so I really appreciate if you can have a look at my request. Thank you very much in advance! Kind regards, Eric van Loon Air France/KLM Storage & Backup From: Loon, Eric van (ITOP

Re: deletion performance of large deduplicated files

2019-12-18 Thread Loon, Eric van (ITOP NS) - KLM
sage- From: Michael Prix Sent: woensdag 18 december 2019 14:57 To: Loon, Eric van (ITOP NS) - KLM Cc: ADSM: Dist Stor Manager Subject: Re: [ADSM-L] deletion performance of large deduplicated files Hello Eric, to come back to this old thread. I got a eFix (8.1.8.201) for IT31042, and it

tdpoconf showenv no longer working after upgrade to 8.1.9.0

2020-01-23 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, We discovered that tdpoconf showenv is no longer working for the oracle user after the upgrade to DP for Oracle 8.1.9.0. It is working OK for root. The cause of this issue is the fact that the random encryption key file TSM.sth is not accessible for the oracle user. I think this file is

Re: tdpoconf showenv no longer working after upgrade to 8.1.9.0

2020-01-24 Thread Loon, Eric van (ITOP NS) - KLM
/23/2020 03:37:39 AM: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 01/23/2020 03:38 AM > Subject: [EXTERNAL] tdpoconf showenv no longer working after upgradeto 8.1.9.0 > Sent by: "ADSM: Dist Stor Manager" > > Hi guys, >

Re: Server 7.1.7.500 APAR info

2020-01-29 Thread Loon, Eric van (ITOP NS) - KLM
Hi Zoltan, Maybe a bit late, but the list of APARS can be found at https://www.ibm.com/support/pages/apars-fixed-ibm-spectrum-protect-server-717-interim-fix-levels Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of

Backup error when using node replication (DP for SAP)

2020-02-12 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm testing the new Data Protection 8.1.9 client on a new SP server which uses node replication. When the user starts a backup he receives the following errors: 02/12/2020 14:19:33 ANS4058I A write failure occurred while attempting to save node replication failover values to the optio

Re: Backup error when using node replication (DP for SAP)

2020-02-13 Thread Loon, Eric van (ITOP NS) - KLM
ectPerformanceMustgather Spectrum Protect Blueprint: https://www.ibm.com/support/pages/ibm-spectrum-protect-blueprints Follow me on: Twitter, developerWorks, LinkedIn -Original Message----- From: Loon, Eric van (ITOP NS) - KLM Sent: Wednesday, February 12, 2020 10:56 AM To: ADSM-L@VM.MARIS

Re: Backup error when using node replication (DP for SAP)

2020-02-14 Thread Loon, Eric van (ITOP NS) - KLM
rint: https://www.ibm.com/support/pages/ibm-spectrum-protect-blueprints -Original Message- From: Loon, Eric van (ITOP NS) - KLM Sent: Thursday, February 13, 2020 10:33 AM To: ADSM-L@VM.MARIST.EDU Subject: [EXTERNAL] Re: [ADSM-L] Backup error when using node replication (DP for SAP) Hi

Re: Backup error when using node replication (DP for SAP)

2020-02-14 Thread Loon, Eric van (ITOP NS) - KLM
on Performance Mustgather for Spectrum Protect: http://ibm.biz/IBMSpectrumProtectPerformanceMustgather Spectrum Protect Blueprint: https://www.ibm.com/support/pages/ibm-spectrum-protect-blueprints -Original Message----- From: Loon, Eric van (ITOP NS) - KLM Sent: Friday, February 14, 2020 06:51

Operations Center custom report column width

2020-03-03 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm trying to port our reports from the good old TSM Operational Reporter to the SP Operations Center. I created some custom reports, but the output is quite ugly because of the column width. For instance, a node name with a dash in the name is cut off and displayed across two lines, w

Re: Operations Center custom report column width

2020-03-06 Thread Loon, Eric van (ITOP NS) - KLM
Hi Erwann, Substr and cast do not seem to matter. The column width seems to be determined by the column header label (thanks Venu Bommasani!) . So the length of the AS statement seems to set the column width. And using spaces like in SELECT NODE_NAME AS "Client node name" seems to break it too,

Re: Operations Center custom report column width

2020-03-12 Thread Loon, Eric van (ITOP NS) - KLM
-Original Message----- From: Loon, Eric van (ITOP NS) - KLM Sent: vrijdag 6 maart 2020 10:55 To: ADSM: Dist Stor Manager Subject: RE: Operations Center custom report column width Hi Erwann, Substr and cast do not seem to matter. The column width seems to be determined by the column header labe

Error in OC for device class

2020-03-18 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, In Operation Center an critical error is shown for some of my servers with a device class without a storagepool. When I issue the command q monitorstatus status=error, the following error is listed: Server Name Activity DateActivity NameElement Name Element E

Re: Error in OC for device class

2020-03-26 Thread Loon, Eric van (ITOP NS) - KLM
Hi Erwann, Yes, that's indeed what I discovered too. When I issue the command q monitorstatus status=error, the error status trigger which SPOC uses is displayed. In my case: Server Name Activity DateActivity NameElement Name Element Element String Element State

Combining SQL queries

2020-03-26 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I have two SQL queries: select count(*) as "Number_Of_Failed" from events where scheduled_start>current_timestamp-24 hours and status='Failed' select count(*) as "Number_Of_Missed" from events where scheduled_start>current_timestamp-24 hours and status='Missed' Is it somehow possible

Re: Combining SQL queries

2020-03-27 Thread Loon, Eric van (ITOP NS) - KLM
led" from events where scheduled_start>current_timestamp-24 hours and status='Failed' ) failed, ( select count(*) as "Number_Of_Missed" from events where scheduled_start>current_timestamp-24 hours and status='Missed' ) missed ; Hope that helps! On Thu

Re: Combining SQL queries

2020-03-30 Thread Loon, Eric van (ITOP NS) - KLM
ount(*) as "Number_Of_Failed" from events where scheduled_start>current_timestamp-24 hours and status='Failed' ) failed, ( select count(*) as "Number_Of_Missed" from events where scheduled_start>current_timestamp-24 hours and status='Missed' ) missed ; Hope

SPOC date format

2020-04-01 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, The report builder in SPOC used a date format of "Month DD, ". Has anybody found a way to change this? I would rather have DD-MM-YY, but I haven't found a way. It doesn't seem to be related to the SQL output itself, because the SQL result is formatted properly. Thanks for your

SQL query

2020-04-07 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, It must be something very easy, but I can't seem find the solution myself... This is the query I use to list the total amount of Oracle backup files older than 30 days: select count(*) as OBSOLETE_BACKUPS from backups a,nodes b where ((days(current_date) - days(backup_date) >= 30)) an

Re: anyone running SPv8.1.8 server on rhel7.8?

2020-04-07 Thread Loon, Eric van (ITOP NS) - KLM
Hi Eric, Did you checkout https://www.ibm.com/support/pages/spectrum-protect-server-fails-start-anr0169e-sql12225n? Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of J. Eric Wonderley Sent: dinsdag 7 april 2020 14

Re: SQL query

2020-04-08 Thread Loon, Eric van (ITOP NS) - KLM
((days(current_date) - days(backup_date) >= 30)) and a.state='ACTIVE_VERSION' and b.contact like '%Oracle%' group by a.node_name On Tue, Apr 07, 2020 at 09:08:58AM +, Loon, Eric van (ITOP NS) - KLM wrote: > Hi guys, > > It must be somethin

Re: Error in OC for device class

2020-04-08 Thread Loon, Eric van (ITOP NS) - KLM
sure your ML is not too high and your MC is not too large, so everything will fit. Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message----- From: Loon, Eric van (ITOP NS) - KLM Sent: donderdag 26 maart 2020 13:03 To: ADSM: Dist Stor Manager Subject: RE: Error

Re: SQL query

2020-04-09 Thread Loon, Eric van (ITOP NS) - KLM
RSION') group by b.node_name Note that I also changed the "group by" and projection to use node_name from the nodes table since that's guaranteed to be set, rather than backups which would only be set for nodes with entries in the backups table. On Wed, Apr 08, 2020 at 08:26:42

Re: SQL query

2020-04-14 Thread Loon, Eric van (ITOP NS) - KLM
ode_name On Thu, Apr 09, 2020 at 10:53:09AM +, Loon, Eric van (ITOP NS) - KLM wrote: > Hi Skylar, > > Sorry, but this one doesn't work either, it returns the same results as all > others. I don't think the NULL result is the issue here, it seems to be the > way the re

ANR1942W

2020-05-07 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, We are implementing node replication on our new server and I noticed the following warning message in the log: ANR1942W Option set SPSERVERS already exists. Skipping for replication from source server AMSE3. All our servers are using standard naming, so option sets are all named

Re: ANR1942W

2020-05-08 Thread Loon, Eric van (ITOP NS) - KLM
ach other after some time of operation. Some settings collide during the replication. Regards, Michael Prix On Thu, 7 May 2020 08:50:23 +0000 "Loon, Eric van (ITOP NS) - KLM" wrote: > Hi everybody, > > We are implementing node replication on our new server and I noticed >

Spectrum Protect Plus IA restore

2020-05-20 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, We are testing the SPP instant access restore. If I understand things well, you cannot restore a full VM with IA in SPP, you only have this option available when you perform a disk restore. However, when we select both disks and perform a IA restore, the disks are created in the wrong

Re: Spectrum Protect Plus IA restore

2020-05-25 Thread Loon, Eric van (ITOP NS) - KLM
the entire VM directly from the vSnap. Del "ADSM: Dist Stor Manager" wrote on 05/20/2020 05:09:12 AM: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 05/20/2020 05:09 AM > Subje

Re: Spectrum Protect Plus IA restore

2020-05-26 Thread Loon, Eric van (ITOP NS) - KLM
Hi Eric, > > Full VM mount/instant Access can be done by selecting 'Test' radio > button in the Restore mode. > > Test mounts the entire VM directly from the vSnap. > > > Del > > > > "ADSM: Dist Stor Manager" wrote on 05/20/2020 > 05:09:12 AM

Re: Spectrum Protect Plus IA restore

2020-05-27 Thread Loon, Eric van (ITOP NS) - KLM
"ADSM: Dist Stor Manager" wrote on 05/26/2020 07:11:37 AM: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 05/26/2020 07:12 AM > Subject: [EXTERNAL] Re: Spectrum Protect Plus IA restore > Sent by: "ADSM: Dist Stor Manager"

Re: Spectrum Protect Plus IA restore

2020-05-29 Thread Loon, Eric van (ITOP NS) - KLM
tore_job.html > > ). > > > > If you want the original VM restored, in production, then choose > > "Production mode" as the restore type and choose the Original Host > > or Cluster as the destination. Production mode will retain the > > origin

Re: Ideal storage solution for SP and SP+ ???

2020-06-05 Thread Loon, Eric van (ITOP NS) - KLM
Hi Rick, Have a look at the latest IBM Spectrum Protect Blueprints and the IBM Spectrum Protect Plus Blueprints. They are based on (of course) IBM hardware (v5100 series) but the performance is good and you have the ability to benchmark your performance and compare it with the performance from

Re: isp replication and automatic failover for backup to target server

2020-07-01 Thread Loon, Eric van (ITOP NS) - KLM
Hi Stefan, I have also talked about this feature with a server architect from IBM during the SP Symposium in Germany, last year. Backup is almost as vital as backup (at least for databases), so failover for backup would be a great enhancement. He told me it's on the roadmap, but definitely not

Re: isp replication and automatic failover for backup to target server

2020-07-02 Thread Loon, Eric van (ITOP NS) - KLM
terRWTH https://www.youtube.com/channel/UCKKDJJukeRwO0LP-ac8x8rQ -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Wednesday, July 1, 2020 9:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] isp replication and automatic failover for back

Tighten client authorization

2020-07-14 Thread Loon, Eric van (ITOP NS) - KLM
Hi all, I read more and more about ransomware which is capable of encrypting data and at the same time deleting backup data. That's why I would like to set BACKDEL=NO on all nodes, wherever possible. I know the Data Protection for SQL client requires BACKDEL=YES to function properly, but are th

Filtering last access date with node replication

2020-08-11 Thread Loon, Eric van (ITOP NS) - KLM
Hi all, We always created exception reports which lists all nodes with a last access date of -2 or more which we send to the client owners. We are now switching to new SP servers and we will start using node replication. With replication, a node is created on the replication target server after

Re: Filtering last access date with node replication

2020-08-11 Thread Loon, Eric van (ITOP NS) - KLM
SM-L@VM.MARIST.EDU Subject: Re: Filtering last access date with node replication If you are using SQL just select node.repl_mode<>'RECEIVE' Sent from my Samsung S10 Op di 11 aug. 2020 12:16 schreef Loon, Eric van (ITOP NS) - KLM < eric-van.l...@klm.com>: > Hi all, > >

Re: Old clients cannot connect to 8.1.10 server

2020-08-20 Thread Loon, Eric van (ITOP NS) - KLM
Hi Erwan, The ANS1357S error is always very confusing. In most cases where I got this error it was certificate related. Try and update one of the nodes with sessionsecurity=transitional and see if the error is gone. Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Mess

Re: Replication Hung after upgrade to v8.1.10

2020-08-20 Thread Loon, Eric van (ITOP NS) - KLM
Hi Sarav, You stated " There is also one more issue on v8.1.10 where server will crash abruptly if you use directory container. It appears to be known issue and we have got efix to address it". I find this very alarming, because I'm about to start production on a new server running this level.

Re: Replication Hung after upgrade to v8.1.10

2020-08-20 Thread Loon, Eric van (ITOP NS) - KLM
1.10 IT33437 Regards Sarav +65 9857 8665 > On 20 Aug 2020, at 11:05 PM, Loon, Eric van (ITOP NS) - KLM > wrote: > > Hi Sarav, > > You stated " There is also one more issue on v8.1.10 where server will crash > abruptly if you use directory container. It appears to be

Re: Replication Hung after upgrade to v8.1.10

2020-08-31 Thread Loon, Eric van (ITOP NS) - KLM
rdag 20 augustus 2020 17:42 To: ADSM-L@VM.MARIST.EDU Subject: Re: Replication Hung after upgrade to v8.1.10 IT33437 Regards Sarav +65 9857 8665 > On 20 Aug 2020, at 11:05 PM, Loon, Eric van (ITOP NS) - KLM > wrote: > > Hi Sarav, > > You stated " There is also one

Re: Replication Hung after upgrade to v8.1.10

2020-09-01 Thread Loon, Eric van (ITOP NS) - KLM
essage- > From: ADSM: Dist Stor Manager On Behalf Of Saravanan > Palanisamy > Sent: donderdag 20 augustus 2020 17:42 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Replication Hung after upgrade to v8.1.10 > > IT33437 > > Regards > Sarav > +65 9857 8665 > >

Amount of stored data with node replication

2020-09-29 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, In our company the creation of TSM nodes is automated via a portal. The script first checks all TSM servers and uses the TSM server database size to select one of the available servers; the one with the lowest DB size is selected. We are now implementing new SP servers and we are switch

Re: Amount of stored data with node replication

2020-09-30 Thread Loon, Eric van (ITOP NS) - KLM
ns_Twitter cir.png] <https://twitter.com/IowaOCIO>[image: social media icons_LinkedIn cir.png] <https://www.linkedin.com/company/state-of-iowa> On Tue, Sep 29, 2020 at 5:07 AM Loon, Eric van (ITOP NS) - KLM < eric-van.l...@klm.com> wrote: > Hi guys, > > In our company t

Server script condition checking

2020-11-12 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm trying to create a script to switch node replication. I created the following script: rem repln $1 upd n $1 repls=en replm=syncse select * from nodegroup where node_name like upper('%$1%') if (rc_ok) goto end def nodegroupm server1 $1 end: The problem is that a SQL query doesn't see

Re: Server script condition checking

2020-11-12 Thread Loon, Eric van (ITOP NS) - KLM
the following: " ... upper(%1) ..." And when run the script, put the node name between single quotes: run script 'NODE' - Thanks, Marc... Marc Lanteigne Spectrum Protect Specialist AVP / SRT IBM Systems, Spectrum Protect / Plus IBM -----Original Message- From: Lo

TDP for SQL Server password file

2020-12-10 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, We have some SQL Server clients which have the wrong password stored through the GUI. The only problem is that the GUI only allows you to update the password when you know the old password. So I need to know where the TDP for SQL Server client stores his password, so I can delete this

Re: TDP for SQL Server password file

2020-12-11 Thread Loon, Eric van (ITOP NS) - KLM
on 12/10/2020 05:15:14 AM: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 12/10/2020 05:16 AM > Subject: [EXTERNAL] TDP for SQL Server password file Sent by: "ADSM: > Dist Stor Manager" > > Hi guys, > > We have

Re: TDP for SQL Server password file

2020-12-14 Thread Loon, Eric van (ITOP NS) - KLM
key is empty and the password files I >find in the path below: C:\ProgramData\Tivoli\TSM\baclient\Nodes Hope it helps. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: sexta-feira, 11 de dezembro de 2020 1

TDP for SAP (Oracle) backup

2020-12-17 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, I'm having a real issue on one of our SAP servers. We upgraded the TDP for SAP (Oracle) client from 7.1.3 to 8.1.11 along with the API client (from 7.1.8 to 8.1.11). Now when we start a full backup, it fails with the following error in the log: RMAN-03009: failure of backup command on

Moving long term archives to new server

2021-01-06 Thread Loon, Eric van (ITOP NS) - KLM
Hi all, I need to move long term archives (10 years+) from an old server (6.3 with virtual tapes) to a new server (8.1.11 with directory containers). The only way to do this is by exporting the data to a temporary filepool and convert this to the containerpool afterwards. The problem is that th

Re: Moving long term archives to new server

2021-01-06 Thread Loon, Eric van (ITOP NS) - KLM
l Message- From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Mittwoch, 6. Januar 2021 16:32 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Moving long term archives to new server Hi all, I need to move long term archives (10 years+) from an old server (6.3 with virt

Client configuration scripts

2021-01-22 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, We are running multiple servers. Both our Windows and Linux departments use their own scripts to configure new (or reinstalled) clients. The script tries to connect to each TSM/SP server sequentially and if a connection is successful, the client is configured for that specific ser

Re: Client configuration scripts

2021-01-25 Thread Loon, Eric van (ITOP NS) - KLM
Efim Sent: vrijdag 22 januari 2021 18:00 To: ADSM-L@VM.MARIST.EDU Subject: Re: Client configuration scripts HI, Maybe you should try checking the client message when connecting, for example ANS2112I? Efim > On 22 Jan 2021, at 19:31, Loon, Eric van (ITOP NS) - KLM > wrote: > > Hi e

Performance protect stgpool

2021-01-28 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, We are running 6 SP servers which are designed according to the Blueprints (Large server). All tests show that the storage and network performance is according to specs. The only thing I find rather disapointing is the PROTECT STGPOOL performance. I measure about 600 to 800 GB/hou

Re: Performance protect stgpool

2021-02-05 Thread Loon, Eric van (ITOP NS) - KLM
U Subject: Re: Performance protect stgpool Eric, While working with IBM to resolve and unrelated issue this came up, what version of SP server are you running ? Thank you, -Rick Adamson -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent:

Re: Performance protect stgpool

2021-02-05 Thread Loon, Eric van (ITOP NS) - KLM
you, -Rick Adamson -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Friday, February 5, 2021 7:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Performance protect stgpool * This email originated outside of the organization. Use c

SP patch versions??

2021-02-15 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, Am I the only one who's getting confused about the patch versions released by IBM recently? I noticed a 8.1.10.200 SP server and OC release last Friday, but 8.1.11.0 is already out for weeks... Kind regards, Eric van Loon Air France/KLM Storage & Backup **

Re: SP patch versions??

2021-02-15 Thread Loon, Eric van (ITOP NS) - KLM
r Manager" wrote on 02/15/2021 03:02:21 AM: > From: "Loon, Eric van (ITOP NS) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 02/15/2021 03:04 AM > Subject: [EXTERNAL] SP patch versions?? > Sent by: "ADSM: Dist Stor Manager" > > Hi everybody, > > Am I

Re: Moving long term archives to new server

2021-02-26 Thread Loon, Eric van (ITOP NS) - KLM
-Original Message- From: ADSM: Dist Stor Manager < <mailto:ADSM-L@VM.MARIST.EDU> ADSM-L@VM.MARIST.EDU > On Behalf Of Loon, Eric van (ITOP NS) - KLM Sent: Mittwoch, 6. Januar 2021 17:31 To: <mailto:ADSM-L@VM.MARIST.EDU> ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM

SQL statement for multiple classes

2021-03-12 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, I'm trying to figure out how to create a SQL query to retrieve the amount of files, per management class, per node in just one query. The ideal output would be: Nodename Class1 Class2 Class3 Mynode1 1234

Re: SQL statement for multiple classes

2021-03-12 Thread Loon, Eric van (ITOP NS) - KLM
eed to do a pivot (aka crosstab), which I'm not sure is possible in through the DB2 interface in dsmadmc. If you run the query w/ "-dataonly=yes -tab" you can import into a spreadsheet easily and do the pivot there, though. Hope that helps! On Fri, Mar 12, 2021 at 03:27:29PM +00

Re: SQL statement for multiple classes

2021-03-12 Thread Loon, Eric van (ITOP NS) - KLM
ks, Marc... Marc Lanteigne Spectrum Protect Specialist AVP / SRT IBM Systems, Spectrum Protect / Plus +1-506-460-9074 <- New phone number marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 15:30 Eastern IBM -----Original Message- From: Loon, Eric van (ITOP NS) - KLM S

Data Protection for Lotus Domino

2021-03-16 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody (and IBM in particular), I noticed TSM 7.1 will be end of support by the end of this year. We are also running several Data Protection for Lotus Domino 7.1 clients, but no 8.1 version seems to be available. Is this product end-of-life or will a Domino client be available later this

Re: Data Protection for Lotus Domino

2021-03-17 Thread Loon, Eric van (ITOP NS) - KLM
Eric, IBM still intends to support Data Protection for Domino after 7.1 goes EOS. Details on that will be available before 7.1 goes EOS. Del "ADSM: Dist Stor Manager" wrote on 03/16/2021 11:40:40 AM: > From: "Loon, Eric van

move container performance

2021-05-06 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, I need to move a lot of containers to empty a filesystem. The LUN used by this filesystem will be moved to a new SP server afterwards. The issue is that the move container process is soo slooow... At the current rate it will take me weeks to empty one single filesystem (13.

Removing a node while replication is running

2021-05-18 Thread Loon, Eric van (ITOP NS) - KLM
Hi guys, Removing an obsolete SP node is an automated process in our company. We recently started to use node replication and I now found that our automation scripts fail every now and then. Apparently you cannot remove a node when replication is running. The required remove replnode results in

Finding the right server when using replication (Windows)

2021-07-27 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, We recently switched to a new server design based on node replication. My Windows users always used scripts which went through all TSM/SP servers to find the right one by just trying to connect to them, one by one. As soon as the dsmc q sess command returned return code 0, it foun

Re: Finding the right server when using replication (Windows)

2021-08-12 Thread Loon, Eric van (ITOP NS) - KLM
h of a difference. Regards, Stefan On Tue, Jul 27, 2021 at 4:41 PM Loon, Eric van (ITOP NS) - KLM < eric-van.l...@klm.com> wrote: > Hi everybody, > > We recently switched to a new server design based on node replication. > My Windows users always used scripts which we

Compare protect stgpool performance

2021-10-12 Thread Loon, Eric van (ITOP NS) - KLM
Hi everybody, We are using a Blueprint-like server setup with two servers, using cross node replication and storage pool protection. I'm not very happy with our protect stgpool performance (approx. 0.5 TB/h) and I like to compare it with other users. So if you are managing a server which is usi

  1   2   >