Importing from a DB2 Database
See CONNX and DB2 for information about security requirements and how the CONNX DB2 module works.
To import from DB2:
1. Go to the main online CONNX Data Dictionary Manager page.
You can select CONNX Data Dictionary from the home page or the tile menu on the top right.
2. Browse to the CDD you want to import in and open it.
3. Click the Import button.
4. In the Import Type window, select DB2 from the dropdown menu and click OK.
5. In the Connection Information step, fill in the connection information in the respective fields and click Next:
a. The server address in the Server field.
b. The username for the server in the Username field.
c. The password for the server in the Password field.
d. The DRDA TCP/IP port in the DRDA TCP/IP Port field.
e. The DB2 database name in the DB2 Database Name field.
f. Select an authentication method from the dropdown menu. For information about the authentication methods, see the DB2 documentation.
g. Turn the Use TLS/SSL option on if you want to use that functionality.
6. In the Import Properties step, choose whether to include system tables and get statistics.
Turn the Include System Tables option on if you want to import the system table metadata into the CDD.
Turn the Get Statistics option on if you want to retrieve the number of rows per table along with index and key information. Click Next when you are done.
7. In the DB2 Options step, do the following:
a. Turn the Build Packages for Dynamic SQL Execution option on if you want to build a set of dynamic SQL packages that CONNX will use for future connection attempts. See CONNX Db2 Dynamic SQL Packages for more information.
This function is a one-time operation that can be performed by a DB2 administrator on the initial import.
b. If this is the first import session for this database, specify the owner, library, or collection name in the Owner/Library text box. The default value is NULLID.
c. Use the Set Current SQLID field if you need to issue a Set Current SQLID command at connect time.
d. If you want to filter the initial import list, type a schema list in the Owner List field.
e. Choose cursor behavior.
Click the Close on Commit radio button if you want to map all dynamic SQL SELECT statements to cursors that close after a commit is issued.
Click the Preserve on Commit radio button if you want to map all dynamic SQL SELECT statements to "sticky" cursors that hold their positions across commits. This is the preferred curosr behavior for Microsoft Access and Visual Basic dynaset processing. See CONNX with Microsoft Access and Visual Basic for more information.
f. Turn the AS/400 Plug-And-Play Mode option on if you want to enable each connection to create dynamic SQL packages as needed in the per-connection QTEMP scratch pad. This option makes it so your user ID does not require BIND and GRANT privileges.
g. Turn the Convert Binary to Character option on if you want to translate SQL BINARY/VARBINARY, or LONGVARBINARY column data from the host code page to the PC character code page.
h. Select a Job Priority from the dropdown menu.
Selecting an option different from default causes CONNX to issue an OS/400 CHGJOB remote command to alter the job run priority, where 1=highest job run priority.
i. Enter the schema name in the Shadow Catalog Prefix field if you have a DB2 installation that makes periodic copies of the SYSIBM.* metadata.
j. Turn the Enable Tracing to CNXDB2.TRC option on to have CONNX write a binary trace of all sent/received messages via either TCP/IP or APPC/SNA LU 6.2 to the cnxdb2.trc file and all executed SQL statements to the cnxdb2.sql file in the 32bit CONNX installation directory.
Use this feature only when you need to troubleshoot and turn it off when you've solved your issue.
k. Click Next when done.
8. In the Table Selection step, mark the tables you want to import in the Available Table(s) pane and press the arrow pointing to the right to move them to the Selected Table(s) pane.
You can use the search field in the Available Table(s) pane to filter the list of tables.
You can mark all tables in a pane by clicking the checkmark next to the Available Table(s) or Selected Table(s) entry.
You can move tables back from the Selected Table(s) pane by marking the tables and clicking the arrow pointing to the left.
9. Click Done to finish the import procedure.