DSXchange

I think parallel jobs are only availabe on UNIX, not Windows.

Vasu,

Are you absolutely certain that the DB2 Wire Protocol works with ***PX*** 7.0? I believe that previous versions of PX did not use the uvodbc.config or .odbc.ini.

BP

I thought there was a PX-specific FTP stage that can take care of this problem. You may want to contact your DS rep and ask for the Parallel FTP stage. It might not be offered in the standard release, but Ascential's engineering/professional services might be able to find it.

- BP

Actually, once I tried to run the same PX job twice from one sequencer, and it just wouldn't work. I had to click on the 'Allow multiple instances' checkbox to run the many instances of the same PX job from one sequencer in 6x. This might have changed for 7x.

- BP

Although I have never seen that error message before, your PX scripts might be suffering from the automatic insertion of hashes and sorts that happens in PX 6+. Check on the PX Forum for a discussion about this feature.

-BP

Another option is to use an outside UNIX script to pick out the ID and generate an Orchestrate Schema File prior to record processing. Orchestrate schema files are PX-specific metadata files that specify record- and field- related layout and type properties. Schema files can be imported into DataSta...

It's a job property, I believe. Click on the bright yellow icon with little black squares in it, and 'Allow Multiple Instances' should be an checkbox on the popup Job Properties dialogue box.

- BP

I'm trying to use a sequencer stage - the execute command stage to call script that has a sqlldr command in it. When I run the the script from the UNIX commandline, it works fine. When I run the script from the Execute Command stage, I get the error below. So, I thought there might be a discrepancy ...

Just to point out: PX lookups are only performant if the lookup table fits comfortably into memory. On SMPs, use the 'entire' partition on your lookup to generate one copy of the table that is entirely shared in memory with all paritions. On MPPs, create a partitioned (typically hashed) to create pa...

No, I still have not gotten the new vmdsrpos.dll, so I am still having the same problem. If the new dll fixes the problem, I'll let you know when I get it.

Thanks to all for your suggestions.

Kiran, I just want to make sure I understand completely the problem completely. 1. Is the OS swap space pointing to /tmp? 2. How are you monitoring /tmp and swap usage? 3. Is the box quiet except for PX? 4. Can you do a 'ulimit -a' on your Solaris box and give us the results? I like to use the top u...

Sometimes, swap space is allocated out of /tmp space, and swapping and /tmp files can compete for the same disk resources. Fork might be failing b/c it's running out of swap space in /tmp. Nothing in your config file should ever point to /tmp. Point your scratch/datasets to a different directory, an...

Amdahl's law, a heuristic for determining "speedup", is below and can be generally used to 'fit' your PX job to your machine. Amdahl's law: If F is the fraction of a calculation that is sequential, and (1-F) is the fraction that can be parallelised, then the maximum speedup that can be ach...

Don't let this scare you from upgrading to 7.0.. DS Server 7.0 is working fine otherwise..

- BP

DataStage Server Edition 7.0 on Windows XP ---------------------------------- Hello. I am having a problem with the "View Data" function on the Oracle9i stage in DataStage Server Edition 7.0. When I click on it, no data comes up even if its SQL query runs fine in SQLplus. Not only does it ...