DB2 10 Migration Planning Workshop - Oakbrook

Event Details

DB2 10 Migration Planning Workshop - Oakbrook

Time: May 11, 2011 all day
Location: IBM Two Lincoln Centre 01-1D/6304 Oak Brook, Illinois United States
Street: IBM Two Lincoln Centre 01-1D/6304 Oak Brook,
City/Town: Illinois United States
Website or Map: https://www-950.ibm.com/event…
Event Type: db2, 10, migration, planning, workshop
Organized By: Paul Bartak
Latest Activity: Apr 27, 2011

Export to Outlook or iCal (.ics)

Event Description


Who should attend?

An MPW contains content that is appropriate to Application Developers, Database, Administrators, System Administrators, Architects, IT decision makers, and Project Managers. For DB2 10 MPW, the overview has been restructured to focus on Application Development topics early in the presentation. Systems oriented topics are near the end and continue into the Migration presentation.

What you can expect?

  • An understanding of the features delivered with DB2 10 and how they can benefit your enterprise.
  • Clarity of the migration process.
  • References for many subjects, including:
    • Migration.
    • Fallback.
    • Prerequisites & preparations.
  • You will leave with:
    • Presentation materials.
    • Checklists.
    • Project plan framework.
    • Networking and Contacts.

DB2 leadership

DB2 10 sets the stage to “give back”. Many infrastructure and optimization changes may provide performance improvement “out of the box”. DB2 also continues to deliver industry leading design, SQL, and utility enhancements for business critical legacy and modern workloads.

  • The past, present, future, and audit. These are all important concepts to an application point in time information. DB2 10 is a Bitemporal Database, enforcing Business Time and System Time.
  • DB2 9 introduced pureXML. DB2 10 takes this to the next level with performance and functional enhancements.
  • On line schema evolution is expanded to include many table space options, including the support for changing several table space types.
  • The DB2 10 optimizer brings many usability and performance benefits, including statement cache reuse for SQL with literals, statement level optimization hints, and much more.
  • New index design and insert processing enhancements.
  • Expanded timestamp and time zone support.
  • The advances in SQL and optimization provide more reasons to run your analytical processing in DB2.
  • Potential for significantly more thread support & possible member consolidation.
  • Enhanced distributed processing performance, including High Performance DBATs.


May be adjusted for special circumstances.

Lunch will be provided.

Topic Focus Areas:

  • DB2 10 for z/OS Overview.
    • DB2 9 Recap (For those migrating from V8).
      • Application Development focused topics.
      • SQL & Application Access.
      • XML.
    • Temporal (Versioned Data).
      • LOBs.
      • Advanced Design Features.
    • Transitional Topics.
      • Optimization Evolution.
      • Index Improvements.
      • Security Enhancements.
      • Utilities.
      • Data Sharing.
      • Distributed Communications.
  • Systems oriented topics.
    • Virtual Storage.
    • Serviceability / Instrumentation.
  • DB2 10 Migration.
    • Review of V8 to V10 & V9 to V10.
    • Preparations.
    • Planning.
    • Process.

Comment Wall

Add a Comment

RSVP for DB2 10 Migration Planning Workshop - Oakbrook to add comments!

Join The World of DB2

Attending (5)

Might attend (1)

Not Attending (2)

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


Automatic storage add path

Started by Fernando Monjes in What's hot ? Feb 12. 0 Replies

Hi I have db2 version 10 and tablespace (dms) with automatic storage, how can I add a container or path, I don't use STOGROUP, is there any option? Thank youContinue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Gagan Kakkar Feb 12. 3 Replies

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service