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.
Managing the data lifecycle
Matching: chen X
On the heels of Vijay's virtual tech briefing on Optim Development Studio 101 (you can register for the replay here, if you missed it!), I'm going to be taking you on a deep dive in one aspect of using the product for SQL Stored Procedure development (with a focus on z/OS). Marichu Scanlon from our continuous engineering team will be on board to help answer questions.
There has been a lots of interest out there in this topic because many people use stored procedures to encapsulate business logic, improve performance, and, with DB2 for z/OS v9 native SQL procedures, they can use them for reduced cost because they are zIIP-eligible.
The first of the two sessions of this briefing will be on September 24 It will last about one hour and will cover topics of creating, deploying, running and working with existing stored procedures. Within this session I will also be answering a lot of the commonly asked questions I have seen both on the forums and customer interactions, and of course I will also be taking your questions during the event itself. Keep in mind, during the September 24 session I'll only touch briefly on how debugging plays in the stored procedure development life cycle since we will be having a follow up deep dive session on October 22 that focuses on how to enable debugging in a z/OS environment. The event is free, and you can register for it here to get the details on accessing the event.
Look forward to seeing you at the tech briefing!
The fix packs for products in the Data Studio family 2.1 have arrived!
The fix packs includes enhancements and fixes to the Version 2.1 release of IBM Data Studio Developer, IBM Data Studio Administrator, IBM Data Studio pureQuery Runtime and of InfoSphere Data Architect 7.5.1. These fix packs are intended to fix problems you may have experienced in the 2.1 release. For additional information or detail on included fixes please check out these links.
Data Studio Administrator Fix Pack 1
InfoSphere Data Architect Fix Pack 1
Data Studio Developer Fix Pack 1
For those who already have these products installed on Windows, you will use IBM Installation Manager to apply the fix pack:
For those who don't have the products installed, go ahead and download the trial versions of the products from the following links:
Data Studio Developer
Data Studio Administrator
InfoSphere Data Architect
(By they way, you can find all these links together on the Data Studio Community Space.)
Now you are ready to go!
We also have fix packs for DB2 Performance Expert and DB2 Performance Expert Insight Feature:
DB2 Performance Expert Version 3.2 Fix Pack 1
DB2 Performance Expert Extended Insight Feature Version 3.2 Fix Pack 1
-- Tina Chen
Curt almost missed his session yesterday. Someone called him 10 mins before the session to remind him -- he recovered quickly and was only 5 mins late. Full room with heads bobbing up and down when talking about problems with supporting Java applications.
Most folks liked Dana Carvey much better last year than Martin Short.
Listening now to Jim Pickel on DB2 Security.
Lost more money at craps and blackjack table. I'm now starting to feel this financial crisis that I keep hearing about on the news.
-- Bryan Smith
I am sitting in the awesome developer den where there is a roomful of colorful bean bags! Along with 2 Wiis that they will be giving away at the end of the week. IOD attendees should stop by to enter into the Wii contest and there are many laptops set up with Data Studio developersWorks articles. Visitors can check out articles on Data Studio and its family of products and also ask the experts about Data Studio. We are located in Breakers G from 10am - 5pm.
Bad news, we had connectivity problems in the Data Studio for DB2 for z/OS labs. But we have a re-do on Thursday, and I hope everyone who really wanted to do this lab with a DB2 for z/OS server will come:
Session: HOL-2670B Data Studio and DB2 for z/OS
Time: Thu, 30/Oct, 02:00 PM - 05:00 PM
Location: Mandalay Bay South Convention Center - Lagoon F
-- Tina Chen
This is actually day 4 for me as I spent the weekend with DB2 LUW customers attending the DB2 Customer Advisory Council, a group of DB2 customers that provide feedback to the DB2 Toronto team on upcoming releases and future strategies to help shape DB2 LUW. We had a three hour window with these customers on Data Studio and the feedback was tremendous. The big change I'm seeing from 6 months ago at IDUG is customers are now downloading and using Data Studio throughout their developer communities. They're seeing the value Data Studio has to add over and above what they get from either Developer Workbench or other 3rd party development tools. Also, not only are they using this for their DB2 LUW environments, but several users indicated that they're using this for DB2 z/OS, as it enables their developers to easily build and debug SQL stored procedures for their DB2 z/OS environments. This is a big change from 6 months ago when customers didn't even know Data Studio existed.
Yesterday I held a session called "Empowering DBAs with Data Studio", the room was full with standing room only. Goes to show that DBAs are always looking for the latest and greatest technology to manage their databases. I demonstrated the new Data Studio coming soon. This upcoming release has added a ton of functionality for the DBA; including utilties, commands and more DDL management. The audience was very excited and really wants to see Data Studio become their tool for managing both DB2 LUW and DB2 z/OS databases. There's definitely a buzz around Data Studio at this conference.
Tonight I arranged a podcast with YL&A consultants and Curt Cotner on Data Studio. I'll let you know how that goes....
-- Deb Jenson
"RU Ready?" This is what I was thinking when I was on the plane to China.
Being that this was my first time in China, I didn’t even know what to expect much less how many people would show up at my Data Studio session. I was on my way to attend the Rational Software Development Conference in China, which was hosted in the Shanghai Convention Center in September.
When I finally arrived I was completely surprised to see how many people showed up at the one day conference!
Around 900-plus people packed the 2nd floor to listen to “R Heroes” discuss what Rational had to offer this year. Due to the larger than expected audience, the auditorium was packed with attendees for the keynote speech, and since so many people showed up they had to open a separate hall to televise the speech! Did I mention the entire conference was also streamed online live? Talking about using technology to its fullest advantage!
To my surprise, I had around 110 people show up at my talk, and the conference hall was so packed that there were people standing on chairs outside the door trying to get a glimpse of the slides.
By the request of the local team at the last minute, I was asked to present my Data Studio slides in Chinese. Now I really had to put my 10-plus years of Chinese school learned in the US to work!
When I speech was over, there was silence. I could hear people scribbling on their notepad, jogging down notes. Was my Chinese so bad that no one knew what I was saying?
And all of sudden, hands were popping into the air.
This was the first time many of the attendees were introduced to Data Studio and its family of products. Attendees were asking great questions like how to use pureQuery with their existing Hibernate applications. And how Data Studio could help them become productive.
On my plane ride back to the states I exhaled a sigh of relieve as I boarded the plane. My mission was complete.
-- Tina Chen