DSXchange

I'd like to convert a varbinary to a bigint. The input data looks like {00 00 00 00 00 00 00 00 00 00 00 00 05 f5 e1 02} The target data would be 100000002 Using a server job, the following transformation gives the correct result Oconv(Oconv(%Arg1%, "MY"), "MCX") I'd like to use ...

I ended up opening a ticket with IBM after several runs with varying times. They took a look at the previous job logs and recommended changing the partitioning method on the Lookup Stage from AUTO to HASH. Test 1 -- Run job pointing to a SQL Server 2005 database on a Windows 2003 64bit Ent R2 SP 2 s...

We completed a test on a new VM with a clean DataStage 8.7 install on Windows 2008 R2 (64 bit) For job ODBC DSN created using c:\Windows\SysWOW64\odbcad32.exe Driver: SQL Server Native client 10 Test 1 -- Run job pointing to a SQL Server 2005 database on a Windows 2003 64bit Ent R2 SP 2 server with ...

Thanks for the suggestions. On the Insert (last stage in job), the SQL Server Enterprise stage has an Insert Array Size = 20000 using a Write Method of Upsert. All the Lookups (SQL Server Enterprise stages) have a lookup type of Normal. Our last test, we modified the pagefile size on the TEST server...

A parallel job was re-written by one of the ETL developers to replace an old 7.5 job that performance issues once we completed the upgrade to 8.7 The parallel job reads a flat file and does 28 lookups to SQL Server split across 7 Lookup Stages, a transform stage and then inserts rows to a SQL Server...

Just to post the final findings on this issue. After many tests, performance monitoring, and explaining how DataStage works..... A registry change (by the Tech folks) to 'fix' a previous FTP issue we were having has been found to cause problems with file caching, clearing memory caches and some othe...

The jobs so far that have had performance issues use only flat files and hash files. We haven't had issues extracting from DB2 on z\os. Likely due to our job design (one job per table\query extracted to flat file). We've been monitoring the read\write I/O on the various files and the processes aren'...

Hi We have a DataStage server (7.5x2) with 2 projects; SysTest and UAT I have an issue where job performance is not consistent across these projects. Although job design, job sequencing, file sizes, directory structure - everything appears to be the same. I've confirmed the projects are setup the sa...