Search

1 to 6 of 6
Sort by

Blog Entry
IDUG Tech Talk: Vital Statistics - What You Should Know About DB2 for LUW Catalog Statistics

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...


Blog Entry
Learning Machine Learning

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...

Emil Kotrc's profile image

Library Entry
SQL to extract low2key & high2key values for DECIMAL data

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 ...


Library Entry
IBM DB2 RUNSTATS Utility and Real-Time Statistics

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


Library Entry
IBM DB2 RUNSTATS Utility and Real-Time Statistics

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


Library Entry
Exploiting Real Time Statistics, a Real Time Saver

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