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...
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...
2 Comments - no search term matches found in comments.
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...
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...
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...
1 Comment - no search term matches found in comments.
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...
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...
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? ...
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...
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...