Bonjour,
I create a job that write data to a temporary DB2 table. For the performance reason, I create the table without index.
To create the INDEX and make a RUNSTATS I tried to run an After Job with ExecSH but this is not working because I got the following DB2 error.
*** Output from command was: ***
DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period.
Is somebody can help me.
Error with ExecSH (DB21015E)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If a script works fine from the command line of a user and not from a job, then the only variable is the environment. The script runs under the environment of the DS Engine, so troubleshoot problems there.
In your situation, it sounds like this is not the issue, but one of opportunistic timing. You're running the script by hand probably means that the jobstream is not running, versus the script running in the midst of processing. Sounds like instantaneous server load related issues, as Ray has suggested.
In your situation, it sounds like this is not the issue, but one of opportunistic timing. You're running the script by hand probably means that the jobstream is not running, versus the script running in the midst of processing. Sounds like instantaneous server load related issues, as Ray has suggested.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Camaj,
does that mean that this problem occurs every time you issue the command? Does it happen when you manually execute it from a user session?
does that mean that this problem occurs every time you issue the command? Does it happen when you manually execute it from a user session?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 22
- Joined: Tue Oct 31, 2006 5:16 pm
Hi,
Even I'm getting the same error while trying to execute (ExecSH) a script from Before-job subroutine.
Waring msg:
djp_CDE_INTERFACE_MI..BeforeJob (ExecSH): Error when executing command: sh /data/ds/dpr_smi_dev/scripts/truncate.sh usr_val xyz abc bkh cde_interface_mi /data/ds/dpr_smi_dev/scripts
*** Output from command was: ***
DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period.
The same script takes just couple of seconds to execute from the Unix prompt.
Please help! Thanks.
Even I'm getting the same error while trying to execute (ExecSH) a script from Before-job subroutine.
Waring msg:
djp_CDE_INTERFACE_MI..BeforeJob (ExecSH): Error when executing command: sh /data/ds/dpr_smi_dev/scripts/truncate.sh usr_val xyz abc bkh cde_interface_mi /data/ds/dpr_smi_dev/scripts
*** Output from command was: ***
DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period.
The same script takes just couple of seconds to execute from the Unix prompt.
Please help! Thanks.