DSXchange

We use DataDirect v6.0 SP2 ODBC drivers to connect to an SQL Server 2008 Database. The ODBC v6.0 drivers support SSL encryption. Could you please let me know the process or refer any available online documentation to configure DataStage / ODBC drivers to establish a secure SSL encrypted connection t...

The issue has been reported to IBM support.

The interesting part is that, when the password is set to an invalid value, the 'view data' almost immediately reports an error saying 'Username and /or password invalid'. Whereas when reset to a valid value, the error is reported as 'Password missing'. !!

Hi We connect to a remote DB2 database using DB2 API stage in a server job. While migrating the server jobs to parallel, we are going to replace the DB2 API stages with the DB2/UDB Enterprise Stage. After configuring it, we tried to test the connection using 'view data' from the DB2/UDB Enterprise S...

When I use a DRS stage(configured to ODBC) instead of ODBC EE stage, the DataStage throws the exact error message. This means that the driver is retreiving the errors from SQL server.

Should I use a DRS stage instead of ODBC stage? What should be the decision based on?

We have a simple job that takes data from Oracle Enterprise stage and populates an SQL server table using ODBC enterprise stage. Oracle Enterprise -> Transformer -> ODBC Enterprise We have defined constraints on some of the fields in the SQL Server table. But even if the constraints are not met, the...

Raised the issue to IBM. They have asked us to lower the insert array size. We have increased the swap memory from 2 GB to 24 GB. We will be testing the job once again and monitor.

One of our ETL jobs on DataStage 8.1 failed in Live environment with the following error - APT_CombinedOperatorController,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver]20157 odbcwrt_EX_POST_RESULTS,0: Failure during execution of operator logic. ... main_program: APT_PMsectionLeader(1, node1), play...

As advised by IBM, we are upgrading the drivers to DataDirect v6.0

We had raised this issue with IBM. They have responded by saying that the DataDirect v5.3 drivers(default with IS 8.1) does not support SQL Server 2008.

We have to upgrade our ODBC drivers to DataDirect v6.0 and above, which support SQL server 2008.

Hi As part of a major overhaul in our project, we are migrating from SQL Server 2005 to SQL Server 2008, as a target database. All our DataStage 8.1 ETL jobs fetch data from Oracle and populate tables in SQL Server. We use ODBC Enterprise stages and have DataDirect Release 5.3 Service Pack 1 drivers...

We changed the uvodbc.config file in the project directory to reflect the following: <DPServer32> DBMSTYPE = ODBC MAXFETCHBUFF = 16384 Array size = 1 Row commit interval = 5000 The job still failed. We did not change the MAXFETCHCOLS as it is 400 columns by default. The job is failing at the same re...

Sorry Ray, I was not able to view the premium content

The number of columns is 120. Are these 'configurable maximum number of bytes per row' and 'configurable maximum number of columns per row' set through some environment variables?

We have created a server job with the same logic which is working fine.

Hi One of our parallel jobs fetches data from Oracle 10g and inserts into a SQL server table. The job design is as follows: Oracle Enterprise > Transformer > ODBC Enterprise The job nees to fetch and populate approx 20 million records. The job is failing due to the following error. odbcwrt_EX_POST_R...