Question
Verizon Wireless
US
Last activity: 21 Sep 2017 5:19 EDT
Do we need a separate schema for BIX in addition to PEGARULES and PEGADATA ?
Hi Team,
Do you recommend a separate schema to be created for BIX in addition to PegaRules and PegaData ?If it is a YES,please provide the reasons.
Regards,
Pradeep Pydi.
Pegasystems Inc.
US
The BIX tables needed are typically in the PegaDATA schema.
If you are extracting to a database then that could be in an entirely different database from where your PegaRules and PegaData schemas are.
Verizon Wireless
US
BIX PEGA OOTB tables pr_sys_queues_bix and pr_extract_time will be created in the Pega Data Schema.
We are extracting data to a database and you are recommending us to create a BIX schema in a different database or can it be in the same database ?
What happens if we create the BIX extract tables in the PegaData schema (Any specific reasons why we cant do this ?).
Regards,
Pradeep Pydi.
JPMorgan Chase & Company
US
Hi,
It is recommendation to create separate database for BIX extract tables, the business data is huge so keeping BIX tables in data schema might cause maintenance issues.
Verizon Wireless
US
sure.Thank you.
Could someone please comment about the memory and JVM requirements to be increased/maintained so as to accomodate BIX command line extraction process (I know it depends on the frequency of extractions and the load,but wanted to understand the recommendations to setup the right values to hold up the BIX volume).
Note : We are planning to run the BIX within the application running JVM itself instead of maintaining a separate Batch JVM.
Pegasystems Inc.
US
@Pradeep, you can have a look into How efficient is BIX and how will it impact the performance of my Process Commander applications? over here.
Verizon Wireless
US
Hi,
Clicking on the Hyper link takes me to https://community.pega.com/content-not-found.
Could you please copy paste the content to this post.
Thank you.
Pegasystems Inc.
US
@Pradeep - i couldn't notice that this piece of information is visible to only internal Pega employees, that is the reason you were not able to access it.
Pegasystems Inc.
US
Additionally, The best practice for maintaining high availability in a cluster is to dedicate a couple of nodes in the cluster to offline processing, such as for BIX and search indexing, and not have those nodes participate in end-user session load-balancing. This method minimizes the impact of agent processing on production performance for end-user sessions, which is explained over here.
Verizon Wireless
US
To be precise,you are saying that we need a dedicated node (Batch node) for BIX Command line extraction process, right ?
Pegasystems Inc.
US
Yes Pradeep, that is what the above documentation explains to achieve high availability in Pega in cluster environment.