IBM Optim and developerWorks present: Virtual Tech Briefings on Optim Solutions for Integrated Data Management

Join our team of experts for a series of low-key and no-cost technical chats designed to get you up to speed on technology and products related to data management, data-centric application development, and more.

No budget for education or conference travel this year? Tired of webcasts that provide more style than substance? Join our team of experts for a series of low-key and low-cost (free to you!) technical chats designed to get you up to speed on technology and products related to data management, data-centric application development, and more -- and they are only an hour, so you can fit them into your schedule.

The focus of these online technical briefings will be on products and technologies in the Data Studio and Optim™ portfolios (Integrated Data Management).

These online technical briefings are free. To participate, simply click on the appropriate registration link below. We recommend that you join the briefing a little early to do a system check.

You will need:

Each session may be recorded and each attendee may have the capability of distributing this recording. Each participant's use of recordings and participant information is subject to U.S. and international privacy laws.

pureQuery deep dive Part 1: Client optimization

There's a surge of interest from people who are becoming aware of the cost savings and management benefits of pureQuery. The client optimization capability of pureQuery enables DBAs to enable static execution for any existing Java™ and .NET application without changing any application code. In this first Integrated Data Management tech briefing of the year, we show you step by step how to client optimize an existing Java application and provide hints and tips for managing the process and making it more efficient. z/OS® environments are covered as well.

Date and time: 04 February 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

pureQuery Deep Dive Part 2: New application development

The pureQuery data access platform includes an easy to use API that is designed to help developers write high-performance data access layers. Productivity, troubleshooting, and query tuning are all enhanced with powerful tooling. In this session, Information Champion Dan Galvin speaks from experience on using pureQuery for developing new applications, including an overview of the API styles, best practices, and hints and tips from his personal experience. He'll also describe how pureQuery can be integrated with existing Java frameworks to extend its capability. Sonali Surange, pureQuery tools architect, provides a step by step overview of using Optim Development Studio for new data access development.

Date and time: 11 March 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

What's new in Optim Performance Management tooling

Get the latest and greatest news about the IBM Optim performance management solution for DB2 for Linux®, UNIX®, and Windows to help you resolve emergent performance problems before they affect the business. The briefing is for DBAs and IT managers who are interested in seeing the new capabilities enabled by such enhancements as a browser-based display, new system health overview with guided drilldown into detailed diagnostics for faster problem diagnosis, interactive reports for trend analysis, and integration to other solutions in the Tivoli® and Optim product familes. This comprehensive solution guides administrators from problem isolation and analysis to problem resolution.

Torsten Steinbach, Lead Architect for performance management, will take you through some of the new scenarios that are enabled with these exciting enhancements and demonstrate the new Web-based interface. Beta client Jean-Marc Blaise, Technical Architect from VENEDIM, will be on hand to tell you what he likes about the tooling and how he intends to use it.

Date and time: 29 April 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

Best practices in data modeling using InfoSphere Data Architect

Whether you are a new or experienced user of InfoSphere Data Architect, you are bound to learn something new from our speaker, Dr. Vladimir Bacvanski. Dr. Bacvanski uses practical use cases to demonstrate the value of model-driven development, as well as practical recommendations for logical and physical data model creation for diverse databases, and guidance on improving productivity using automation and team development capabilities.

Dr. Vladimir Bacvanski has over two decades of experience in consulting, mentoring, and training, focusing on architecture and design of mission-critical distributed enterprise systems, tools, and model driven development approaches.

Date and time: 13 May 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

pureQuery Deep Dive Part 3: Client optimization administration enhancements

Our expert speakers will walk you through the latest enhancements to streamline administration for the process of using pureQuery for existing Java applications, known as client optimization. Client optimization can help improve the performance, security, and administration of Java database applications. These enhancements are driven by real customer experiences and are centered around a relational repository that enhances security, fosters collaboration and streamlines the process of administering a pureQuery-enabled application. Tooling support for these capabilities in Optim Development Studio will be demonstrated.

Date and time: 24 June 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

DB2 Connect for DBAs: A primer and look ahead

