Baltimore / Washington DB2 Users Group

BWDB2UG's DB2 Educational Session

Susan Lawson

When? March 8th, 2017, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered: $250 (lunch and break refreshments included)
At-the-door: $350 (lunch and break refreshments included)

Meeting Schedule:

  8:30 - 9:00 Registration
  9:00 - 10:15 DB2 11 and 12 Performance and Availability: What Can I Take Advantage Of?
  Susan Lawson

With every new release of DB2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in DB2 11 and 12 that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features that can be utilized by DBAs and application programmers.

Topics to be covered include:

  • Database Enhancements
    • Suppress null indexes
    • Pseudo-deleted index entry cleanup
    • Help for indirect references
    • Large number of partitions access improvement
    • No log declared temporary tables
    • Incremental bind avoidance for DGTTs
    • Parallelism support for DPSIs
    • Partition elimination on join predicates
    • Selective decompression
    • RTS immediate externalization
    • Access command parallelism
    • Statistics feedback
    • Work file usage thresholds
    • Physically delete empty partition-by-growth partitions
    • Subsystem and Data Sharing Enhancements
    • LOB compression (V 12)
    • RI support on temporal tables (V 12)
    • Inclusive periods on temporal tables (V 12)
    • Range-partition tablespace size increase (V 12)
    • Partition insert into middle (V 12)
    • Basic row format deprecated (V 12)
    • Profile support for stats feedback (V 12)
  • SQL and Optimization
    • Reclassification of buffer pool pages
    • Buffer pool size simulation
    • MRU queuing support for utilities
    • Increased number of open datasets
    • Restart light with CASTOUT option
    • Group buffer pool write-around protocol
    • Improved castout processing
    • Log record sequence number spin avoidance
    • Overflow for PGSTEAL(NONE) (V 12)
    • In-memory indexes (V 12)
    • Improved log sequence number (V 12)
    • Claim and drain improvements (V 12)
    • Improved lock avoidance checking (V 12)
    • DDF shared session data across group (V 12)
  • Database Availability
    • RELEASE(DEALLOCATE) thread interruption
    • Cancel DDF threads
    • Online drop column
    • Online alter limit key
    • Deferred definition DBD lock release
    • PIT recovery for deferred schema changes
    • Reorg without sorting
    • Option to skip PIT recovery for non-updated page sets (V 12)
    • PIT recovery after materialization for UTS PBG (V 12)
    • Pending column level alters (V 12)
    • Pending level index compression (V 12)
  • Application Enhancements
    • Global variables
    • ARRAY data type performance
    • Transparent archiving
    • Cancel thread
    • Cancel SQL
    • Column processing above the bar
    • Data type processing improvements
    • Rollback to savepoint
    • Advanced triggers (V 12)
    • LOB support in global variables (V 12)
    • Global variables defined as array type (V 12)
    • Fetch/open/execute with global variables (V 12)
    • Profile based global variables (V 12)
    • Views, UDFs intact on DDL for underlying tables (V 12)
    • Increase max number of tables referenced in view, UDF, statements (V 12)
    • New built in functions (V 12)
    • Unicode columns in EBCDIC tables (V 12)
    • SQL pagination (V 12)
    • SQL PL improvements (V 12)
    • SQL PL triggers (V 12)
    • XML enhancements (V 12)
  • Distributed Performance
    • Package based continuous block fetch
    • Implicit commit for stored procedures
    • DDF synchronous receive
    • Multi-threaded Java stored procedures
    • JDBC/ODBC stored procedure optimizations
    • Cancel DDF thread improvement
    • JDBC/ODBC type 2 performance ODBC driver improvements (V 12)
    • prepareAttribute literal replacement BIND option (V 12)
    • DRDA fast load (V 12)
    • DBAT pooling (V 12)
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 DB2 11 and 12 Performance and Availability: What Can I Take Advantage Of? (cont.)
  Susan Lawson
  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 11 and 12 Performance and Availability: What Can I Take Advantage Of? (cont.)
  Susan Lawson
  2:00 - 2:15 Break
  2:15 - 3:30 DB2 11 and 12 Performance and Availability: What Can I Take Advantage Of? (cont.)
  Susan Lawson

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, March 3rd, 2017.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs performance and availability audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring books, articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM Gold Consultant and an IBM Analytics Champion and is the author of the IBM DB2 11 for z/OS Database Certification Review Guide.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.