Cleaning up workunits and reclaiming tablespace

Hello,

We have been working no cleaning up our old workunits and starting to regularly purge logs etc.

Trying to determine where this data is stored in the DB (schema and tables) to get some before and after statistics on the data and to help our DBA's on what they can reclaim tablespace wise.

We are On-Prem and on Oracle. 10.x Lawson

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

cleverly

In theory your schema could be whatever your DBAs chose when you first installed Landmark On Prem. We were On Prem v10 with Microsoft SQL Server (as opposed to Oracle). Our schema was named "ipaprod" (again, if that matches yours it is only by coincidence). However, the tables related to workunits all begin with PFIWORK% and (at least on SQL Server) S$PFI% for the corresponding CLOB/BLOB storage.

lrjurgen

I've got the Schema's, we have Contracts in one and normal Lawson in one (ours are IPA and LMCM) . But there are a LOT of PFI tables, just trying to narrow down where the blobs are stored to get an idea of what we've saved.

I did find a bunch of S$ tables, such as S$PFIAT, S$PFICP, some empty and some with HUGECLOB's so guessing I'm getting close.

cleverly

Going off of the "prefix is Pfi..." in the busclass business logic LPL I believe these are the mappings:

S$PFIAC = PfiActivity
S$PFIAD = PfiAmazonS3DeleteQueue
S$PFIAS = PfiAmazonS3DeleteStat
S$PFIAT = PfiTranslation
S$PFIAV = PfiActivityVariable
S$PFIAp = PfiClassicApplication
S$PFIBA = PfiBciApiInfo
S$PFIBD = PfiBatchAmazonS3DeleteQueue
S$PFIBF = PfiClassicField
S$PFIBG = PfiBODGroup
S$PFIBN = PfiLoadBalancerNode
S$PFIBT = PfiLoadBalancerTenant
S$PFICA = PfiComparisonActivity
S$PFICF = PfiChannelField
S$PFICH = PfiChannel
S$PFICL = PfiCloverleafConnection
S$PFICO = PfiClassicConnection
S$PFICP = PfiConfigurationProperty
S$PFICR = PfiReceiver
S$PFICS = PfiConfiguration
S$PFICV = PfiConfigurationParameter
S$PFICW = PfiComparisonWorkunit
S$PFIDO = PfiDocument
S$PFIEC = PfiEDICarrier
S$PFIEH = PfiEventHubConnection
S$PFIEM = PfiErrorMessage
S$PFIEP = PfiEmailConnection
S$PFIEW = PfiEDIWorkFile
S$PFIFA = PfiFileActivityConnection
S$PFIFD = PfiFlowDefinition
S$PFIFF = PfiFormField
S$PFIFI = PfiFrontOfficeConnection
S$PFIFK = PfiFilterKey
S$PFIFO = PfiForm
S$PFIFP = PfiFTPConnection
S$PFIFS = PfiFileStorage
S$PFIFV = PfiFlowVersion
S$PFIGT = PfiBODGroupType
S$PFIHD = PfiHealthStatusDataArea
S$PFIHS = PfiHealthStatus
S$PFIIB = PfiIONBatchNum
S$PFIIM = PfiIDMConnection
S$PFIIO = PfiIONConnection
S$PFIIV = PfiIONVariationId
S$PFIIX = PfiIOBox
S$PFIJD = PfiJDBCConnection
S$PFIJM = PfiJMSConnection
S$PFILC = PfiLandmarkConnection
S$PFILD = PfiLdapConnection
S$PFILp = PfiInbasketLandingPage
S$PFIM3 = PfiM3Connection
S$PFIMA = PfiMingleService
S$PFIME = PfiMessage
S$PFIMI = PfiMingleInbox
S$PFIML = PfiMingleLogicalId
S$PFIMQ = PfiMQConnection
S$PFIMS = PfiMetricsSummary
S$PFIMT = PfiMetrics
S$PFIMU = PfiMingleInboxUserTask
S$PFIPI = PfiProcessIndicator
S$PFIPR = PfiProcessReport
S$PFIPX = PfiProxy
S$PFIQA = PfiQueueAction
S$PFIQR = PfiQueueReminder
S$PFIQS = PfiQueueAssignment
S$PFIQT = PfiQueueTask
S$PFIQU = PfiQueue
S$PFIRC = PfiXRefCode
S$PFIRV = PfiXRefValue
S$PFISC = PfiSystemCommandConnection
S$PFISD = PfiServiceDefinition
S$PFISF = PfiServiceFlowDefinition
S$PFISM = PfiSMSConnection
S$PFISV = PfiServiceVariable
S$PFISr = PfiServer
S$PFITA = PfiTask
S$PFITF = PfiTriggerFolder
S$PFITK = PfiTaskReport
S$PFITP = PfiTriggerServiceJSON
S$PFITQ = PfiTimerQueue
S$PFITR = PfiTrigger
S$PFITV = PfiTriggerVariable
S$PFITX = PfiTXConnection
S$PFIUC = PfiUserCategory
S$PFIUP = PfiUserPreference
S$PFIUR = PfiUserProfile
S$PFIUT = PfiUserTask
S$PFIWC = PfiWebServiceConnection
S$PFIWD = PfiWorkunitInputData
S$PFIWF = PfiWorkunitFolder
S$PFIWI = PfiWorkunitInfo
S$PFIWR = PfiWebRunConnection
S$PFIWS = PfiWorkunitState
S$PFIWU = PfiWorkunit
S$PFIWV = PfiWorkunitVariable

Copyright © 2025 Infor. All rights reserved.