Whether you are a DB2 for LUW DBA who would like to access enterprise information or a z/OS DBA wondering how all those Java and .NET programmers are getting to your data, DB2 Connect is the solution. Frank Fillmore, A DB2 Gold Consultant with an extensive history in training and consulting, will step you through a DB2 Connect primer from end-to-end, including platform architecture, DB2 Connect configuration parameters, and more. Case studies from large scale DB2 Connect health checks will be included. Kevin Foster, who manages the development of the product, will be on hand to discuss licensing, new packaging options such as the DB2 Connect Advanced Edition, which provides pureQuery acceleration in the box, and upcoming changes to the product.

Date and time: 19 August 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides:
Part 1
Part 2

Using what's new in InfoSphere Data Architect to accelerate design for data warehouse and BI

InfoSphere Data Architect is a data design solution to model, relate, and develop data assets. IDA accelerates design of data warehouses, automatically discovers and creates data warehouse schema, and enables the use of standardized logical models to centralize data definitions across the enterprise. New features include integrated modeling of InfoSphere Warehouse OLAP engine with bidirectional transformation between IDA data model and the cubing model in InfoSphere Warehouse Design Studio. IDA reduces the development cost of BI warehouse applications with bidirectional model interchange between IDA and Cognos, expediting problem determination by identifying relationships impacting data lineage across warehouse models and BI design.

You will learn:

Date and time: 14 October 2010, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the event


Watch this space for more events to come!

2009 replays

Listen to previous briefings.

Data Studio becomes Optim -- What it means for you

So Data Studio is now Optim, except where it isn't. We know there will be lots of questions, so let's use this first low key lunch and learn to get some of the facts on the table and get answers to such questions as: Is it just a rename or are there real integration points between the old Data Studio and Optim technologies? Can someone explain what's free and what isn't? What are the new products? Where can we get trial downloads? What products support which databases?

Date and time: 30 June 2009, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Listen to the replay

Download the slides

InfoSphere Data Architect 101

Formerly known as Rational Data Architect, InfoSphere Data Architect is a foundational data modeling technology for any data-centric design and architecture work. In this overview session, you'll learn about features and functionality, but you'll also get hints and tips on getting started. A must-see for anyone who does data architecture, modeling and database design and hasn't worked with this tool before.

Date and time: 22 July 2009, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Listen to the replay

Download the slides

Optim Development Studio 101

Confused about Data Studio, Data Studio Developer, and now Optim Development Studio? Get a tour of Optim Development Studio and an understanding of the additional features over "free" Data Studio and Rational Application Developer for WebSphere Software. This is very cool stuff, and we'll have more sessions later to do deeper dives into some of the technology.

Date and time: 20 August 2009 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

SQL Stored procedure Development and Debug for DB2 for z/OS: Getting Started

Stored procedure development is one of the areas we get the most questions about. In this first session, get familiar with Optim Development Studio capabilities and then create, deploy, and run a stored procedure. These capabilities are similar across all DB2 platforms, so DB2 for Linux, UNIX, and Windows stored procedure developers are encouraged to attend.

Date and time: 24 September 2009, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

SQL Stored procedure Development and Debug for z/OS: Advanced

The previous session covered debugging on the client machine. Now let's move into a more advanced configuration (we'll briefly describe the typical setup) and get into more details and hints and tips on using the debugging capabilities for z/OS stored procedures. We'll also describe how you can use Rational Developer for System z to augment your stored procedure development.

Date and time: 22 October 2009, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides

Query tuning for DB2® for z/OS® developers and DBAs

DB2 has a great optimizer, but that doesn't mean that you shouldn't learn and practice good SQL coding techniques. Learn about new tools to help advise you on writing better SQL -- while you're in the middle of development!. And if you code Java using a framework, you can still tune the generated SQL. Our experts will go through a few scenarios to help you understand the tools in action. DBA won't want to miss this either as the Query Workload Tuning capabilities are demonstrated as well.

Download the slides (no replay is available for this event)

Performance Management 101 for DB2 for Linux, UNIX, and Windows

Ever been up late trying to pinpoint a performance problem in a Java environment? Or worse, trying to find where the problem might be buried in all of the data? Tired of the finger pointing among staff when performance is an issue? Find out how you can create exception monitoring metrics, track and measure performance indicators and quickly diagnose performance problems when they arise using DB2 Performance Expert and Extended Insight Feature to make the process easier and more efficient.

Date and time: 8 December 2009, 10:00-11:00AM Pacific, 1:00-2:00PM Eastern

Register for the replay

Download the slides