Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Microsoft training - Omni Loader
    • Synapse Dedicated Pool to Fabric Warehouse
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Connection Details
  • Server
  • Port
  • Username
  • Password
  • Database
  • Encryption
  1. Connections

DB2 iSeries

PreviousDatabricksNextDB2 LUW

Last updated 11 months ago

Connection Details

Server

Input the hostname or IP address of the system where the DB2 iSeries database is hosted.

Port

Enter the TCP/IP port number that the DB2 iSeries database listens on. The default port is often 8471 for non-encrypted connections and 9471 for encrypted connections, but it's crucial to verify the correct port for your setup.

Username

Provide the username with sufficient privileges to access the desired database on the DB2 iSeries server.

Password

Enter the password corresponding to the username provided.

Database

Type in the name of the specific database on the DB2 iSeries server you wish to connect to for data migration.

Encryption

Choose between Not encrypted and Encrypted to indicate if the connection should be secured with SSL. Selecting Encrypted is recommended for production environments to ensure data security.

Ensure that the users have the correct permissions to access the database and that the server information is accurate to prevent connection issues. Remind users to handle credentials securely and to use encryption whenever sensitive data is being transferred.