DSXchange

Code: Select all

#!/usr/bin/ksh

#########
# Define Parameters Files
#########

. /home/dsadm/.bash_profile
. /it/resrc_disk1/DS_OLTP_CRM/paramcd/OLTP_ds_ITenv_param.txt

# Define log file
SCRIPT_LOG=${LOG_DIR}/$(basename $0)_$(date +%Y%m%d).log
#echo "script directory :${SCRIPT_LOG}"

#########
# process input parametes 
#########

while getopts j:R: param 
do 
    case ${param} in 
         j) DSSEQNAME=${OPTARG} ;;
	 R) RESET=${OPTARG} ;; 
        \?) exit 1 ;; 
    esac 
done 
shift `expr ${OPTIND} - 1`

######### 
# Check that required arguments are present 
######### 

echo "***************** Script Started $(date +"%Y%m%d%I%M") **********************" >>${SCRIPT_LOG} 

if [ -z "${DSSEQNAME}" -a -z "${RESET}" ] 
then 
 echo "$(date +"%Y%m%d%I%M") :: -j <job name> and -R <YES or NO>  - DataStage job name is required to invoke script." >>${SCRIPT_LOG} 
exit 1 
fi 
RESET1=$(echo ${RESET} | tr -s  '[:lower:]'  '[:upper:]')
echo " new test ":${RESET1}

$DSHOME/bin/dsjob -jobinfo $PROJECT ${DSSEQNAME}
jobreturncode=$?
#echo " ${DSSEQNAME} job return code :${jobreturncode}"
if [ ${jobreturncode} == 255 ]
then
echo  " Failed to open Datastage job ${DSSEQNAME} in $PROJECT Project " >>${SCRIPT_LOG}
echo "***************** Script End $(date +"%Y%m%d%I%M") **********************" >>${SCRIPT_LOG}
exit 1
fi
$DSHOME/bin/dsjob -run -mode RESET ${PROJECT} ${DSSEQNAME}
L_DS_STATUS_CODE=$($DSHOME/bin/dsjob -jobinfo $PROJECT ${DSSEQNAME} | grep "^Job Status" | cut -f2 -d\( | cut -f1 -d\))>>${SCRIPT_LOG} 

if [ "${L_DS_STATUS_CODE}" = '' ]
then
echo " $(date +"%Y%m%d%I%M"):: Invalid Datastage job name :${DSSEQNAME}">>${SCRIPT_LOG}
echo "***************** Script End $(date +"%Y%m%d%I%M") **********************" >>${SCRIPT_LOG}
exit 1
else
echo " $(date +"%Y%m%d%I%M"):: Datastage job ${DSSEQNAME} status :${L_DS_STATUS_CODE}">>${SCRIPT_LOG}
fi

#########
# Reset Datastage Job
#########

# Define Datastage log file
DS_LOG=${LOG_DIR}/${DSSEQNAME}_$(date +%Y%m%d).log

echo "***************** Datastage Job Process Started $(date +"%Y%m%d%I%M") **********************" >>${DS_LOG}
if [ ${RESET1} == "YES" ] 
then
if [ ${L_DS_STATUS_CODE} == 21 ] 
then      
echo " $(date +"%Y%m%d%I%M"):: Datastage Job ${DSSEQNAME} is already reset status" >>${DS_LOG} 
else
	if [ ${L_DS_STATUS_CODE} == 3 -o ${L_DS_STATUS_CODE} == 96 -o ${L_DS_STATUS_CODE} == 97 -o ${L_DS_STATUS_CODE} == 98 -o ${L_DS_STATUS_CODE} == 99 ] 
	then
		$DSHOME/bin/dsjob -run -mode RESET ${PROJECT} ${DSSEQNAME}>>${DS_LOG} 
    		if [ $? -ne 0 ] 
    		then 
      		echo " $(date +"%Y%m%d%I%M") :: Failed to reset Datastage job ${DSSEQNAME}" >>${DS_LOG} 
    		else 
      		echo " $(date +"%Y%m%d%I%M"):: Success fully reset Datastage job ${DSSEQNAME}">>${DS_LOG} 
    		fi 
	else 
	echo "  $(date +"%Y%m%d%I%M"):: ${DSSEQNAME} job is in valid Status">>${DS_LOG}
	fi
fi
else 
echo " RESET is not required for this job"
fi
#########
# Run Datastage Job
#########

dsjob -run -wait -warn 1000000 -jobstatus ${PROJECT} ${DSSEQNAME}>>${DS_LOG}
#echo " $(date +"%Y%m%d%I%M") :: run command CMD = dsjob -run -wait -warn 1000000 -jobstatus ${PROJECT} ${DSSEQNAME}" >>${DS_LOG} 
  
RETURNCODE=$? 
echo " $(date +"%Y%m%d%I%M") :: Data Stage Job ${DSSEQNAME} Process Completed  .............">>${DS_LOG} 
echo " $(date +"%Y%m%d%I%M") :: Return Code from Data Stage Job = $RETURNCODE">>${DS_LOG} 
  
if [ "$RETURNCODE" -eq 1 ]
then
#if the Datastage job return code is one, then the job finished .
   echo " $(date +"%Y%m%d%I%M"):: DataStage job finished ">>${DS_LOG}
   exit 0
elif [ "$RETURNCODE" -eq 2 ] 
then 
#if the Datastage job return code is two, then the job finished with warnings. 
   echo " $(date +"%Y%m%d%I%M"):: DataStage job finished with warnings">>${DS_LOG}
   exit 0 
elif [ "$RETURNCODE" -ne 1 ] 
then 
#  if the Datastage job return code is not one or two, then set script return code to aborted 
   echo "  $(date +"%Y%m%d%I%M") :: DataStage job  failed  with Return code : $RETURNCODE">>${DS_LOG} 
   exit 1
fi 
echo "***************** Script Ended $(date +"%Y%m%d%I%M") **********************">>${SCRIPT_LOG}
echo "***************** Datastage Job Process Ended $(date +"%Y%m%d%I%M") **********************">>${DS_LOG}

### 
#Remove Log files from log directory older than 30 days 
### 
  
    find ${LOG_DIR} -name "*$(basename $0)*" -mtime +30 -exec rm -f {} \;>>${SCRIPT_LOG} 
    find ${LOG_DIR} -name "*${DSSEQNAME}*" -mtime +30 -exec rm -f {} \;>>${SCRIPT_LOG}