DB2 Load Utility
DB2 Load utility most people think that it is Admin task. But it is a developer task too. Load utility highly useful when the volume of data is more.
These points are useful for your interviews on DB2 Load Utility
Performance wise much better than INSERT and Import.
Access Control to Load Utility
You need these two accesses:
SQL State Error 5U014
During Load operation, if there are any protected columns, you will get 5U014 error. So you need LBAC access to your session id.
The Important Modes on Load Utility
The INSERT mode, just append the new rows in the Table. It will not DELETE any rows.
It DELETEs all the rows, and inserts new rows in Table. The definition of Table and Indexes will not be changed.
** One of the best interview question
It restarts from previously committed point. That means, where it stopped previously.
The Terminate mode is little tricky. It Terminates till the point where it initially started.
It brings all the objects and indexes to normal.
The LOAD TERMINATE issues on LOAD REPLACE, then it keeps in a state that, Table data truncates. That means, you can see empty Tables.
The LOAD TERMINATE will not remove backup pending state.
The LOAD TERMINATE issues on LOAD INSERT, The Table will retain all its original rows. That means the Table will be as before when you start LOAD INSERT.
It means the indexes will not build during a load operation. But, these can be build using REBUILD mode.
- DB2 Five key areas to improve Performance
- Real logic you need to connect DB2 using PHP engine
- Top DB2 privileges really useful for certification seekers