Using IBM Db2 LUW as a source for AWS SCT

27 July,2022 by Tom Collins

Thinking of migrating DB2 LUW to AWS ?  AWS Schema Conversion Tool (SCT)  is useful for the health assessment & schema conversion .   For a deeper dive into AWS  SCT use the link below in the useful links section

The AWS SCT tool only supports DB2 LUW as a source  , not as a target database.    A typical scenario may be AWS SCT DB2 LUW to PostgreSQL migration 

To setup a source connection to a DB2 LUW server and database

Step 1 : Download valid drivers to connect to the server and connect to the database . This link will take you through to an AWS page listing links to drivers sources . Look for the Database Engine - IBM Db2 LUW.   Drivers - db2jcc-db2jcc4.jar

Downloading the required database drivers 

 

Step 2: Add the correct file path reference in the AWS SCT Global Settings for the DB2 driver path 

Aws_sct_global_settings_db2_driver_path

 

Step 3:  Privileges for DB2 LUW as a source  & Connecting to Db2 LUW as a source    use this link to the AWS site  to detailed information 

Using IBM Db2 LUW as a source for AWS SCT

 

Useful links 

Dive deep into database migration services AWS DMS and AWS SCT

Author: Rambler(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Using IBM Db2 LUW as a source for AWS SCT

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright