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.
To modify attribute-limits:
- If your results database connection is valid,
IBM® DevOps Test Integrations and APIs (Test Integrations and APIs) 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).