DSXchange

Ray, When I verified with DBA, they say that the file is having read permission to everyone. I myself verified and found that it is having read permission to all. Also, the job runs successfully when it is rerun for the second time. So I am confused if it is an interface issue. If multiple processes...

Hi Whenever we try to run some jobs, they abend with the following message "The file `/db2home/sqllib/db2nodes.cfg' must exist and be readable by all users!" But on the second or third rerun, they complete successfully. This does not happen to all the jobs and not during all the runs but t...

Hi One of our jobs which is calling a shared container to generate a sequence number aborts frequently with the following warning and error messages. SCGenSeqNo.db2API_Max_Seq,0: Logging delayed metadata. SCGenSeqNo.db2API_Max_Seq,0: Requesting delayed metadata. SCGenSeqNo.db2API_Max_Seq,0: Failure ...

Ray,

So you mean to say that we need to repartition the table to make collocated. Or otherwise we need to create one more table which is partitioned on the required keys and then move all the records from the original table to this table and do a join. Am i right?

Hi Yogesh,

Check your metadata definitions in your job. Also since the number of records is just around 300-400, you can click view data in the stage and see if the columns are populated correctly in each of the records. I think this will help you.

Hi Prashanth,

This question does not need a separate post as you have ample number of posts in the same forum. Use the search in this forum and get enlightened

Hello Everyone, I have a question here. Say, we are having 2 huge tables (each having around 700 millions of records). One table is partitioned on column1 where as another table is partitioned on column2. Is it advisable to do a parallel extraction from a query that joins these two tables (which is ...

Hi Everyone, We have a requirement. we are extracting and processing data from DB2 database. After processing the records are to be fed into MQ as messages. The volume will be around 2-10 millions. Is there a workable solution for this in DataStage? Also is there anybody who has implemented this suc...

Hi Arnd,

Thank you very much for the info. This would be of great help to our project.

Hi We are having an after-job subroutine that creates the job run report in the needed format. In our project we are having nearly 100 jobs, few are independent and few are dependent on each other. The doubt I have is that all the jobs are accessing the same after-job subroutine to generate the repo...

Hi We tried to use the functions DSOpenProject, DSOpenJob and DSCloseJob in the basic routines but on compilation, it is returning the following error: Array 'DSOpenProject' never dimensioned. Array 'DSOpenJob' never dimensioned. Array 'DSCloseJob' never dimensioned. 3 Errors detected, No Object Cod...

Roy and Arnd, Thanks for your quick response! To be true, I never tried these DataStage in-built basic routines. I just want to know if these routines can give the details like type of the stage (Transformer, Sorter, Aggregator, etc) and stage-link relationships (like In_Trns is the input link and O...

Hi, In our project, we need to develop an ETL auditing process as a part of ensuring Data Quality. For that we need to develop an automated process (either an ETL job or routine) that captures all information about the jobs under our project. The information are to be stored separately in different ...

Hi We are getting a warning in our job when trying to validate. The warning is as below: JOIN_Records: When checking operator: User inserted sort "{natural="SORT_Guest:InTo_Join_Left.v", synthetic="buffer(0)"}" does not fulfill the sort requirements of the downstream op...

Hi If the join is an inner join, the condition we put in ON clause is equivalent to putting the same condition in WHERE clause but when the condition is left-outer join or right-outer join it differs based on the condition we give. Am I right? For example, if the SQL is like this, Select T1.* from t...