Test table definitions for the ODBC tuning utility (db2fedsvrcfg)
In some cases, you must create the test tables for the ODBC tuning utility manually. The test table definitions are described in this topic.
You must create the test tables for the ODBC tuning utility under
the following circumstances:
- If you want to use table names that are different from the default
- If the data source that you are accessing through ODBC is read-only
- If the ODBC tuning utility is unable to create the test tables that are required by the utility
The following table definition applies to all seven of the test tables that are needed (IITEST1 through IITEST7). The default table name prefix is IITEST and the default suffix is an empty string. If you specify a different prefix and suffix, you must specify the -prefix and -suffix options when you run the ODBC tuning utility.
Column name | SQL data type | SQL data type identifier | Length |
---|---|---|---|
IT1C1 | integer | SQL_INTEGER | |
IT1C2 | integer | SQL_INTEGER | |
IT1C3 | char(1) | SQL_CHAR | 1 |
IT1C4 | char(3) | SQL_CHAR | 3 |
IT1C5 | char(10) | SQL_CHAR | 10 |
IT1C6 | varchar(10) | SQL_VARCHAR | 10 |
IT1C7 | char(100) | SQL_CHAR | 100 |
Column name | SQL data type | SQL data type identifier | Length |
---|---|---|---|
IT2C1 | integer | SQL_INTEGER | |
IT2C2 | integer | SQL_INTEGER | |
IT2C3 | char(30) | SQL_CHAR | 30 |
Number of columns in each table | Column name | SQL data type | SQL data type identifier | Length |
---|---|---|---|---|
66 | ITxCn | char(100) | SQL_CHAR | 100 |
- x
- The number corresponding to the table that is being defined.
- n
- The column number.
For example, IT3C1 is the column name for the first column in table IITEST3.