Re: TSM API for Cassandra database

[Bommasani, Venu]

Hi Del,

Thanks for your response. 

The "dump and sweep" method may not good solution here as taking Backup and 
dumping onto local/remote filesystem may take some time and then taking that 
flat file Backup onto TSM using BA client would more time & resource consuming 
process as the Database size is already more than 3 TB.

I was really not sure about that option "1" - Leverage the new "S3" interface 
to the Spectrum Protect server (instead of the TSM API).
Appreciate if you could able to share any reference technote for the same. 
Thanks.


Best Regards,
_

Venu Bommasani
Storage & Data Protection
Capgemini India | Bangalore
 Mobile: +91 7795213309 / venu.bommas...@capgemini.com

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Del Hoobler
Sent: Saturday, April 24, 2021 12:08 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM API for Cassandra database

There is no "TDP for Cassandra".

Some ideas to consider:

1. Leverage the new "S3" interface to the Spectrum Protect server (instead of 
the TSM API).

2. Use the "dump and sweep" method, i.e. dump the backup to a file and then 
back up the file with the Backup/Archive client.


Del



"ADSM: Dist Stor Manager"  wrote on 04/23/2021 
02:24:59 PM:

> From: "Bommasani, Venu" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 04/23/2021 02:25 PM
> Subject: [EXTERNAL] TSM API for Cassandra database
> Sent by: "ADSM: Dist Stor Manager" 
> 
> Hello Team,
> 
> Does anyone taking Cassandra database Backup using TSM API ?
> 
> I have a request to perform a Backup for Cassandra database , But 
> could not able to find any TDP agent for the same..!
> Does it possible to Backup Cassandra database Backup using a 
> customize API and perform an online Backups to TSM ? Thanks in Advance.
> 
> 
> Best Regards,
> _
> 
> Venu Bommasani
> Storage & Data Protection
> Capgemini India | Bangalore
> Mobile: +91 7795213309 / venu.bommas...@capgemini.com
> 
> This message contains information that may be privileged or 
> confidential and is the property of the Capgemini Group. It is 
> intended only for the person to whom it is addressed. If you are not
> the intended recipient, you are not authorized to read, print, 
> retain, copy, disseminate, distribute, or use this message or any 
> part thereof. If you receive this message in error, please notify 
> the sender immediately and delete all copies of this message.
> 
This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

TSM API for Cassandra database

[Bommasani, Venu]

Hello Team,

Does anyone taking Cassandra database Backup using TSM API ?

I have a request to perform a Backup for Cassandra database , But could not 
able to find any TDP agent for the same..!
Does it possible to Backup Cassandra database Backup using a customize API and 
perform an online Backups to TSM ? Thanks in Advance.


Best Regards,
_

Venu Bommasani
Storage & Data Protection
Capgemini India | Bangalore
Mobile: +91 7795213309 / venu.bommas...@capgemini.com

This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

Re: TSM API for Cassandra database

[Del Hoobler]

I do not personally have details on how this works, but I have heard it 
mentioned by a few people.

I was mainly reminding the community that Spectrum Protect introduced an 
S3 interface last year:

https://www.ibm.com/docs/en/spectrum-protect/8.1.12?topic=cs-sending-data-spectrum-protect-by-using-s3-client-applications



Del




"ADSM: Dist Stor Manager"  wrote on 04/23/2021 
03:26:11 PM:

