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).
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