TDI v7.1.1 - System Store configuration information using IBM SolidDB.

Technote (troubleshooting)


Problem(Abstract)

The TDI System Store provides the ability to use other multi-user RDBMS systems such as IBM SolidDB. Due to product limitations: the provided by default DDL statement will not configure the tombstone database table. The tombstone table must be created using an IBM SolidDB SQL Editor.

Symptom

The following error may be seen:

CTGDIJ005W Unable to obtain schema information from the database. The following exception was encountered: java.lang.Exception: CTGDIJ037E The table or view specified (IDI_TOMBSTONE) was not found, or not accessible.

The Installation and Administration Guide does not provide the statements to configure the tombstone table correctly for solidDB.

Cause

Product Limitation.

Environment

Tivoli Directory Integrator v7.1.1; SolidDB v7.0

Diagnosing the problem

Tombstones are not created as expected.

Resolving the problem

To configure the System Store to use IBM SolidDB and define the IDI_TOMBSTONE table you will need to complete the following steps:

1. Review the Installation and Administration Guide, Chapter 12: System Store. Follow the instructions provided related to driver and configuration settings.

2. Verify the global.properties and/or solution.properties contain the correct SQL statements to create the IDI tables as defined in the IBM SolidDB section. These can be found under the "Create table statements" heading.

3. Using the IBM solidDB SQL Editor, execute the following statements:


CREATE TABLE IDI_TOMBSTONE (ID INT PRIMARY KEY, COMPONENT_TYPE_ID INT, EVENT_TYPE_ID INT, START_TIME TIMESTAMP, CREATED_ON TIMESTAMP, COMPONENT_NAME VARCHAR(1024), CONFIGURATION VARCHAR(1024), EXIT_CODE INT, ERROR_DESCR VARCHAR(1024), STATS LONG VARBINARY, GUID VARCHAR(1024) NOT NULL, USER_MESSAGE VARCHAR(1024), UNIQUE (ID, GUID));

CREATE SEQUENCE tombseq;

"CREATE TRIGGER tombtrigger ON IDI_TOMBSTONE BEFORE INSERT REFERENCING NEW ID as new_id BEGIN EXEC SEQUENCE tombseq.NEXT INTO(new_id);END";

COMMIT WORK;


4. Verify the database details from the TDI Config Editor:

Verify the default server is started.
Right click on the default server > Edit System Store Settings

Click on Test Connection push button. The following message should be displayed.


Select the Browse Data push button to list the table names


NOTE(s):
  • Selecting Browse Data will list the tables. The Connect and Next push button, by default, will display values in the IDI_PS_Default regardless of the table name highlighted under JDBC Tables. To display attributes and values from another table, highlight the Connection tab and change the table name.



  • When the "Browse Server store" is chosen instead of "Edit System Store settings", the IDI_TOMBSTONE table is not listed, although the table has been created.


5. Verify tombstones are captured.
You can enable all tombstones to be captured via settings in the solution.properties file or in individual assembly lines.
  • Enable via solution.properties
    The solution property settings are listed here and commented by default.
    ## Tombstone Manager properties
    ## ---------------------

    com.ibm.di.tm.on=true
    com.ibm.di.tm.autodel.age=0
    com.ibm.di.tm.autodel.records.trigger.on=10000
    com.ibm.di.tm.autodel.records.max=5000
    com.ibm.di.tm.create.all=true
  • Enable an individual solution.
    Select Solution Logging and Settings > Tombstones Tab > enable
        Create Tombstones for Configuration
        Create Tombstones for all AssemblyLines

6. The statistics are stored as a binary array. You can view using the sample script code.

var stats = work.getObject("STATS");
if (stats != null) {
var ois = java.io.ObjectInputStream(java.io.ByteArrayInputStream(stats));
var statsEntry = ois.readObject();
task.logmsg("Stats are: ");
task.dumpEntry(statsEntry)
}

Related information

TDI 7.1.1 Admin Guide > System Store
IBM solidDB Information Center

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Security Directory Integrator
General

Software version:

7.1.1

Operating system(s):

Multi-Platform

Reference #:

1635023

Modified date:

2013-08-23

Translate my page

Machine Translation

Content navigation