Home › View all posts by vpinot
Author: vpinot

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

Posted on by vpinot Posted in News from the labs

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”.

Read more ›

Tagged with:

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

Posted on by vpinot Posted in News from the labs

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.

Read more ›

Tagged with:

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

Posted on by vpinot Posted in News from the labs

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 ?

Read more ›

Tagged with:

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

Posted on by vpinot Posted in News from the labs

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.

Read more ›

2018-09 Db2 Console output : Message in a bottle

Posted on by vpinot Posted in News from the labs

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 (!)

Read more ›

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

Posted on by vpinot Posted in Db2 12, Db2 Continuous Delivery, News from the labs

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…

Read more ›

Tagged with: , , ,

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

Posted on by vpinot Posted in Db2 12, Db2 Continuous Delivery, News from the labs

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…

Read more ›

Tagged with: , ,

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

Posted on by vpinot Posted in Db2 audit, News from the labs

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…

Read more ›

Tagged with: ,

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

Posted on by vpinot Posted in Db2 audit, News from the labs

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…

Read more ›

Tagged with: , ,

2018-04 Negative DBIDs: Something new something old

Posted on by vpinot Posted in News from the labs

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…

Read more ›

Tagged with: ,