Hi all, I have to load a flat file of size 106 GB through mload.I have 390GB space left in the database.However I'm not able load this file because of space . I get the error as 'No more room in the database'. Is it because the worktable is consuming more space? Can anybody explain how much space is consumed by the mload worktable?
See chapter 2 of the MultiLoad Reference for a full discussion of disk space usage. Depending on the number of target tables and usage of optional features (fallback, permanent journals, etc.) the space requirement could be several times the size of your flat file.