We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, April 07, 2015

Get Datastage Job Lock List by Script


** This script will fetch all locks currently on Datastage Server irrespective of Projects.
** We can modify this script to correct the data display format as per our need
** Can modify sort command as it changes its behavior in different Linux flavour



==========================================================================================================
# Script Name - DSlistJobLock.sh
# Developer - Atul Singh
# Description - This script query on the Datastage UV DB
# and get the locks which is currently existing over datastage jobs
# Date - Feb 25, 2015
# Plateform - AIX,LINUX, UNIX, Solarix and all NIX
#!/bin/ksh
. /opt/IBM/InformationServer/Server/DSEngine/dsenv > /dev/null 2>&1
# /.dshome is a file holding the DS HOME location
DS_HOME=`cat /.dshome`
cd $DS_HOME
echo " "
echo " INODE USER PROCESS USERID ITEM"
echo " NUMBER NUMBER ID ID"
echo " -------- ------ ------- -------- ---------------------------------------------"
bin/list_readu |grep -v 'Active' |grep -v 'Device' |cut -b11-19,30-38,44-90 |sort -k 4.1b,4r -k 2.1b,2
echo " "
==========================================================================================================




Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you

https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098


No comments :

Post a Comment