Is Data Studio free for non-Db2 database users?

Robert Plata

Is Data Studio free for non-Db2 database users?

Hello,

I work at Oregon State Lottery and our agency has not purchased any Db2 (LUW nor z/OS) licenses.  We are strictly a Microsoft SQL Server shop.  

However, a new project will allow a direct connection to one of our vendors who is running Db2 LUW.  We will be connecting to the vendor to SELECT data for reporting and analytics purposes.  I would like to use Data Studio 4.1.3 as a database tool, since I am very familiar with using Data Studio as an ex-Db2 DBA.  I don't believe that SQL Server Management Studio will allow a ODBC/JDBC connection to Db2 LUW except through a linked server.  

===> My question is: can I install and use Data Studio for free even though my agency has not purchased a Db2 license? 

We have other agencies that are currently licensed for Db2 LUW and z/OS.  I don't have contact with our other agency's IBM software representatives to ask them for a definitive answer.

Thanks for your time!

Rob Plata

All opinions are my own and do not reflect those of my employer.

Philip Nelson

Is Data Studio free for non-Db2 database users?
(in response to Robert Plata)
Yes

On Thu, 6 Feb 2020 at 23:49, Robert Plata <[login to unmask email]> wrote:

> Hello,
>
> I work at Oregon State Lottery and our agency has not purchased any Db2
> (LUW nor z/OS) licenses. We are strictly a Microsoft SQL Server shop.
>
> However, a new project will allow a direct connection to one of our
> vendors who is running Db2 LUW. We will be connecting to the vendor to
> SELECT data for reporting and analytics purposes. I would like to use Data
> Studio 4.1.3 as a database tool, since I am very familiar with using Data
> Studio as an ex-Db2 DBA. I don't believe that SQL Server Management Studio
> will allow a ODBC/JDBC connection to Db2 LUW except through a linked
> server.
>
> *===> My question is:* can I install and use Data Studio for free even
> though my agency has not purchased a Db2 license?
>
> We have other agencies that are currently licensed for Db2 LUW and z/OS.
> I don't have contact with our other agency's IBM software representatives
> to ask them for a definitive answer.
>
> Thanks for your time!
>
> Rob Plata
>
> All opinions are my own and do not reflect those of my employer.
>
> -----End Original Message-----
>

Daniel Luksetich

Is Data Studio free for non-Db2 database users?
(in response to Robert Plata)
Yes. I believe you can connect to Db2 and SQL Server via Data Studio. Although I have not done the latter. SSMS can also connect to Db2. So, you have choices to explore!

Dan



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Robert Plata <[login to unmask email]>
Sent: Thursday, February 6, 2020 5:50 PM
To: [login to unmask email]
Subject: [DB2-L] - Is Data Studio free for non-Db2 database users?



Hello,

I work at Oregon State Lottery and our agency has not purchased any Db2 (LUW nor z/OS) licenses. We are strictly a Microsoft SQL Server shop.

However, a new project will allow a direct connection to one of our vendors who is running Db2 LUW. We will be connecting to the vendor to SELECT data for reporting and analytics purposes. I would like to use Data Studio 4.1.3 as a database tool, since I am very familiar with using Data Studio as an ex-Db2 DBA. I don't believe that SQL Server Management Studio will allow a ODBC/JDBC connection to Db2 LUW except through a linked server.

===> My question is: can I install and use Data Studio for free even though my agency has not purchased a Db2 license?

We have other agencies that are currently licensed for Db2 LUW and z/OS. I don't have contact with our other agency's IBM software representatives to ask them for a definitive answer.

Thanks for your time!

Rob Plata

All opinions are my own and do not reflect those of my employer.



-----End Original Message-----

Attachments

  • image001.png (9.6k)
  • image002.png (14k)
  • image003.png (13.1k)
  • image004.png (11.7k)
  • image005.png (15.3k)
  • image006.png (14.2k)
  • image007.png (7.5k)