As many other I got challenged to set up a database architecture. Not only database objects related, describing the different environments was also asked and there was an urgent need for a decent security setup to support rollouts in general.
I searched for the manual which would explain how to write proper SQL. I never found it and the more I talked to people on which strategy I should follow, the less useful information I seemed to get. The same was true whenever I asked for general rules to decide which index was needed.
Help Db2 security RFEs get the attention they deserve by voting for your favorites!
DB2 is particularly good at running complex query and analytical processing. Since all modern hardware contains multiple cores and CPUs, and many systems are composed of multiple machines, it is critical that DB2 run individual queries across all available computing resources.
One of the most common maintenance activities performed on a Db2 LUW database is running Runstats on tables and indexes. Accurate database statistics are vital for the Db2 Optimizer to produce the most optimal plans.