Reg:DB2 loading issue

sudarsan · Post by **sudarsan** » Fri Sep 18, 2009 3:12 am

Hi,

My job design looks like this.

Sequential file ---> Tfm ----> DB2 stage

I am trying to load one record from file to temporary DB2 table.

In my target stage, Before loading,I am dropping the table/creating that
table again.

Dropping and creating the table is happening properly.

But loading is not happening, job is running for hours and hours but it's not finishing. I am forcefully killing the job.

Regarding this issue I have checked with my DBA, but they conformed saying that there is no problem from database side.

Note: This job ran fine and loaded to DB2 table successfully till 'day before yesterday'.

Can any one please help me on this.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 18, 2009 3:42 am

If the job had been working until yesterday and if there is no change in DataStage side, I will check with the DB2 DBAs for any changes on their settings after your last successful run.

Secondly, as them to monitor the session whilst you run your job.

Thirdly, what happens for other jobs which loads without dropping and recreating the tables ?

Did you check the object creation date for the table to ensure that your drop and recreation was successful ? Maybe you can add one extra (dummy) column to prove the change.