(Eddy Coppens) I was working at a customer who wanted to have a database replicating data bi-directional towards another database by means of InfoSphere Data Replication (IIDR aka CDC), but also wanted to have a failover mechanism in place in conjunction with the bought replication solution.

(Ted Holt) The dates in our database are stored as seven-digit packed-decimal values in the common CYYMMDD format. In 2018 I wrote an SQL query that reported the number of days between two dates, but it quit calculating properly as soon as it started using 2019 dates. Can you tell me the proper way

(Scott) 100% of our HUGE audience learned something! #MindBlown The secrets to analyzing Db2 problems are out! Pavel gave us a fantastic introduction to his top problem determination tricks and techniques! You will learn about db2pd, DB2SLEEP, db2fodc, db2dart, db2pdcfg, db2trc, db2diag, analyzetrac

(Ember Crooks) Many of the posts I write focus on either how to do or approach something or a story about something I did. Instead of the How, this post focuses on the What.

(Juan Macias) The command Call SQL Procedure (CALLSQLPRC or CALLP) allows us to call an SQL or external procedure and optionally retrieve some or all of the result sets returned by the procedure.

(Emil Kotrc) The performance of Db2 depends on many things. It spreads from the application and the SQL, through the Db2 itself, down to the underlying system configuration.

(Martin) 100% of our studio audience learned something!Dave provided information and information resources that should help the any ML project.

(Rav Ahuja) Still waiting…it’s been over an hour and still nothing. I watch the clock, get some tea, ruminate on the structure of dark matter….

(Paul McWilliams) APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11.

(Joe Pluta) As I detailed in a previous article, QUSROBJD allows you to see all the details of an object. However, it is specifically designed to return the data for a single object.