Network Router User Manual

40 GINA V4.0 System Administrator Guide – September 2000

Customizing the database layout

5.2.3 Further options

The mgendb tool can also be used to inﬂuence the conﬁguration of the database. In addi-

tion to speciﬁcations concerning the default database user and NLS/GLS speciﬁcations, the

-d option can be used to determine a dbspace in which the database tables to be created

are to be set up. The mgendb supports the following options:

-d

dbspace

The named

dbspace

of the database instance is used as the default storage area of

the database to be generated. If this option is not set, the database is generated in the

root dbspace of the instance. See also [19].

Example

mgendb ... -d gina ...

-l

ltype

Specifying this option generates the database in such a way that it is NLS-/GLS-com-

patible (native language support/global language support), assuming the database

server supports this functionality. The concrete language variant (locale) is speciﬁed by

ltype

. The syntax of

ltype

depends on the current database server and the operating

system used. It is described in the database reference manual or the NLS documenta-

tion of the operating system. If the -l option is not set, the database is generated with-

out NLS/GLS.

The following environment variables are set in the mgendb for an NLS-/GLS-compatible

database:

CLIENT_LOCALE=

ltype

DB_LOCALE=

ltype

The DB_LOCALE environment variable is needed for the database server. If this variable

is set, then the new databases will be generated using the locale speciﬁed by the vari-

able DB_LOCALE instead of the standard locale.

The CLIENT_LOCALE environment variable is needed for the database client and the

database server. It must also be set before an application that works with an NLS-/GLS-

capable database is started.

Example

for INFORMIX V9.2 for creating a database with the German character set:

on SunOS mgendb -l de_de.8859-1 myDB (LANG=de)

on SINIX mgendb -l de_de.8859-1 myDB (LANG="De_DE.88591@TE")

on HP-UX mgendb -l de_de.8859-1 myDB (LANG=de_DE.iso88591)