Db2 Experts on a Data Science Quest
Well, I knew it was going to be slow, and that is part of why my plan is a 20-year plan instead of just a short-term plan. The fall was particularly difficult due to a couple of issues at work and two conferences that I absolutely loved, but that took time away from the already 60-hour work weeks that I needed to be putting in.… Read the rest
Continue reading »For more than 5 years I’ve managed to average at least one blog entry a week through fluctuating workloads and even through changing employers. And then came this autumn. The combination of a couple of large clients and going into holiday peak period for a couple of retail clients, collided with the IDUG EMEA conference where I was presenting two new sessions nearly combined to do me in.… Read the rest
Continue reading »
When I was in my early thirties, I was diagnosed with a learning disability. This really put my learning style into perspective. Teaching myself via a book was incredibly hard, and still is in some ways. Where I thrived was with hands on labs and engaging speakers.… Read the rest
Continue reading »
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.
Note that before starting, you should have a Db2 Client installed on the server you wish to connect from.… Read the rest
Continue reading »
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. … Read the rest
Continue reading »
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.
The recovery history file is one of the many files associated with a database, but it is one of the most important.… Read the rest
Continue reading »
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.… Read the rest
Continue reading »
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.… Read the rest
Continue reading »
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.… Read the rest
Continue reading »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.… Read the rest
Continue reading »