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
  • November 21, 2019 Ember Crooks

    Backing up an RDS MS SQL Server Database to an S3 Bucket

    Note: I’m new to both MS SQL Server and to RDS databases. My base expertise is as a Db2 (LUW) DBA.

    There is a really complete document on this available from Amazon.

    Scenario

    In this scenario, I have just spun up a new RDS instance for a project using a CloudFormation template.… Read the rest

    Continue reading »
  • November 19, 2019 Ember Crooks

    Troubleshooting SQL0803N

    SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest

    Continue reading »
  • October 22, 2019 Ember Crooks

    Ember Changing Jobs

    I have left XTIVIA. This is nothing against XTIVIA or the wonderful people there, it’s just an evolution on what I want to do.

    5 years ago, when I started at XTIVIA, it was the perfect place for me at that time.… Read the rest

    Continue reading »
  • October 2, 2019 Ember Crooks

    DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space

    To Continue reading »
  • September 5, 2019 Ember Crooks

    Ember Speaking at Midwest Users Groups Meetings September 10 and 11

    One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.

    Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest

    Continue reading »
  • July 3, 2019 Ember Crooks

    Why dsmtop isn’t Even Half as Good as db2top

    I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients. These are the ones that really pay the developer’s salaries, after all.… Read the rest

    Continue reading »
  • June 20, 2019 Ember Crooks

    The DBA is Dead? No, the DBA as Gatekeeper is Dead!

    I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest

    Continue reading »
  • June 19, 2019 Luke Numrych

    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 »
December 10, 2019 Uncategorized

Db2 Basics: IBM IDs – How to Sign Up for One

IBM IDs are completely, 100% free. You pay with a bit of your personal information. You have to provide an email address and a first and last name.

Purpose

Those of us who have been working with (or for) IBM for years, really don’t even remember signing up because it is just a minor thing.… Read the rest

Continue reading »
December 5, 2019 Uncategorized

DataGeek to Start Offering Some Spanish Language Translations

Welcome readers! I have a friend who has offered to provide Spanish language translations of some blog entries. The list of entries to work through is long, so if you have any articles you’d particularly like to see in Spanish, please comment with them so we can add them to his list.… Read the rest

Continue reading »
November 21, 2019 Featured

Backing up an RDS MS SQL Server Database to an S3 Bucket

Note: I’m new to both MS SQL Server and to RDS databases. My base expertise is as a Db2 (LUW) DBA.

There is a really complete document on this available from Amazon.

Scenario

In this scenario, I have just spun up a new RDS instance for a project using a CloudFormation template.… Read the rest

Continue reading »
November 19, 2019 Featured

Troubleshooting SQL0803N

SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest

Continue reading »
October 22, 2019 Featured

Ember Changing Jobs

I have left XTIVIA. This is nothing against XTIVIA or the wonderful people there, it’s just an evolution on what I want to do.

5 years ago, when I started at XTIVIA, it was the perfect place for me at that time.… Read the rest

Continue reading »
October 2, 2019 Featured

DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space

To Continue reading »
September 5, 2019 Featured

Ember Speaking at Midwest Users Groups Meetings September 10 and 11

One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.

Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest

Continue reading »
July 3, 2019 Featured

Why dsmtop isn’t Even Half as Good as db2top

I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients. These are the ones that really pay the developer’s salaries, after all.… Read the rest

Continue reading »
June 20, 2019 Featured

The DBA is Dead? No, the DBA as Gatekeeper is Dead!

I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest

Continue reading »
June 19, 2019 Featured

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 »
June 11, 2019 Featured

Wrap-Up: IDUG Db2 North American Technical Conference in Charlotte

The IDUG Conference in Charlotte this year was one of the best-run North American Conferences I have been to. They rose close to the high standard that the IDUG European conference committee sets. I had fewer issues with how things ran.… Read the rest

Continue reading »
May 23, 2019 Uncategorized

IDUG NA Technical Conference in Charlotte, NC – June 2019

This is my regular pre-conference blog entry. I write these every year to share details about the conference and to share my excitement for this form of education and networking. The IDUG conferences in the US and Europe are my favorite weeks of the year.… Read the rest

Continue reading »

Posts navigation

1 2 3 … 45 Next Posts»

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