Skip to content

DataGeek.blog

Db2 Experts on a Data Science Quest

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • Español

Tag: Windows

September 3, 2020 Uncategorized

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 which can cause an impact.… Read the rest

Continue reading »
June 19, 2019 Uncategorized

Working with Db2 copies …on Windows

How to investigate Db2 copies installed on a Windows system

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 »
August 30, 2016 Uncategorized

PowerShell Script for Local DB2 Database Activation

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 »
August 19, 2016 Uncategorized

The Database isn’t Available from Half the Servers – it Must be DB2

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 »
August 11, 2015 Uncategorized

PowerShell for DB2 DBAs – Part 1

Luke Numrych

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 »
August 4, 2015 Uncategorized

Multiple Instances in DB2 for Linux/UNIX and in DB2 for Windows

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.

The Basics

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 »
July 30, 2015 Uncategorized

Error When Running PowerShell Script with IBM.Data.DB2 Driver

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.

Problem

This genereally occurs when you are executing a PowerShell script using the IBM.Data.DB2… Read the rest

Continue reading »
April 14, 2015 Uncategorized

A Few Scripting Basics with DB2 and PowerShell

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 »
February 17, 2015 Uncategorized

Introduction to Using the PowerShell Command Line with DB2 on Windows

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 »

Search

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
 

Loading Comments...