dsjob usefull shell

findjob.sh すべてのプロジェクトからジョブを検索する

#!/bin/sh
# name findjob.sh
# find $1 jobs in all projects
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

if [[ $# = 0 ]]; then
echo "This script name is `basename $0`, enter jobname to be searched!"
exit 1
fi

if [[ `whoami` != 'dsadm' ]]; then
echo "please login as dsadm."
exit 1
fi

list=`/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -lprojects`
for prj in $list
do
echo "searching project: $prj"
/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -ljobs $prj | grep $1
done
exit 0

listupjobs.sh すべてのプロジェクトのジョブをリストアップする

#!/bin/sh

# name listupjobs.sh

# listup all jobs in all projects

# $project.jobs.txt will be generated as the result

. /opt/IBM/InformationServer/Server/DSEngine/dsenv

if [[ `whoami` != 'dsadm' ]]; then

echo "please login as dsadm."

exit 1

fi

list=`/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -lprojects`

for prj in $list

do

echo "searching project: $prj"

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -ljobs $prj >$prj.jobs.txt

done

exit 0

uvclearlog.sh 特定のジョブのDataStageジョブログをクリアする

#!/bin/sh

# name uvclearlog.sh

# DataStage clear log script

# parameter1: project

# parameter2: jobnumber

if [[ $# != 2 ]]; then

echo "Syntax uvclearlog.sh Project Jobnumber."

exit 9

fi

if [[ "dsadm" != `whoami` ]];then

echo "please login as dsadm!"

exit 9

fi

BASE=/opt

DSHOME=${BASE}/IBM/InformationServer/Server/DSEngine

. ${DSHOME}/dsenv

cd ${BASE}/IBM/InformationServer/Server/Projects/$1

$DSHOME/bin/uvsh << begin_command

CLEAR.FILE RT_LOG$2

QUIT

begin_command

exit 0

cleardslog.sh 特定プロジェクトのDataStageジョブログをクリアする

#!/bin/sh

# name cleardslog.sh

# DataStage clear log script main

# listup job number and call clearuvlog.sh

if [ $# = 0 ]; then

echo "syntax cleardslog.sh Project."

exit 9

fi

PROJECT=$1

cd /opt/IBM/InformationServer/Server/Projects/${PROJECT}

listno=`ls -d RT_SC* | grep -E [0-9]`

for rtno in ${listno}

do

  no=`echo $rtno | cut -d 'C' -f2`

  echo "uvclearlog.sh ${PROJECT} ${no}"

  uvclearlog.sh ${PROJECT} ${no}

  rc=$?

  if [[ $rc -ne 0 ]];then

    echo "error occurred!"

    exit 9

  fi

done

echo "completed."

exit 0