Name: F5 | You should concentrate (your literals) - Dynamic SQL performance tips
Start: 2026-10-26T16:30:00-0400
End: 2026-10-26T17:30:00-0400

F5 | You should concentrate (your literals) - Dynamic SQL performance tips

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 7

In today's world, dynamic SQL usage is on the rise.The presentation will show ways to enhance dynamic SQL performance,Focusing on CSWL feature with actual big savings achieved.Skeleton:Dynamic vs static SQL Literals vs parameter markersDSC Cost vs benefit LimitationsCSWL How does it work Cost vs benefit Where can I use it Real life savings from mataf Limitations Should I use it globally?

Speakers

Shay Miller

DBA, FIBI

I'm a DBA of DB2 for zOS for 25 years, both system DBA and application DBA.I've worked as a DBA in the IDF and for the last 18 years in FIBI.
I've attended IDUG EMEA 2015 at Dublin.I've attended and presented a session in IDUG NA 2024 at Charlotte.
I hold the following IBM certif... Read More →

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 7

Track F, Technical Session

Audience All
Subject z/OS
Area AppDev, Best Practices, Latest and Features z/OS, Performance and Monitoring, User Stories, Working with SQL

IDUG NA 2026

Shay Miller

Get help with the event

IDUG NA 2026

Shay Miller

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with the event