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