with Tags: section X
NishantSinha Tags: dft_queryopt class db2 plan query optimizer current explain_from_section explain compiler section access optimization 1,139 Visits
A query optimization class is a set of query rewrite rules and optimization techniques for compiling queries. It is one of the most important determinants in the evaluation and selection of an access plan for a particular query. DB2 provides multiple ways to...
from Blog: DB2 Problem Troubleshooting and Tips
Arun.Narayanan Tags: nist ibmeam section fdcc usgcb 508 sp800-131a security maximo fips federal 3,261 Visits
You may have many questions surrounding Maximo support for USGCB, FDCC, FIPS support, NIST SP800-131a and Section 508 accessibility. The following article provides you further details regarding Maximo support for these standards. USGCB is the US Government...
from Blog: Asset Management
SergeRielau Tags: section function profile db2exfmt procedure actuals explain trigger 17 Comments 46,374 Visits
UPDATE: Feb 11, 2012 I have added a TRACE procedure and renamed ENABLE/DISABLE_EXPLAIN_ACTUALS to ENABLE/DISABLE_ACTIVITY_MONITOR. The TRACE procedure returns a formatted trace of all SQL monitored by the activity monitor. This includes nested compiled...
from Blog: SQL Tips for DB2 LUW