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

Tuesday, August 21, 2012

Example "DSENV" file


Hi Friends
Here I am sharing a example of "DSENV" file.



#!/bin/sh
####################################################################
#
# dsenv - DataStage environment file
#
#          Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2007 All Rights Reserved.
#          This is unpublished proprietary source code of IBM Corporation
#          The copyright notice above does not evidence any actual or
#          intended publication of such source code.
#
# This script is sourced by the DataStage dsrpcd daemon to establish
# proper environment settings for DataStage client connections.
#
# This script may also be sourced by bourne shells to establish
# proper environment settings for local DataStage use.
#
####################################################################

# PLATFORM SPECIFIC SECTION

set +u

#if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
#then
#          DSHOME=`cat /.dshome`
#          export DSHOME
#fi

if [ -z "$DSHOME" ]
then
DSHOME=/iis/IBM/InformationServer/Server/DSEngine; export DSHOME
fi

if [ -z "$DSRPCD_PORT_NUMBER" ]
then
            true
            ##DSRPCD_PORT_NUMBER_TAG##
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/iis/IBM/InformationServer/Server/PXEngine; export APT_ORCHHOME
fi

#if [ -z "$UDTHOME" ]
#then
UDTHOME=/iis/IBM/InformationServer/Server/DSEngine/ud41 ; export UDTHOME
UDTBIN=/iis/IBM/InformationServer/Server/DSEngine/ud41/bin ; export UDTBIN
#fi

#if [ -z "$ASBHOME" ] && [ -f "$DSHOME/.asbnode" ]
#then
            ASBHOME=`cat $DSHOME/.asbnode`
            export ASBHOME
#fi

#if [ -z "$ASBHOME" ]
#then
            #ASBHOME=`dirname \`dirname $DSHOME\``/ASBNode
            #export ASBHOME
#fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
            ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
            HOME=${HOME:-/}; export HOME
           
            #LANG="<langdef>";export LANG
            #LC_ALL="<langdef>";export LC_ALL
            #LC_CTYPE="<langdef>";export LC_CTYPE
            #LC_COLLATE="<langdef>";export LC_COLLATE
            #LC_MONETARY="<langdef>";export LC_MONETARY
            #LC_NUMERIC="<langdef>";export LC_NUMERIC
            #LC_TIME="<langdef>";export LC_TIME
            #LC_MESSAGES="<langdef>"; export LC_MESSAGES

# Added by Kev

LANG="en_US";export LANG
LC_ALL="EN_US.UTF-8";export LC_ALL
LC_CTYPE="EN_US.UTF-8";export LC_CTYPE
LC_COLLATE="EN_US.UTF-8";export LC_COLLATE
LC_MONETARY="EN_US.UTF-8";export LC_MONETARY
LC_NUMERIC="EN_US.UTF-8";export LC_NUMERIC
LC_TIME="EN_US.UTF-8";export LC_TIME
LC_MESSAGES="EN_US.UTF-8"; export LC_MESSAGES
           
# End of addition

# Old libpath
#          LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$LIBPATH

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:/usr/mqm/lib64:$LIBPATH

            export LIBPATH

            ulimit -d unlimited
            ulimit -m unlimited
            ulimit -s unlimited
            ulimit -f unlimited
# below changed to unlimited from 1024
            ulimit -n unlimited


            LDR_CNTRL=MAXDATA=0x60000000@USERREGS
            export LDR_CNTRL


fi


# General Path Enhancements
PATH=$PATH:/iis/IBM/InformationServer/Server/PXEngine/bin:/iis/IBM/InformationServer/Server/DSEngine/bin:/usr/mqm/bin:/var/mqm:/usr/mqm

############################
#    Source DB2 instance
############################

. /home/db2/sqllib/db2profile

####################################################
# DB2 Ver 9.7 Parameter Variables Set Up for
# Multiple instance connection
####################################################

DB2INSTANCE=db2; export DB2INSTANCE
DB2DIR=/opt/IBM/db2/V9.7; export DB2DIR
INSTHOME=/home/db2; export INSTHOME
DB2CODEPAGE=1208; export DB2CODEPAGE

###########################################################
# Append the DB2 directories to the PATH
###########################################################

PATH=$PATH:$INSTHOME/sqllib:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc:$DB2DIR/bin export PATH
THREADS_FLAG=native; export THREADS_FLAG

LIBPATH=/usr/IBM/db2/V9.7/lib64:/usr/IBM/db2/V9.7/lib32:$LIBPATH;export LIBPATH

DATASTAGE_JRE=/iis/IBM/InformationServer/ASBNode/apps/jre; export DATASTAGE_JRE

APT_CONFIG_FILE=/iis/IBM/InformationServer/Server/Configurations/default.apt; export APT_CONFIG_FILE




njoy the simplicity.......
Atul Singh

No comments :

Post a Comment