DataStage job fails with code=-14 [Timed out while waiting for an event]

DataStage job fails with code=-14 [Timed out while waiting for an event] - this generally happens when jobs are called from sequencers 

 

Solution :

Follow steps 1-3 in resolving this error.
1) DSWaitStartup - environment variable -
When multiple instances of a job are run from a sequence, and one or more of the job instances are set to reset, the sequence might report a status=99 or -14. This can occur because the controlling sequence did not give the job instances enough time to reset before polling its status. The start up time for a job reset must be increased. The environment variable DSWaitResetStartup can be used for this purpose.

(The maximum value that can be set for DSWaitResetStartup is the value of DSWaitStartup (default is 60). For example, if a value of 120 is required for DSWaitResetStartup, then ensure that DSWaitStartup is also set to a minimum of 120.)

Add both DSWaitStartup and DSWaitResetStartup to your project environment variables in DataStage Administrator.

These values can be increased to a maximum of 300, but should be incremented in increments of 60 to determine the best value for your system.

Note: If you use dsjob to run your sequencers, the above 2 environment variables need to be added to the dsenv file in $DSHOME (DSEngine) directory and then DataStage will need to be restarted for these to become effective.
DSWaitStartup=120; export DSWaitStartup
DSWaitResetStartup=120; export DSWaitResetStartup

2) uvconfig changes - NOTE - do not reduce your current values - if your values are higher than these minimum required for sequencer job usage, do not adjust them unless Information Server Support requests that you do.
Unix.Linux:
a. Please log on as dsadm or root.
b. Next, make sure there are no connections to DataStage
(Unix/Linux) specific instructions - Windows will need to use Task Manager
ps -ef | grep dsapi -->This will test for open client connections
ps -ef | grep dscs --> This will test for running jobs.if you find any client connections
and you know everyone is out, they are probably dormant. Please kill them
using kill -9 <pid>.
c. If all is clear, from the DSEngine directory, source the dsenv and
shut down the server. ./dsenv./bin/uv -admin -stop
d. edit the uvconfig file and make the necessary changes
MFILES to 150
T30FILES to 300
RLTABSZ 200
MAXRLOCK to 199
Syncaloc to 0
e. To save the changes to uvconfig and generate a new .uvconfig binary
file you will need to run regen:./bin/uv -admin -regen
f. Now restart server:./bin/uv -admin -start

Windows:
a. Make sure you are the Administrator on this machine
b. Next, make sure there are no connections to DataStage
c. If there are no connections, stop the dsrpc services.
d. edit the uvconfig file in the DSEngine directory and make the necessary changes
MFILES to 150
T30FILES to 300
RLTABSZ 200
MAXRLOCK to 199.
Syncaloc to 0
e. To save the changes to uvconfig and generate a new .uvconfig binary file you will need to run regen from the DSEngine directory: bin\uvregen
f. Now restart dsrpc services

3) If the above 2 steps do not resolve the -14 error and you are using DataStage/Information Server 8.1 - verify that either patch JR30015 is installed in the Version.xml or that you have FixPack1 installed for 8.1.

NOTE: You may need to schedule your job runs so there are not so many processes running at the same time.

Ref :- www.ibm.com


Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098