DSXchange

Hi All, I have strange situation in my project. In the DB2 Connector I enable: Enable partition reads. Then I choose Modulo and specify column. I have examples where the DB2 connector after such settings multiplies my data by 2. But I also have DB2 connectors where it doesn't multiply the data. What...

But for example i have sequence with 100 jobs and i would like to control which job is currently running and also i would like to log whole runtimes history. Is it possible to achieve it in Operations Console?

Regards

Hi,
I would like to log runtimes every my job.
I see this runtimes in Director directly but how can i get this information
to database or file?

Regards

Hi,
During opening Performance Analysis i receive an error window:
"Exception occured in loadPerformanceInfo(): Index and length must refer to a location within the string. Parameter name: length"

Regards

Yes,
I read but i still don't know how open this file Performance.XXXX ?
Could you help?
Performance Analysis expect .pdz files.

Hi, I executed a job with the environment variable - APT_PERFORMANCE_DATA & defined the performance directory. It has to produce performance file in that directory - performance.8788 How can i analyze this file? I thought that i can use Performance Analysis but it doesn't see this file. Could yo...

Hi,
Could you explain how to set up BULK-LOAD?
Need it some set up on server side and then on DB2 connector?

default

Hi, I wanted to use bulk-load method to insert data to DB2 database. I set the write mode to "Bulk load" and "Bulk load to DB2 on z/OS" set "YES". I have run job and received an error: The 'Bulk load to DB2 on z/OS' property must be 'Yes' when loading to a DB2 server on...

Hi,
Thanks for an explanations and advise.
I will inform you after my tests.
Regards

Hi, I made sort after filter and it decrease time of running job. Now I am planning to decrease columns in joins to use only needed and the rest i will send to the end of job usig copy. I also going to merge these two jobs in one job to avoid loading to dataset and then loading from dataset. I think...

Hi, Answers to questions: 1. Data is coming from other job which is ended by dataset 2. It is filtered by some date and the conditions are different, 3 and 4 steps are different ( my mistake i edited it in my post). 3. All joins are left outer joins 4. At the beginning this one sort take a lot of ti...

Hi,
Input is a dataset and goes to filter then build 3 other streams:
ALL ,AGG1 and AGG2.

Hi,
These keys are different:
AID,BID,CID,DID and so on.
Regards

Hi, My project looks like that: Input: 75 milions rows 150 columns ->Sort by ID ->Filter ->AGG Max(AID) grooup by ID (16 milions 2 columns) ->AGG2 MAx(AID) group by ID (16 milions 2 columns) ->ALL rows and Sort on other key AID (75 milions) -> Join AGG with ALL by AID -> Join AGG2 with ALL by AID ->...