DSXchange

Posted: **Thu Feb 08, 2007 6:50 pm**

Stick in a "-wait" option so that the execution wont step ahead after the job is reset. Most probably, the second dsjob command is trying to execute a job that is in the process of being reset and hence your error.

Posted: **Thu Feb 08, 2007 8:29 pm**

A couple of other things which might be a problem.

Code: Select all

/bin/ksh 
DSHOME=/usr/local/Ascential/DataStage/DSEngine 
export DSHOME 
. $DSHOME/dsenv 
$DSHOME/bin/dsjob -run \ 
-mode RESET \ 
-warn 10000 MANC pa1 
$DSHOME/bin/dsjob -run \ 
-param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/nod 
e1.apt' \ 
-param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL=""' \ 
-param REMOTE_SERVER="MANC2P_MR" \ 
-param DB_USER="kishore" \ 
-param DB_PASSWORD="rama123" \ 
-param SOURCE_TABLE_NAME="price_order" \ 
-param PARTITION="P0122" \ 
-param TARGET_TABLE_NAME="aprice_order" \ 
-param NZ_DATA_SOURCE="NZSQL" \ 
-param NZ_DB="manc_ds" \ 
-param NZ_SERVER="50.1.11.18" \ 
-param NZ_USER="manc_d" \ 
-param NZ_PASSWORD="mancd" \

Code: Select all

#!/bin/ksh 

DSHOME=/usr/local/Ascential/DataStage/DSEngine 
export DSHOME 
. $DSHOME/dsenv 

$DSHOME/bin/dsjob -run \ 
-mode RESET -wait \
MANC pa1

$DSHOME/bin/dsjob -run \ 
-mode NORMAL -wait \
-param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/node1.apt' \ 
-param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL=' \ 
-param 'REMOTE_SERVER=MANC2P_MR' \ 
-param 'DB_USER=kishore' \ 
-param 'DB_PASSWORD=rama123' \ 
-param 'SOURCE_TABLE_NAME=price_order' \ 
-param 'PARTITION=P0122' \ 
-param 'TARGET_TABLE_NAME=aprice_order' \ 
-param 'NZ_DATA_SOURCE=NZSQL' \ 
-param 'NZ_DB=manc_ds' \ 
-param 'NZ_SERVER=50.1.11.18' \ 
-param 'NZ_USER=manc_d' \ 
-param 'NZ_PASSWORD=mancd' \ 
-warn 10000 MANC pa1

Posted: **Sat Feb 17, 2007 3:26 pm**

thanks a lot kduke , it works fine.
thanks to others also who offered help