Issue with the DB2 load utility

ranjanp · New User Joined: 02 May 2006 Posts: 25

Hi All,

I am running a JOB with DB2 load utility to upload a DB2 table with data.
Some data in the upload file is corrupted and the job has abended. Now when i go to view the table it gives me

SQLP100H DB2 Error: Unavailable resource (-904), Press HELP for information

Let me know how I can avoid this situation i.e. table getting locked.

I want even if the job abends the table is available for viewing in its prior form with the prior data (before the job run).

mkarmegam · New User Joined: 28 May 2006 Posts: 13 Location: USA

Did you use LOG NO in the load? If yes did you image copy the table after the load? The table may be in copy pending status which typically gives -904!
Thanks
Mugs

ranjanp · New User Joined: 02 May 2006 Posts: 25

Yes i used LOG ON. But it also has NOCOPYPEND.

mkarmegam · New User Joined: 28 May 2006 Posts: 13 Location: USA

I think you need to terminate the utilid that may be hanging because the job abended.

-dis util(*)
-term util(utilname)
Thanks
Mugs