DataGeek.blog

December 20, 2011 Uncategorized

Naming Standards in WebSphere Commerce Databases

So this is a good page in the Commerce info center. It sets forth naming standards for custom objects in WebSphere Commerce databases. I know for a fact that other naming standards work in daily operation. I wonder if using these naming standards makes upgrades go more smoothly (or like some Commerce features that is an intended future use of these).… Read the rest

December 15, 2011 Uncategorized

An interesting post on Craig S Mullins’ Blog

So Craig S Mullins is a mainframe DB2 DBA blogger and author- though he writes some cross platform stuff (and even cross-RDBMS stuff), and I’ve read his stuff off and on over the years. He has a good post out about how understanding database technology is not enough: http://datatechnologytoday.wordpress.com/2011/12/14/business-eye-for-the-dba-guy/… Read the rest

December 12, 2011 Uncategorized

The WebSphere Commerce Data Model

So I have several posts already on this topic. It’s a big topic, and I imagine I’ll write many more posts on it. But I thought something kind of general would be good.

I’ve talked about 10 Commerce Tables You Should Be Familiar With, and about making alterations to Commerce objects, and about general observations about Commerce databases.… Read the rest

December 8, 2011 Uncategorized

Come listen to me on the DB2Night Show

So I’ve got a spot coming up on the DB2Night Show – a popular db2 webcast. I’ll be talking about tips for e-commerce databases in general, not just for WebSphere Commerce databases. Come and listen!

The DB2Night Show Episode #66: Top 10 tips for E-commerce Databases with guest Ember Crooks

Join us for a Webinar on January 6

Space is limited.

… Read the rest Continue reading »

December 7, 2011 Uncategorized

The basics of Index Design for DB2

The keyword in the title of this post is “basics”. I spend some time training SQL Server or Oracle DBAs on DB2, and so this is the answer on the most basic level to how to identify indexes to add. There are certainly greater experts on this topic than me, so I don’t claim to have a comprehensive view on Indexing.… Read the rest

December 6, 2011 Uncategorized

Commerce Database Facts

So these are miscellaneous things that I sometimes note about Commerce databases. Though some of the details here may reference DB2, the basic facts are RDBMS-independent, so they would be true for Oracle Commerce databases as well as DB2 ones.

Most tables have generated primary keys

Commerce tends to use sequential numbers for most primary keys, or as a component of a composite primary key.… Read the rest

December 1, 2011 Uncategorized

SQL Analysis Overview

So I thought I’d do a short series on analyzing SQL. I want to focus on some of the techniques I use, so not necessarily everything you could know about it, but some basics on one way to do it.

I’m going to focus on what you can do manually with no pay-for-use or even tools that require additional installation tasks.

… Read the rest Continue reading »

November 29, 2011 Uncategorized

Identifying Problem SQL

Many DBAs have their own methods and approaches in this area, but there are some basic sources and methods that I use. I’ll cover at least the basics of SQL analysis in one or more future posts

Get SQL from Developers

So the optimum situation is that your developers give you the SQL they’re planning to use in custom code (or better yet, they have a dba write it in the first place).… Read the rest

October 13, 2011 Uncategorized

How to Download DB2 FixPacks via FTP

Edited 2018-02-01. This post is obsolete. For the best way to use FTPS to get fix packs direct to a server, see: Using FTPS to get a Fix Pack Directly to a Db2 Server

Just a simple post here, but you used to be able to fairly easily find the link for FTPing Fix Packs.… Read the rest

September 29, 2011 Uncategorized

Top 10 tips for SQL performance on DB2

Ok, so everyone has their top 10, and some of them are significantly different – but here’s my top 10 on SQL performance for DB2. I mostly share this information with developers, but it’s important for a DBA to be aware of these things.… Read the rest

September 28, 2011 Uncategorized

What are Parameter Markers?

Parameter Markers

Parameter Markers show up as ? in queries when you look at them in a dynamic SQL snapshot or in the sysibmadm views. They show up when the value for a variable is not hard-coded at the time of preparation, but instead is changeable at execution time.… Read the rest

September 15, 2011 Uncategorized

Holiday Preparation

What do you do to prepare for the holidays? We’re starting to think about Black Friday for our retail clients in September or maybe even August. Each business has its Black Friday equivalent – the few days each year that account for 5%(or more) of your online revenue for the year – even if they aren’t anywhere near November.… Read the rest

DataGeek.blog

MySQL’s “partial” Group By

Using ChatGPT to Write SQL

Introducing: Roll for Database!

Comparing Db2 and MySQL: Naming Objects and Reserved Words

Db2 Basics: Getting Data Out of Db2

Comparing Db2 and MySQL: Explain

Comparing Db2 and MySQL: NULL in Indexes

Comparing MySQL and Db2: Table and Index Structure

Naming Standards in WebSphere Commerce Databases

An interesting post on Craig S Mullins’ Blog

The WebSphere Commerce Data Model

Come listen to me on the DB2Night Show

The basics of Index Design for DB2

Commerce Database Facts

Most tables have generated primary keys

SQL Analysis Overview

Identifying Problem SQL

Get SQL from Developers

How to Download DB2 FixPacks via FTP

Top 10 tips for SQL performance on DB2

What are Parameter Markers?

Parameter Markers

Holiday Preparation