Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Saurabh Gupta (SaurabhG2392)
Accenture

Accenture
US
SaurabhG2392 Member since 2013 24 posts
Accenture
Posted: Jun 19, 2018
Last activity: Jun 20, 2018
Posted: 19 Jun 2018 13:04 EDT
Last activity: 20 Jun 2018 0:03 EDT
Closed

BIX Batch size

We are calling Exract rule through activity Rule-Admin-Extract. pxExtractDataWithArgs. This runs in a batch of 30 records from PRPC database and our BIX rule is configured to run as Database schema.

Where is the number of records configured that it picks in one batch and how can we change it?

Example:

2018-06-16 15:22:46,840 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - Target database using batch inserts
2018-06-16 15:22:47,529 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - # Instances Retrieved till this batch: 30 -- 00.20% Complete - Last Id Processed in this Batch Execution: I-30
2018-06-16 15:22:47,670 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - # Instances Retrieved till this batch: 60 -- 00.40% Complete - Last Id Processed in this Batch Execution: I-60

***Edited by Moderator Marissa to update platform capability tags***

To see attachments, please log in.
Data Integration
System Administration

Posted: 6 years ago
Posted: 20 Jun 2018 0:03 EDT
Raju Botu (Raju Botu)
Aaseya IT Solutions
AVP
Aaseya IT Solutions
IN
You can use the command line argument "-b" to change it Set pyArgs before you are invoking the pxExtractDataWithArgs Param.pyArgs = "-b 50" -b Specify the batch size (the number of extracted class instances) for commits to a relational database. This option only applies to databases with JDBC drivers that support batch updates. Note: This option is not available when running an Extract rule on the cloud.
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice