DSXchange

You have posted potentially sensitive data, depending on your organization's security policy, such as your server's host name, your client's machine name, your user name, etc. Anyhow, the technote says to "update the certificates in WAS and then run UpdateSignercerts on all Information Server s...

Your job type says server but you mention the Copy stage. If it is actually a parallel job then you could run it on a different number of nodes to improve the extract performance. It still writes your text file sequentially.

There is one available on UNIX simply called zip, also known as Info-ZIP. The one I found was bundled with a database client, not bundled with UNIX. That one has a split on size option. The command would be "zip -s50m file" to compress the file into multiple compressed files no larger than...

The Multi-Client Manager allows you to select which DataStage client version is active on a given Windows desktop. It normally takes 3 to 5 minutes to switch back and forth between versions each time.

Request more Windows desktops from your Citrix admin.

This should shed some light on the problem... This has to do with the Char() function. It must have originally been coded to handle only 7-bit ASCII characters. When you give it a value outside that range, it defaults to using a space rather than aborting or warning. Try using what the product docum...

I guess I don't understand what you are asking. In the same run, the new customer can be present in more than one service providers, so can have more than one instance. When you generate a key for the first instance, and when the second comes in, you need to find his/her key in the dataset, or it wi...

I wonder if you may be missing a DB2 environment variable.

Did you query the table outside of DataStage to see what it looks like?

Perhaps you could remove duplicates prior to assigning surrogate keys.

I would guess that the answer to #1 is no, unless someone finds documentation or a sales rep that confirms otherwise. It's a guess though...

If you search IBM developerWorks there is a salesforce article from 2008 showing many PX screen shots, and parallel loading is one of the highlighted features.

I try looking up directly from a transfomer, Datastage states it's not allowd a cycle operation. I try it with sequential file, it's allowed, but look up returns nothing even a match is there. If you are doing a normal lookup, then it reads all the reference data into memory before processing the m...

Or ask a technical sales rep.

Applying patches should be considered as equivalent to upgrading versions. Always test in a lower environment before making the same change into an environment that matters more.

See also: viewtopic.php?t=153323

See also: viewtopic.php?t=153322

Post the entire job log with full details.