Siebel Search Administration Guide > Installing Siebel Search Under UNIX >

Creating a DataDirect ODBC Data Source on DB2 Under UNIX

You must configure a DataDirect ODBC data source to use with SearchServer. This topic covers creating a DataDirect ODBC data source on a DB2 database.

To create a DataDirect ODBC data source on a DB2 database

1. Navigate to the fulcrum/DataDirect, for example:

   cd /export/home/fulcrum/DataDirect

2. Open the file odbc.ini in this directory with a text editor such as vi, for example:

   vi odbc.ini

3. Apply the following changes to the file Odbc.ini:
   1. Within the [ODBC] section, replace all instances of <enter Connect ODBC installation path> with the fully qualified path up to and including your ./DataDirect directory.
   2. Add a data source to the Odbc.ini file.
4. Under the [ODBC Data Sources] section, add a new line for your data source, for example:
   • For Hummingbird SearchServer Version 5.3.6

   Siebel_Search=DataDirect 4.20 DB2 Wire Protocol Driver

   • For Hummingbird SearchServer Version 6

   Siebel_Search=DataDirect 5.0 DB2 Wire Protocol Driver

5. Add a new section to odbc.ini for your own data source, specifying parameters for your database connection.
   1. Add the following for SOLARIS and AIX:

   [Siebel_Search]

   Driver=<Install_Directory>/DataDirect/lib/<Driver>

   Description=DataDirect <version> DB2 Wire Protocol

   ApplicationUsingThreads=1

   ArraySize=60000

   CachedCursorLimit=32

   CachedDescLimit=0

   CatalogIncludesSynonyms=1

   CatalogOptions=0

   DefaultLongDataBuffLen=1024

   DescribeAtPrepare=0

   EnableDescribeParam=0

   EnableNcharSupport=0

   EnableScrollableCursors=1

   EnableStaticCursorsForLongData=0

   EnableTimestampWithTimeZone=0

   LocalTimeZoneOffset=

   LockTimeOut=-1

   LogonID=<db logon >

   Password=<db password >

   HostName= <db hostname >

   PortNumber=<db port>

   SID=<SID>

   ProcedureRetResults=0

   2. Add the following for HP-UX:

   [Siebel_Search]

   Driver=<Install_Directory>/DataDirect/lib/<Driver>

   Description=DataDirect <version> DB2 Wire Protocol Driver

   Database=<db name>

   IpAddress=<db server>

   LogonID=siebel

   Password=<db password>

   Package=db2pac

   TcpPort=<portnumber>

where:

• Install_Path contains the path to the driver HDdb219.sl (HP-UX) in your own setup.
• Driver corresponds to the version of the driver for the Hummingbird SearchServer version, and the operating system that you are using, for example:
  • For Hummingbird SearchServer version 5.3.6, use driver HDdb219.so (for SOLARIS and AIX), or HDdb219.sl (for HP-UX).
  • For Hummingbird SearchServer version 6, use driver HDdb220.so (for SOLARIS and AIX), or HDdb220.sl (for HP-UX).
• LogonID is the ID you use to connect to the database.
• Password is the name of the password for the specified LogonID.
• Hostname is the name or the IP address of the server to which you want to connect.
• Port Number. Check the *.ini file for the port number.

6. Save your changes to odbc.ini.

NOTE:  For DB2 UDB or DB2/390 databases, you must use a different value for the Package parameter than that listed in the previous example. Moreover, for DB2 UDB, you must use Database. However, for DB2/390, you must use the Location and Collection parameters. You may need to confirm the correct values of these parameters with your Database Administrator. In the section Additional Step for Setting Up ODBC Datasources for DB2 Databases you run the bind program to connect to the DB2 database. If your database information is not configured correctly, your bind program will fail.

Additional Step for Setting Up ODBC Datasources for DB2 Databases

If you are using a DB2 database, you must perform the following additional step.

NOTE:  You must use the user name and password specified above (siebel and db2) for this step to work correctly. You also must log in to the Siebel application with this user name and password (siebel and db2) whenever you want to create, or refresh indices.

To perform additional step to set up ODBC datasource for DB2 database

1. Run a program that binds a package with the database server you want to connect to.

   You can do this by using the bind19 program located in the fulcrum/DataDirect/lib directory. You run the command with one argument, the name of the data source (in this case, Siebel_Search):

   source '/export/home/fulcrum/setfuladmin.csh'

   'cd /export/home/fulcrum/DataDirect/lib'

   './bind19 Siebel_Search'

   This step only needs to be done once, because other data sources can use the same bind package named db2pac. This parameter is specified by the Package variable in your data source configuration.

NOTE:  DataDirect constrains the Package parameter to be no more than six characters in length.