Optimizer, Static SQL, Dynamic SQL like there are many specific keywords in DB2. Explained for you to read quickly.
The DB2® command DISPLAY UTILITY displays the status of utility jobs, including utility jobs in a data sharing group. The output from the command consists
Utilities in DB2 checks data consistency while loading data into Tables. CHECKDATA utility has two top functionalities. It checks for referential integrity and Data validation
UTILINIT -Performs initialization.RELOADLoads record types and writes temporary file records for indexes and foreign keys. RELOAD makes one pass through the sequential input data set.
The best DB2 Load utility options that you need when you are working with DB2 projects. The methods given here always good to improve performane.