<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/dba_table_and_index_repository_procedure" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">RDBMS table and index repository procedure</Title>
		<Keyword ContextSensitive="No"><Level1>RDBMS administration</Level1>
			<Level2>table and index repository procedure</Level2>
		</Keyword>
	</Header>
	<GeneralSection><SectionTitle>Introduction</SectionTitle>
		<List><ListIntro>With this procedure, you can convert the [RDBMS]_storage file from the run time data dictionary to the RDBMS Administration module. During the conversion process, the [RDBMS]_storage file is split up into two separate files.</ListIntro>
			<ListItem>The database storage parameter file, [RDBMS]_storage_param</ListItem>
			<ListItem>The database driver parameter file, [RDBMS]_driver_param</ListItem>
		</List>
		<Paragraph class="Default">If you split up the [RDBMS]_storage file, then the performance between ERP LN and the database will be improved. For example, this reduces the time required to run a query.</Paragraph>
		<List><ListIntro>To optimize the table and index repository, you must do the following:</ListIntro>
			<ListItem>Convert the table and index repository</ListItem>
			<ListItem>Optimize the storage parameters</ListItem>
			<ListItem>Optimize the driver parameters</ListItem>
		</List>
		<Note><SectionTitle>Result</SectionTitle>
			<Paragraph class="Default">As a result of this procedure, the interaction between ERP LN and the database in improved. This results in an improved performance of ERP LN.</Paragraph>
		</Note>
		<Note><SectionTitle>Warning</SectionTitle>
			<Paragraph class="Default">The information in the Table and Index repository affects the data transfer to the database. Be sure to store the correct information in the repository to ensure that you do not corrupt the data transfer.</Paragraph>
		</Note>
		<Figure space-and-orientation="indented-estimated"><FigIntro>The following figure illustrates the steps in the procedure you must take to optimize the table and index repository:</FigIntro>
			<HTML:IMG width="259" height="229" SRC="../images/tr_graph_dba_optimize_table_and_index_procedure.gif" path="/enterpriseserver/tools/tt/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="tr_graph_dba_optimize_table_and_index_procedure.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/images/tr_graph_dba_optimize_table_and_index_procedure.gif" ID="IDAOBYBC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/></Figure>
		<List><ListIntro>This procedure is divided into the following three sub-procedures:</ListIntro>
			<ListItem>Use the <Link href="/baanerp/tt/dba/ttdba0540m000" role="session">Convert Table and Index Repository (ttdba0540m000)</Link> session to split up the [RDBMS]_storage file.</ListItem>
			<ListItem>Optimize the [RDBMS]_storage_param file.</ListItem>
			<ListItem>Optimize the [RDBMS]_driver_param file.</ListItem>
		</List>
		<Note><SectionTitle>
                                 Note
                              </SectionTitle>
			<Paragraph class="Default">Splitting up the [RDBMS]_storage file in to two separate files is a one time only action. After you split up the [RDBMS]_storage file, the file still exists, however, because the file has expired, the file no longer used. The other two steps are for maintenance purposes of the [RDBMS]_storage_param file and the [RDBMS]_driver_param file.</Paragraph>
		</Note>
	</GeneralSection>
	<GeneralSection><SectionTitle>To convert the table and index repository</SectionTitle>
		<Paragraph class="Default">You can use this procedure to split up the [RDBMS]_storage file for improved interaction between ERP LN and the database.</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>The following list shows the procedure steps and the corresponding sessions. Convert the table and index repository with the following session:</ListIntro>
				<ListItem><Link href="/baanerp/tt/dba/ttdba0540m000" role="session">Convert Table and Index Repository (ttdba0540m000)</Link>.</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
	<GeneralSection><SectionTitle>To optimize the storage parameters for the specific database</SectionTitle>
		<Paragraph class="Default">You can use this process to maintain the [RDBMS]_storage_param file, which is a part of the [RDBMS]_storage file.</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>The following list shows the procedure steps and the corresponding sessions. Optimize the storage with the following sessions:</ListIntro>
				<ListItem><Link href="/baanerp/tt/dba/ttdba0530m000" role="session">Storage Parameters Optimization (ttdba0530m000)</Link>
				</ListItem>
				<ListItem><Link href="/baanerp/tt/dba/ttdba0130s000" role="session">Storage Parameters Optimization (ttdba0130s000)</Link>
				</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
	<GeneralSection><SectionTitle>To optimize the driver parameters for the specific database</SectionTitle>
		<Paragraph class="Default">You can use this process to maintain the [RDBMS]_driver_param file, which is a part of the [RDBMS]_storage file.</Paragraph>
		<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
			<List><ListIntro>Optimize the database drivers with the following sessions:</ListIntro>
				<ListItem><Link href="/baanerp/tt/dba/ttdba0535m000" role="session">Driver Parameters Optimization (ttdba0535m000)</Link>
				</ListItem>
				<ListItem><Link href="/baanerp/tt/dba/ttdba0135s000" role="session">Driver Parameter Optimization (ttdba0135s000)</Link>
				</ListItem>
			</List>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
