DSXchange

Have you re-booted after changing the environment variable? Often this is required on Windows systems.

Sometimes you just can't effect reusable design. What's the problem with not being able to?

You have simply been alerted by DB2 to the fact that you have selected 0 rows from a table.

It does seem thus. Do you have another project, and is the DS_STAGETYPES record empty there too? If not, you can use "UniVerse" commands to copy the record from one project to the other. Establish a file pointer with SET.FILE then use COPY. If you're using ED then I'm guessing you're famil...

Vertical pivot then combine the non-key columns into one pipe-delimited column.

Two things spring immediately to mind. The obvious one is to run on bigger hardware. The other one is to store your data already sorted in Data Sets where, among other things, sort order is preserved. Insert explicit Sort stages on the inputs to the Join stage so as to assert "don't sort (previ...

Verify that the port numbers used at your site for JobMonApp are open in the firewall and not bound to some other process.

Is the number of comma-delimited fields, including the empty ones, constant for all records? If so, import the table definition for the sequential file and use that in your job design. If not, life gets slightly more complex for you - you'll need to read the entire line as a single string and parse ...

Add environment variable APT_DISABLE_COMBINATION to the job as a job parameter and set it to False.

Operator combination can be disabled in any parallel stage, but the approach described above is the quickest for your purposes, and more easily reversed subsequently.

Yes. Essentially, the pertinent parts of the dimension table are cached in memory.

Let me counsel you to avoid 8.0.1. It's very buggy. Get 8.1 or even 8.5. Version 8.0 mandates the "ade" shared memory key. Therefore you will need to change the shared memory key that your 7.5 installation uses - there are scripts for accomplishing this. I believe that version 8.5 may be m...

Get in touch with your official support provider, or search IBM Fix Central, to see whether this is a known issue and, if so, whether a patch exists for it. Does it occur on everyone's client or just on yours?

1. You probably don't need test environments for IA, but you might consider having a production environment for IA separate from development, so that you can use baseline and checkpoint analyses to monitor data quality over time in the production database(s). 1. You probably do need the full softwar...

Disable operator combination to determine where the error actually is, then we may be able to assist.

Set DB2INSTANCE environment variable.