Db2: Loading and unloading of data on remote clients with external tables

Unload Db2 data to remote client

Today, I am going to take a look at another variation of external tables. They can be used to load data from a remote Db2 client or unload data to that client - directly from or into a file. I tested it with the Db2 CLP and with a Python script and it was quite easy.

Simple container-based Minio deployment for Db2

MinIO console with Db2-generated files

You probably have read that I am testing Db2 external tables and remote storage. External tables are data files stored outside the database itself, either in the local file system or on (typically) S3-compatible object storage. To be able to test everything locally, even without Internet connectivity while traveling, I installed and configured MinIO. Here are the few steps to get it up and running as a Docker/podman deployment.

Once again: Db2 External Tables

Db2 log files and data on IBM COS

Today, I once again share some notes about Db2 External Tables. Recently, I set up Db2 12.1 Community Edition and had some time to "play" with external tables, multi-tenancy, and catalog tables. As this blog serves me as external memory :), here is what I need to remember...

Db2 12.1 Community Edition for Docker on Fedora

Db2 version 12.1 is ready for testing

Last November, Db2 v12.1 became generally available. It took some days before the containerized Db2 Community Edition was upgraded. Today, I pulled the new container image and installed it on my Fedora system with/in a Podman environment. Here is my quick writeup.