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:
DSNL082I LOCATION LUNAME GENERICLU
DSNL083I DA1B USILDA01.DA1BDB2 USILDA01.DA0GPTIB
DSNL084I TCPPORT=9500 SECPORT=9501 RESPORT=9502 IPNAME=-NONE
DSNL086I SQL DOMAIN=p390.themisinc.com
DSNL086I RESYNC DOMAIN= p390.themisinc.com
DSNL089I MEMBER IPADDR=::126.96.36.199
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.