Managing IDAA with Data Studio

Recently, I downloaded and installed Data Studio 4.1 with the IBM DB2 Analytics Accelerator (IDAA) plug-in. I was going to write about using this solution to create a database connection, but it turns out that this topic is already well covered by David Simpson. Check out this terrific presentation he gave to the Baltimore/Washington DB2 User Group.

While David doesn't get into the features of IDAA, you'll learn a lot about the basics of using Data Studio with DB2 for z/OS. Page 14 lists the parameters needed to create the database connection, though there are actually several ways to find this information. One option is to look at the DB2 master address started task and do a find on "DDF." You can also use the DB2 command: –DIS DDF.

Output from –DIS DDF command with values changed to match page 14.

DSNL080I  !DA0G DSNLTDDF DISPLAY DDF REPORT FOLLOWS:          

DSNL081I STATUS=STARTD                                         

DSNL082I LOCATION            LUNAME                           GENERICLU       

DSNL083I DA1B                    USILDA01.DA1BDB2       USILDA01.DA0GPTIB

DSNL084I TCPPORT=9500  SECPORT=9501  RESPORT=9502  IPNAME=-NONE

DSNL085I IPADDR=::140.212.64.35                                

DSNL086I SQL    DOMAIN=p390.themisinc.com                        

DSNL086I RESYNC DOMAIN= p390.themisinc.com                       

DSNL089I MEMBER IPADDR=::140.212.64.35                        

DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE

Once Data Studio is installed and a database connection to a subsystem with an accelerator is established, you can start managing the accelerators as well as DB2 tables that use the accelerator with Data Studio. Here are some relevant resources:

* The presentation, "Deep Dive into IBM DB2 Analytics Accelerator Query Acceleration."

* This blog. Over the past year-plus, I've written three posts on IDAA. They're listed here.

* Data Studio help: Just select HELP and enter ACCELERATOR for a list of topics.

Data Studio software can be downloaded here. Be sure to pick the option that includes IDAA and other third-party product extensions. This will allow you to access the accelerator features.