Configuring Tables

This section describes the tables TAFJ_CACHE_KS_INIT and TAFJ_CACHE.

• TAFJ_CACHE_KS_INIT - It holds the default encryption initialiser (algo). You can encrypt the keystore password in the cache.properties file by changing the default encryption initialiser.
• TAFJ_CACHE - Configuration of tables to be cached is done in the TAFJ_CACHE table. If TAFJ_CACHE doesn’t exist, you need to create it by running the script createtable_tafj_cache.sql in your $TAFJ_HOME/dbscripts directory for the appropriate database.
  NOTE: When you run the above table creation script, it can also insert some default tables. You need to check and see, which tables are included.

Creating the TAFJ_CACHE table

Procedure

1. Run the script below in the $TAFJ_HOME/dbscripts directory for the appropriate database.

   createtable_tafj_cache.sql

2. Use the following SQL command to view the table structure.

   desc tafj_cache;

   Name                                      Null?    Type
   ----------------------------------------- -------- ----------------------------
   RECID                                     NOT NULL VARCHAR2(255)
   CACHENAME                                          VARCHAR2(255)
   WRITEBATCHROWS                                     VARCHAR2(5)			

3. Create the appropriate rows for tables that should be cached. For example,

   INSERT INTO TAFJ_CACHE (RECID,CACHENAME,WRITEBATCHROWS) VALUES ('F.EB.LOOKUP','Tables',NULL);

NOTE: When you do new DBImports using the DBImport progam, the TAFJ_CACHE table gets created with empty records.