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.

Table 1. ODBC tuning utility test table definition for the table IITEST1
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
Table 2. ODBC tuning utility test table definition for the table IITEST2
Column name SQL data type SQL data type identifier Length
IT2C1 integer SQL_INTEGER  
IT2C2 integer SQL_INTEGER  
IT2C3 char(30) SQL_CHAR 30
Table 3. ODBC tuning utility test table definition for the tables IITEST3 through IITEST7
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.