Search

1 to 10 of 10
Sort by

Blog Entry
Partition By Growth Table Spaces - Partition 1, Getting Started

Partition By Growth Table Spaces - Partition 1, Getting Started Universal Table Space (UTS) Universal Table Spaces (UTS) were introduced in Db2 9 to bring together the advantages of partitioned table spaces, where you can have a capacity >64Gb, and segmented table...

Julia Carter's profile image

Blog Entry
Introduction to Db2 for z/OS System Profiles

System profiles are available as of Db2 for z/OS version 9, but they are still not widely used and known. However they represent quite a strong Db2 capability that can help you with a variety of needs such as managing and monitoring Db2 connections, modelling production environment, tuning...

Denis Tronin's profile image

Blog Entry
DB2 for z/OS query support over FTP

There are many types of DB2 applications, from batch to online to data warehouse to analytics to data science, you name it, there are as many types as you can think of. In this day and age, though, there are a growing number of applications that require the transmission of query results to other...


Blog Entry
Managing Multiple DB2 Instances

Managing Multiple DB2 Instances Although it may not always be considered to be a best practice, I frequently find myself working on servers with multiple DB2 instances, and I need to switch between managing databases in the different instances quite frequently. I have seen some DBAs manage...

Ian Bjorhovde's profile image

Blog Entry
Introduction to XML in DB2 11 for z/OS - Part 1

Introduction to XML in DB2 11 for z/OS – Part 1 Have you ever thought about using XML in DB2 for z/OS, but were afraid that you would need to study a lot of material before you could actually begin? Don’t worry! You do not need to know much before you start. You can get by with basic DB2 for...

Jan Marek's profile image

Blog Entry
Introduction to DB2 for z/OS Performance Monitoring - by Denis Tronin

Let’s speak today about database monitoring. DB2 is usually presented as a black box that stores and retrieves data for you. Usually we don’t care much about what is happening inside it. However as soon as a trouble arises, information about its internals becomes critical. How many connections...

Denis Tronin's profile image

Blog Entry
What Does a DB2 Beginner Need to Learn?

There are several categories of DB2 beginner. You might be a novice programmer, or an experienced programmer who is new to database access. Or, you might have experience with a different DBMS, but not DB2. Others might be new DBAs, either with or without programming experience. How long do...

Joe Geller's profile image

Blog Entry
Key Pieces - An Introduction to the Primary and Foreign Key

Imagine a student who has taken a few semesters of a foreign language – they have covered the basics of reading, writing, and conversation. They have learned about the culture of the lands that speak the foreign language. Are they fluent? No. Could they pass as a native on the street? ...

Archive User's profile image

Blog Entry
The DB2 Family

When dealing with DB2 it is first important to understand which member of the DB2 “family” you are working with. While the DB2 brand is used on a variety of platforms the underlying infrastructure is somewhat different on each. There are 4 flavors of the DB2 product but most of the material...

David Simpson's profile image

Blog Entry
Welcome!

Welcome to the DB2 Beginner's Blog! We are planning some great content for people who are new to DB2 on all platforms in any job responsibility. Check the classification of each post to see what may apply to your situation. Some of the content here will be original and sometimes we will...

David Simpson's profile image