From InfoSphere InformationServer 9.1.2 onwards when a job is optimized using InfoSphere Balanced Optimization by default we get JDBC Connector either at source or target after optimization. If JAQL Connector is required as optimized job then user need to tweak gandalf.properties file. Based on the configuration settings a user has, optimized job is executed on JDBC Connector and MapReduce Connector environment.
Let’s say we have job by name BDFSTest01 as given in Figure 1.
Figure 1: Sample job
When we optimize the job we get JDBC Connector after optimization as shown in Figure2
Figure 2: Optimized job
If a user environment is configured to JAQL and would like to see MapReduce/JAQL Connector instead of JDBC Connector then user need to tweak an entry in “gandalf.properfies”
Let’s see How?
InfoSphere Balanced Optimization is a client side tool. So open windows explorer on your client machine and if InfoSphere DataStage Client is installed with Administrator user then go to location
For example you will see location as given below
Open “gandalf.properties” in any editor and you will see entries as shown below figures 3 and 4.
Figure 3: Location of “gandalf.properties”
Figure 4: Default entries in "gandalf.properties"
Modify entry jaql.dialect=BIGSQL_JAQL to jaql.dialect=JAQL_JAQL. Then optimize the job again to get MapReduce/JAQL Connector as shown in Figure 5
Note: No restart of Designer required after modifying “gandalf.properties”
Figure 5: Optimized job with MapReduce Connector