Introduction of db2 load edus in single partition database

Answer

During load in a single partition database, there are following edus generated.

1)db2agent:The load agent does a little bit of initialization. Mostly the agent is responsible for spawning all of the other processes below and then waiting for termination messages. The agent does very little of the actual work except maintaining a central point of communication between the processes and between the server and the client.

2)db2lmr:Media Reader,this process is always present and reads the load input. It will disappear once the input file is read and may happen even before the load itself has completed.

3)db2lfrmX:Load Formatter, it formats the input data into internal form. Always present till the end of load.

4)db2lrid:Ridder,it organizes data to be written to disk. The ridder has three jobs. One is SMP synchronization, the second is to allocate Record IDs (RIDs), the last is to build the indexes.

5)db2lbmX:Load Buffer Manipulator, it writes loaded data to the database and can be involved in Async I/O.

6)db2lmwX: Load Media Writers, it write the load copy. If there is no load copy then there is no media writer. They usually get input from a buffer manipulator.

7)db2ltsc, db2lfs, db2lbs: Load Scanners, In order they are the table scanner,long field scanner, and lob scanner. They are only used in special cases.