MASS INSERT is idle...

ajay kumar

MASS INSERT is idle...

We are downloaded a data from ADL, the data is in float format, we want to
convert to decimal, for that we defined a temporary table with column
defined as float. We uploaded data to the temporary table(using LOAD
After that we insert the temporary table rows into main table (The
corresponding column is defined as decimal), it went thru,

Our problem is when the insert is more than 200000 rows or 1500 tracks of
data, the insert process is simply idle...

To avoid this what to do...? I defined a table space priqty as 27000 and
secqty 8000, only one table is defined on this tablespace.

I am using DSNTIAUL batch job..
thanks in Advance


Get Your Private, Free Email at