Summary: In the defect DE62736, 'pg_terminate_backend' command was introduced which kills any lock held by any other user. Request from support was to add a logging mechanism so whenever 'pg_terminate_backend' was called it should write a log in a table which will help support to understand when 'pg_terminate_backend' was called during the DWH execution.
STEPS TO REPRODUCE:
Expected Results: Data Warehouse job should finish successfully by removing the locks held by other users and store the information in one of the tables.
Actual Results: Data Warehouse job finishes successfully by removing the locks held by other users but no logs on which PID was killed.
This is an enhancement request, resolved in 16.0.1.
The Process IDs are now logged in the DWH_CFG_GENERAL_MESSAGE table.
For more information regarding DE62736, reference the following article: