Datastage - Important Configuration Files

Important Configuration files : 

 

§ dsenv

§ uvconfig

§ .odbc.ini

§ uvobdc.config

§ default.apt

dsenv:

Go to DSHOME directory:

For Example: /opt/IBM/InformationServer/Server/DSEngine



$ pwd

/opt/IBM/InformationServer/Server/DSEngine



$ ls -l dsenv

-rwxrwxr-x 1 dsadm dstage 3153 Jul 02 06:57 dsenv



- dsenv : DataStage environment file

: To establish proper environment settings (Directory, PATHS,

LIBPATHS and ulimit etc for DataStage client connections.

uvconfig:

§Go to DSHOME directory:



For Example: /opt/IBM/InformationServer/Server/DSEngine



$ pwd

/opt/IBM/InformationServer/Server/DSEngine



$ ls -l uvconfig

-rwxrwxr-x 1 dsadm dstage 28783 Dec 17 2009 uvconfig




§ uvconfig : DataStage Server tunable parameters

: Like T30FILE - specifies the number of dynamic files that may be opened.

(T30FILE 512)

: SCRSIZE - specifies the size of newly allocated internal scratch buffers. This

value must not be smaller than 512 and values greater than 2048 are

not advised. (SCRSIZE 512)

.odbc.ini

§Go to DSHOME directory:



For Example: /opt/IBM/InformationServer/Server/DSEngine



$ pwd

/opt/IBM/InformationServer/Server/DSEngine



$ ls -l .odbc.ini

-rw-rw-r-- 1 dsadm dstage 12417 Jul 12 04:17 .odbc.ini




§.odbc.ini : Contains Data Sources to connect to ODBC databases

§uvodbc.config

- Go to DSPROJECT directory:



For Example: /app01/Projects/RADW_UAT





$ pwd

/app01/Projects/RADW_UAT





$ ls -l uvodbc.config

-rwxrwxr-x 1 dsadm dstage 1141 Jul 10 23:13 uvodbc.config


-
§uvodbc.config : Contains Data Sources to connect to ODBC dbs