32 Clear Table Cache

This chapter discusses these topics:

32.1 Understanding Clear Table Cache

The JDB feature called Clear Table Cache can be used to improve performance by caching specific tables in the Call Object Kernel. For tables cached by JDB, any update or delete of a record in a cached table requires a clear of the cache on that kernel for the data to be available to all users. The adoption of the JDB Clear Cache API in specific EnterpriseOne Applications provides up-to-date data availability. CNC administrators with administrator access can use Server Manager to perform a dynamic cache refresh while users are logged on.

Clear Table Cache refresh allows a specific JDB table cache that is registered in the F98613 table to be cleared across kernel processes and across all Enterprise Servers as long as they are managed by the same Server Manager. As a result, all Enterprise Servers and all JD Edwards EnterpriseOne HTML Web Servers managed by the same Server Manager no longer need to be bounced (restarted) in order to clear cache. Since there is no table caching for the HTML Web Servers, it is not necessary to clear the cache on those machines.

32.2 Using the Clear Table Cache Feature

To use the Clear Table Cache feature in Server Manager:

  1. Launch the Server Manager Management Console.

    This image is described in surrounding text.
  2. In the What do you want to do? section, click the Table Cache link.

    This image is described in surrounding text.
  3. On the Clear Table Cache Results page there are two sections:

32.2.1 Clear Table Cache by Environment

To clear all caches for all tables which are registered in F98613 in all environments across all Enterprise Servers that are managed by the same Server Manager:

This image is described in surrounding text.
  1. On the Clear Table Cache Results page, go to this section:

    Clear Table Cache by Environment

  2. Complete these fields:

    • Table Name

      Enter a valid table name that is registered as a cached table in F98613 table using the P98613 application.

    • Environment Name

      Enter a valid JD Edwards EnterpriseOne environment from which the table cache will be cleared.

  3. Click the Clear Table Cache button.

    The system displays a section that lists all cache that has been cleared for the requested table. For example, if you chose the F0010 table and the JDV910SA1 environment the following is displayed:

    This image is described in surrounding text.

32.2.2 Clear All Tables Caches in All Environments

To clear all caches for all tables which are registered in F98613 in all environments across all Enterprise Servers that are managed by the same Server Manager:

This image is described in surrounding text.
  1. On the Clear Table Cache Results page, go to this section:

    Clear All Table Caches by Environment

  2. Click the Clear All Table Caches button.

    The system displays a section that lists all cache that has been cleared for all tables in the selected environment. An example is shown below.

    This image is described in surrounding text.

32.3 Clear Data Cache (Release 9.2.3.4)

Clear Data Cache can be used for clearing the data cache on the AIS and HTML Servers. If the HTML Server and AIS Server are setup in a cluster, Clear Cache will clear all the relevant cache on all the members of the cluster. In the case of HTML Server, cache is cleared for Form Extension, Personalized Forms, and Search Group entries. In the case of AIS Server, the cache is cleared for Orchestration, Notification, Form Service and Data Service, and Read Data entries.

32.3.1 Using the Clear Data Cache Feature

To use the Clear Cache feature in Server Manager:

  1. Launch the Server Manager Management Console.

  2. On the Managed Instances section of the Server Manager Management Dashboard, click on the required managed instance of the HTML or the AIS Server for which you want to clear the cache.

  3. Do one of the following:

    1. On the EnterpriseOne HTML Server managed instance page, click the Clear Caches button to clear the Form Extension, Personalized Forms, and Search Group caches.

    2. On the EnterpriseOne Application Interface Services managed instance page, click the Clear Caches button to clear the Notification and Orchestration caches. Click the second Clear Caches button to clear the Form Service and Data Service, and Read Data caches.

Note:

The Clear Caches button is disabled if the status of the HTML or AIS server is anything other than "Running".