Hi Prasad,
when this are 2 schema on the same DB just point the entries to the live schema:
update OPERATION_PARAMETER set PARAMETER_VALUE = '<IS-Schema>' where PARAMETER_CD = 'PROCESS_SCHEMA';
update OPERATION_PARAMETER set PARAMETER_VALUE = '<IS-Schema>' where PARAMETER_CD = 'ISCORE_SCHEMA';
where IS-Schema is the live schema.
Remeber to commit these changes.
When the archive schema is on a different database you will find according entries with name ending in âLINKâ these need to point to the live db server then.
See appendix in Monitor Users Guide as you need to grant SELECT and DELETE rights in the live schema to the archive schema user.
grant SELECT, DELETE on PRA_ERROR to ARCHIVE20601; -- vormals WMERROR
grant SELECT, DELETE on PRA_PROCESS to ARCHIVE20601; -- vormals WMPROCESS
grant SELECT, DELETE on PRA_PROCESS_ACTION to ARCHIVE20601;
grant SELECT, DELETE on PRA_PROCESS_CUSTOM to ARCHIVE20601; -- vormals WMPROCESSASSOC
grant SELECT, DELETE on PRA_PROCESS_RECENT to ARCHIVE20601; -- vormals WMPROCESSRECENT
grant SELECT, DELETE on PRA_PROCESS_STEP to ARCHIVE20601; -- vormals WMPROCESSSTEP
grant SELECT, DELETE on PRA_PROCESS_STEP_LOOP to ARCHIVE20601; -- vormals WMPROCESSSTEPLOOP
grant SELECT, DELETE on PRA_STEP_LOGGED_FIELD to ARCHIVE20601; -- vormals WMCUSTOMPROCESSDATA
grant SELECT, DELETE on PRA_STEP_LOOP_LOGGED_FIELD to ARCHIVE20601; -- vormals WMCUSTOMLOOPDATA
grant SELECT, DELETE on PRA_STEP_MESSAGE to ARCHIVE20601;
grant SELECT, DELETE on PRA_STEP_TRANSITION to ARCHIVE20601; -- vormals WMPROCESSTRANSITION
grant SELECT, DELETE on WMCONTROL to ARCHIVE20601;
grant SELECT, DELETE on WMCUSTOMFIELDDEFINITION to ARCHIVE20601;
grant SELECT, DELETE on WMDOCUMENT to ARCHIVE20601;
grant SELECT, DELETE on WMERROR to ARCHIVE20601;
grant SELECT, DELETE on WMPROCESSDEFINITION to ARCHIVE20601;
grant SELECT, DELETE on WMPROCESSIMAGE to ARCHIVE20601;
grant SELECT, DELETE on WMPROCESSTASK to ARCHIVE20601;
grant SELECT, DELETE on WMPROCESSTASKSTEP to ARCHIVE20601;
grant SELECT, DELETE on WMPROCESSTASKUSER to ARCHIVE20601;
grant SELECT, DELETE on WMSECURITY to ARCHIVE20601;
grant SELECT, DELETE on WMSERVICE to ARCHIVE20601;
grant SELECT, DELETE on WMSERVICEACTIVITYLOG to ARCHIVE20601;
grant SELECT, DELETE on WMSERVICEASSOC to ARCHIVE20601;
grant SELECT, DELETE on WMSERVICECUSTOMFLDS to ARCHIVE20601;
grant SELECT, DELETE on WMSERVICE_MIN_MAX to ARCHIVE20601;
grant SELECT, DELETE on WMSESSION to ARCHIVE20601;
grant SELECT, DELETE on WMSTEPDEFINITION to ARCHIVE20601;
grant SELECT, DELETE on WMSTEPTRANSITIONDEFINITION to ARCHIVE20601;
grant SELECT, DELETE on WMTXIN to ARCHIVE20601;
grant SELECT, DELETE on WMTXOUT to ARCHIVE20601;
When only using IS Auditing and not ProcessAuditing you can shorten this list.
Replace ARCHIVE20601 with your archive schema user.
After this is set up you can invoke the archving services to clean your tables.