Db2 Experts on a Data Science Quest
This is the third time I have written this post. It keeps changing, so I keep sharing.
I work from home, so downloading software to my laptop and then uploading it to a server is not very efficient. Download speeds aren’t bad, but uploading can take 8 hours or more, depending on the client.… Read the rest
Continue reading »
I ran into this error message recently and thought I’d describe what the issue was.
I was building a new consolidated development database server for a client – moving away from 10 separate database servers to one (big) VM to run their development workloads.… Read the rest
Continue reading »
Updated 11/22/2017: instructions on how to run the SQL statement
There are a number of places where we can store and change configuration for a Db2 server. I wanted to walk through the main areas and a few details about them.… Read the rest
Continue reading »
There are plenty of things that I want to try in a sandbox VM before I let them anywhere near even a development environment. Even if I didn’t use it constantly for blogging, I would still need it for trying things to see how they work before advising clients.… Read the rest
Continue reading »
I ran into an interesting problem installing 11.1, fix/mod pack 1 on Ubuntu, and thought I would share. Please read to the bottom before trying anything, as this entry goes through things I tried that did not work before I got to what did work.… Read the rest
Continue reading »
Like any software, DB2 requires frequent patching. A database should be one of the most secure parts of any enterprise, and keeping it secure means keeping up with the fixes that are delivered in fix packs.
DB2 delivers many things through fixpacks, including:
IBM delivered Native Encryption in Fix Pack 5 of DB2 10.5.… Read the rest
Continue reading »
I can’t say that I work with federation on a daily basis. I have, however, set up federation for an Oracle data source from top to bottom, and support at least one system on a daily basis that uses federation to access Oracle, Informix, and DB2 for AS/400.… Read the rest
Continue reading »I have been working with multiple instances on Windows servers lately, and have learned a few things about them, so I thought an article about multiple instances in general would be a good thing.
First, if you don’t understand what an instance is, check out my earlier blog entry: DB2 Basics: What is an Instance?… Read the rest
Continue reading »DB2 doesn’t have any defaults for filesystems because that is an OS-level thing. However, there are a few sanity checks and some recommeded separation when installing DB2 on Linux and UNIX operating systems. These are my best practices for installations, in general terms.… Read the rest
Continue reading »I was a bit shocked when I searched my own blog for entries on db2look and came up with nothing. While it’s not a complicated tool, db2look is an essential tool.
db2look is a tool provided with DB2.… Read the rest
Continue reading »I have not made extensive use of the HADR Tools that IBM offers in the past. Most of my HADR setups to date have either been same-data-center using NEARSYNC or have used ASYNC to copy data between data centers. I haven’t had much cause to tweak my network settings or change my SYNCMODE settings based on hardware/networking.… Read the rest
Continue reading »
Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments.… Read the rest