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
  • January 31, 2023 Ember Crooks

    MySQL’s “partial” Group By

    This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2 and most RDBMSes do not allow.… Read the rest

    Continue reading »
  • January 26, 2023 Ember Crooks

    Using ChatGPT to Write SQL

    Working in technology, I’ve heard a number of things about ChatGPT from various news sources.

    I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I heard a teacher talking about how this was the new ‘calculator’ that teachers need to learn how to leverage in their curriculums.… Read the rest

    Continue reading »
  • January 18, 2023 Ember Crooks

    Introducing: Roll for Database!

    Alright, so I’m playing around with something. I’ve developed a bit of a TikTok addiction after exploring the platform to connect with my 14-year-old. One of the post types I’ve enjoyed is the “Roll for ______” type, where the content creator uses dice typical to Dungeons and Dragons to choose combinations of things that are sometimes magical, sometimes ridiculous, and occasionally disgusting.… Read the rest

    Continue reading »
  • December 6, 2022 Ember Crooks

    Comparing Db2 and MySQL: Naming Objects and Reserved Words

    Every RDBMS has areas where the differences from other RDBMSes are noticeable, and this is one of them between Db2 and MySQL. Most RDBMSes have quirks to the way SQL is written, and this is certainly true of Db2 where some things were there before the SQL-92 standard or other standards existed.… Read the rest

    Continue reading »
  • December 1, 2022 Ember Crooks

    Db2 Basics: Getting Data Out of Db2

    One of the things that learning a new platform (MySQL) has taught me is just how critical the most basic topics are, so I thought I’d do an overview of how to get data out of a Db2 (on Linux, Unix, or Windows) database.… Read the rest

    Continue reading »
  • November 8, 2022 Ember Crooks

    Comparing Db2 and MySQL: Explain

    The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for the query and why.… Read the rest

    Continue reading »
  • November 3, 2022 Ember Crooks

    Comparing Db2 and MySQL: NULL in Indexes

    I’ve been spending some time working with indexes as I learn MySQL, and there were a few things I thought were were worth mentioning. As always, I’m writing from my own knowledge with deep experience in IBM DB2, and as a learner when it comes to MySQL.… Read the rest

    Continue reading »
  • October 27, 2022 Ember Crooks

    Comparing MySQL and Db2: Table and Index Structure

    I’ve spent some time understanding how MySQL structures tables and indexes, and wanted to share what I’ve learned. This is not the structure as created in the CREATE TABLE or CREATE INDEX statements, but how that data is generally structured on disk, both logically and physically.… Read the rest

    Continue reading »
March 7, 2011 Uncategorized

What to do when DB2 won’t work

This probably falls more in the DB2 newbie category, but I suspect I may have some readers who are DB2 newbies or at least not veterans.

Several years ago (ok, probably more than 5), DB2 seemed to be considering a “Problem Determination Mastery” certification.… Read the rest

Continue reading »
March 4, 2011 Uncategorized

The role of the DBA in supporting WebSphere Commerce

I have generally been a bit disappointed on the information coming out of IBM on supporting Commerce databases. I also meet clients who don’t believe they need a dba or that they can hire someone out of college or with minimal database experience to fill such a role.… Read the rest

Continue reading »
March 2, 2011 Uncategorized

Data Movement Options for Commerce Databases – Synchronizing Data Between Commerce Environments

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR.… Read the rest

Continue reading »
March 1, 2011 Uncategorized

Never do runstats on volatile tables

Ok, so everyone will tell you that it doesn’t matter if you do runstats on volatile tables. The volatile flag is supposed to tell DB2 that the statistics are absolutely not correct, and heavily bias db2 to use indexes over table scans.… Read the rest

Continue reading »
February 28, 2011 Uncategorized

DB2 and Transparent LDAP

Ok, so I know I’m in the middle of a multi-part post on Data Movement between Commerce databases (and I will get back to that), but I found this and had to share it because I’m so excited DB2 has finally added support for it.… Read the rest

Continue reading »
February 25, 2011 Uncategorized

Data Movement Options for Commerce Databases – Creation of staging database during build

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR.… Read the rest

Continue reading »
February 17, 2011 Uncategorized

Stagingprop – SQL0803 – a rarer cause

I went through the most common cause of SQL0803 back in a previous post. There’s a rarer cause that can look very similar, and I thought I’d detail it.

What this problem looks like:

The following appears in the stagingprop log.… Read the rest

Continue reading »
July 16, 2010 Uncategorized

I tried Data Studio, I really did.

The attempt to like a GUI falls flat again. Continue reading »
July 14, 2010 Uncategorized

Popping the Stored Procedure Cherry

A first experience with creating stored proceedures. Continue reading »
June 16, 2010 Uncategorized

Stagingprop – SQL0803 “oops, you inserted data directly on production”

So I plan to go through some of the stagingprop problems I've seen - especially the more common ones. This is probably the most common of all, especially if the java developers you're working with have not used Commerce and particularly stagingprop before. Continue reading »
June 15, 2010 Uncategorized

Stagingprop – the high-level explanation

So every client I support has issues with stagingprop at some point. The vast majority of them are due to mistakes made in the development process. Many developers do not fully understand what stagingprop does, so here's a general description that might help. Continue reading »
June 7, 2010 Uncategorized

Registry Variables and DB2_WORKLOAD=WC

I was happy to see the new workload registry variable in Commerce 7/DB2 9. Mostly out of laziness – it requires fewer variables to be set manually, but it also ensures that nothing major is missed (I imagine they may come up with more that won’t be added to the workload registry variable in real time).… Read the rest

Continue reading »

Posts navigation

«Previous Posts 1 … 46 47 48 49 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
 

Loading Comments...