Difference between revisions of "Information Systems:Periodic-Purge"
Jump to navigation
Jump to search
m |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | We have some large |
+ | We have some large transaction 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, so 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. |
During month end processing, PURGE01 is called. |
||
| Line 23: | Line 23: | ||
Records over one year old (purdate2) |
Records over one year old (purdate2) |
||
| − | |||
| − | |||
'''PURGE04''' |
'''PURGE04''' |
||
| + | PURGE04B PLRFLGP |
||
| − | |||
| + | RFHR981 RFORFILG |
||
| + | RFORFCLG |
||
| + | RFORIDLG |
||
| + | RFORFPLG |
||
| + | CSBR869 SROOFL |
||
| + | EDSR401 SROEVMSG |
||
| + | SROEVMGL |
||
| + | SROEVMGR |
||
| + | SROEVHIS |
||
| + | ASGR045 SROPRM |
||
| + | DMR781 SROPUS |
||
| + | PURGE04C UROPAL |
||
| + | PURGE04D URORFB |
||
| + | PURGE04E UXSDOCP |
||
| + | PURGE04F WHOLTR |
||
| + | PURGE04G UZIVLIP |
||
| + | PURGE04I USOTSDPL |
||
| + | PURGE04J SROFFA |
||
| + | PURGE04K SROFFI |
||
Clear sales order copy files |
Clear sales order copy files |
||
purg04L |
purg04L |
||
| + | PURGE04C SROCSPRF |
||
| + | |||
| + | [[Category: I.T. Periodic Tasks]] |
||
Latest revision as of 10:29, 1 October 2018
We have some large transaction 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, so 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
PURGE04B PLRFLGP
RFHR981 RFORFILG
RFORFCLG
RFORIDLG
RFORFPLG
CSBR869 SROOFL
EDSR401 SROEVMSG
SROEVMGL
SROEVMGR
SROEVHIS
ASGR045 SROPRM
DMR781 SROPUS
PURGE04C UROPAL
PURGE04D URORFB
PURGE04E UXSDOCP
PURGE04F WHOLTR
PURGE04G UZIVLIP
PURGE04I USOTSDPL
PURGE04J SROFFA
PURGE04K SROFFI
Clear sales order copy files
purg04L PURGE04C SROCSPRF