developerWorks spaces: IBM Integrated Data Management Community (Optim and Data Studio)

developerWorks > My developerWorks > Spaces >
	Integrated Data Management (Optim and Data Studio)


View the non-JavaScript version


Welcome guest	\|	Sign in

Home

Articles & Tutorials

Downloads here!

Latest news

Optim trials and Data Studio no-charge downloads are now available!

Download and try the new releases of

Optim Development Studio 2.2
Optim Database Administrator 2.2
InfoSphere Data Architect 7.5.2

In addition, for those of you who have IBM Data Servers and are looking for the no-charge stuff, it's available separately this release (that is, no more waiting for the trial features to time out to use the free stuff). It's called, yes, IBM Data Studio and is available in two flavors. You can read more about that on the download tab.

More news: Notice anything different in the Forums portlet directly to the right? We've added more forums targeting specific products and staffed them up with experts so you can get answers to your questions. (And get help from others who are also using the products.) Don't be shy.

One more thing for now. We changed the name of the Data Studio blog to the Integrated Data Management Experts blog to reflect the broader nature of the discussion that needs to take place around this topic.

What is IDM?

Integrated Data Management: Managing data across its lifecycle

Trying to figure it all out? Follow these easy steps:

Read the big picture article. Subscribe to the experts blog. See the Webcast on Optim solutions.
Check out the pureQuery platform web page and FAQ.
See the products in action with our Day in the Life of a DBA demo or our Optimizing Query Performance for z/OS demo or any of the other demos and videos on this page.
Download the software.

Performance

Optimize your existing JDBC applications with pureQuery

Now you can optimize both Java and .NET applications to use static SQL without requiring changes to the application code. Here's a tutorial on the latest and greatest - .NET support in Version 2.1

Forgotten why you should care about static SQL? This article explains why you should care, for performance, manageability, and security reasons.

Be sure to check out the results of this performance study that compares static SQL using pureQuery with JDBC, EJB2 and OpenJPA.

You can get better performance using pureQuery for dynamic access as well. The WebSphere Customer Center team migrated from EJB 2 to pureQuery and got great results.

Latest news:Performance results using pureQuery with .NET applications

Where we'll be

IOD NA (October 25-20): Be there!

Learn More!

Basics of Data Studio Environment: Online course basics of IBM Data Studio Developer. NO CHARGE if you enroll in 2008.
Preparing for Stored Procedure Certification, Tutorial Series: Prep for Exam 735
Developing Database Applications with IBM Data Studio and pureQuery: Three-day intensive course offered by InferData.
Using InfoSphere Data Architect: 2-day course.

Forums

IBM Data Studio
- Use of this forum: not for job postings!
  30 Jun 2009 6:47 AM
  This is to remind you all...
- DS V2.2 Generates bogus DDL for Nickname Columns
  29 Jun 2009 7:26 AM
  I was able to select "CRE...
IBM Optim Development Studio and pureQuery Runtime
- Optim Development Studio 2.2 and Optim pureQuery Runtime 2.2 now available!
  23 Jun 2009 6:03 AM
  Hi, all<br/> Welcome ag...
- Welcome to IBM Optim Development Studio and pureQuery Runtime forum
  17 Jun 2009 7:34 AM
  Welcome to this forum to ...
IBM Optim Query Tuning Solution
- Welcome to IBM Optim Query Tuning Solution forum
  17 Jun 2009 8:03 AM
  Welcome to this forum to ...
IBM Optim Database Administrator
- Data Studio Administrator Console - Installation Error ¿?
  25 Jun 2009 11:20 AM
  Hello I downloaded the...
- Welcome to IBM Optim Database Administrator
  17 Jun 2009 8:08 AM
  Welcome to this forum to ...
Optim Database Relationship Analyzer (DRA)
- Welcome to Optim Database Relationship Analyzer (DRA) forum
  02 Dec 2008 6:53 AM
  This is a forum in which ...
Optim LUW
- Attunity server License
  09 Jul 2009 5:11 AM
  Hi , Could anyone please...
- OPTIM 7.1.1 and DBALIAS on Oracle 8i
  09 Jul 2009 5:04 AM
  I have a fresh install of...
Optim z/OS
- Welcome to Optim z/OS forum
  29 May 2009 3:08 AM
  This is a forum in which ...
- inaugural New England Information Management Users Group
  26 May 2009 4:30 AM
  To all New Englanders, ...
IBM InfoSphere Data Architect
- [RDA] How to open a physical model (schema)
  07 Jul 2009 2:51 AM
  Hey, I would like to k...
- IDA 7.5.2 Release Notes
  26 Jun 2009 11:18 AM
  Are there release notes f...
High Performance Unload
- Welcome to the DB2 High Performance Unload forum
  12 Jun 2009 6:52 AM
  Welcome to the DB2 High P...

Blogs

Integrated Data Management Experts
- A no-charge, stand-alone offering for DBAs? Yes, it’s here now with the release of Data Studio v2.2!
  02 Jul 2009 7:02 AM
  <img ...
- What does Integrated Data Management really mean?
  26 Jun 2009 12:00 PM
  <img src="http://www.ib...
- Learn while you earn - Virtual tech briefings - first one is on June 30
  25 Jun 2009 4:46 AM
  Hi, everyone<br><img sr...
- What’s new in Optim Development Studio and pureQuery – (Also trial is now ready for download!)
  22 Jun 2009 4:16 AM
  <img src="h...
- An Overview of Oracle support in Optim Development Studio
  15 Jun 2009 10:29 AM
  Hello everyone,<br>...
Informix Application Development
- Fastest DBA Part 2
  09 Jul 2009 6:59 AM
  A new version of the <a h...
