Apply and Activate button in Siebel Tools

The Author of this Article is Karthik Chatakondu. This is all what I know about him right now will update once I get to know more about him.

The Apply and Activate buttons appear in the Table and Index sections of Siebel Tools. They are a means to synchronize the logical and physical schema and alert other users that changes have been made to the schema.

The logical schema is stored in the following tables in the Siebel database.

  • S_TABLE
  • S_COLUMN
  • S_INDEX
  • S_INDEX_COLUMN

The physical schema is defined in the RDBMS (IBM DB2, Microsoft SQL Server or Oracle) that is being used.

There are a limited number of things that can be done that cause changes to the schema. They are adding a new column, table or index or deleting an extension column, table or index. Each of these actions require an update to the logical schema and a change to the physical schema. This can be done through Siebel Tools or using the Database Server Configuration Utility

Next, the Apply button is clicked, which prompts you to connect to the database using ODBC and to log in as the table owner. This is required since Data Definition Language (DDL) is being performed by Siebel Tools. Here is a sample SQL statement that Siebel Tools runs against the database.

DROP INDEX S_CONTACT_JOHN1

After applying changes to the schema is completed, the changes have been made to the database. You can take advantage of these changes once a new Siebel repository file (.srf) has been distributed. If an index has been added, the database may start using this regardless of whether or not a new .srf file has been distributed. The database works independently from the .srf file.

Clicking the Activate button simply updates the schema version in the S_APP_VER table. The schema version signals clients, mobile clients and server components that a schema change has been made and that they need to update their own logical or physical schema’s. Server components use the dictionary cache or diccache.dat to reference objects in the Siebel database quickly. Diccache.dat is loaded into memory and shared by all server components. Whenever a server component runs, it validates the schema by querying S_APP_VER and comparing the schema version against that which is stored in the diccache.dat. If a newer schema exists, the Siebel application rebuilds the diccache.dat.

Compile a new .srf file after making schema changes to ensure that you are working with the proper schema.

If instead of dropping a custom index, an extension column were being added, the SQL would be slightly different. Instead of DELETE statements, there would be INSERTS and instead of the DROP statement, there would be CREATE or ALTER statements.

In summary, a schema change in Siebel Tools needs to be propagated to the Siebel database and applied to the physical database. The final step is to activate the changes, or increment the schema version in the S_APP_VER table.

NOTE: When clicking the Apply button to apply data model changes, you will be prompted for the Privileged User Id / Password. This must be the table-owner name/table-owner password. Before Siebel 7.7, this was typically DBA/SQL. With Siebel 7.7, this has changed to SIEBEL/local user password. For example, suppose your login id is JSMITH and password is DB2. When you apply schema changes to the local database, your Privileged User Id / Password would be SIEBEL/DB2.

I would like to Thanks Karthik for sharing really useful information with us. Please rate this article if you found it good.

23 Responses to Apply and Activate button in Siebel Tools

  1. Good one. but seems to be copied as-is from siebel books.

    Guys, could you start adding live content .ie., which you find out of your experinece , some good config or other examples, rather than just copying text from other sources.

    Anyways thanks for this article.

    • Hi,
      Here is my experience. I am facing problems with Apply & Activate of columns in Siebel 8.1. It takes almost 4 hours for it, in our local machine.
      Developer A checks in a new column.Apply & activate on server. Developer B gets it on her Local, and tries do apply & activate. It takes 4 hours!!
      The free tablespace is 2.8GB. Could it be because our development server is consuming 100% CPU Usage.
      What could be the issue?

      Thanks,
      Heidi

      • Hi,
        Same experience seen that for development tool apply and activate will take very minimal time but in System test environment, it is taking 1 hr to apply in DB.

        What may be the problem? can any one help here 

  2. Good one. but seems to be copied as-is from siebel books.

    Guys, could you start adding live content .ie., which you find out of your experinece , some good config or other examples, rather than just copying text from other sources.

    Anyways thanks for this article.

  3. Hi,
    Good effort Karthick. Thanks for putting things together in a readable format.

    Regards,
    M Prabu Shanker.

  4. Hi,
    Good effort Karthick. Thanks for putting things together in a readable format.

    Regards,
    M Prabu Shanker.

  5. Hi

    An Excellent Document with a Wonderful Explanation about the Apply and Activate Buttons and Explanation about what happens in the Background

    Could you please elaborate about diccache.dat and dicdat.dat files..

    Thanks in Advance

    Babu Rajendra Prasad

  6. Hi

    An Excellent Document with a Wonderful Explanation about the Apply and Activate Buttons and Explanation about what happens in the Background

    Could you please elaborate about diccache.dat and dicdat.dat files..

    Thanks in Advance

    Babu Rajendra Prasad

  7. Good Explanation to index this topic.Really appreciate if u could share about workflows simulation and its critical issues faced in real time.

    Thanks

  8. Good Explanation to index this topic.Really appreciate if u could share about workflows simulation and its critical issues faced in real time.

    Thanks

  9. Hi,
    Suppose if I have created a new column in S_PROD_INT and I have done Apply & Activate Locally. And I have checked into the Server.

    Would it required to do Apply & Activate on the Server again?

    • Hi Anil,

      when you creating new column in S-PROD_INT ,that time how much time taking Apply and Activate Locally.

    • I have created a new column in S_PROD_INT and I have done Apply/DDL But taking so munch time  Locally. Please can any one help here

Leave a Reply

Contribute