To open large number of tables in a single session

A session can update a large number of tables. On systems that have a small maximum number of open files, this can create a problem. Suppose a session with a limit of 30 open files starts to update 50 tables.

After opening the information and sequence files for the first 30 tables, the system reaches the maximum limit of open files. If files for table31 are opened, the LRU logic is activated and files for table1 are closed. But table1 is itself in transaction and its files are locked. When the audit server closes the files, the locks are released and other processes can alter the files. Now, the same audit server might again have to operate on the audit files of table1.

For this reason, the audit files for table1 must be reopened. However, if the files were changed in the meantime, the status changes to ABORT_DONE. In this case, the audit server returns an error and cancels the transaction.