Author: vpinot

2019-01: Regular Expressions in Db2 SQL – Regulate this!

Impress your JAVA colleagues with Regular Expressions in Db2 SQL – Become a regex specialist with these samples (regex usage in the TSO Editor & regex as a predicate).
The references to blogs focusing on this topic (advanced pattern matching, regex testing and REGEXP_LIKE usage) will help round out your knowledge all about “Regular Expressions in Db2 SQL”.

Tagged with:

2018-12: Db2 Checklist – SQLCODEs as never seen before

With this SQLCODE list, from the “bad guys” through to the “odd guys” – e.g. the SQLCODE 100 – and then onto the “not so bad guys”, you can see a practical list of current SQLCODEs in production from around the globe, including their meaning. This review also analyzes the behaviour of some SQLCODEs and proposes some solutions to get your Db2 z/OS programs correctly processing these SQLCODEs.

Tagged with:

2018-11 db2 Numeric Primary Keys: Space, the final frontier?

What do Db2 numeric Primary Keys have to do with space management ?
SMALLINT – INTEGER – DECIMAL – BIGINT…
How to find out which sequences are nearing their physical limit ?

Tagged with:

2018-10 Db2 bind lock: The Scary Case of the Missing Package

In the Db2 world during a BIND/REBIND, while using the command EXPLAIN(ONLY), you may experience a LOCK problems in production: get rid of Db2 lock-timeout – Db2 bind lock with the exposed SQL queries.

2018-09 Db2 Console output : Message in a bottle

With these sample queries, find out how to review your Db2 messages from a high level overview down to the details.
You can review the Db2 Console output from different perspectives and simply bypass the boring „J“ ones for Full Log and Log Offload to leave behind the interesting ones.

Now you have two possibilities to get the Console Messages from Db2, just write your own IFI program or buy our newly updated software (!)

2018-08 SOUNDEX and other “cool” features – Part six All new for Db2 12

Part six of my – everlasting – walk through of new Aggregate and Scalar functions. Following with :  HASH & WRAP Previous “SOUNDEX” Newsletters Part 5:  2018-07:  SOUNDEX and other „cool“ features – Part five All new for Db2 12 Part

Tagged with: , , ,

2018-07 – SOUNDEX and other “cool” features – Part five All new for Db2 12

Part five of my – everlasting – walk through of new Aggregate and Scalar functions. This time I will start with the new AGGREGATE functions introduced in Db2 12. LISTAGG This is mainly of interest due to the fact that

Tagged with: , ,

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 arrives for

Tagged with: ,

2018-05 Audit 2.0 – GDPR Audit guide and checklist for Db2 z/OS

Or: How I Learned to Stop Worrying and Love the Auditor A guideline in 5 big Steps to Audit for Personal Data Protection First up, this is not another Audit review and health check sell! We, and I mean especially

Tagged with: , ,

2018-04 Negative DBIDs: Something new something old

Or: „Even Roy learns things from Listserv!“ While discussing negative DBIDs on Listserv the other day, another poster commented on my SQL Code snippet and said that it could well be better changing from LOCATE and HEX to using the

Tagged with: ,