Format..AddressidtbloutHash.Addresstbl: DSD.BCIOpenW call to function SQLExecDirect failed.
DELETE FROM "AddressidtblHash"
SQLSTATE=40001, DBMS.CODE=950261
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: NOWAIT, Can't lock file, conflict with user "63978".
SQLSTATE=S1000, DBMS.CODE=1502
[DataStage][SQL Client][UNIVERSE]Unable to continue. Aborting!
Killed how? Not cleanly as your hashed table is still "busy" and cannot be locked, something the error message clearly notes. Find and kill the remaining process(es) for that job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Was the same user number shown after your restart (number 63978)? How one goes forward depends upon that, since it is highly unlikely that the same user/lock scenario will happen twice in a row.