- Chat with the lab - Compression
  30 Jun 2009 8:10 AM
  If you're interested in t...
- The Ubuntu Informix virtual appliance
  22 Jun 2009 9:52 AM
  IDS virtual appliances no...
- Links to AWS Demos (Chat with Lab follow-up)
  12 Jun 2009 3:09 AM
  During this morning's Cha...
- Chat with the labs - Virtualization and Cloud Computing
  08 Jun 2009 5:00 AM
  This month's Informix Cha...
Fillmore Group blog
- Q-Replication Administration Console Webcast
  In conjunction with the D...
- I can see clearly now…introducing, “Integrated Data Management”
  The IBM team made another...
- Baltimore/Washington DB2 Users Group Meeting
  The next scheduled Baltim...
Willie Favero on DB2 for z/OS
- More DB2 for z/OS publications have been update; this time DB2 Version 8
  I almost committed a huge...
- A new Draft IBM Redbook is available: "DB2 9 for z/OS: Distributed Architecture"
  Finally, a well written, ...
- Upcoming No-Charge IBM Teleconference on DB2 Database Maintenance and Recovery
  On July 7, 2009 IBM will ...
Chris Eaton on DB2 for LUW
- DB2 9.7 Announced by IBM - I think it has something for everyone
  By now you may have seen ...
- IDUG North American Conference
  Dont miss your chance to...
- Improved stability with DB2 and AIX memory protection
  In AIX 5.3 running on the...
Dave Beulke
- Four more reasons to migrate from Oracle to DB2.
  I received some great com...
- Many Reasons to Go to the New DB2 9.7
  Going through the DB2 9.7...
- DB2 Version 9 for z/OS Performance Features
  As each version of DB2 co...

Demos

A Day in the Life of a DBA: Ever have one of those days? Jackie handles it well - find out how.
Introduction to InfoSphere Data Architect: 15 minutes of pure modeling fun with Oracle and DB2.
DB2 Performance Expert for LUW: Solving a runaway query problem.
Query Tuning and client optimization for DB2 for z/OS: Two part demo: 1. Tune query using Optimization Expert. 2. Optimize existing JDBC apps using pureQuery.
Upgrading an application: The original integrated demo shows the fictional JK team adding new features to an app and how it's easier with Integrated Data management solution.

Channel DB2 videos

How to Set Up, Configure, and Use IBM DB2 Performance Expert's Performance Warehouse
DB2 Performance Expert Extended Insight Feature: Torsten walks you through the new capabilities for monitoring Java apps accessing DB2.
Data Studio 2.1 Video: Great introduction to key new features.
DB2 Performance Expert System Overview: Nathan walks you through the cool stuff in the PE dashboard.
Build an eforms solution with pureXML: Uses Data Studio to build the Web service.
pureQuery explained: Rafael explains how pureQuery is different than other data access approaches.
NEW! Sonali demonstrates Optim Development Studio 2.2: Oracle support and copy/paste are demo'd.

Webcasts & podcasts

Integrated Data Management Solutions for Performance Optimization: You're going to be hearing a lot about integrated data management. Learn about an integrated solution to improving performance and manageability.
Data Studio for z/OS: From requirements to retirement, managing your data environment
Improve data security with Rational Data Architect V7.5
Monitoring and managing change for database administration
Podcast: Curt Cotner with YL&A (Cocktail Hour)
Rafael Coss: Agile Data and Data Studio
Podcast: Enhancing Java environments with pureQuery: Wow! You'll learn a lot in about the time it takes you to get to the grocery store.
Use pureQuery to improve QoS for WebSphere&DB2 apps
A Smarter Way to Successful SOA: Information as a successful strategic asset: A Z-focused view of information and data as a key part of a successful SOA implementation.
Accelerating Solutions Delivery: No matter what your development methodology, it's always better to do faster and with better quality.

Product documentation

Links to relevant product documentation.

IBM Integrated Data Management Information Center 2.2: Start here for all your information needs.
DB2 High Performance Unload
InfoSphere Data Architect 7.5.x: Direct link to IDA documentation.
IM for z/OS Information Center: Includes all your z/OS tools.
IBM Optim Database Relationship Analyzer product documentation: Includes program directory for z/OS and user's guide.

Message board

Link to IOD guide focusing on Data Studio and IDM
- DataStudio
- Posted: Fri Oct 10 01:59:46 EDT 2008
- IOD is a pretty huge even
Test your skills - SQL procedures for DB2 9.5
- KRZ
- Posted: Thu Jul 17 06:27:47 EDT 2008
- Hi, all
  Just wante
Give me some feedback on what you want to see
- KRZ
- Posted: Tue Jul 08 10:57:51 EDT 2008
- Hi everyone.
  Wel
Sorry about the difficulties last week
- KRZ
- Posted: Fri Jun 13 01:50:20 EDT 2008
- Some of you may have noti


	Post new thread			View threads

Note: This portlet requires that you be a member of the space to view and post messages. You may request to join the space by going to the Message board portlet and clicking "Join space." We'll be in touch after we've reviewed your request.

If you are already a member, please make sure you're logged in to developerWorks.
Log in or register now.

Group space

Overview

Join space

	Description: The IBM Optim and Data Studio portfolio provide leading-edge integrated data management capabilities, making it easier to manage data-centric tasks across the lifecycle spanning design, development, deployment, management, optimization, and governance. This space will serve as a central hub of information and conversation about Integrated Data Management products, technologies, and best practices.
	Objective: To share experiences with IBM Data Studio users.
	Audience: Data Architects Database Administrators Data Stewards Database developers Java developers
	Group type: Public
	Date created: 19 Sep 2007

	Show member list

About IBM

Privacy

Contact

Integrated Data Management (Optim and Data Studio)