This presentation will review DBA solutions that have been developed and implemented to enhance the administration of Db2 Z/OS systems. These solutions have been implemented at Navy Federal Credit Union with Db2 V12 and V13 mission critical applications. Db2 features such as SQL to review object usage, real-time statistics, utility history, package binds, Db2 health, dynamic query management and utility template generation will be discussed. 1. Db2 object usage SQL 2: Advisory Space Display 3: Real-Time Stats Queries 4: Utility History Queries 5: Auto Bind Considerations 6: Dynamic Query Stabilization Management Concepts 7: Utility Template Generation 8: Standardized System Queries to review the status and health of your Db2 system. (Sponsored by IDUG)