Schlagwort: dynamic SQL

2017-05 Db2 version 12: A little bit too agile?

  How to handle APPLCOMPAT when it comes to Dynamic SQL? I have been involved in testing in Db2 version 12 for a while now, and I think we need a discussion about a few features that come in with this

Getagged mit: , , , ,

Rotten Results from RUNSTATS Require Rescue

Do you know the basic rules to ensure access path stability when using RUNSTATS? DB2 z/OS Access path stability: Time for another of my “I noticed something strange at a customer site recently” Newsletters. Enjoy!   RUNSTATS are good aren’t they? At

Getagged mit: , , , , , , ,

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

Getagged mit: , , , , , , ,

BIF HealthCheck Licensed Freeware for DB2 10

Detect static and dynamic SQL and match to the relevant collection, packages,… BIF/ICI HealthCheck overview (Built-in Function Checker for DB2 z/OS) BIF/ICI HealthCheck reports the following BIF incompatibilities in DB2 10 Execution of the DB2 9 for z/OS version of

Getagged mit: , , , , , , , , , , ,

BIF HealthCheck Licensed Freeware for DB2 11

Detect static and dynamic SQL and match to the relevant collection, packages,… BIF HealtchCheck overview (Built-in Function Checker for DB2 z/OS) BIF HealthCheck reports the following BIF incompatibilities in DB2 11 Execution of the DB2 9 for z/OS version of

Getagged mit: , , , , , , , , , , ,

GIVE and TAKE Programme 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

Getagged mit: , , , , , , , , , , , , , , ,