IBM® InfoSphere™ DataStage®: If there are a large number of users performing concurrent activities such as logging into a client, job design, job compilation, some of these activies can fail.
Symptom
The activities can fail with one or more of the following error messages:
- Error calling subroutine DSR_JOB (Action=5); check DataStage is set up correctly in project dstage_perf (Subroutine failed to complete successfully (30107)) (This problem can occur on any operating system)
- ACCESS DENIED: Project currently locked. The project is currently locked by the Administrator. Try again later or see your Administrator.
- Record J\x\yyyyyy in file DS_JOBOBJECTS is locked by another user
Cause
These failures are due to the lock and open file limits in DSEngine being reached.
Resolving the problem
You can increase the limits by performing the following actions on the DSEngine (as the DataStage administrative user):
1) cd to /opt/IBM/InformationServer/Server/DSEngine or equivalent
2) Edit the uvconfig file and change the following settings; MFILES=64, T30FILE=512, GLTABSZ=100 and RLTABSZ=100
3) Source dsenv if necessary (execute ". dsenv")
4) Stop the DSEngine by executing "bin/uv -admin -stop"
5) Apply the configuration changes by executing "bin/uvregen"
6) Start the DSEngine by executing "bin/uv -admin -start"
No comments:
Post a Comment