Know Db2

Db2 10 Advanced SQL Migration

Duration: 3 Day, Lecture, Hands-on lab

Audience: Application Programmers, DBAs and SQL Users

Db2 10 Advanced SQL Migration

Class Outline:

Advanced SQL Migration

  • SQL Access
  • -Currently Committed data
  • Extended Indicator Variables
  • Extended SQL Procedure Language
  • -Native SQL Procedures
  • SQL Scalar Functions
  • Additional OLAP specifications
  • TIMESTAMP
  • -Precision
  • -WITH TIMEZONE
  • TRIM functionally additions
  • 64 bit ODBC Driver for z/OS
  • Hands-on LAB
  •  
  • Support for
  • -ALTER ADD COLUMN
  • -New High Values
  • Literal replacement
  • IN List improvements
  • Safe Query Optimization
  • OPTIMIZE FOR 1 ROW changes
  • Row Level sequential detection
  • Parallelism
  • -Dynamic record range partitioning
  • -Straw model
  • Hands-on LAB
  •  
  • Expanded sort replacement
  • pureXML Enhancements
  • -Partial update
  • -Schema validation
  • -Binary XML formats
  • -CHECK DATA support
  • Expanded small sort workfile support
  • Statistics
  • -RUNSTATS Profile
  • -Autostats
  • -Index/RTS
  •  

Advanced SQL Migration (Continued)

  • RID overflow to workfiles
  • Compress on Insert
  • Hands-on LAB
  •  
  • BIND
  • -EXPLAIN(ONLY)
  • -SQLERROR(CHECK)
  • REBIND strategy for CM
  • Access Path Stability
  • -APCOMPARE, APREUSE
  • Policy in Plan Management
  • -APRETAINDUP
  • Hands-on LAB
  •  
  • Virtual storage relief
  • In-Memory Table / Index
  • Workfile enhancements
  • 1MB frame size
  • On Demand Buffer Pool storage
  • Statement level monitoring
  • -Profiles for:
  • -Connections
  • -With more granularity
  • -Threads
  • -Idle thread timeout
  • Prefetch / Deferred Write
  • Hands-on LAB
  •  
  • RUNSTAT zIIP exploitation
  • WLM information in DISPLAY
  • Db2 Catalog Structure Details
  • In-Line LOBs
  • Business Analytics
  • - Moving sum, moving averages, moving aggregates
  • IBM Smart Analytics Optimizer
  • Hands-on LAB
  • Summary
  •  
  • ©2017 Computer Business International, Inc.
  •  

     

Would you like to schedule or customize this class?
Please call our toll free number (866-224-4968) or email us at info@cbi4you.com.