Page 1 of 1
would anybody please help us in solving following error
Posted: Wed Dec 23, 2009 6:50 pm
by YENIKOOL
would anybody please help us in solving following error
job is failing with DataStage status code is: 81002.
Posted: Wed Dec 23, 2009 8:02 pm
by chulett
I'm sorry but that's not nearly enough information for anyone to be able to help. Post the complete, unedited error message and explain your job design as well.
Posted: Wed Dec 23, 2009 8:26 pm
by ray.wurlod
Welcome aboard.
81002 = connection (between client and DataStage server) is broken.
This might be because an inactivity timeout triggered, because there was a glitch in the network between the two machines, or because of a failure on the server side, particularly in one of the "agent" processes (dscd, dsapi_server or dsapi_slave).
Once an 81002 error has occurred you have no choice but to re-start the client application. The previous incarnation may have the design locked, so your DataStage Administrator may need to go through the process of clearing the lock, perhaps using Cleanup Resources in the Director client, perhaps using the UNLOCK command on the server itself.