Originally posted by: SaikatMuhuri

Hi,

My map's input card was in INTRGRAL mode and I was able to process 100K instructions by one batch map but when I switched on the BURST mode it started failing with -804 for high volume instructions with burst count as 20. I ran the same batch with burst count 20000 and it was successful. My understanding is that map is failing if number of instruction in batch is greater than the burst count because when it is trying to fetch second time then it is failing with -804(problem in Prepare statement). I am using the map with Z-OS in mainframe and source as database in input card setting.Please advise if we can use small burst count but can process large messages without -804.

Regards,
Saikat
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: karthikpc

Hi Saikat,

How the FetchUnit is interpreted depends on what the adapter's capabilities are. For database adapters, an input query represents one transactional unit that can be divided into rows by the adapter. In this case, the *FetchUnit is the maximum number of rows*(s) to retrieve from the database for a given burst( this becomes integral mode indirectly - which means fetch everything from the source at one go into buffer).

If the source adapter can only retrieve ONE TRANSACTIONAL UNIT of data, then the Scope is limited to MAP

If the the source adapter can retrieve MULTIPLE TRANSACTIONAL UNIT of data, the source Scope can be Map, Burst or Card.example : file or MQ adapters

So in your case, Database adapter can only retrieve one transactional unit of data. so you can not have burst in your case. Or in other words Database adapter does not support burst on z/os.
cheers,
karthik
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender