First you must verify the DB space with this:
Select Sum(MaxPerm) - Sum(CurrentPerm)
Where DatabaseName = 'xxx'
Then calculate how many bytes are each row inserted.
If your PI are always distinct, then you not will have skew.
Load a sample of the data to ensure that your job is properly mapping the source field to the target PI. If it is loading nulls to the PI for instance, the job will be terribly skewed.
CREATE MULTISET TABLE DEVA1_RSDS_HIST.T_CAPCISAU_CAPACCTD10ST ,NO FALLBACK ,
Since , the PI has distinct values, then 1.change PI to UPI.
Then , check from dbqlogtbl , if during the same period were running(insert statements) other queries which were taking pernament space.If yes ,
1)the one possibility is that some other jobs had really big skew ,, so you have to fix the PI.
2)if not , then the space that you have is not enough ,add space.
Before adding more space , try to check the skew of all tables on the target DB and then add if needed space.