dsjob
Moderators: chulett, rschirm, roy
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
Mamu Kim
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm