Friday, 26 March 2021

[DB2 LUW] gathering statistcs

The runstat command is used to gather statistics on tables and indexes in DB2 LUW. However, it is no standard SQL command, not even an IBM extension. It is an IBM specific to be run on their CLI. However, one can still issue from any SQL client it encapsulated in the ADMIN_SYS procedure. For details, check the IBM documentation

Example

call sysproc.admin_cmd('runstats on table MY_SCHEMA.SOME_TABLE use profile');

[git] Create a local branch from another branch

From the active branch git checkout -b <LOCAL_BRANCH> From a donator branch git checkout -b <LOCAL_BRANCH> <DONATING_BRANCH...