DSXchange

tried your suggestion, didn't help

Hi We are facing with DB2 Bulk load issue with the jobs failing with a SQL2019N error. We are moving from 9.1 to 11.5 and the same jobs work fine in 9.1 environment running to the the same remote database,but they fail in 11.5 We have opened a ticket with IBM, but they haven't been able to diagnose ...

Hi, for the 3rd party jar files, should they be copied from the server(hadoop distribution) to the engine server? i see that the document specifies 3 jar files. i am assuming they will be on the server where hadoop distribution is installed and we should copy them manually to the engine server and p...

Hi I need to write about ~100 files to S3. I have different schema for each file and instead of having few 100 jobs, planning to use RCP. The job design is something like this: sequential file --> copy --> s3 No columns are defined and the sequential file uses a schema file. The schema file the colu...

Yes, its 11.5.0.1 and this patch is included in that. I also tried with a delimited file. I get the same error though the file is present with all permissions.

Hi We are trying to read an Avro file using file connector/webhdfs. I am just specifying the name node (host name) and the path to the .avro file, user name and password for the hdfs access When i run the job, i get the message, file not found or you don't have permissions. I see the file and permis...

Hi We are using ODBC Connector against SQL Server database. Have many jobs specified as Timestamp 23,3 to read sql server datetime fields. However datastage is ignoring the milli seconds 2016-10-01 23:59:59.997 its ignoring .997 using microsecond it adds more digits(6) after the decimal How exactly ...

Sorry i didn't realize that its moved. Its not resolved yet. we have a PMR with IBM, still waiting for response.

Is dsjob available somewhere in is-suite?

test

Hi,

while working with dsjob, we kind of accidentally messed up. the bottom line is we dont have a dsjob executable in the bin directory. is there a way to retrieve it from the is-suite directory and copy it over to bin directory

thanks for your responses. at this point we will just go with offloading the data to a hashfile enforce data typing and then load the database from reading it in the same job. looks good so far

We have some server jobs migrated from 7.5 days and now in 11.5.0.1. these jobs were using drs plugin and now the drs connector replaced them. this actually exposed a bug(?) in the basic transformer stage. essentially we have 2 numeric fields define as 19,8. these will be multipled and result stored...

We are currently on 11.3.1.2 windows and migrating to 11.5.0.1 (aix 7.1). we have some server jobs using dynamic rdbms stage back from ascential days that worked till 11.3.1.2, with 11.5 the stage is retired and we used the connector to migrate. However the connector is causing many issues. When we ...

Hi Teez,

we are facing the exact same issue on windows environment. Using 11.3 version..I cant believe its still a bug in the latest. Do you have a solution/work around?

Hi, We are upgrading from DS8.1(Linux) to 11.3 (Windows). We have quite a few jobs that use a design similar to fork join. The jobs are getting into a deadlock situation and stuck with no progress. These jobs are running fine in 8.1(linux) But when we change the buffering policy from automatic to fo...