DSXchange

Hi , In our project we are using Datastage 8.1 on HP UX platform. Client and Server are located in different countries. What we have found when we work at Client side using datastage designer it is working very slow. It takes a lot of time to edit soomething. It seems that there are two modes of dat...

Arnd, The problem is solved now. The problem was of NULLs. I had done NullHandling in the transformer but I repleced NULLs with the Empty string "" .I Read in some post that database treats empty string as a NULL.So I replaced it with one space " " then it is run fine. I am not g...

Datatypes are Varchar , Decimal.
From the source I am applying function UstringToString for som,e columns.

Hi , I am trying to create a table using Enterprise ODBC stage.Database is Oracle. But I am getting below fatal errors. main_program: Driver doesn't support the datatype. DataType Code = -9 main_program: Could not get mapping for one or more datatypes. Cannot create table:CSTG2.MM_ZMARA ODBC_Enterpr...

Thanks Craig

Thanks Craig.

As per our admin , there were special libraries for address cleansing stuff that these env variables were pointing too.

Hi ,

This problem is solved now.

Our admin has changed environment variables
$DS_OPERATOR_BUILDOP_DIR
$OSH_PRELOAD_LIBS
to the default values(which is basically null).

Earlier they were pointing to some other special libraries.


Thanks everyone for their replies.

ArndW ,
I am on HP unix.

{cdsusr@cdhiiad1:/home/cdsusr}uname -a
HP-UX cdhiiad1 B.11.31 U ia64 1789613992 unlimited-user license

I am also talking to our Admin team. Will post If we get something.

ArndW, I tried below command. cd /opt/IBM/InformationServer find . -name libqabwvcd.sl -print Below is the output. {cdsusr@cdhiiad1:/opt/IBM/InformationServer}find . -name libqabwvcd.sl -print find: cannot open ./Server/DSEngine/CAT find: cannot open ./Server/DSEngine/VCOMM I think shared library is...

I created an empty library file. But got the below error. main_program: /opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl: Could not load "/opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl": I/O error mapping in '/opt/IBM/InformationServer/Server/DSEngine/QAS/...

ArndW , Please find below my findings. {cdsusr@cdhiiad1:/home/cdsusr}ll /opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl /opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl not found {cdsusr@cdhiiad1:/opt/IBM}find . -name libqabwvcd.sl -print find: cannot open ./Informat...

Craig , I checked the dsenv file and there in the variable LD_LIBRARY_PATH above path is mentioned. ArndW , The full warning message is as below. main_program: /opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl: Could not find "/opt/IBM/InformationServer/Server/DSEngine/QAS/lib/li...

In our Datastage environment , when we execute any job there is this one warning pops up everytime. It is as below. main_program: /opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl: Could not find "/opt/IBM/InformationServer/Server/DSEngine/QAS/lib/libqabwvcd.sl" on the libra...

This issues is solved now. The problem was my command was too big for unix command prompt. I realized that when I tried with all the parameters dsjob command was getting truncated at DMDev. I copy the command in the unix shell script and ran the script and it worked. Same command is running fine now...

Try specifying options -domain -user -password and -server Ray , I tried as you have suggested but gave the same error. dsjob -domain 10.202.131.46:9080 -user cdsusr -password cdsusr -server CDHIIAD1:31538 -run -param GENERATION_PARAMETER=Gen_Param -param ET_SOURCE_TABLE=CSTG1.MDR_VW_SAP_FUNCTIONAL...