DSXchange

I was going through the Deploying Grid solution with Infosphere Information Server Redbook where a section describes the usage of sequencer.sh script to be run from within the sequence to create dynamic configuration file and use the same for jobs downstream. The individual jobs however have differe...

A job with DB2 connector stage is failing with the beloww error CC_DB2DBStatement::rejectRowAt, file CC_DB2DBStatement.cpp, line 2,795 I ran the below command to take a look into the .cpp file metioned in the log from within the Project directory find ./ -name CC_DB2DBStatement.cpp Astonishingly not...

We were using DB2 UDB enterprise stage with Datastage 8.0 which reads the db2nodes.cfg file under the instance home directory to identify the db2 nodes for direct communication and requires ssh set up over the db2 nodes and datastage engine for password less communication. We now moved to Datastage ...

We migrated from Datastage 8.0 to DataStage 8.5 on grid environment that uses IBM Tivoli Workload Scheduler LoadLeveler for creating dynamic configuration file. Is there any documentation that describes how to set up IBM Tivoli Workload Scheduler LoadLeveler with Infosphere Information server on AIX...

Looks like its time to talk to IBM support

I did face import/compile issue when we migrated from 7.5 to 8.1 and when raised an incident with IBM support they took a look and gave a patch which had set things right

I was going through the documentation of aggregator stage and wondering what data structure is used to hold data in the heap.

Thanks

First point - Auto will always yield correct results (though it may not perform optimally). I recall an instance where I had multiple (20) join stages running on 2 nodes in V7.5 and while testing I came across data discrepancy and reran on single node which updated my data correctly, didn't have ti...

Also I have one more question. The checkpointing happens for each activity (configured to be checkpointed) of the sequence marking failure or success and on restart it checks the failure/success stuats in the checkpoint record to identify which activities have to be rerun. OR Only those activities t...

Consider the below sequeence Routine A -----> Job A ------ Job B The trigger of routine is unconditional and I am passing a timestamp as return value which goes as parameter in job A and job B. Job A and Job B have failure triggers which run AbortToLog routine that aborts the sequence if any of the ...

The routine return value is not stored. It does, however, trigger a Failure if its value is not zero. If the return value is not stored then in a checkpointed sequence if the routine runs fine but a job following the routine that reads a parameter from routine return value fails, on restartable rer...

I have a checkpointed sequence which contains a routine that passes its return value to a jobs parameter. The sequence has failed but I was wondering in which of the RT_XXXX hashed files the routines return value is stored. Could anyone please let me know from which hashed file and record id the rou...

Two engines on same database and different schemas ? or two different databases in same instance ?

The last time i was trying to install 8.5, it was asking for a fresh database.

Arithmetic operations on varchars is not right approach. convert them into integers using AsInteger() and even before that, check if they can be converted into integers using num() .

I hope to see this facility added in upcoming releases

Also the jobs which have too many parametes when used in sequences need each parameter to be mapped to one of the sequence parameters, wish there was auto name match facility.

I have a sequence which uses a parameter set and calls multiple jobs which again contain multiple parameter sets, in the job page of Job activity the parameter set appears as single entity and asks for values file but I need to map specific parameters of parameter set in the job activity to specific...