Schlagwort: TIMESTAMP

2018-06 – DST Db2 timestamp problems: I really hate Daylight Saving Time

How to avoid timestamp problems while going from winter to summer time in a Db2 for z/OS system ? Is the CHAR or Timestamp use, the safest timestamp procedure ? How do you fix it? This year, as every year, the moment

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

Index Maintenance Costs, EXPLAIN Suppression, BIF Limited free-of-Charge Db2 Application This Program started in Europe, during our 30th anniversary was such a success, that it is now being Extended for the benefit of North American Db2 z/OS sites. SQL WorkloadExpert™ for

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