Selecting a data source

You can select your data source from any of the five tabbed pages presented on the Source page. Each data source type has its own set of required values that must be entered in order to properly access your data.

To select a single SQL statement:

In the Input SQL statements text box, enter one or more SQL statements that you want to tune.
Ensure the statement terminator character that you want to use appears in the field provided.
Ensure the default schema for the database you selected appears in the field provided. This value is used for any unqualified objects found in the SQL statements you submit.
Click Next to advance to the Scope page.

To select queries stored in a local file:

Click the Local File tab.
Click Browse And Upload Files.
From the File Upload box that appears, navigate to the file you want to load, select it and click Open.
Ensure the values are correct for the following properties:
- Statement terminator
- Encoding type
- Default schema
- Maximum number of statements (between 1 and 10,000)
Click Next to advance to the Scope page

To select statements from a user-defined repository:

Click the User defined repository tab.
In the fields provided, enter the qualifier and name of the table or view from which you want to capture runtime metrics or SQL text.
Note: The text of the SQL statements and the runtime metrics can be in more than one table. If this is the case, you will need to create a view that joins the tables on an ID that is unique to each set of runtime metrics, and you must have the SELECT privilege on that view.
For example:
```
CREATE VIEW
```
.(
```
SUBSYSTEM, PLANNAME, COLLID, PACKNAME, CONSISTOKEN, OWNER, TEXT, ID, SEQNO,
        SCHEMA, STARTINTERVAL, ENDINTERVAL, SECTNO, STMTNO, EXECCOUNT, CPUTIME, ELAPTIME, NGETPAGE,
        METRICID) AS ( SELECT 'db2subsys', 'plannam',A.COLLID, A.NAME, 'consistoken', C.OWNER,
        A.STATEMENT, A.STMT_ID, A.STMT_ID, C.OWNER, TIMESTAMP('2015-06-15 13:05:12'), TIMESTAMP('2015-06-15 14:05:12'),
        A.SECTNO,A.STMTNO,1, -1,-1,-1,-1 FROM SYSIBM.SYSPACKSTMT A,   SYSIBM.SYSPACKAGE C where
        A.COLLID=C.COLLID AND A.NAME=C.NAME AND C.NAME='AOC5OADM') ; 
```
where
- SUBSYSTEM is the Db2 subsystem from which the runtime metrics and SQL statements were collected [VARCHAR(128)]
- PLANNAME is the name of the plan [VARCHAR (128)]
- COLLID is the collection ID of the Db2 plan or package [VARCHAR (128)]
- PACKNAME is the name of the package [VARCHAR (128)]
- CONSISTOKEN is the consistency token for the DBRM or Db2 package [CHAR (8)]
- OWNER is the primary authorization ID used to run the statement [VARCHAR (128)]
- TEXT is all or part of the SQL statement [CLOB (2M), NOT NULL]
- ID is a unique value, used to identify fragments of the statement spread across different rows of a table (INTEGER)
- SEQNO is a to-be-deprecated value (INTEGER)
- SCHEMA is the value of the CURRENT SCHEMA special register
- STARTINTERVAL is the start time of the interval within which the runtime metrics were collected (TIMESTAMP)
- ENDINTERVAL is the end time of the interval within which the runtime metrics were collected (TIMESTAMP)
- SECTNO is the number of the section within the Db2 package where the SQL statement is located (SMALLINT)
- STMTNO is the number of the SQL statement within the package (SMALLINT)
- EXECCOUNT is the number of times that the SQL statement ran (BIGINT)
- CPUTIME is the amount of CPU time that was needed to run the statement the number of times specified by the EXECCOUNT property (FLOAT)
- ELAPTIME is the amount of Class 2 time that was needed to run the statement the number of times specified by the EXECCOUNT property (FLOAT)
- NGETPAGE is the number of getpage requests that were issued (BIGINT)
- METRICID is an ID, unique to the runtime metrics collected for the SQL statement, that is used to join a table of runtime metrics to a table of objects references by SQL statements in the repository database (INTEGER)
If using object filters, you will need to create a view, for example:

CREATE VIEW

.( OBJ_QUALIFIER, OBJ_NAME, OBJ_TYPE, DBNAME, TBSPNAME, OBJ_METRICID)
where
- OBJ_QUALIFIER is the qualifier or schema of the referenced object [VARCHAR (128)]
- OBJ_NAME is the name of the referenced object [VARCHAR (128)]
- OBJ_TYPE is the type of object referenced [VARCHAR (20)]:
  - T (table)
  - I (index)
  - D (database)
  - R (table space)
- DBNAME is the name of the database in which the referenced object is stored [(VARCHAR (20)]
- TBSPNANE is the name of the table space in which the referenced object is stored [VARCHAR (20)]
- OBJ_METRICID is a reference to the matching column in the repository database defined by the user (INTEGER)
Click Next to go to the Scope page.