XMA: Changing Transaction Size for Cleanup/Archive Params

XMA: Changing Transaction Size for Cleanup/Archive Params

There are 2 solutions, one for XMA v1.90 and later, and pre-v1.90

pre-v1.90
Perform the following commands, substituting the actual volume name XMA is installed in for $volume in the following steps;

INSERT INTO $volume.XMADAT.PARAMS VALUES ("ARCHIVE ","ARCHIVE "
,"TRANTIMEOUT","120","Transaction Timeout");
INSERT INTO $volume.XMADAT.PARAMS VALUES ("ARCHIVE ","ARCHIVE "
,"TRANRECCOUNT","50","Records per Transaction");
INSERT INTO $volume.XMADAT.PARAMS VALUES ("ARCHIVE ","ARCHIVE "
,"TIMEBLOCKSIZE","1800","Time Block Size");
INSERT INTO $volume.XMADAT.PARAMS VALUES ("ARCHIVE ","ARCHIVE "
,"MAXCPUBUSYPERCENT","30","Maximum CPU Busy Percent");


v1.90 and later

At the Main Menu in XMA_MANAGER, select Option 3 for Database Menu, then Option 17: Alter Cleanup/Archive Params
Change the Transaction Size to 100.
 


If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.