DSXchange

You state that you've made changes to your startup.apt file. I would like to point out a passage in your error statement: ##I IIS-DSEE-TFPM-00181 22:15:12(005) <main_program> A startup script is not being used. If you're settings in startup.apt is important for your current runtime enviroment then i...

I tried APT_DB2LOADER_DEBUG Environemental variable to debug db2load operator. If APT_DB2LOADER_DEBUG is set, db2load would pipe data into a on disk rather than to a database. I didn't provide me with the load command statement, it did however give me some column and load file info. As stated it als...

I have tried APT_DEBUG_DB2=True I gives me alot of great information, sadly not the command itself. I havn't tried APT_DB2LOADER_DEBUG=True The documentation states the following APT_DB2LOADER_DEBUG Environemental variable to debug db2load operator. If APT_DB2LOADER_DEBUG is set, db2load would pipe ...

Hi, I am using datastage 7.5.2 on AIX with DB2 9.1 DPF (MPP) also on AIX. We are using db2 enterprise stage to load data in parallell to each dpf node respectively. Sometimes a load on one node fails and the table ends up in a strange state. Pending on one node but ok on the other. The consequense o...

Ok, cross-platform is in general not an issue even if your database is on another plattform than your datastage installation, regardless of your db installation, SMP,MPP,DPF etc. However there is a "special" feature in datastage enterprise edition in combination with DB2 DPF (eg DB2s MPP s...

If you use the DB2 enterprise stage properly it will ask the database how data is spread over the 12 partitions (eg partition key) and if that key is present in your in/out stream it will start as many processes as there are data nodes (12 if your data is spread over all partititions. Your tablespac...

In the DB-enterprise stage using for example MODE = Write Create, you get a option called DB Options within which you can specify tabelspace amongst other (however missing a whole lot of options available in regular DDL) Type: String Specify an optional table space or partitioning keys to be used by...

Depends on which database (stage) and read method you are using. If you're not reading data from each database partition(node) your data will be returned on a single node and thereby your dataset will remain as a single node when using SAME partitioning. Using DB2EE-stage for example and read method...

First, I would recommend you to sort using the sort-stage since it enables alot of additional features, such as tuning memory etc. Regarding your sort warning it could be that the 2 input links are different on the input tab. If not please check what datatypes are in your partitioning columns and if...

Could you please supply the drop warning written to your job log?

What read method and what write method are you using? have you imported the table definitions into datastage? And if so using what importer?

What is it that you wish to do?

Stefan,
Do you know if I can make that happen in any manner short of running the installer and installing the engine layer? Perhaps by simply copying the PX runtime library from the ETL server?

As Ray described....

Maybe your field in the database is not just one character after all. Try a SQL on that table with HEX(colname) to see if it is already padded before datastage fetches it.

On 7.5 the PX engine is not required to be installed on each db2 node, however the PX runtime library must be accessable on each node.