XMA: Database Tables are filling up

XMA: Database Tables are filling up

You may either partition the tables or create new, larger tables.

Option 1 - Partition the AUDSESS and AUDDET tables
Partitioning the AUDSESS and AUDDET files will give them more room to grow. To assist in this process there is a file in the XYGATEMA subvolume called PARSAMP. It contains the instructions and SQLCI commands needed to create the partitions and move your existing data to the appropriate partition.


Option 2 - Create new, larger tables
1.    Stop the XMA pathway servers
2.    Rename the existing tables
3.    Create the new tables

The definitions for the tables are found in the file NEWTBLS file in the XYGATE subvolume. The section names are AUDSESS and AUDDET. It is suggested that you copy these two sections from NEWTBLS into a separate obey file. Alter the primary and secondary extent allocation to the desired values.

             NOTE  If the version of your SQL catalog is 3.50 or greater on all nodes
             these files can be type 2 files.

4.    Copy the data from the existing tables to the new tables
5.    Drop the renamed tables from catalog
6.    Using XMA_SQLCOMPALL recompile all the SQL programs
7.    Re-start the XMA pathway servers


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.