IBM Data ReplicationのChange Data Captureを使って、Db2のデータとスキーマ情報をIBM Event Streamsに連携し、Kafka Connect Sink JDBC Connectorを使って、SQL Serverにリアルタイムレプリケーションを行う。 概要 このブログでは、 IBM Data Replication の強力な**Change Data Capture (CDC)**機能を利用し、 Db2 データベースのデータとスキーマの変更をリアルタイムで捕捉・連携する手法を解説します。 連携先として...
Db2 z/OS 13 - using profiles to monitor/block unsecure TCPIP connectivity Db2 13 added enhancements to this feature starting in FL504 or through APAR PH48764. This enables monitoring and blocking unsecure distributed connectivity. Db2 system profiles are a powerful yet flexible tool that’s been...
1313 IBM_TechXchange_2025_Secure Port Profiles v2_1757016428634001iUpm.pdf
Whether you are moving to cloud, another platform or fixing a tablespace, data movement is a basic task for a DBA. When the database becomes more complex, bigger in size and very active, it becomes a very difficult and time-consuming task. I'll share my own home grown CDC including how to use...
1334+-+All-Inclusive+Db2+Data+Movement+tools.pdf
This presentation will review DBA solutions that have been developed and implemented to enhance the administration of Db2 Z/OS systems. These solutions have been implemented at Navy Federal Credit Union with Db2 V12 and V13 mission critical applications. Db2 features such as SQL to review object...
1351 DIY Db2 Administration Solutions_1756483958822001gqTK.pdf
The use of Artificial Intelligence (AI) for optimizing IT operations is a trending topic in the industry over the last years. Join this session to learn how HUK-COBURG, the largest German car insurance company, leverages IBM Db2 AI for z/OS to enhance their SQL application performance, CPU...
1523 Get the most out of your Db2 system with AI ΓÇô a Db2 AI for zOS success story @ HUK-COBURG_1756974285945001Ht7H.pdf
Integrating IBM Db2 Query Monitor, SQL Performance Analyzer and the Db2 Admin Tool over the past year has been a key objective. In this Session, I’ll show you the latest enhancements and explore synergies between these key IBM Db2 products. We will discuss the setup requirements and how to...
1168 IBM Turns a Triple Play_1757601980887001noxB.pdf
Database Security is the most important aspect for the business and specially, your business faces international audience. We have developed one of the most secured database offerings using all the latest available technologies and, looking forward to quantum security. This will be a great...
1335+-+Beyond+Comfort+Zone+-++Highly+Secured+Db2+on+Prem+and+Cloud.pdf
We don’t have highly complex and active database with 7 billion SQL per day with above 2 TB of transaction logs per day, we manage 250 databases and 300 clients. Managing all configuration and upgrades by few DBAs with 100% accuracy is a tall task. I have developed a system, using JSON and...
1274+-+Db2+Auto-Upgrade+and+Auto-Config+using+Python.pdf