We released several fixpacks on April 19th that I want to call your attention to. Not only do they provide defect fixes, but also some cool new function.
Data Studio Health Monitor - This fixpack adds support for health monitoring for DB2 for z/OS as well as alert notification support. Customers that we previewed the function with really liked the easy setup and the ability to share it with teams members in development and other operations staff. It monitors and alerts application blocking conditions like database down or log full plus users can view system log messages and see what application and utilities are running. Data Studio Health Monitoring is available at no charge and support DB2 for z/OS and DB2 for Linux, UNIX, and Windows databases. Check it out now! For more information, see the IBM Data Studio Health Monitor Version 184.108.40.206 Release Notes and product overview pages. You can download Data Studio Health Monitor V220.127.116.11 for an upgrade from version 2.2.1 or for a fresh install at IBM software downloads.
Optim Query Tuner - Query Tuner users will definitely want to pick this up! This fixpack for Optim Query Tuner offerings provides a new Access Plan Explorer. Many customers who have very complex SQL wanted a textual access plan navigation method in additional to the visual explain. This new tool displays access plans as tables or hierarchical trees. There are also additional usability and SQL capture enhancements. See What's New in Optim Query Tuner and the Release Notes pages.
InfoSphere Data Architect - This is a standard fixpack with defect fixes. For more information, see the IBM InfoSphere Data Architect Version 18.104.22.168 Release Notes and product overview pages. View the download document to learn how to download InfoSphere Data Architect V22.214.171.124 to upgrade from version 7.5.3.
Let us know how you like these enhancements :-)
Managing the data lifecycle
Matching: zos X
You’ve heard a lot here about pureQuery value: better performance, faster development, improved manageability, and increased security. Now we’re making it even easier to purchase pureQuery. We’re announcing two new DB2 Connect offerings that bundle Optim pureQuery Runtime:
Purchasing is made easier because most DB2 for z/OS customers already have DB2 Connect on their approved products list, speeding up procurement. And you can easily upgrade from DB2 Connect Application Server Edition or from DB2 Connect Unlimited Edition for System z to the respective Advanced Edition offering. Check out our announcement letter here.
And for those of you going to the Information On Demand Global Conference, be sure to check out how State Farm (State Farm Optimizes App Performance with Optim Development Studio, pureQuery, TDM-1718) and Handelsbanken (Evaluating Java Data Access Technologies at Handelsbanken, TDM-2177) are realizing pureQuery value.
Today I was talking with a customer who has Java applications that call COBOL and SQL stored procedures to do some additional business logic. My customer asked me if IBM offers a tool that can assist programmers and DBAs to do seamless debugging between Java applications and stored procedures.
This isn’t the first time that I have heard this request from customers because it can be a real pain point.The scenario is this: during development, developers need to debug a Java application that invokes a COBOL stored procedure and a SQL procedure. To debug that, you might need multiple tools - one that debugs the Java application, one for debugging COBOL stored procedures and another for the SQL. In fact, by co-installing (shell sharing) Optim Development Studio with Rational Developer for System z, you actually can do this end to end debugging without switching contexts. ODS provides the SQL procedure debugging capability, and RDz provides Java application and COBOL stored procedure debugging capabilities.
Next week, please join me on a follow up to our previous session on on building and deploying SQL stored procedures for DB2 for z/OS. In next week's session, Marichu Scanlon and I will go into more details on debugging, including some hints and tips. And we have our Rational friends on board to demonstrate debugging how to debug COBOL stored procedures.
May the demo gods be smiling upon us.