Author: Ember Crooks

2

DB2 Basics: Statement Terminators

The default statement terminator for DB2 on Linux, UNIX, and Windows platforms is the semi-colon (;). If you are executing a script of SQL using the -tf options, and do not specify an alternate terminator, DB2 will assume you are using the semi-colon. There are some statements that require semi-colons within the statements, though. For these kinds of statements, the...

1

Nothing Changed! A DB2 LUW Performance Investigation

I think that one of my least favorite phrases is “Nothing else changed!” More common than a performance problem that simply slowly creeps up with performance getting worse and worse over time is the sudden performance problem. Many times, sudden database performance problems can be mapped back to a specific change at some level. Nothing Changed! Other times, everyone involved...

20131107_101224 2

Ember’s Take on Monitoring DB2 LUW

I have some very specific perspectives on monitoring DB2. In addition to regular consulting in my day job, we also provide full-service virtual DBA services, including monitoring. The monitoring we choose to do is very much under my control, and I’m constantly working on enhancements. I thought I’d blog on what I like to monitor and alert on without going...

db2s_green 0

Ember Speaking at DB2 Symposium on 16 May

Once again this year, I’ll be speaking at the DB2 Symposium in Einhoven on 16 May! I’ll be giving a day-long intensive on DB2 Security, Performance, and a Touch of Cloud. I’ve been working hard on creating and polishing the presentation, and am quite excited to be including Jupyter Notebook topics in this presentation, in addition to the topics mentioned...

file0001332675785 0

db2setup on Windows – Repair Option

Sometimes with DB2 on Windows installs just don’t go right. There is a repair mode on db2setup that can help. The Problems There are a number of problems that can manifest. One is a completely successful install on Windows, but the menu items just don’t show up under “all programs” on the start menu. Today, I received this error message...