| QSYS2.DELIMIT_NAME | SWAP_DYNUSRPRF.sql |
| SQL generated table comparison query |
| Publishing file contents using JSON and SQL.sql |
| mti_info.sql |
| QSYS2.OVERRIDE_QAQQINI | Change trigger programs in production.sql |
| Alerting on high levels of jobs.sql |
| QSYS2.PARSE_STATEMENT | Extract SQL DML insight from the Plan Cache.sql |
| Kitchen Sink for the Admin.sql |
| parse_statement udtf.sql |
| Plan Cache Services | Github Gist |
| QSYS2.DUMP_PLAN_CACHE | Extract SQL DML insight from the Plan Cache.sql |
| Performance Services | Github Gists |
| QSYS2.ADD_QUERY_THRESHOLD | Query Supervisor - Holding a job.sql |
| QSYS2.MTI_INFO | mti_info.sql |
| QSYS2.QUERY_SUPERVISOR | Query Supervisor - Holding a job.sql |
| QSYS2.RESET_TABLE_INDEX_STATISTICS | Reactive index strategy.sql |
| QSYS2.REMOVE_QUERY_THRESHOLD | Query Supervisor - Holding a job.sql |
| QSYS2.SYSIXADV | Work Management and jobs.sql |
| SYSTOOLS.ACT_ON_INDEX_ADVICE | Reactive index strategy.sql |
| SYSTOOLS.REMOVE_INDEXES | Reactive index strategy.sql |
| Utility Services | Github Gist |
| QSYS2.EXTRACT_STATEMENTS | Extract SQL DML insight from the Plan Cache.sql |
| QSYS2.SWAP_DYNUSRPRF | SWAP_DYNUSRPRF.sql |
| SQL catalog views | Github Gists |
| QSYS2.AUTHORIZATIONS | Well isnt that special.sql |
| QSYS2.SYSCATALOGS | Find save files.sql |
QSYS2.SYSCOLUMNS | Publishing file contents using JSON and SQL.sql |
| QSYS2.SYSCOLUMNS2 | db2_to_json.sql |
| Decimal column checker upper.sql |
| SQL generated table comparison query |
| Virtually done.sql |
| QSYS2.SYSFILES | Virtually done.sql |
| QSYS2.SYSINDEXES | Reactive index strategy.sql |
| QSYS2.SYSINDEXSTAT | Reactive index strategy.sql |
| QSYS2.SYSPARTITIONINDEXES | Largest MTIs in use today.sql |
| QSYS2.SYSPARTITIONSTAT | Flexible view over a mmpf.sql |
| Kitchen Sink for the Admin.sql |
| Collection Services made easy with SQL.sql |
| QSYS2.SYSPERIODS | Temporalize a library.sql |
| QSYS2.SYSPROGRAMSTAT | SWAP_DYNUSRPRF.sql |
| QSYS2.SYSTABLESTAT | Largest MTIs in use today.sql |
| QSYS2.SYSTRIGGERS | Sending an E-mail via SQL.sql |
