Building CONNX for DB2 Sample Database Tables on Target Host via SNA APPC LU 6.2
These tables can be built during installation of the CONNX DB2 client, or later via the MS-DOS compatibility box command line. See
DB2 Host Configuration for configuration information before attempting to install the sample database tables.
1. During installation, click Yes to install the sample database tables, or go to Start > All Programs > CONNX Sample Databases > Build DB2 Sample Data.
You may also start an MS-DOS command prompt. To do so, go to the CONNX installation directory > Utils. From the MS-DOS command prompt. start the CONNX sample tables application using start sampgen db2.
2. The first DB2 Sample Database Logon dialog box appears after the prompt, before the installation completes, or if you selected Build DB2 Sample Data in the program group. Enter the DB2 RDBNAME and the logon information.
The Build Packages check box remains unchecked, which indicates that the DB2 dynamic SQL packages have already been built in the NULLID schema. These packages must be built prior to executing the DB2 sample application.
3. In the SNA Settings tab, the mode name is IBMRDB, which is the standard APPC mode name for DB2 access via DRDA and APPC. The Remote LU is defined in your communications vendor configuration. The Vendor Stack is the SNA vendor stack installed on your client machine.
4. Go to Settings and fill the required information.
All DB2 databases require three-part names for SQL objects, such as tables and views. A valid table name is as follows: Rdbname.schema.table.
If the Owner List field is left blank, CONNX creates the sample tables with the user ID as the schema/owner/library/collection name.
If the specified or default schema/owner/library/collection does not exist, the attempt to build the sample tables fails with a schema/owner/library/collection not found SQLState/SQLCode.
5. Click OK. The DB2 sample application connects to the target host and creates five tables in the target schema/owner/library/collection.
If run during CONNX installation, the DB2 sample application imports the sample table metadata into the Samples.CDD file in the \connx32\utils directory. If you can run the DB2 sample application from the command line, you can import the created tables into any CONNX CDD.