Information Systems:Periodic-Purge - Revision history

Norwinu at 17:29, 1 October 2018

2018-10-01T17:29:45Z

New page

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

[[Category: I.T. Periodic Tasks]]

Sheilav at 01:03, 1 March 2016

2016-03-01T01:03:06Z

Sheilav at 00:06, 1 March 2016

2016-03-01T00:06:08Z

Sheilav: 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..."

2016-02-29T23:41:19Z

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..."

New page

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.

PURGE05

@@ 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 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.
@@ Line 23: / Line 23: @@
 Records over one year old (purdate2)
  '''PURGE04'''
 Clear sales order copy files
  purg04L

← Older revision		Revision as of 00:06, 1 March 2016
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