Db2 Experts on a Data Science Quest
According to one of the definitions from the UrbanDictionary, adding the words “in bed” to any sentence can make that sentence “more interesting”. I like to think that the Db2 LUW world equivalent of that is taking a task – such as working with Db2 copies – and adding words “…on Windows”.… 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 »
It is no secret that I’ve been doing more work with DB2 on Windows lately. I know a number of clients who are looking for DBAs with experience with DB2 on Windows and are frustrated that they cannot find more candidates.… Read the rest
Continue reading »
I get it. The database server is a single point in many environments that have many points at most levels. Therefore any problem that affects more than one point must be the database.
As DBAs, sometimes we feel the database is under attack.… Read the rest
Continue reading »
The database directory is something many of us use every day. It includes informaiton for connecting to databases, both local and remote, as well as additional information like alternate servers and filesystems where database directories reside. Getting just the local database names out of it may take a bit of practice.… Read the rest
Continue reading »
Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload. Of course, the benefits of scripting do not end there. … Read the rest
Continue reading »Having just solved this problem for the second time in two weeks, I thought I’d blog about it to make it easier to find the next time.
This genereally occurs when you are executing a PowerShell script using the IBM.Data.DB2… Read the rest
Continue reading »Not long ago, I posted some of the details of using PowerShell as your command line for DB2 on Windows. I am definitely addicted to PowerShell as my command line when I have to work on Windows servers.
I also have to write some scripts for some Windows systems.… Read the rest
Continue reading »One of the awesome things about running scripts locally on a DB2 server is that if they’re run as a privileged user, you do not have to specify the password. This makes for easier scripting without storing or encrypting passwords. When I first connected to a database with PowerShell, it took me a bit to figure out how to do the password-less local connection, so I thought I would share.… Read the rest
Continue reading »
I have worked with DB2 on Windows on and off over the years and have largely not enjoyed it all that much. Most likely because the vast majority of my time is spent on UNIX and Linux systems, so when I end up at a windows command line, my fingers type things like “ls” and “grep” before I can even stop them.… Read the rest
Continue reading »