Is it possible to truncate PM tables ?
Article ID: 191541
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Is it possible to truncate PM tables ?
Environment
Release : 12.3
Component : AUTOMATION ENGINE
Resolution
PMMAV truncate is possible but not PMMA table.
And delete on cascade is not enabled in the table definitions to truncate the PMMA with referenced data.
you have to remove all the constraints on all the PM* tables
ALTER TABLE PMMA
DISABLE CONSTRAINT FK_PMMA_PMMD
ALTER TABLE PMID
DISABLE CONSTRAINT FK_PMIA_PMID
ALTER TABLE PMIAM
DISABLE CONSTRAINT FK_PMIAM_PMMA
DISABLE CONSTRAINT FK_PMIAM_PMID
ALTER TABLE PMMAV
DISABLE CONSTRAINT FK_PMMAV_PMMA
ALTER TABLE PMIA
DISABLE CONSTRAINT FK_PMIA_PMID
Then truncate, then enable the constraints again, just replace DISABLE with ENABLE in the statements above
Permanent fix: Set PERFORMANCE=N in UC_SYSTEM_SETTINGS (Client 0)
And delete on cascade is not enabled in the table definitions to truncate the PMMA with referenced data.
you have to remove all the constraints on all the PM* tables
ALTER TABLE PMMA
DISABLE CONSTRAINT FK_PMMA_PMMD
ALTER TABLE PMID
DISABLE CONSTRAINT FK_PMIA_PMID
ALTER TABLE PMIAM
DISABLE CONSTRAINT FK_PMIAM_PMMA
DISABLE CONSTRAINT FK_PMIAM_PMID
ALTER TABLE PMMAV
DISABLE CONSTRAINT FK_PMMAV_PMMA
ALTER TABLE PMIA
DISABLE CONSTRAINT FK_PMIA_PMID
Then truncate, then enable the constraints again, just replace DISABLE with ENABLE in the statements above
Permanent fix: Set PERFORMANCE=N in UC_SYSTEM_SETTINGS (Client 0)
Feedback
Yes
No
Powered by
