To build CONNX for DB2 sample database tables on the 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 Step 8 - DB2 Host Configuration for configuration information before attempting to install the sample database tables.

  1. During installation, click Yes to install sample database tables, or click the Start button, and then point to All Programs. Point to CONNX Sample Databases,  and click Build DB2 Sample Data. You may also start an MS-DOS command prompt, and then go to the CONNX installation directory. Select the Utils subdirectory, for example, C:\connx32\Utils. From the MS-DOS command prompt, start the CONNX sample tables application by typing start sampgen db2

  2. The first DB2 Sample Database Logon dialog box appears after the prompt, before installation completes, or if you selected Build DB2 Sample Data in the program group.

    In this example, the RDBNAME is an example; substitute the RDBNAME or location name of the target DB2 host.

  3. Click 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 an example; substitute values defined in your communications vendor configuration. The Vendor Stack is an example; select the SNA vendor stack installed on your client machine.

    image\db2smp03.gif

  4. Click the Settings tab.

    image\db2smp04.gif

    The owner list shows a sample schema name = CONNXDB2. All DB2 databases require three-part names for SQL objects such as tables and views. A fully qualified table name is as follows:

    Rdbname.schema.table


    where, for example,

    Rdbname = sample
    schema = connxdb2
    table = customers_db2


    If the Owner List is left blank, CONNX DB2 creates the sample tables with the userid as the schema/owner/library/collection name; hence the above table is created as

    Sample.connx.customers_db2


    If the specified 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 the OK button. 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. Refer to the CONNX User Reference Guide, which can be found online, in the CONNX product, and on the CONNX CD-ROM for a detailed explanation of import procedures.