IDUG Blog for Beginners in Db2.
View All Blogs
Db2 for zOS V12 introduces a new UNLOAD authority permission for tables. This is “beside” the good-old-fashioned classic table authority permissions for SELECTAUTH, INSERTAUTH, DELETEAUTH, UPDATEAUTH, read more...
Partition By Growth Table Spaces - Partition 2, Living with PBGs In Part 1 of this blog we looked at the different ways to create or convert to Partition by Growth (PBG) table spaces. In this part we read more...
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 read more...
After a discussion with a friend, I came across an interesting article about the modern SQL in PostgreSQL (sorry the article is in czech). What raised my attention was a mention about the Lateral join read more...
Programmers, Take a Look at Db2 and SQL! It seems that at every customer site I visit the database administrators and application programmers are separated into “us and them”. Never the two groups read more...
It has been some time since the first part of this short series came out. The previous post reviewed SQL/XML functions and concluded our short series of basic introductions to XML support in Db2 for read more...
In the last two parts we covered XPath and XQuery expressions. Both expressions are heavily used in DB2 SQL/XML functions. This part follows up the previous articles and is dedicated to SQL/XML functions. read more...
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 read more...
10 questions to review and understand your active log data set configuration Alain Pary, dbizners The db2 logging process is an old strong process. You must take care of it because if all your read more...
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 read more...
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 read more...
Today’s post builds on the previous one , where the XPath was briefly introduced. It will introduce the XQuery language and cover a basic subset of this language, including constructor and FLWOR expressions. read more...