Question

8
Replies
537
Views
Shezad Mohammad (ShezadM8)
Oligos

Oligos
FR
ShezadM8 Member since 2016 7 posts
Oligos
Posted: January 17, 2019
Last activity: January 18, 2019
Posted: 17 Jan 2019 9:13 EST
Last activity: 18 Jan 2019 15:01 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.