Question & Answer
Question
How to get details of the purged records such as which records, how many records, etc…?
Answer
How/Where to store details of the purged data:
Enable the checkbox “Write to Log File”
(Navigate to Document Specific > (Document Type) > Purge Criteria). The Purge
Agent writes details of the purged data to a log file, on enabling this
checkbox. One can then backup the log file and use it as a journal later.
Enter the log file name in the checkbox provided
(“Log File Name”). The Purge Agent then creates this log file in
the directory specified in the yfs.purge.path of the yfs.properties
file.
Query to get the number of
eligible records from the database for order purge:
For Order Purge transaction the pending
job count is the number of records available to be processed by the transaction
with the AVAILABLE_DATE value less than or equal to (<=) the current date value
in the YFS_TASK_Q table.</span></div> <div> </div>
<div>
SELECT COUNT (*) FROM YFS_TASK_Q
WHERE TRANSACTION_KEY='PURGE' AND AVAILABLE_DATE <= SYSDATE AND HOLD_FLAG <>
'Y' AND TASK_Q_KEY > '20091115143352426637' ORDER BY TRANSACTION_KEY,
TASK_Q_KEY, AVAILABLE_DATE;
Pass the
appropriate TASK_Q_KEY.
To determine
the rows:
Apart from using the query;
if LIVE mode is set as N (live=N; N->Test mode) in Order Purge criteria
parameters; then it determines the rows that will be moved to history tables
without actually moving them.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
HTG2685
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21563182