You can find a ton of articles about recursive SQL dating back as early as 2004, but for this article I was asked to provide actual real-world situations where recursive SQL was put to use. In all of the situations it was a great success!
As DBAs, one of the tasks that we do on a fairly regular basis is install new Db2 code on the database server. Although it can become routine, installing new code on a server can be surprisingly complex. Docker provides a simple alternative.
If you are a serious Db2 user, chances are you have downloaded and used free Db2 versions for a few years. Db2 Express-C was a free way to learn Db2 on Linux, Unix and Windows, to practise and test your SQL skills and in later versions implement or ship Db2 with your small production application.
Statistics event monitors are an extremely useful way to get periodic monitoring of basic metrics on your system. They're just well-disguised behind a somewhat misleading name.
What if we take a look at the current database management systems field research performance?