Optimizer, Static SQL, Dynamic SQL like there are many specific keywords in DB2. Explained for you to read quickly.
Tag: DB2 utilities
How you can use ‘DISPLAY UTILITY’ in DB2
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
2 Top features of IBM DB2 CHECK DATA utility
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
Db2-Load Utility Executes in 13 Phases
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.
Top essential features of DB2 LOAD utility (1 of 2)
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.
