Question
ING Bank NV
NL
Last activity: 9 Sep 2024 11:42 EDT
Disable UDF in Pega post installation
Hi, we have UDF installed in pega 8.8.2 on prem environment in oracle database.
We would like to disable the same,
Could you please share the steps / runbook that needs to be followed to disable UDF post installation.
Pegasystems Inc.
GB
To disable UDFs in your Pega 8.8.2 on prem environment with an Oracle database you can follow these steps: 1. Review the necessity of UDFs: Before proceeding ensure that disabling UDFs will not impact your current application functionalities. Pega has deprecated the usage of Java UDFs due to their severe performance impact and does not recommend their installation for on premises deployments. 2. Remove UDFs from the database: You can manually remove the UDFs by executing the following SQL commands in your Oracle database: ```sql DROP FUNCTION data schema name.pr read from stream DROP FUNCTION data schema name.pr read decimal from stream DROP FUNCTION data schema name.pr read int from stream ``` Replace `data schema name` with the actual schema name used in your Pega database. 3. Update configuration files: Ensure that the UDF generation is bypassed in your configuration files to prevent them from being reinstalled in future updates or installations. Set the following properties in your `setupDatabase.properties` file: ``` bypass.udf.generation true ``` This will bypass the generation and installation of UDFs during database setup. 4. Verify the changes: After making these changes verify that your Pega application is functioning correctly without the UDFs. Monitor the application for any issues related to data retrieval or performance. By following these steps you can successfully disable UDFs in your Pega 8.8.2 on prem environment with an Oracle database.
To disable UDFs in your Pega 8.8.2 on prem environment with an Oracle database you can follow these steps: 1. Review the necessity of UDFs: Before proceeding ensure that disabling UDFs will not impact your current application functionalities. Pega has deprecated the usage of Java UDFs due to their severe performance impact and does not recommend their installation for on premises deployments. 2. Remove UDFs from the database: You can manually remove the UDFs by executing the following SQL commands in your Oracle database: ```sql DROP FUNCTION data schema name.pr read from stream DROP FUNCTION data schema name.pr read decimal from stream DROP FUNCTION data schema name.pr read int from stream ``` Replace `data schema name` with the actual schema name used in your Pega database. 3. Update configuration files: Ensure that the UDF generation is bypassed in your configuration files to prevent them from being reinstalled in future updates or installations. Set the following properties in your `setupDatabase.properties` file: ``` bypass.udf.generation true ``` This will bypass the generation and installation of UDFs during database setup. 4. Verify the changes: After making these changes verify that your Pega application is functioning correctly without the UDFs. Monitor the application for any issues related to data retrieval or performance. By following these steps you can successfully disable UDFs in your Pega 8.8.2 on prem environment with an Oracle database.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Manually installing or re-installing Java UDFs
Post upgrade to Pega8.8.1 we are facing user-defined functions (UDF) Issue