DSXchange

My development server contains a user defined environmental variable CC_MSG_LEVEL which was by default set to 1. It caused me problem in some loading data so I set it to 0 and jobs are running fine. But my production server doesn't contain this variable. How to add this variable in that environment....

no... just my job performs join(where i get some id and timestamp based on keys)... followed by transformer where i separate records based on some value.... in that transformer... in 8.1v records are getting dropped for null timestamps... but in 8.5v records are moving to final dataset even the fiel...

No operation is performed on this data. Just move.

i have set the LEGACY NULL PROCESSING option as well as $APT_TRANSFORM_COMPILE_NULL_HANDLING, but the records are not dropping which is my requirement.

yes,

transformer drops it. No constraint.


I have set mentioned environmental variable to 'True' and ran the jobs. But i am getting the same result.

the legacy null processing option is checked by default. Is there anything else to look upon.

Hi, I performed inner join and inner join is expected to get match for all business keys from source. The join stage is followed by a transformer for some additional operations. If the invalid source records comes then matching ID will not be found in the join stage and record gets dropped in transf...

Issue Resolved. The job took time due to CC_MSG_LEVEL being enabled at project level. This generated huge logs in director and job was crashing for huge volume. Disbaled the env variable CC_MSG_LEVEL and Bulk load went on fly. Points to be noted for Bulk load: 1. Table should be partitioned 2. Non r...

Hi we are using DS 8.1 We able to execute bulk load using DB2 Connector only for less volume of records. It breaks when volume is huge. Bulk load also takes more time compared to Normal insert. I have set Non recoverable load to YES. Normal insert: 189K records: 3:44 mins Bulk load: 80K records: 1:1...