Datastage常見問題及解決方法

DS服務不能正常啟動和連接配接

當DS安裝在AIX作業系統上時，因為存在DS用戶端非正常斷開的而連接配接未釋放的情況，服務啟動後不能正常連接配接，可以采取以下措施解決 1、停止服務20分鐘以上，再啟動服務 2、查詢程序中未釋放的ds的tcp/ip連接配接，并釋放該連結 3、重新開機伺服器，服務将自動啟動   JOB被鎖及解鎖 在Datastage Administrator的工程指令行中運作如下指令， LIST.READU 找到需要解鎖的USERNO後，解鎖該ID， UNLOCK USER USERNO ALL 使用解鎖指令需要預先進行以下配置，成功後方可進行解鎖操作， SET.FILE UV VOC UV.VOC COPY FROM UV.VOC TO VOC UNLOCK   環境變量配置不正确導緻的各種錯誤，重新配置環境變量并重新開機服務 在root使用者的.profile檔案中增加以下内容： . /home/dsadm/Ascential/DataStage/DSEngine/dsenv

export PATH=$PATH:/home/dsadm/Ascential/DataStage/DSEngine/bin   修改dsenv檔案為以下内容： #!/bin/sh

####################################################################

#

# dsenv - DataStage environment file

#

# Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved

# This is unpublished proprietary source code of Ascential Software 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=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME

fi

if [ -z "$APT_ORCHHOME" ]

then

APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME

fi

if [ -z "$UDTHOME" ]

then

UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME

UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN

fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]

then

ODBCINI=$DSHOME/.odbc.ini; export ODBCINI

HOME=${HOME:-/}; export HOME

#;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

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH

export LIBPATH

fi

#####ORACLE#####

export AIXTHREAD_SCOPE=S

export ORACLE_BASE=/oracle/app

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export PATH=$ORACLE_HOME/bin

export PATH=$PATH:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export NLS_DATE_FORMAT=YYYYMMDDHH24MISS

export LIBPATH=$ORACLE_HOME/lib32:$LIBPATH