Welcome to Planet DB2
Sharing best practices and innovative approaches to the continually evolving world of mainframe database and Db2 technology.
Use alfaview on rpm-based Linux
Recently, I tried to prepare for an alfaview session. alfaview is a video conferencing system and used by the university where I teach data security. Only earlier this year alfaview introduced Linux support, and only for Debian-based systems. My system…
The DB2Night Show #227: A look at Graph and REST with Db2
Presented by: Dan Snoddy, Development Manager, IBM Toronto Lab
“The Db2Night Show 227: A look at Graph and REST with Db2” Replays available in WMV and M4V formats!
100% of our studio audience learned something!Dan discussed two exci…
DB2Night Show #Z109: Db2 for z/OS Utilities Hints and Tips
Presented by: Kai StrohUBS Hainer
“The DB2Night Show #Z109: Exploit DB2’s Log” Replays available in WMV & M4V formats and on Youtube!
100% of our studio audience learned something!Kai described the purpose and use of Db2’s log inform…
Convert Your COBOL Db2 Programs to Java Without Rebinding
As most Db2 developers and DBAs know, when you modify a Db2 program you have to prepare the program to enable it to be executed. This program preparation process requires running a series of code preprocessors that—when enacted in the proper sequ…
Planet Db2 is Back!
For those of you who were fans of the Planet Db2 blog aggregator, you’ll be happy to know that it is back up and operational, under new management. For those who do not know what I am talking about, for years Leo Petrazickis curated and managed the Pla…
Some fun digging into IBM Cloud access policies
On IBM Cloud, I have an account with multiple other users. To organize teamwork, I followed best practices for organizing users, teams, applications and made use of the IBM Cloud IAM (Identity and Access Management) capabilities.
With users, service …
Know Your Db2 Universal Table Spaces
One of the biggest changes in the last decade or so has been the introduction of new types of table spaces – known as Universal table spaces, or UTS. Not only are UTS new to Db2, they are quickly becoming the de facto standard type of table space…
What does SNAP_GET_DBM return in the COMM_PRIVATE_MEM element
I have been recently tasked with creation of an early warning solution for a memory condition from which some of our DB2 databases have been occasionally suffering. Once the condition is encountered, the only resolution is to restart the instance whic…
The Benefits of In-Memory Processing
One area that most organizations can benefit from is by better using system memory more effectively. This is so because accessing and manipulating data in memory is more efficient than doing so from disk. Think about it… There are three aspects of comp…
IBM Db2 on Cloud News
If you are thinking about, or have already adopted Db2 in the cloud, there is some recent news you should know about. But before we explore that news, let’s take a look at the quick highlights of using Db2 in the cloud.IBM’s Db2 on Cloud offering is a …
