View previous topic :: View next topic
|
Author |
Message |
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). |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
ranjanp
New User
Joined: 02 May 2006 Posts: 25
|
|
|
|
Yes i used LOG ON. But it also has NOCOPYPEND. |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|