<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/aad/ttaad4112s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database Definitions (Copies/Alternatives) (ttaad4112s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default"> 
                                 Use this session to create copies of <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">databases</Link>, or to create alternative databases.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">Copies of databases can be created on local databases or remote databases. If a table is changed in a database the modifications are also carried out in the copy of that database. This process is called database mirroring. In case of database mirroring, only one database needs to be read. Typically, the application determines which tables have to be read. To tell the system which tables it has to read, select the Force Read check box to specify which database must be accessed to make reading tables possible.</Paragraph>
			<Paragraph class="Default">Alternative databases are used to make sure that no data is lost when a database operation fails on the main database. From the time the database fails, data is written/retrieved of the alternative database.</Paragraph>
			<Paragraph class="Default">Enter the code for the database and a short description. If you want to use the database on a remote system, enter the system name. Specify the database type of the local or the remote system.</Paragraph>
			<Paragraph class="Default">If you do not fill in the <GUIRef href="/baanerp/tt/aad/ttaad4112s000#ttaad412.syst" role="manual">System Name</GUIRef> field, the tabledef6.X file will only be created on the local system. If this field is filled in, the database is created on the local system and on the remote system.</Paragraph>
			<Paragraph class="Default">Make sure that the BSE_REM variable is set. You can only do this if the remote system contains the data dictionary. On the local system, the tabledef6.X file refers to the remote system. The tabledef6.X file on the remote system shows the database type per table.</Paragraph>
			<Paragraph class="Default">If required, use variables in the <GUIRef href="/baanerp/tt/aad/ttaad4112s000#ttaad412.para" role="manual">Parameter</GUIRef> field to define a database copy in another file system on your local system.</Paragraph>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/100004" role="manual">To use remote databases</Link>
			</RelTopic>
			<RelTopic>
                                 Use this session to
                              </RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttaad412.dbse"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database</Title>
			</Header>
			<FuncDesc>The identification code of the database in the <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> environment.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad410.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database</Title>
			</Header>
			<FuncDesc>Specifies the description of the database definition.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad412.copy"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Sequence No.</Title>
			</Header>
			<FuncDesc>Specifies the number of the database copy. You can define more than one database definition. The database copy with the lowest number is first accessed.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad412.alco"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Copy/Alternative</Title>
			</Header>
			<FuncDesc>Specifies whether the database is used as database copy or as an alternative database.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad412.syst"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">System Name</Title>
			</Header>
			<FuncDesc>Enter the name of the system where the database is located.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the database is on the local system, and the system is not part of a remote database configuration, do not fill this field. Specify the database type of the local database in the <GUIRef href="/baanerp/tt/aad/ttaad4112s000#ttaad412.torg" role="manual">Database Type</GUIRef> field.</Paragraph>
				<Paragraph class="Default">If you use a remote database configuration, enter the name of the system where the database is located.</Paragraph>
			</SimpleSection>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">Assume the following configuration: host 1 : the system where the database is located workst 1: work station 1 workst 2: work station 2</Paragraph>
				<Paragraph class="Default">The application manager works on workstation 1 and starts the <GUIRef href="/baanerp/tt/aad/ttaad4110s000" role="session">Database Definitions (ttaad4110s000)</GUIRef> session. He must enter host 1, the system where the database is located, on the <GUIRef href="/baanerp/tt/aad/ttaad4112s000#ttaad412.syst" role="manual">System Name</GUIRef> field. This is the system where the database is located. The application manager specifies the database type of the tables in the <GUIRef href="/baanerp/tt/aad/ttaad4112s000#ttaad412.torg" role="manual">Database Type</GUIRef> field. When he starts the <GUIRef href="/baanerp/tt/aad/ttaad4113s000" role="session">Create Runtime Database Definitions (Tabledef) (ttaad4113s000)</GUIRef> session the application manager can specify to dump the tabledef file on the system where the database is located, workstation 1 and workstation 2.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The application manager must have a remote user file in order to have access to the systems mentioned, to dump the table definition file, tabledef, on the system host1 and workst2.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttaad412.torg"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Database Type</Title>
			</Header>
			<FuncDesc>Enter the database type of the database definition code. The data of those tables assigned to a database definition code, is physically stored in its database (type).</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the <GUIRef href="/baanerp/tt/aad/ttaad4110s000#ttaad410.syst" role="manual">System Name</GUIRef> name field is filled in, the database type of the remote system can be defined on this field. You must use this for converting data to the tabledef6.1 file on the remote system.</Paragraph>
				<Paragraph class="Default"><GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> supports several database types.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttaad412.para"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Parameter</Title>
			</Header>
			<FuncDesc>If required, enter a parameter.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If you use parameters, you can define a database copy in another file system on your local system. If the file system crashes, you still have a backup copy which is located on another file system.</Paragraph>
				<Paragraph class="Default">The databases ORACLE and Informix use parameters, and environment variables in order to indicate tables. For example, an ORACLE database can have the following parameters: ORACLE_HOME=/usr/oracle7,ORACLE_SID=d1.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">It is recommended to create a database copy on a remote system.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttaad412.forr"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Force to Read</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the table is force read.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If you use more than one database, or database redirections to another system, you can specify which database must be accessed for specific tables. Typically, the bshell accesses the database that has been specified as the first database in the table's database definition.</Paragraph>
				<Paragraph class="Default">There can be reasons, for example, performance, to read the table from another database (type). In that case, you can specify to force read table.</Paragraph>
			</SimpleSection>
		</FieldHelp>
	</Fields>
</Session>
