Db2 Experts on a Data Science Quest
IBM has published a document with some additional best practices for configuring TSAMP, so I thought I would add an article to my TSA series covering these settings.
I have published several articles on PowerShell. But the “Hello, Db2 World!” series is designed to be a quick and fairly simple way of properly connecting to a Db2 database. Check out the GitHub repository folder for this blog entry.
One of the struggles for any well-employed person is to find time for further training and educating themselves. Thus I find that I make a lot of progress toward my data science learning goals on airplanes and from airports. I don’t travel a lot for work – maybe once a month this year or a bit less. But when I travel, the time in airports and on airplanes is some of that precious “me” time. Work generally does not expect me to be accomplishing much, and is slow enough that I’m not desperately logging into every WiFi I can find to get off one more email. There is no house to be cleaned or dinner to be cooked, or children or husband to play with or help or talk to.
Critical to recovering a database, but largely invisible, it is a good idea to understand the recovery history file, what it contains, and how to access it.
Connecting to a database is required before most actions can be taken on the database. A Db2 connection is made at the database level, and not at the instance or server level. This entry focuses on how to establish a connection to work with a Db2 database. It applies to Db2 for Linux, UNIX, or Windows.
This is one of those blog entries that I write and I know it will be obsolete and I will show my own ignorance and cringe at it in five years, but I have to write it anyway. I know that Iam biased. I come from a relational database background, and am working hard to open my mind the new data techniques that seem so popular these days.
IBM released fix pack 3, mod pack 3 for Db2 11.1 earlier this year, and there was a high-severity problem in the initial version of that fix pack. IBM fixed the problem and re-released the fix pack within about a day, but the bug was reported far and wide, while I’m not sure the resolution of the bug was, so I thought I’d cover it quickly.
What is an index in an RDBMS(Relational DataBase Management System), and what are the benefits and drawbacks of using an index? Why don’t we index everything? How is a clustered index different? Indexes are powerful tools in relational databases. They can speed up performance of queries exponentially, but they can also slow down inserts, updates, and deletes. Let’s take a look at indexing and why it is so important to RDBMS performance, good or bad.
I'm renaming db2commerce.com to datageek.blog - learn my motivations and my path going forward...
Database servers these days sometimes have a profusion of IP Addresses. IP V4, V6, management networks, and Virtual IP addresses all add to the ways applications connect in to a database server. I ran into an issue recently where I really needed to know what IP address was being used by an application, and thought I would share what I learned.
DB2 has one or two ports that it is listening on for each and every Db2 instance. Two Db2 instances cannot share a port to listen on. Remember that Db2 allows multiple instances per server and also multiple databases per instance, and has for years.
To list the database authorities held by an ID or group – authorities, not privileges. This information is not available in sysibmadm.privileges. The format of syscat.dbauth has columns with ‘Y’ or ‘N’ in them, and reading that quickly to answer the question “What permissions does this ID have?” can be a bit frustrating. This SQL could also be union-ed with SQL to query sysibmadm.privileges to include the privileges on database objects in one result set.