If you ask the DB2 / zOS DBA about the behavior of DB2, the database administrator will refer to the DB2 engine as “he”, just as the sailor uses “she” to indicate his ship.
For example: “When you populate freespace, DB2 still wants to keep these rows in cluster order in the table space. Therefore, it will split this page in half and you will get many half-empty pages. That is, if the cluster key of the row you just inserted is the highest in the table, in which case it creates a new blank page, and it only puts your new row on this page. So I wouldn’t have to do this REORG if you just sorted your input as I suggested. "
Does anyone know where this tradition comes from?
source
share