Creating a Unicode database for use with DB2 Content Manager OnDemand on UNIX

Answer

OnDemand uses UTF-8 for its Unicode database. Complete the following steps to create an OnDemand Unicode database:

1. Ensure that you have all of the following prerequisites:

• UTF-8 locale environment

AIX®: You can use lslpp -l 'bos.loc.utf.*'

Solaris Operating Environment: You can use pkglist | grep UTF-8 or enter locale -a | grep UTF-8

HP-UX: You can use swlist or use locale -a | grep utf8

Linux: rpm -q or use locale -a | grep utf8

• DB2 Universal Database™ V8


Ensure that the DB2 Universal Database conversion packages are installed.
For example, on AIX: lslpp -l db2_08_01.cnvucs and lslpp -l db2_08_01.conv                                            
Use the equivalent command on the other UNIX® operating systems.

• DB2 V9 and above will have the correct environment installed.

• DB2 Universal Database:

Follow the DB2 Universal Database and OnDemand installation instructions until you need to specify the ARS_LANGUAGE in the ars.cfg file.

Add the following entries:
ARS_CODEPAGE=1208
ARS_CODESET=UTF-8
ARS_LOCALE=en_US
ARS_USE_LOCALE=1
Change your language environment:
export LANG=EN_US.UTF-8
and run the arsdb -cv command
These steps allow you to create a DB2 Universal Database UTF-8 database.

• Oracle:

Use the Oracle Database Configuration Assistant. You need to customize the database settings and change the Character Set to UTF-8.
Add the following entries to the ars.cfg:
ARS_CODEPAGE=1208
ARS_CODESET=UTF-8
ARS_LOCALE=en_US
ARS_USE_LOCALE=1
Change your language environment:
export LANG=EN_US.UTF-8
and run the arsdb -rtv command

This step is best done with a script similar to the following sample:

#!/bin/ksh
#
# Set the language environment
export LANG=EN_US.UTF8
#
# Start OnDemand
/usr/lpp/ars/bin/arssockd


You are now running OnDemand in a UTF-8 environment with a UTF-8 database.