> From: "Bommasani, Venu" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 04/23/2021 03:26 PM
> Subject: [EXTERNAL] Re: TSM API for Cassandra database
> Sent by: "ADSM: Dist Stor Manager" 
> 
> Hi Del,
> 
> Thanks for your response. 
> 
> The "dump and sweep" method may not good solution here as taking 
> Backup and dumping onto local/remote filesystem may take some time 
> and then taking that flat file Backup onto TSM using BA client would
> more time & resource consuming process as the Database size is 
> already more than 3 TB.
> 
> I was really not sure about that option "1" - Leverage the new "S3" 
> interface to the Spectrum Protect server (instead of the TSM API).
> Appreciate if you could able to share any reference technote for the
> same. Thanks.
> 
> 
> Best Regards,
> _
> 
> Venu Bommasani
> Storage & Data Protection
> Capgemini India | Bangalore
>  Mobile: +91 7795213309 / venu.bommas...@capgemini.com
> 
> -Original Message-
> From: ADSM: Dist Stor Manager  On Behalf Of Del 
Hoobler
> Sent: Saturday, April 24, 2021 12:08 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] TSM API for Cassandra database
> 
> There is no "TDP for Cassandra".
> 
> Some ideas to consider:
> 
> 1. Leverage the new "S3" interface to the Spectrum Protect server 
> (instead of the TSM API).
> 
> 2. Use the "dump and sweep" method, i.e. dump the backup to a file 
> and then back up the file with the Backup/Archive client.
> 
> 
> Del
> 
> 
> 
> "ADSM: Dist Stor Manager"  wrote on 04/23/2021 
> 02:24:59 PM:
> 
> > From: "Bommasani, Venu" 
> > To: ADSM-L@VM.MARIST.EDU
> > Date: 04/23/2021 02:25 PM
> > Subject: [EXTERNAL] TSM API for Cassandra database
> > Sent by: "ADSM: Dist Stor Manager" 
> > 
> > Hello Team,
> > 
> > Does anyone taking Cassandra database Backup using TSM API ?
> > 
> > I have a request to perform a Backup for Cassandra database , But 
> > could not able to find any TDP agent for the same..!
> > Does it possible to Backup Cassandra database Backup using a 
> > customize API and perform an online Backups to TSM ? Thanks in 
Advance.
> > 
> > 
> > Best Regards,
> > _
> > 
> > Venu Bommasani
> > Storage & Data Protection
> > Capgemini India | Bangalore
> > Mobile: +91 7795213309 / venu.bommas...@capgemini.com
> > 
> > This message contains information that may be privileged or 
> > confidential and is the property of the Capgemini Group. It is 
> > intended only for the person to whom it is addressed. If you are not
> > the intended recipient, you are not authorized to read, print, 
> > retain, copy, disseminate, distribute, or use this message or any 
> > part thereof. If you receive this message in error, please notify 
> > the sender immediately and delete all copies of this message.
> > 
> This message contains information that may be privileged or 
> confidential and is the property of the Capgemini Group. It is 
> intended only for the person to whom it is addressed. If you are not
> the intended recipient, you are not authorized to read, print, 
> retain, copy, disseminate, distribute, or use this message or any 
> part thereof. If you receive this message in error, please notify 
> the sender immediately and delete all copies of this message.
> 

Re: TSM API for Cassandra database

[Del Hoobler]

There is no "TDP for Cassandra".

Some ideas to consider:

1. Leverage the new "S3" interface to the Spectrum Protect server (instead 
of the TSM API).

2. Use the "dump and sweep" method, i.e. dump the backup to a file and 
then back up the file with the Backup/Archive client.


Del



"ADSM: Dist Stor Manager"  wrote on 04/23/2021 
02:24:59 PM:

> From: "Bommasani, Venu" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 04/23/2021 02:25 PM
> Subject: [EXTERNAL] TSM API for Cassandra database
> Sent by: "ADSM: Dist Stor Manager" 
> 
> Hello Team,
> 
> Does anyone taking Cassandra database Backup using TSM API ?
> 
> I have a request to perform a Backup for Cassandra database , But 
> could not able to find any TDP agent for the same..!
> Does it possible to Backup Cassandra database Backup using a 
> customize API and perform an online Backups to TSM ? Thanks in Advance.
> 
> 
> Best Regards,
> _
> 
> Venu Bommasani
> Storage & Data Protection
> Capgemini India | Bangalore
> Mobile: +91 7795213309 / venu.bommas...@capgemini.com
> 
> This message contains information that may be privileged or 
> confidential and is the property of the Capgemini Group. It is 
> intended only for the person to whom it is addressed. If you are not
> the intended recipient, you are not authorized to read, print, 
> retain, copy, disseminate, distribute, or use this message or any 
> part thereof. If you receive this message in error, please notify 
> the sender immediately and delete all copies of this message.
> 

TSM alternatives

[Stahlberg, Michael]

HI all,

unfortunately IBM decided to stop the support for Solaris Clients. This is
a pain for us and we have decided to move to a different product. I'm
checking for alternatives and would like to know if somebody has the same
issue and/or has already decided to move to a different product. I'm not
happy about this, but our main clients are all Solaris Clients still..

regards



*Michael Stahlberg*
Engineer IV Consultant - Network Eng & Ops
Server & Services Management International -* Global Operations | Verizon*
Wireline Network
Tel: +49 231 972 0 | Cell: +49 231 972 0

==

