topic Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500? in Qlik Replicate

Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Fri, 15 Nov 2024 22:07:19 GMT

Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Dana_Baldwin — Wed, 20 Jul 2022 22:30:43 GMT

Can you please confirm the version of Replicate you are running? We did not publish a version 5.3, we went from version 5.2 to version 5.5 (these versions came out a few years back). I did check our most recent release, version 2022.5, and it does support DB2 V12 source on z/OS.

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Support%20Matrix/supported_source_endpoints.htm#Supported%20source%20endpoints

Thanks,

Dana

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Dana_Baldwin — Wed, 20 Jul 2022 22:43:11 GMT

Hi @jdvan123

I found it, you're referring to the version of AIS (Attunity Integration Suite). I will check on this and follow up with you. Please also let me know the full version number of Replicate that you're using.

Thanks,

Dana

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

lyka — Wed, 20 Jul 2022 22:47:04 GMT

Hello @jdvan123

I hope you are doing well. Just to add on Dana's reply. i just want to let you know as well that AIS is a retired product .

Please refer here for more info.

https://community.qlik.com/t5/Support-Updates-Blog/Retirement-of-legacy-Attunity-products-on-January-31-2022/ba-p/1732910

I hope this helps!

Thanks
Lyka

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Dana_Baldwin — Wed, 20 Jul 2022 23:09:56 GMT

Hi @jdvan123

You might be able to use a native endpoint to connect to your source. What platform is DB2 hosted on in your environment?

Thanks,

Dana

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Barb_Fill21 — Thu, 21 Jul 2022 00:10:16 GMT

Hi @jdvan123

Here is a link to consider if you would like to use the Db2 z/OS Native Endpoint.

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/IBM%20DB2%20for%20zOS/db2.htm#ar_ibm_db2_456845099_1404492

Thanks

Barb

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

john_wang — Thu, 21 Jul 2022 00:23:34 GMT

Hello @jdvan123 , copy @Barb_Fill21 , @Dana_Baldwin , @lyka ,

There are many benefits of migration to Qlik Replicate (rather than using Qlik/Attunity AIS):

1. AIS is out of support;

2. Qlik Replicate support end to end replication, AIS is a middleware which needs 3rd party ETL tool cooperation

3. Qlik Replicate support DDL , AIS does not.

4. Qlik Replicate needs a very lite component on Mainframe, AIS component on Mainframe is a fat AIS Server.

5. Qlik Replicate is easy use, drag/drop to design a task quickly in GUI by simple steps. In AIS Studio configuration a project/solution is pretty complex.

6. Qlik Replicate provides error/warning notification emails, resource control, transformations (in column level, table level, global level ) ... so many new features/enhancement while AIS does not contain these abilities.

Hope this helps.

Regards,

John.

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Thu, 21 Jul 2022 14:32:19 GMT

Hi Dana,

Here's the message I see in the SYSPRINT ddname output of my started task:

Attunity Server Daemon (IRPCD)(V.5.3.3.43 32-bit)

Thank you,

Jim VanArsdale

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Thu, 21 Jul 2022 14:32:57 GMT

Hi Dana,

Here's the message I see in the SYSPRINT ddname output of my started task:

Attunity Server Daemon (IRPCD)(V.5.3.3.43 32-bit)

Thank you,

Jim VanArsdale

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Thu, 21 Jul 2022 14:38:09 GMT

Hi Dana,

I found another started task that displays the following identifier in its output:

Attunity Server Log (V5.3.3.43, MVS 32-bit)

Thank you,

Jim VanArsdale

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Bill_Steinagle — Wed, 27 Jul 2022 11:13:35 GMT

Jim,

Hello, thank you for the post to the QDI forums. The AIS product is now out of Service and depending on how the product is being used will depend on if you can move to the Replicate (ARC) Product for Z/OS. Can you share more details on the AIS Product and configuration you have for these environments and what type of Datasources you have configured on Z/OS? Since the AIS Product is out of Service (Support) you would be able to run with the new DB2 12 version however if you run into any issues we would not be able to assist if there is a DB2 12 issue with the tool. As posted the Replicate (ARC) component can be installed on Z/OS to connect to DB2 Tables defined to this environment, VSAM files, Flat Files along with IMS running on Z/OS with the new Product.

Regards,

Bill Steinagle

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Wed, 27 Jul 2022 12:18:57 GMT

Hi Bill,

We’re using AIS to connect to DB2 tables on the mainframe:

Attunity Server Daemon (IRPCD)(V.5.3.3.43 32-bit) - Started at 24-Jul-22 03:54:53

STEP1 EXEC PGM=IRPCD,REGION=64M,PARM='-B -L 142.30.33.222:2552 START IRPCDINI'

ddname GBLPARMS:

NAVROOT = PATTD.AC5327

SUBSYSTEM = PDB2

PLAN = PLAN

SMS_STORAGE_CLASS = SCUAT

SVC_VOLUME = *

!NOSIMPL = PROF

!NV_NO_IDCAMS=1

Attunity Server Log (V5.3.3.43, MVS 32-bit) Started at 2022-07-24T03:54:58

Permanent license issued by Attunity US on 28-Dec-2017 (55008026)

STEP1 EXEC PGM=NAVUTIL,REGION=384M

ddname GBLPARMS:

NAVROOT = PATTD.AC5327

SUBSYSTEM = PDB2

PLAN = PLAN

SMS_STORAGE_CLASS = SCUAT

SVC_VOLUME = *

!NOSIMPL = PROF

!NV_NO_IDCAMS=1

ddname DSNAOINI:

ÝCOMMON¨

MVSDEFAULTSSID=ODB2

; Example SUBSYSTEM odbcini for DSN1 subsystem

ÝODB2¨

MVSATTACHTYPE=CAF

PLANNAME=DSNACLI

Thank you,

Jim VanArsdale

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Bill_Steinagle — Wed, 27 Jul 2022 12:30:53 GMT

Jim,

Thank you for the reply and confirmation. Since the AIS Product is out of Service and your current setup is accessing DB2 Tables on Z/OS you can upgrade and install a Support Replicate version for the same access. However keep in mind how the Tables are being used with AIS Product as from the update you have ODBC connections setup to the Datasources you have defined in AIS for an ETL process downstream?

Confirm the below:

- how are the Tables accessed from AIS via the Datasource you defined in the Bindings

- what processing are you running on the DB2 Tables

- what is the purpose of the AIS Setup to the DB2 Tables

- Replicate is used to Load and Change Data Capture of Tables from Source to Target environment

- depending on the setup and how the Tables are being used in AIS will depend on if you need to upgrade or stay with the AIS product

Thanks!

Bill

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

jdvan123 — Wed, 27 Jul 2022 13:04:59 GMT

Hi Bill,

I checked with the team that uses the AIS software. They are using the software to direct access defined VSAM/IAM and SEQ files and DB2 tables. At this time, they plan to sunset this software prior to the end of this year. Therefore, we are planning to stay on the AIS software until the sunset.

Thank you for your feedback.

Jim VanArsdale

Re: Is Attunity Server (Qlik Replicate) V5.3.4.0 compatible with DB2 V12 FL 500?

Bill_Steinagle — Wed, 27 Jul 2022 13:15:45 GMT

Jim,

Great thank you for the reply as with the current setup and use of AIS for the data access the Replicate product can connect and access the data but your use case would not fit the Replicate usage. Just to cover all bases I have attached the Replicate Connect (ARC) component you install on the Z/OS environment to use with the Replicate product. Thank you again for reaching out and hope you find this information helpful.

Note: I just wanted to make sure you had all your options and possible replacement to AIS.

Thanks!

Bill