DSXchange

Hi Experts, We need to automate the process which takes backup of the complete project. I found the command 'istool' which we can use to export the jobs in specific folder. Export option for istool is istool export authentication options [generic options] -archive "pathname" [-updatearchiv...

Thanks for the help! We are able to sucessfully login to Oracle wallet from the linux box where DS is installed. But some how the same credentials are not working in Oracle connector stage. Do we have to restart the DSEngine so that these changes(changes in sqlnet.ora and tnsnames) will be effective...

Hi experts, We are unable to connect to Oracle database (wallet) through Oracle connector stage. Below is the error:- OCIServerAttach, Error Code: 28,759, Error message ORA-28759: failure to open file. When I try to login with the same credentials in linux it is working fine. :roll: Is there any spe...

Hi Experts, Datastage 9. O/S Windows 2008 R2 DB SQL Server We are unable to read just the filename from the sequential file for Datastage windows operating system. Currently the file name is populated as D:\LoadInputFile\StageArea\<FileName>.txt The file path varies in different environment,so we ca...

Thanks all for the help.

The file name which C complier was searching for "windows.h", but in our server the file name was "Windows.h"
I have rename this file to "windows.h" and we were able to compile and run the job

Again thanks all for your help!!

Hi Experts, We have installed Datastage 9.0.1 in windows 2008 R2 EE. When we compile job having transformer stage it is giving below compliation error:- Below are the steps which we have varried out:- 1. Installed Datastage 9 2. Installed Microsoft Visual C++ 2008 Express Edition. ##W IIS-DSEE-TOSH-...

Thanks for the help!!

Looks like I have to start again(complete re-installation of our dev box).

Hi Experts, Can we change the default installation directory structure post installation? Currently we have installed infosphere pacakge in default location that is:- /opt/IBM Is it possible to change this location to new location without effecting the current jobs or do we have to again complete re...

We are loading the data from SQL Server into NZ using the NZ Enterprise stage, all the columns are nullable. Jobs design SQL--> Copy -->NZ But still while loading the data into these columns we are getting below error and records are rejected:- Netezza_Enterprise_6: When checking operator: When vali...

Hi, We are trying to load the data from the SQL Server into Netezza using nzload option. The table are created into Netezza through Datastage. When I try to read the data from SQL server for data type like "xml" and Nvarchar(max), odbc connector is giving below error message :- ODBC_Connec...

Thanks Keith for the suggestions... Below are the modifications which I have done to the job:- 1. Change in the DNS to enable bulk load EnableBulkLoad=1 BulkBinaryThreshold=32 BulkCharacterThreshold=-1 BulkLoadBatchSize=1024 BulkLoadOptions=0 2. Reading parallelly from the source by "Enable Par...

Then work on the issue optimizing the read and/or write depending upon which presents itself as the problem. To really help with tuning past that point, you will need to provide some details that explain what you are doing more thoroughly now. Is your read a select without a where clause? Have you ...

BI-RMA wrote:Are there any active indexes on the target-table while loading?

Thanks for the help!

There are no index on the target table. It is simple truncate and load process....

DS Version 8.7 Hi Experts, We are using ODBC connector to fetch the record from AS/400 table( through driver VMdb225.so) and insert into SQL Server again by using ODBC connector(through driver VMsqls25.so). Its taking approximately 24 minutes to load 1.2 million records. :x I have tried to change th...

We have setup Information Analyzer 8.7 for SQL Server. While running the column analysis it is erroring out. Below is the error message:- Failed to create FreqDist Summary Details are:- Failed to create FreqDist Summary for com.ascential.investigate.exception.CreateFrequencyDistributionException: Fa...