DSXchange

If you are have the resolution, please mark the topic as resolved.

Was the Procedure or tables it referes/writes to are modified recently? Its the segmentation error. Procedure may not have write access to some of the tables or table size is full or database file size is not defined as incremental or may be it tries to write in non-nullable column. (I am assuming O...

deepa_shenoy wrote:I read that too... but I dont know where and how to see the log file!!

If you have root access on Unix machine (u could try with your login), a simple find command would help you locate the file.

find / -name ora.2714.131128.1.log

Even in file .odbc.ini defines a lot of ODBC datasources, and they work well in the ETL jobs, when try to import table defintion from ODBC datasource, the following is showed with Import Meta Data (ODBC) Empty DSN: list returned from host svrxxx You have to add an entry in uvodbc.config under your ...

LD_LIBRARY_PATH system variable must have the DSEngine/lib path. Hope the quote below helps. /opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/bin # ./dsjob ./dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory /opt/IBM/InfoSphere/Asce...

.. but I could find any duplicate entries of user defines env variables in the DSParams file. Please check the User Defined Env Variables with the Existing ones ( system generated ), like APT_ variables. Also TMPDIR is one variable which I was trying to add in User Defined section, however it alrea...

Thanks Ray. I tried all the formats 01/01/2500 2500-01-01 01-01-2500 2500/01/01 01012500 25000101 Unfortunately nothing worked. However I did one thing that resolved the issue. I deleted dsinstall folder from /tmp and copied the installable package again with binary transfer option. Checked that I h...

Ascen - How did you manage to resolve the "Internal Error: failed to convert date" issue? Guys, I am facing same problem with the installation. I am trying to install Datastage 7.5.2 on Suse Linux Entersrise Server 9. After I enter serial number, expiration date and server codes and doing ...

Yes you can pass parameter to "Read First Rows" option in a sequential file property. Insert the parameter in the value tab of "Read First Rows", example: #minrows# where "minrows" is a parameter declared in job properties either with a default value or could be passed ...

You can't run Parallel jobs unless you have Datastage version installed on Unix. If its 7.5 and installed on Windows OS it will not work. If you want Parallel jobs to work on Windows OS you should look for 7.5x2 version which was desiged for running parallel job on windows environment. Try and get D...

Thanks Guys.

Regards
Rupesh

Hi There are many ways one could sequence the mainframe jobs. 1. Have a common JCL for all jobs and run them in sequence in different steps. 2. If you want few jobs to run parallel that are independent of each other, can be achieved by using mainframe job scheduler like Control-M or TWS. Thanks for ...

Thanks Craig. DS Server, Client and Oracle 11g server are on the same machine. And, I did not replace the values anywhere. Meaning, PATH variable in Project Properties -> Environment Variables was empty. Also, PATH variable in system environment variables already had the oracle home string. Hence, I...

Hi Craig I have specified the PATH in two places, as I was not sure where to add. 1. In Datastage Administration, Project Properties, Environment Variables, General -> PATH ....and the value was full path of the oracle home directory 'F:\app\rup\product\11.1.0\db_1\bin' 2. In Control Panel, System, ...

Hi I have installed DS PX 7.5x2 on windows. Database is Oracle 11g. I am trying to use Oracle Enterprise Stage to read data directly from oracle db and get the required rows in a dataset. I get the following error, when I try to view data. ##I TFCN 000001 14:30:49(000) <main_program> Ascential DataS...