** 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
==========================================================================================================
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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