Modifying attribute-limits

Attributes identify the data that is stored by the counters. By default, the number of attributes is limited to five. You might want to increase the number of attributes and can do so by modifying a table definition in the database creation script.

About this task

To modify attribute-limits:

Procedure

  1. If your results database connection is valid, Rational® Integration Tester silently queries the attribute-limits. If the limits are exceeded, invalid rows are shown in red and no rows can be edited until the extra ones are removed.
  2. You can increase the number of attributes by modifying a table definition in the database creation script.

    The example that is shown is from the Oracle create script. (Some lines of SQL are omitted for brevity.)

    The ATTR_ID_6 entries show the lines that must be added to increase the number of attributes by one.

    
    CREATE TABLE "LOGMEASUREMENT_MRV"(
        "ID"          NUMBER(19, 0)    NOT NULL,
        "ATTR_ID_1"   NUMBER(19, 0),
        "ATTR_VAL_1"  VARCHAR2(255),
        ...
        "ATTR_ID_5"   NUMBER(19, 0),
        "ATTR_VAL_5"  VARCHAR2(255),
        "ATTR_ID_6"   NUMBER(19, 0),
        "ATTR_VAL_6"  VARCHAR2(255),
        CONSTRAINT "LOGMEASUREMENT_MRV_PK" PRIMARY KEY ("ID"), 
        FOREIGN KEY ("ATTR_ID_1")
        REFERENCES "COUNTER_DETAILS"("ID") ON DELETE CASCADE,
        ...
        FOREIGN KEY ("ATTR_ID_5")
        REFERENCES "COUNTER_DETAILS"("ID") ON DELETE CASCADE,
        FOREIGN KEY ("ATTR_ID_6")
        REFERENCES "COUNTER_DETAILS"("ID") ON DELETE CASCADE
    )
    ;
    
    Important: You can increase the table sizes even if the results database contains data. If you need help, consult your local database administrator (DBA).