views:

172

answers:

1

If you ask a DB2/zOS engine DBA a question about DB2's behavior, the DBA will refer to the DB2 engine as "he" much the way a sailor uses "she" to refer to his ship.

For example: "Once you fill the freespace, DB2 still wants to keep those rows in cluster order in the tablespace. That's why he'll split that page in half, and you end up with lots of half-empty pages. That is, unless the cluster key of the row you've just inserted is the highest in the table, in which case he makes a new empty page, and he puts just your new row into that page. So I wouldn't have to do this REORG if you would just sort your input like I suggested."

Does anyone know where this tradition comes from?

+5  A: 

This is certainly not a settled topic. There was a recent discussion on the DB2-L mailing list on this very topic, and Phil Grainger tallied the over 100 responses like this:

  • 29% said "DB2 is an it"
  • 25% said "DB2 is just DB2"
  • 21% said "Definitely a he"
  • 20% said "DB2 is a she"
  • Other 5% claimed that the question had never occurred to them

The poll is currently ongoing here.

Ian Bjorhovde
Sorry for my lack of DB2 culture but *is this a joke?*
Alexandre Jasmin