DSXchange

To Eric: Yep, DB2 allows inserting to a view under some conditions. Better yet the SQL optimizer will determine which underlying table is the target by looking at the predefined table column constraint, and therefore is able to prune the DML. This is a typical technique in DB2 to implement something...

We have implemented pseudo range-partitioning in DB2 with UNION ALL views across multiple tables each capturing transactions of different months. To make the ETL job less dependent on the underlying range-partitioning scheme, we wanted to insert records directly into the UNION ALL view using a DB2 E...

Is there any systematic way to estimate the memory usage requirement of a particular DS Job?

Thanks.

We are facing memory contention problems. With SVMON we have identified the exact system processes that are eating up gigabytes of memories (which is not expected in our development memory with very little data). With the UNIX process ID (PID), is there any way to track exactly to which DataStage Jo...

It seems to me the performance is much more affected by the number of fields being passed in links (in our case > 40) as opposed to the number of stages. We had some jobs with many stages but only processing a few number of fields (<8) and they seem to compile reasonably fast. Having said that we st...

It has occured a number of times that my column generator logics (e.g. cycle, initial=0, increment=1....etc) have been removed automatically. This happens a number of times in vairous jobs, and there is no sign of this happening until we found out when the job failed in runtime. Has anyone had simil...

My DataStage installation seems to have problem dealing with Timestamp datatype with DB2. I have a simple testing job with a DB2 Enterprise Stage selecting a single timestamp column, and output to a sequential file. The job failed during execution with error "main_program: Fatal Error: Invalid ...

The compilation of my job is taking almost 4 mins to complete and this is becoming intolerable. A typical job has around 30 stages in total including those within containers. It has 1 transformer stage and others are simply Lookup's DB2 Enterprise Stages and etc. I notice that while the job is compi...