The DB2 for Linux, UNIX and Windows query optimizer is responsible for choosing optimal query access plans, however it can't do its job properly without vital information about your data and database objects. The RUNSTATS utility has been used for years by database administrators to collect...
Machine learning is a rapidly growing field of the computer science, which has many far-reaching applications. Unless you've been living in a cave, you have probably heard a lot about Machine Learning (ML) in the last couple of years. Of course, there are many relevant materials available as...
The below SQL interprets the columns high2key & low2key of sysibm.syscolumns for decimal columns. Note the restrictions: coltype='DECIMAL' (since just designed for this case) and statstime (which should normally guarantee that low2key and high2key are filled). WITH a(t,c,n,l,s,v1,v2) AS ...
This presentation reviews the basics of the RUNSTATS utility (What it does; Why you need to run it; How DB2 uses the information), and explores new statistics collected on data and indexes, including: partition level information on Data Partitioned Secondary Indexes; non-uniform distributon...
EU07B05.flv
MOST DBA DON'T HAVE ENOUGH TIME ! So let's fully automate the day to day maintenance !! Real Time Statistics (RTS) can save any DBA a lot of time. So let DB2 take care of most housekeeping and free up your time for the fun stuff. This technical session will show you RTS setup step by step,...
EU07B04.flv