Terminate the agent running the load, then execute the load with the
'terminate' command. You will then have to backup the tablespace to get
it out of backup pending before you attempt the load again.
Ken

-----Original Message-----
From: Divakar Goel
[mailto:db2udbdba-ezmlmshield-x48042278.[Email address protected]
Sent: Wednesday, May 23, 2007 8:49 AM
To: LazyDBA Discussion
Subject: How to kill LOAD Command


I am on db2 v8.2 on AIX

We fired a LOAD Command. It was suppose to load some half-a-million
records from a delimited text file..

The command did not complete after 10 minutes.
When we checked the messages file, we found that the there was some
error with the input and it was logging errors..

We wanted to kill the LOAD but could not find a way to do it..

Can anyone tell how to do it..

We had run command from Command Line directly..

Divakar




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This message is subject to PrimeSource's policies regarding
the confidentiality and non-disclosure of the company's
confidential and proprietary information. Any unauthorized
disclosure of the contents of this message and/or any attachments
hereto is strictly prohibited.


DB2 & UDB email list listserv db2-l LazyDBA home page