Developers often struggle with SQL tuning, often calling upon a DBA to help. In the world of agile processes and Continuous Integration, this approach no longer works and developers need tools to help...
One of my client was trying to start SQL Service and it was failing. I asked to hare ERRORLOG so that we will get some idea about the cause. Here is the information from ERRORLOG file.
2017-01-31 01:...
DB2 LUW indexes, like any database indexes, can be extremely helpful for queries that need data that’s scattered in the database. They act, of course, like a book’s index – rather than methodically ...