Siebel Analytics Platform Installation and Configuration Guide > Configuring Siebel Analytics Scheduler Server >

Changing Scheduler Table Names Under UNIX

Analytics License: All licenses.

Operating System: UNIX only.

This topic is part of the process Configuring Siebel Analytics Scheduler Server.

NOTE:  Before modifying the instanceconfig.xml file, set up the UNIX environment with the command scripts sa.sh or sa.csh, as described in Siebel Analytics Scripts for Korn, Bourne, or Bash Shells and Siebel Analytics Scripts for C Shell.

Set the UNIX display, then continue with the following procedure.

To change table names for Analytics Scheduler (UNIX)

1. Navigate to Siebel Analytics data directory at the following location:

   /SiebelAnalyticsData/web/config

2. Locate the file instanceconfig.xml and make a backup copy.
3. Using a text editor, open the file instanceconfig.xml.
4. After the <ServerInstance> tag, create the tag pair <DBColumnNames> and
   </DBColumnNames>.
5. Between the DBColumnNames tags, create the tag pairs shown in the following table.

   Tag Pair	Value
   <TableJobs> </TableJobs>	S_NQ_JOB
   <TableInstances> </TableInstances>	S_NQ_INSTANCE
   <TableParams> </TableParams>	S_NQ_JOB_PARAM
   <TableErrmsgs> </TableErrmsgs>	S_NQ_ERR_MSG

   Between each of these tag pairs, enter the values shown in the table. These are the values used for Scheduler table names. For example:

   <DBColumnNames>
      <TableJobs>S_NQ_JOB</TableJobs>
      . . .
   </DBColumnNames>

6. Save the file when you are done.
7. From the Analytics /setup directory, run the following command to import the modified configuration file:

   $ sa-cli.sh

   Your changes take effect when the Analytics Web Server service is restarted.