Originally posted by: SystemAdmin

Hello all, I am trying to do some performance testing using one odbc connection as a source with an MDQ file and want to control the burst size of the source from a command file (batch file.) so we can performance test...

Is there an override for burst on the command line?

Thanks,
Kris
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi Kris,

There is a command line option for changing the fetch unit. The syntax would be:

mercnt <mapname> -ID1UFx .

x represents the fetch unit. The important part here is there is a space between the value of x and the dot

For example

mercnt mymap.mmc -ID1UF3 .

says burst using a fetch unit of 3.

The U tells the engine to bUrst, and the Fx defines the fetch unit.
The . represents not changing the arguments to the adapter (in this case odbc).

Hope that helps.
-Lew
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks Lew this really helped!
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

I don't find the -UFx . documented anywhere. Is it documented? Is this option also available for the File adapter?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi Jim,

It's part of the -I option. To do this with input 1 for a file for example, you would use

dstx <mapname> -IF1UF5 <filename>

to burst in fetch units of 5 for example. The digit on the right of the F is the card number, the digit to the right of the F is the fetch unit. <filename> is after a space of the command and is the name of the input file. You can use a . (period) to use the name of the file compile into the map. If you have a prior version than 7.5, replace dstx with mercnt (or mercator if on unix).

Off hand, I believe it's been around since 6.0, but was undocumented until the last few releases. It would be in the "Execution Commands" help.

-Hope this helps
-lew
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Thanks, Lewis. I don't know what you consider a release but it's not documented in the online 7.5 Execution Commands Reference Guide or in the 6.7 Help screens as far as I can see.

I guess I assumed the option was always available but I hadn't used it. Now I'm writing a utility to perform iterative map executions for performance tuning purposes and I have to have it. I was worried my work so far was for nought.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender