 |
 |
 |
 |
 |
 |
 |
During the Morning Sessions Enjoy a Full, Continuous Continental Breakfast
Morning Session 9:00 to 12:00 PM
Full Hot and Cold Lunch Buffets including Dessert and Beverages
Afternoon Session 1:00 to 4:45 pm
Monitoring, Analyzing and Tuning Database Access
| Save $25 Register before August 7th and receive the early bird special price! | |||
The meeting includes a full continuous
continental breakfast through out the morning and a full hot and cold lunch
buffet including dessert and beverages
|
|||
Early bird |
After August 7th
|
Walk-ins
|
|
| Members | $125
|
$150.00
|
$175.00
|
| Non Members | $150
|
$175.00
|
$200.00
|
| You must register before the end of the business day of the Tuesday prior to the meeting date to be eligible for the registered price. | |||
| Cancellations must be made by fax or email within 48 hours before the meeting. | |||
|
Register via email at
nestu_mail@yahoo.com (specify SQL Day in subject line, include your company and the names of the individuals that will be attending) |
|||
Session 1. SQL Database Enhancements
This session will cover the operational differences between SQL and DDS created database objects. Topics presented will include the following:
-
SQL Tables versus DDS Physical Files
- Fast Read
- Enabled Concurrent Write (ECW) support
-
SQL Indexes versus DDS Keyed Logical Files
- 64K Access Path
- SQL Views versus DDS Non-Keyed Logical Files
- Materialized Query Tables (MQT)
- Partitions versus Members
- Reverse Engineering DDS database objects into SQL DDL statements
- SQL Index Access Path Sharing
Session 2. Database Optimization Basics
This session will cover the process of optimization from an iSeries perspective. Topics presented will include the following:
-
Database architecture overview
- IO and CPU parallelism (SMP)
-
The optimization engines and the Query Dispatcher
- Classic Query Engine (CQE) versus the SQL Query Engine (SQE)
-
The optimization goal
- First I/O versus All I/O
-
The importance of statistics and where they come from
- Metadata, indexes and column statistics
-
Environmental influencers
- SMP, packages, embedded versus dynamic, etc
-
The QAQQINI file
- Overriding the optimizer behavior
Session 3. Data Access Methods
This session will cover the various access methods used by SQL and how they compare to High Level Language (HLL) data access methods. Topics will include:
- Table scans and probes
- Index scans and probes
- Temporary results
- Join, grouping and ordering optimization
-
Coding examples including:
- CPYF versus INSERT with Subselect
- CRTDUPOBJ versus CREATE TABLE AS
- Fast COUNT support
- Fast DELETE support
- Replacing temporary work files with Common Table Expressions (WITH)
- Blocked FETCH and INSERT
Session 4. Monitoring, Analyzing and Tuning Database Access
This session will cover the tools that are available for monitoring SQL and HLL transactions. This includes the Performance Explorer Statistics collector and the SQL Database monitors. Topics will include:
- The emerging role of the DBA in i5 medium and large system environments
-
Using PEX to collect application performance statistics
- Creating PEX statistics definitions (Flat and Hierarchical)
- SQL examples for analyzing the collected PEX data
-
Using the SQL monitors to gather SQL performance data
-
Using iSeries Navigator to start, stop and analyze data
- The Visual Explain tool
- Customizing the iSeries Navigator queries
- Using "as is" commands for Starting, stopping, dumping and checking the SQL memory monitor
-
Using iSeries Navigator to start, stop and analyze data
- Using the proxy RunQry command to transform Query/400 queries to SQL equivalents.
- Harold Whitman
Home
About us Next Meeting
Membership Calendar
Board of Directors
Links