I need to read data from 4 tables , each hosted at 4 separate DB's. I want this to happen parallely ?? 1. Should i create 4 DB connections for ech DB and then run 4 separate jobs ? Bad option!! 2. Does context help me somewhere.
It would be good if i can have just one job and configure it to run for different DB connections parallely??
Vaiko: "If you like to have maximum parallelism in Java: build you job for one data source. Put the db configuration into a context and execute the java cmd with the different contexts 4 times. This should rarely be necessary, I think."
How can i Execute a job with different contexts 4 times ? using something like tContextLoad ??? but each context wud be loaded one by one , and then the job will be sequential for each context .... wud'nt it be ?
better would be , to create 4 jobs , each accessing a different DB(each table in the different DB's have a similar schema) , and then make them run parallely ?
Link you can use as entry point for other posts about the 3864
You can export a job and run it from the command line. If you check the option the export will automatically create the batch file. You need to edit the batch file to include: --context_param xxx=yyy
xxx is the context variable
yyy is the new value
Excample:
java -Xms256M -Xmx1024M -cp ../lib/systemRoutines.jar;../lib/userRoutines.jar;.;myfirstjob.jar;../lib; test.myfirstjob.MyFirstJob --context=Default --context_param fileName1=adsfakf --context_param fileName2=sljdafslhf
If you defined you connection parameter in a contexts variables you can set them at runtime.
How you call multiple times the batch parallel depends on your operating system.
its like this : image attached my tmysql_input 1 is to be changed . I have 4 DB's from which input shud be read parallely.... All the rest mysql inputs and outputs are same. So its like , the context is not specific to a job but just a DB.... how can i do this , such that input can be taken from all the DB's and 4 instances of the same job run parallely????
