Create the database or schema for Distributed Marketing with the help of your database
administrator. After you create a schema, enter the correct information about it in the data source
information worksheet.
About this task
Complete the following tasks to create the Distributed Marketing system
tables or schema:
Procedure
- Work with a database administrator to create the required
database or schema for IBM® Distributed Marketing.
Note: The Distributed Marketing system
database must use UTF-8 character encoding. If you do not use UTF-8,
you can encounter a problem when you copy certain characters from
a Microsoft™ Word document
into Distributed Marketing.
In an Oracle database, certain characters display as ? when
you copy them from Word to a Distributed Marketing field.
For DB2®, this issue causes a
problem when you view objects. To fix the problem, you must go into
the database and remove the problem characters.
- Have the database administrator create an account for
the database or schema. Specify this account as a data source for
a system user later in the installation process.
This
account must have at least CREATE
,DELETE
, SELECT
, INSERT
, UPDATE
,
and DROP
rights.
If you are using DB2, make
sure that the buffer pool for the table space is at least 32 K; otherwise,
you are not able to create templates.
- Obtain the information about your database or schema and
the database account and then print and complete the Distributed Marketing database information
worksheet.