by Craig S. Mullins | Aug 30, 2021 | change management, packages, REBIND
Db2 DBAs are constantly working with database objects such as Databases, Tablespaces, Tables, and Indexes. And many requirements cause DBAs to have to modify these objects. Some modifications may be simple, such as just issuing an ALTER statement. Others may be more...
by Craig S. Mullins | Aug 16, 2021 | CTE, sql
Sometimes what seems like a simple request might take a little bit of thinking to devise and implement a solution. Recently, I was asked how to write SQL that returns the nth maximum value from a column. If you think about it, it isn't too difficult.Assume that you...
by Craig S. Mullins | Jul 29, 2021 | cloud, data growth, mainframe, storage
Gain more value from your mainframe data with IBM StorageEvery year the amount of data that is created continues to expand. Analysts at IDC estimate that data will grow at a compound annual growth rate of 23 percent through the year 2025. Furthermore, efficient...
by Craig S. Mullins | Jul 16, 2021 | BCV5, data governance, data movement, data refresh, DBA, migration, test data
Creating and managing test data for Db2 application development and testing requirements can be a significant challenge. To enable not only the development of new programs, but to be able to maintain existing ones, organizations must ensure that there is an adequate...
by Craig S. Mullins | Jul 6, 2021 | DB2 Catalog, query, temporal
Sometimes it can be difficult to remember where information is stored in the Db2 Catalog. Usually, with a little rumination and a little review of Appendix A of the IBM Db2 SQL Reference manual (SC27-8859), you can come up with a solution.For example, I was...
Recent Comments