I am trying to load data into DB2 table and got the error S04E (because SORT CAPACITY EXCEEDED). I checked the status of the utility and terminated the utility. Now since the issue is resolved I can run the utility again. Now my question is this time how can I make sure that don’t get SORT issue. Please let me know.
Is this a sort error i think not ,if i am not wrong this error you have got during running DSNUPROC utility for loading DB2 database,
this error i once got because my job got abended in between due to which table got locked,please check once more.......?
second time when we run we have to unlock tables..........it is not sure that every time table got locked.