Tag: IBM

Community

Improve DB2 Connect Performance

(Kondal) In day-to-day activities we run into different issues one of them is Performance issue. As a DBA you have to look into every possible place to improve database performance. One of them is to implement DB2 Connection Pooling and Connection Concentrator to improve database performance of appl

Community

The Mainframe DBA Exam

(Howard Fosdick) IBM splits its DB2 Universal Database certifications for DBAs into two paths: one for Linux, Unix, and Windows (LUW) and another for DB2 UDB for z/OS. I covered the LUW path in an earlier column. In this column, I’ll focus on tips for becoming a certified DB2 DBA for z/OS.

Community

Utilizing Triggers within DB2

(Aleksey Shevchenko) I have been recently challenged with implementing an enhancement to an existing Web application and a batch process. Similar to many applications that I encounter in my everyday professional life, this application is poorly written and lacks any basic documentation and source co

Community

High-Performance ETL

(Roger Deng) DB2 Universal Database Enterprise Server Edition (ESE) with the Database Partitioning Feature uses an architecture that’s optimized for scalability and high performance in a partitioned environment — in other words, one that’s perfect for extract, transform, and load (ETL) projects. ETL