<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/dba/ttdba0540m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Convert Table and Index Repository (ttdba0540m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to view the <Link href="/baanerp/tt/glossary/glossary#000000000000024" role="glossary">RDBMSs</Link> for which you can optimize the table and index storage. This session converts the &lt;RDBMS&gt;_storage file to the runtime data dictionary. During the conversion process the &lt;RDBMS&gt;_storage file is split up into two separate files:</Paragraph>
		</AimSection>
		<GeneralSection><ProcedureList><ListItem>The storage parameter file, &lt;RDBMD&gt;_storage_param</ListItem>
				<ListItem>The database driver parameter file, &lt;RDBMD&gt;_driver_param</ListItem>
			</ProcedureList>
			<Paragraph class="Default">You can maintain these two files in the <GUIRef href="/baanerp/tt/dba/ttdba0530m000" role="session">Storage Parameters Optimization (ttdba0530m000)</GUIRef> session and the <GUIRef href="/baanerp/tt/dba/ttdba0535m000" role="session">Driver Parameters Optimization (ttdba0535m000)</GUIRef> session. Splitting up the &lt;RDBMS&gt;_storage file improves the performance between <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> and the database. For example, the time required to run a query is reduced.</Paragraph>
			<GeneralSection><SectionTitle>WARNING</SectionTitle>
				<Paragraph class="Default">The information in the Table and Index repository affects the data transfer to the database. Make sure not to corrupt the data transfer by storing incorrect information in the repository.</Paragraph>
			</GeneralSection>
			<Paragraph class="Default">Select a RDBMS in the grid, and then on the <GUIRef href="" role="menu">Specific</GUIRef> menu choose Convert Repository to start the conversion process.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The &lt;RDBMS&gt;_storage file is not deleted but will not be used anymore when the &lt;RDBMS&gt;_storage_param file and the &lt;RDBMS&gt;_driver_param are created.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/000000000000001" role="manual">The Database Administrator (DBA) module</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/000000000000002" role="manual">To create a link between the ERP LN user and the database user</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttaad410.dbse"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Create the database in the <GUIRef href="/baanerp/tt/aad/ttaad4510m000" role="session">Database Definitions (ttaad4510m000)</GUIRef> session.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttaad410.torg"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database Type</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> type.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You can use several <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">databases</Link> of different types in <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef>.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttaad410.syst"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">System Name</Title>
			</Header>
			<FuncDesc>The remote system's name where the <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> is located.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Use this field if the <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> is located on a remote system. You need the remote system's name to convert the data to the tabledef6.x file.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListIntro>This field is empty if:</ListIntro>
					<ListItem>The <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> is located on a local <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link>.</ListItem>
					<ListItem>The system is not part of a remote system.</ListItem>
				</List>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttaad050.bsep"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">BSE Path</Title>
			</Header>
			<FuncDesc>The specified host system's <Link href="/baanerp/tt/glossary/glossary#000000000000025" role="glossary">BSE path</Link>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListIntro>This field is empty if:</ListIntro>
					<ListItem>The <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> is located on a local <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link>.</ListItem>
					<ListItem>The system is not part of a remote system.</ListItem>
				</List>
			</Note>
		</FieldHelp>
	</Fields>
</Session>
