Tag: EXPLAIN

Can you guess how interesting the DSN_PREDICAT_TABLE really is?

DB2 z/OS literal replacement: Do you know the queries to list the Dynamic SQL which have literals or Parameter markers? Here is a very handy method to (fairly) quickly see if you have a literal problem that is killing the DSC

Tagged with: , , , , , , ,

GIVE and TAKE Program

1,2,3 Give and Take 2020 Information on the Give and Take Programs 4,5,6,7 Previous Give & Take We have “GIVEn” various free-of-charge Use Cases from our SQL WorkloadExpert for Db2 z/OS like: 1 Index Maintenance Costs 2 EXPLAIN Suppression 3

Tagged with: , , , , , , , , , , , , , ,