Verizon Deutschland GmbH - Sebrathweg 20, 44149 Dortmund, Germany - Amtsgericht 
Dortmund, HRB 14952 - Geschäftsführer: Detlef Eppig - Vorsitzender des 
Aufsichtsrats: Francesco de Maio

Re: TSM alternatives

[Del Hoobler]

Thanks Michael.

Just to be sure it's clear to all.

IBM Spectrum Protect still supports Solaris for x86_64. It's the Solaris 
SPARC platform that is API only support:

https://www.ibm.com/support/pages/node/84861#Solaris%20x86_64

Some other notes:
- You can still use the Spectrum Protect V7 Solaris SPARC B/A client until 
the end of this year with full support... and longer with extended 
support.
- You can also mount the Solaris SPARC filesystems and back it up from a 
proxy server.


Del




"ADSM: Dist Stor Manager"  wrote on 04/23/2021 
09:32:19 AM:

> From: "Stahlberg, Michael" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 04/23/2021 09:33 AM
> Subject: [EXTERNAL] TSM alternatives
> Sent by: "ADSM: Dist Stor Manager" 
> 
> HI all,
> 
> unfortunately IBM decided to stop the support for Solaris Clients. This 
is
> a pain for us and we have decided to move to a different product. I'm
> checking for alternatives and would like to know if somebody has the 
same
> issue and/or has already decided to move to a different product. I'm not
> happy about this, but our main clients are all Solaris Clients 
still..
> 
> regards
> 
>  u=http-3A__www.verizon.com=DwIFaQ=jf_iaSHvJObTbx-
> 
siA1ZOg=0hq2JX5c3TEZNriHEs7Zf7HrkY2fNtONOrEOM8Txvk8=6A_Oax46rHV7OFpRD535E9xEkLeChb5REQjB-
> ceSTLc=HAwiCutcUMO04kWTHODK3NR79sbupV9T8nQJfPSIaZE= >
> 
> *Michael Stahlberg*
> Engineer IV Consultant - Network Eng & Ops
> Server & Services Management International -* Global Operations | 
Verizon*
> Wireline Network
> Tel: +49 231 972 0 | Cell: +49 231 972 0
> 
> ==
> 
> Verizon Deutschland GmbH - Sebrathweg 20, 44149 Dortmund, Germany - 
> Amtsgericht Dortmund, HRB 14952 - Geschäftsführer: Detlef Eppig - 
> Vorsitzender des Aufsichtsrats: Francesco de Maio
> 

Re: spectrum protect 8.1.11.100 strange behaviour with dedup pool

[Uwe Schreiber]

That is related to APAR IT36573.
Michael already mentioned the eFix versions which provide a fix for that 
"feature".

Regards, Uwe

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Michael Prix
Sent: Freitag, 23. April 2021 08:59
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] spectrum protect 8.1.11.100 strange behaviour with dedup 
pool

Hello,

that feature is handled in eFix 8.1.11.101, contact IBM to get access to it.
It also affects 8.1.10.200 and is fixed in eFix 8.1.10.204.

--
Michael Prix

On 4/23/21 8:52 AM, Tsm Tsm wrote:
> Hello,
>
> on my test servers if you move or defragment (automatic) containers 
> the spectrum protect application crashes, DB2 service still alive.
>
> ANR0984I Process 2 for Move Container (Automatic) started in the 
> BACKGROUND at 02:02:07.
>
> ANR0984I Process 3 for Move Container (Automatic) started in the 
> BACKGROUND at 02:02:07.
>
> ANR0984I Process 4 for Move Container (Automatic) started in the 
> BACKGROUND at 02:02:07.
>
> ANR0984I Process 5 for Move Container (Automatic) started in the 
> BACKGROUND at 02:02:07.
>
> ANR0984I Process 6 for Move Container (Automatic) started in the 
> BACKGROUND at 02:02:07.
>
> ANRD_1199904567 SdWriteContainer(sdio.c:1588) Thread<207>: 
> Improper setup for writing to container 0058AE36CFB0 (nil) True
>
> ANRD Thread<207> issued message  from:
>
> ANRD Thread<207>  7ffb7afe5582 OutDiagToCons()+b2
>
> ANRD Thread<207>  7ffb7afde2c2 outDiagfExt()+122
>
> ANRD Thread<207>  7ffb7ad0c943 SdWriteContainer()+483
>
> ANRD Thread<207>  7ffb7ad0d54e SdWrite()+b8e
>
> ANRD Thread<207>  7ffb7acf0969 ProcessDefragData()+219
>
> ANRD Thread<207>  7ffb7acef0f8 ProcessStreamBuffer()+238
>
> ANRD Thread<207>  7ffb7aced8b8 SdCntrStreamThread()+14f8
>
> ANRD Thread<207>  7ffb7a2ad2d3 startThread()+5b3
>
> ANRD Thread<207>  7ffba3cdf4a0 o__realloc_base()+60
>
> ANRD Thread<207>  7ffbaf0b13f2 BaseThreadInitThunk()+22
>
> ANRD Thread<207>  7ffbb14254f4 RtlUserThreadStart()+34
>
> Entering exception handler.
>
>
> anything known about this?  before crash many nondedup files going to 
> state unavailable. you can audit them successful but the next move 
> runs into a failure or server crashes.
>
> with best regards
> Stefan Savoric

