DB2 - Statistics last time updated

Managing statistics is important for index performance. A quick way of displaying the last time statistics were updated is with this sql statement. Select tabschema,tabname,stats_time from syscat.tables where type = 'T' Ref:Jack Vamvas(http://www.dba-db2.com) Read more →

DB2 Database objects overviews

Servers,Instances,Databases Hierarchy --------------------------------------- System Instance (Multiple) Databases (Multiple) Instance Management --------------------------------------- DB2INSTANCE environment variable defines the default instance. Multiple instances are possible . Commands used to manage\create instances db2icrt db2idrop db2ilist db2imigr db2iupdt db2start db2stop How to create a database -------------------------------------- The simple syntax is (there are many more syntax options available): CREATE DATABASE [DatabaseName] There are some naming rules: Only characters allowed are : a-z,A-Z,0-9,@,#,$,_ The first character must not be a name "DBM","SYS","IBM" cannot be the initial sequence Must be a unique name Tasks performed when a database is created 1)The directory\subdirectory structure is created in the chosen... Read more →