Error with ExecSH (DB21015E)

Camaj · Post by **Camaj** » Fri Dec 09, 2005 9:33 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 09, 2005 6:00 pm

Probably your system is overloaded. DB2 needed to start a process but failed to do so within some timeout limit. Try again when the system is not so busy.

Camaj · Post by **Camaj** » Mon Dec 12, 2005 7:10 am

Thank Ray, but the proplem is not related to the system resource.

My script can run normally outside DataStage. My problem is probablement related with the db2bp but I can't not found where it is.

kcbland · Post by **kcbland** » Mon Dec 12, 2005 7:38 am

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.

ArndW · Post by **ArndW** » Mon Dec 12, 2005 7:40 am

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?

hsbc_ds_dev · Post by **hsbc_ds_dev** » Wed Sep 26, 2007 2:37 am

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.