DSXchange

In the shared library search path; the set of directories specified by the LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH environment variable, depending upon your operating system. ... Yes, LD_LIBRARY_PATH works, thanks for that. I also need to set some environment vars: APT_CONFIG_FILE APT_ORCHHOME Any i...

How similar is "very similar"? Similar as in the logic is indentical, the only difference being the schema definition in the initial step (which is a complex flat file). The business problem is essentially reading in a series of flat files, performing some minor filters and transformation...

Hi all
To those of you who have problems compiling PX jobs under a Windows environment,you should request for a patch from IBM support as well as installing to right version of the C++ compiler.

The patch is in the form of a script that needs to be run.

Rgds
Chin

Chin, my observations have been quite different. Is your DB/2 a partitioned database? What sort of a config file do you have? Does the read speed correlate with the write speed? Hi ArndW, Thanks for the reply. currently the DB2 database has not been installed with DPF yet which we have requested th...

Hi Chuah, Presently, in your job config file is set for 4 nodes. But, your output database is set for single partition. Problem is your Dataset is created for 4 nodes and it is trying to load the data in a single node constraint partition database. To get out of this problem we can do one thing, ju...

Thanks Ray. Ok then.
Is there a way for Data Stage to automatically import an Orchestrate Schema file without going through DS Manager manually ?


Rgds,
Chin

Hi ,

Is it possible for MetaStage to import Orchestrate Schema Files directly without having to go through Data Stage ?
I would like to automate this through a script or command line if possible.

Rgds
Chin

Hi, I am trying to compare the performance of the DB2/EE stage against the DB2/UDB API Stage. In a read-only job, the DB2/UDB stage reads more than 50000 rows/sec whereas the EE stage could only manage 11000 rows/sec on the same database / table. Incidentally the speed of the EE stage is almost the ...

Hi, I have a simple job that loads to a DB2 database using the DB2/EE stage. When the job runs it aborts and the following error is shown: main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel DB_STG_CustCupe_ins_EE. The number of partit...

The BASIC Transformer stage in parallel jobs uses the BASIC run machine that used in Server jobs. Hence it need to be loaded when the parallel job is executed. But it gives you richness of the function set in BASIC. Do a search on "Basic Transformer", you ll find numerous post. Thanks for...

Hi,

Just want to sus out what the general opinion is of using BASIC Transformers in PX jobs, is it safe or advisable to use them ?
Does it cause instability in jobs and cause random crashing etc ?
Should I even consider using them or are they to be avoided at all cost?

Cheers
optimus

Hi, This is a new install of DS7.5x2 on a windows machine. All other stages compiled properly with the exception of jobs with a parallel Transformer stage. The error looks like this : ##I TOSH 000002 12:00:44(000) <main_program> orchgeneral: loaded ##I TOSH 000002 12:00:45(000) <main_program> orchso...

Well I do know there are less database plugins for PX than server but when we did the install we chose All Plugins so there should be more than just the Db2 stage in there. All the rest are greyed out.
Thanks.

Hi , I have just installed dS 7.5.2 on our test Windows 2003 server. All seems fine but I noticed that all the other database plugins for Parallel jobs are greyed out except for the DB2 plugin. In the server jobs I can see all the database plugins without any problems. How can I get the plugins to r...

Not so much "overhead of BASIC" as "overhead of translation into and out of BASIC (typeless) environment from the C++ (strongly typed)envionment". It is likely that this overhead will cause perceiv ... If I use the BASIC Transformer in my PX jobs ,does that mean then I'll lose t...