Tags

Recent tweets

I wanted to point you to a new video series on pureQuery development , specifically developing a new application using pureQuery annotated methods. If you are new to pureQuery and would like a quick overview of the development experience and productivity benefits using Optim Development Studio, then these videos are a must see. When using DB2, the videos will show you in action, the potential for improving SQL performance in your application by using static SQL. The series is based on a tutorial in the Integrated Data Management information... [More]

Hi, everyone. I’m the performance architect for, among other things, the pureQuery platform . My team has the responsibility for not just ensuring that our products perform well, but also to help produce verifiable performance numbers that we can share with confidence. I’m happy to say that we are ready to share our performance numbers for pureQuery access to DB2 for Linux, UNIX and Windows. (We already have some great numbers published for z/OS for both Java and . NET ). The goal of this particular performance test was to measure... [More]

Hi all, I want to take a moment of your time to share the new support page that highlights the features and capabilities between the stand-alone and IDE packages of IBM Data Studio: Feature in IBM Data Studio (Stand-alone versus IDE) Previously, this feature comparison table was available only from the Features and Benefits page but now it has its own dedicated page and is available through the IBM Support site. Use this page to compare features and help you determine which package is appropriate for your needs. Regards, Richie Escarez

Well, I'm glad I got your attention... One of the things that I've been pondering lately is what percentage of DBAs manage more than one database platform. Since this is an IBM blog, how many DBAs manage both DB2 for Linux, UNIX, and Windows and DB2 for z/OS? I've heard that they exist, but maybe I haven't been asking, and y'all haven't been telling. Does your shop have any of these elusive creatures? If so, what platforms do they support? If not, why not? Does this model work well for you?... [More]

Hope you have the upcoming Virtual Tech Briefing on pureQuery by Information Champion Dan Galvin on your calendars. We had a meeting to discuss this today, and hearing about pureQuery (a topic I spend a fair amount of time on) from someone who is not an IBMer is refreshing, and I hope you feel the same. I think it’s important for people to hear a perspective from someone who is both really knowledgeable on the topic, and has real-world implementation expertise as well. If you are an architect, developer, or an interested DBA, you will want to... [More]

I'm on the plane today returning from two customer visits in the D.C. area where I was talking about the advantages of pureQuery in DB2 for z/OS environments for DBAs (as opposed to applications developers). One uses WAS on z/OS and the other uses WAS on Linux for System z. Both customers were very familiar with how to manage and monitor CICS applications accessing DB2 data, and they felt out of control with Java application access to their mainframe. One customer even said, "we tried to tell our application teams to stop using... [More]

Hi, all. I am a developer on our Optim Query Tuner products. A new feature called ‘Compare Access Plan’ was shipped in Optim Query Tuner (for DB2 for z/OS) and Query Workload Tuner V2.2 fix pack 1 that allow DB2 for z/OS DBAs to compare the access path cost of SQL statements in packages between the latest two EXPLAIN versions. The tool generates a HTML report that provides high level package cost and individual package details. In this blog, I’ll describe how to launch the feature, and then I’ll describe some common scenarios. Launching the... [More]

Hi, everyone I wanted to let you know that today we published a new e-book called Getting Started with Data Studio (for DB2). It's part of the DB2 on Campus effort, but we wrote it with the idea that anyone (not just college students) learning DB2 and Data Studio could use this free book to get comfortable with the user interface and for performing everyday database administration tasks and for routine and Data Web Services development. You can use this with any edition of DB2, including Express-C , which you can also download for free. And... [More]

In one of my last blogs, I wrote about the untold story of data privacy focusing on non-production systems. This past week, IBM made a significant acquisition of Guardium to improve support for compliance and the protection of privacy across all systems. As discussed in the previous blog, we often forget about the systems not in production and think that the current security in place is enough yet that is not the case. The addition of Guardium to the mission of privacy, protection and compliance continues IBM’s mission in helping... [More]

Today's entry is inspired by a recent Dilbert cartoon where the pointy-haired boss tells Dilbert that he needs to get better at anticipating problems. While we'd all like to see problems before they happen, we need a little help here, and inspiring words from the pointy-haired boss just doesn't cut it. Today's DBAs have a lot of responsibility; arguably more than they have had in the past in terms of number of systems and the complexity of these systems. Most DBAs have implemented early detection mechanisms for production systems, but what... [More]

Many of us on this blog talk about what IBM is doing to improve the Java database applications space, both from an application development and database administration point of view. Here is the way I like to categorize the areas in which these improvements are seen: A comprehensive monitoring capability that gives you a broad, yet contextual perspective on database and application performance, and early warning of emergent problems. Better insight into applications, and the ability to stabilize, and improve resource utilization in a non... [More]

Hi, I’m the lead architect for Optim pureQuery Runtime , and I want to start using this blog to help address questions that I get from people as they learn about or use pureQuery capabilities. In this first blog, I’ll discuss the new SQL replacement capability. By using client optimization, an administrator can modify the SQL from a captured application. The enhanced tooling to support this capability is described in Sonali's article, What's new and cool in Optim Development Studio 2.2 . The intended usage of this feature is to let a DBA make a... [More]

After IBM bought Telelogic I was (and still am) frequently asked “What is the difference between InfoSphere Data Architect and Telelogic (now Rational System Architect). Here is the information I have about the product roadmaps and how these two products complement each other. Before the acquisition: First, some background to set the stage. As you know, even before the acquisition IBM marketed a data modeling tool which at that time was called Rational Data Architect, which had originated from the old Rational Rose and Rational Software... [More]

In my earlier posting on Oracle support in Optim Development Studio, I briefly mentioned our support for Visual Explain. Now, I will provide more details and walk you through a couple of use case scenarios for Oracle Visual Explain. Visual Explain for Oracle is modeled similarly to the Visual Explains for other platforms - DB2 LUW, DB2 for z/OS and Informix. The simple use case scenario is one in which you gather explain information for a SQL statement (SELECT, INSERT, DELETE, UPDATE or MERGE). Let's take a look at gathering and showing... [More]

Hi All, In my last blog I focused on tooling support for the new DB2 BLU Acceleration and rightfully so. BLU Acceleration is a game changer and tooling support makes it even easier to use. I also want to point out there were many enhancements to Data Studio beyond support for BLU Acceleration. A number of requests from the Data Studio user base led to one of these enhancements, checkpoint support in the script editor. Checkpoint's provide significantly more control over the execution of scripts. It... [More]