Unwanted entries being included from the $aleph_root/tab/file_list.XXX templates

• Article Type: General
• Product: Aleph

Description:
I like to use the file_list mechanism to set up table sizes. In earlier versions of Aleph, these were located in the $data_root directory, but I seem to recall that either they moved in Aleph 18 or there was a change we could make so that they could continue to be in that location.

I find that with Aleph 20, creating all tables is not looking at my file_list but must be looking at something else.

KB 8192-3719 recommends commenting out the file_list_type and file_list_size, but if I do that I get the Segmentation Fault described there.

We have tried adding file_list_TSnD / file_list_TSnX lines with dummy tablespace names, but it seems to default to ts0 / ts1 in that case.

Resolution:
If you find that tables which you don't want to have defined are being included from the file_list.XXX template, then you can prevent their being created by adding a line such as this in your $data_root/file_list:

NA z13u

This entry in the $data_root/file_list will take precedence over the entry in the template. This is described in detail in KB 8192-5095.

Or, if you don't like that solution, you could delete all the lines in each of the $aleph_root/tab/file_list.XXX's.

(It's possible that something could complain if they were deleted, but certainly having no lines would not be a problem....)

You would need to check after each Service Pack to make sure that new, populated ones have not replaced your empty ones.

• Article last edited: 10/8/2013