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.
  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

To create the TAFJ_CACHE table,

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);

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