DSXchange

Do you mean improper partitioning in the Change capture stage? I used "Hash partitioning" for before and after links. If I rerun the job can finish successfully or fail with deadlock message. That happens once a week and it is difficult to catch. I have no time and I should promote the job...

Hi Everyone, I have a problem with deadlock in DB2 database (z/OS). ETL job consists of 4 DB2 connectors and change capture stage. The table contains about 1,5 million records. Updated, inserted and deleted records are about 150 thousand. The job performs commit after 100 records. The table is not u...

Maybe try wrapping the SQL query into a database view and import that view via the import > table definitions > odbc table definitions option in the DS Client? I thought about it but I have no access to create and delete views directly and it's slow. ... and Information Server metadata importers ha...

You need to import table definitions from the tables accessed by the query. There is no mechanism for importing from the query itself; it contains no other useful metadata than the column names (and e ... Thanks. Maybe you know Netezza and DB2 tools help to describe data type from a SQL query? For ...

Hi,

I have a SQL query. The SQL query consists of several types of join operations and tables. I need to import table definitions from the SQL query, for example, for Netezza connector and DB2 connector. Is it possible?

You are right, %CPU increases from 1% to 28% but the loading time is not long.
running

finished


truncate

truncate


change capture stage (read, insert and delete)

chulett wrote:But if that is working for you without 'impacts on performance' then yay.

The SQL query returns about 60 000 rows and the change capture stage don't impact on performance in this case.

Once the query has executed - how long is it taking for data transfer? If all you are after is not having the table empty for so long, is it silly to ask if your query is optimised? The original SQL executed for minimum 20 minutes and I optimized it and now it executes for minimum 10 minutes. But i...

I think that it is impossible too. But I know one way but it impacts on performance. That is to use Change Capture stage and create 4 additional DB2 connector stage(READ, INSERT, UPDATE, DELETE) and Transformer stage. I will be forced to use them. Maybe you know another way?

Hi, I have a issue. SQL query performs for a long time from DB2 Connector stage and the target table is truncated before data extraction. During this time the target table is empty. How to prevent truncating the target table before data extraction from source table by using only one parallel job? Th...