Difference between revisions of "Information Systems:Periodic-Purge"
Jump to navigation
Jump to search
(Created page with "We have some large transactions files; as of February 2016 SROLOGGL (G/L Transactions log) is over 100 million records. At one point, we were starting to get tight on disk sp...") |
|||
| Line 1: | Line 1: | ||
We have some large transactions files; as of February 2016 SROLOGGL (G/L Transactions log) is over 100 million records. At one point, we were starting to get tight on disk space, we we starting purging older records from some files. However, not transaction files; we wanted to retain the ability to rebuild a balance file by summarizing transactions. |
We have some large transactions files; as of February 2016 SROLOGGL (G/L Transactions log) is over 100 million records. At one point, we were starting to get tight on disk space, we we starting purging older records from some files. However, not transaction files; we wanted to retain the ability to rebuild a balance file by summarizing transactions. |
||
| + | During month end processing, PURGE01 is called. |
||
| + | Records over two month old (purdate3) |
||
| + | '''PURGE02''' deletes members from POBACKP |
||
| + | '''PURGE06''' calls USDR881 to delete records from USODFLG |
||
| + | Records over six month old (purdate1) |
||
| − | PURGE05 |
||
| + | |||
| + | '''PURGE03''' |
||
| + | PURGE03A ECUCHPP |
||
| + | PURGE03B ECUIBPP |
||
| + | PURGE03C ECUIBAP |
||
| + | PURGE03D ECUOMDP |
||
| + | PURGE03E ECUCHGP |
||
| + | PURGE03F IMPLINP |
||
| + | PURGE03G IMSLINP |
||
| + | IMSXHDP |
||
| + | PURGE03H OMSLINP |
||
| + | PURGE03I IOPEXTP |
||
| + | |||
| + | Records over one year old (purdate2) |
||
| + | |||
| + | |||
| + | |||
| + | '''PURGE04''' |
||
| + | |||
| + | |||
| + | Clear sales order copy files |
||
| + | |||
| + | purg04L |
||
Revision as of 17:06, 29 February 2016
We have some large transactions files; as of February 2016 SROLOGGL (G/L Transactions log) is over 100 million records. At one point, we were starting to get tight on disk space, we we starting purging older records from some files. However, not transaction files; we wanted to retain the ability to rebuild a balance file by summarizing transactions.
During month end processing, PURGE01 is called.
Records over two month old (purdate3)
PURGE02 deletes members from POBACKP PURGE06 calls USDR881 to delete records from USODFLG
Records over six month old (purdate1)
PURGE03
PURGE03A ECUCHPP
PURGE03B ECUIBPP
PURGE03C ECUIBAP
PURGE03D ECUOMDP
PURGE03E ECUCHGP
PURGE03F IMPLINP
PURGE03G IMSLINP
IMSXHDP
PURGE03H OMSLINP
PURGE03I IOPEXTP
Records over one year old (purdate2)
PURGE04
Clear sales order copy files
purg04L