IBM Db2 for IBMi

Data Connection Configuration

To connect to IBM Db2 for IBMi, complete the following fields in your data connection setup:

Replication Options

IBM Db2 for IBM i supports two types of replication connections:

• Continuous data replication
• Mainframe data replication

Configure the following fields for replication:

Manual Installation of Db2 Packages

When a Db2 for i (Db2i) database is used for the first time by the Progress JDBC driver, the driver automatically creates all required Db2 packages in the NULLID collection (library), provided the user has BINDADD privilege. Manual intervention is not required in most cases.

If you need to explicitly create packages, follow these steps to download and install the packages:

1. Download the save files

   Download the save files from: Progress iSeries Save Files

2. Create a library

   CRTLIB MYLIB

3. Create a save file in the library

   CRTSAVF MYLIB/DDJV6R1

4. Transfer the save file

   FTP the CfODBC DB2 SQL Package save file to the host system into the SAVEFILE you created in the previous step. Use binary mode for FTP. Select the file appropriate for your IBM i version:

   V7R1: DDJV7R1.savf 
   V6R1: DDJV6R1.savf 
   V5R4: DDJV5R4.savf 
   V5R3: DDJV5R3.savf 
   V5R2: DDJV5R2.savf
   ftp> bin
   200 Representation type is binary IMAGE.
   ftp> put DDJV6R1.savf /qsys.lib/mylib.lib/DDJV6R1.savf
   200 PORT subcommand request successful.
   150 Sending file to member DDJV6R1 in file DDJV6R1 in library MYLIB.
   226 File transfer completed successfully.                 

5. (Optional) Verify the save file transfer

   Log in to your host system and execute the following command to display the packages and verify the transfer:

   DSPSAVF MYLIB/DDJV6R1

   This command displays the saved objects:

   Display Saved Objects
   Library saved . . . . . . . : NULLID
   Type Options press Enter.
   5=Display
   Opt   Object    Type    Attribute Owner        Size (K)   Data
   DDJC510A  *SQLPKG PACKAGE   NCDDTEK            96   YES
   DDJC510B  *SQLPKG PACKAGE   NCDDTEK           100   YES
   DDJN510A  *SQLPKG PACKAGE   NCDDTEK            96   YES
   DDJN510B  *SQLPKG PACKAGE   NCDDTEK           100   YES
   DDJR510A  *SQLPKG PACKAGE   NCDDTEK            96   YES
   DDJR510B  *SQLPKG PACKAGE   NCDDTEK           100   YES
   DDJS510A  *SQLPKG PACKAGE   NCDDTEK            96   YES
   DDJS510B  *SQLPKG PACKAGE   NCDDTEK           100   YES
   DDJU510A  *SQLPKG PACKAGE   NCDDTEK            96   YES
   DDJU510B  *SQLPKG PACKAGE   NCDDTEK           100   YES                  

6. If necessary, create the NULLID library

   CRTLIB NULLID

7. Restore objects into the NULLID collection

   RSTOBJ OBJ(*ALL) SAVLIB(NULLID) DEV(*SAVF) SAVF(MYLIB/DDJV6R1)

8. Grant privileges to the PUBLIC group for all packages

   GRANT EXECUTE ON PACKAGE NULLID.DDJR510A TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJR510B TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJS510A TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJS510B TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJU510A TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJU510B TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJC510A TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJC510B TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJN510A TO PUBLIC
   GRANT EXECUTE ON PACKAGE NULLID.DDJN510B TO PUBLIC                  

IBMi System Restore Configuration for SQLPKG

This topic describes the required system values and restore parameters to be used when restoring save files containing *SQLPKG objects on the same IBM i system and the same OS release, including temporary changes and post-restore rollback steps.