DB2 Reorg and Run stats commands – life saver
Below are some life saver commands for DB2 admin for reorg and subsequent runstat – Reorganising tables:: This process helps in bringing together of widely...
A typical DB2 DB config
Below is a tuned DB config for a heavily loaded workflow application – [db2inst1@intranet db2inst1]$ db2 get db cfg for wf Database Configuration for Database...
Sample PL/SQL script for cleaning a detail table referring a master table
Have you ever had a need to write a PL/SQL snippet to clean a table. If you are in need, here is one below –...