Question

8
Replies
490
Views
Close popover
Shezad Mohammad (ShezadM8)
Oligos

Oligos
FR
ShezadM8 Member since 2016 7 posts
Oligos
Posted: January 17, 2019
Last activity: January 18, 2019
Closed

Bix Extract from Work History without using BLOB

Hi,

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 ?

Thanks.

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

System Administration
Moderation Team has archived post