The JADE 2022 release meets tomorrow’s business demands.
Operationally we are unable to determine what function(s) the data pump is performing at any given time. This becomes a lot more important during the deployment process.
The JADE/user data pump performs several functions and these don't appear to be able to be identified programatically.
- replay to database/SQL server
- reorganization
- generating alter script (tableAlter script)
- executing alter script (tableAlter script)
- extracting tables
- loading tables (autoBulkInsert script)
Within each of these phases the success / failure of each cannot be discerned, except for extract of tables
(Process constants RPS_EXTRACT_FAILED_EVENT and RPS_EXTRACT_FINISHED_EVENT)
Also, it would be beneficial to be able to obtain the progress of potentially lengthy tasks like:
- reorganization
- extracting tables
- loading tables
or at least to be able to identify that this phase is still running.