ShezadM8 Member since 2016 6 posts
Sopra Steria
Posted: 1 year ago
Last activity: 1 year 9 months ago

Bix Extract from Work History without using BLOB


I need to perform a BIX extract from the workhistory table that contains 100 millions lines. (After an initial extraction, we'll use the PEGA Purge tool to reduce the amount of data in the database, but we need an extraction first)

The property needed are :

  • pxAddedByID
  • pxTimeCreated
  • pyMessageKey
  • pyPerformer

All that properties are exposed so use of BLOB is not necessary.

However, PEGA keep using pzPVStream while extracting and that take too much time.

We use PEGA 7.1.9. is it possible to force PEGA to not use that BLOB column or to delete the BLOB column in order to perform a faster BIX extraction ?

If we only have exposed column to extract, is it usefull to use BIX or not ?


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

System Administration
Moderation Team has archived post
Share this page LinkedIn