Re: spectrum protect 8.1.11.100 strange behaviour with dedup pool

[Michael Prix]

Hello,

that feature is handled in eFix 8.1.11.101, contact IBM to get access to it.
It also affects 8.1.10.200 and is fixed in eFix 8.1.10.204.

--
Michael Prix

On 4/23/21 8:52 AM, Tsm Tsm wrote:

Hello,

on my test servers if you move or defragment (automatic) containers the
spectrum protect application crashes, DB2 service still alive.

ANR0984I Process 2 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 3 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 4 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 5 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 6 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANRD_1199904567 SdWriteContainer(sdio.c:1588) Thread<207>: Improper
setup for writing to container 0058AE36CFB0 (nil) True

ANRD Thread<207> issued message  from:

ANRD Thread<207>  7ffb7afe5582 OutDiagToCons()+b2

ANRD Thread<207>  7ffb7afde2c2 outDiagfExt()+122

ANRD Thread<207>  7ffb7ad0c943 SdWriteContainer()+483

ANRD Thread<207>  7ffb7ad0d54e SdWrite()+b8e

ANRD Thread<207>  7ffb7acf0969 ProcessDefragData()+219

ANRD Thread<207>  7ffb7acef0f8 ProcessStreamBuffer()+238

ANRD Thread<207>  7ffb7aced8b8 SdCntrStreamThread()+14f8

ANRD Thread<207>  7ffb7a2ad2d3 startThread()+5b3

ANRD Thread<207>  7ffba3cdf4a0 o__realloc_base()+60

ANRD Thread<207>  7ffbaf0b13f2 BaseThreadInitThunk()+22

ANRD Thread<207>  7ffbb14254f4 RtlUserThreadStart()+34

Entering exception handler.


anything known about this?  before crash many nondedup files going to state
unavailable. you can audit them successful but the next move runs into a
failure or server crashes.

with best regards
Stefan Savoric

spectrum protect 8.1.11.100 strange behaviour with dedup pool

[Tsm Tsm]

Hello,

on my test servers if you move or defragment (automatic) containers the
spectrum protect application crashes, DB2 service still alive.

ANR0984I Process 2 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 3 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 4 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 5 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANR0984I Process 6 for Move Container (Automatic) started in the BACKGROUND
at 02:02:07.

ANRD_1199904567 SdWriteContainer(sdio.c:1588) Thread<207>: Improper
setup for writing to container 0058AE36CFB0 (nil) True

ANRD Thread<207> issued message  from:

ANRD Thread<207>  7ffb7afe5582 OutDiagToCons()+b2

ANRD Thread<207>  7ffb7afde2c2 outDiagfExt()+122

ANRD Thread<207>  7ffb7ad0c943 SdWriteContainer()+483

ANRD Thread<207>  7ffb7ad0d54e SdWrite()+b8e

ANRD Thread<207>  7ffb7acf0969 ProcessDefragData()+219

ANRD Thread<207>  7ffb7acef0f8 ProcessStreamBuffer()+238

ANRD Thread<207>  7ffb7aced8b8 SdCntrStreamThread()+14f8

ANRD Thread<207>  7ffb7a2ad2d3 startThread()+5b3

ANRD Thread<207>  7ffba3cdf4a0 o__realloc_base()+60

ANRD Thread<207>  7ffbaf0b13f2 BaseThreadInitThunk()+22

ANRD Thread<207>  7ffbb14254f4 RtlUserThreadStart()+34

Entering exception handler.


anything known about this?  before crash many nondedup files going to state
unavailable. you can audit them successful but the next move runs into a
failure or server crashes.

with best regards
Stefan Savoric