Loading…
This event has ended. Create your own event → Check it out
This event has ended. Create your own
View analytic
Wednesday, March 15 • 8:30am - 10:00am
Analyze your SQL Queries with IBM I Navigator IBM ACS Part I

Log in to save this to your schedule and see who's attending!

SQL becomes more and more the standard for accessing data in physical files or SQL tables. Contrary to native I/O where the programmer specifies a physical or logical file that is to be used, with SQL the Optimizer decides which or if any index is used or if the complete table/file is read. Long running queries are a nuisance. IBM i Navigator as well as Access Client Solutions (ACS) provide multiple interfaces for recording information about SQL queries and for analyzing the collected data, such as Visual Explain, SQL Plan Cache (Snapshots) or SQL Performance Monitors. All advised indices from both query engines (SQE and CQE) are recorded along with information about how often and when an index was used for the last time. With IBM i Navigator and ACS those information can be accessed and necessary indexes immediately created.


 

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Courtyard 2

Attendees (12)