Whether you’re a seasoned Db2 professional or you’re just beginning, keeping up with Db2 metrics is no trivial task, and you will have to become familiar with lots of metrics, parameter names and meaningful numbers if you want to be successful and have a deep understanding of your environment,...
Hi! I cobbled together a little SQL to create a cross-reference of all DB2 tablespace, tables and indexes with key columns, uniqueness etc. I use it all the time and I finally got around to making it recursive as well. Tested in all available releases of DB2 Roy
sysselix.txt
“As time goes by…..” DB2 for z/OS continues to enhance support for temporal data. Since the availability of the initial temporal support with DB2 10 for z/OS, the functionality has been extended several times. The subject of this article is one of the temporal extensions, the temporal special...
Why Data Studio? IBM’s Data Studio holds a lot of features that are not really commonly known by the DB2 audience. Many people regard it as the replacement of the old Control Center, but as such this isn’t true, as Control Center held features that are no longer in Data Studio and Data Studio...