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