Author: Ember Crooks

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...

select2 0

DB2 Administrative SQL Cookbook: Generating a Comma Separated List of Columns in a MON_GET Table Function

Purpose To generate a comma separated list of columns in a MON_GET table function, in the same order you should get the columns if you query the table. This SQL should handle larger tables like MON_GET_DATABASE that have a very large number of columns. This is especially useful when pulling data into Excel to play with it or getting it...

804b26eba5cc743127edb24221f259aa 2

SQL0752N on Rollforward After Redirected Restore

I’d like to think that I’m pretty decent at backup and recovery. I’ve done hundreds of restores in my career in a vast array of scenarios for real-world recovery, data movement, and fixing developers’ mistakes. Today I saw an error I’ve never seen before, so I thought I’d share. The Scenario This restore was grabbing an older backup image from...

select2 0

DB2 Administrative SQL Cookbook: When Were Runstats Done (Beyond STATS_TIME)?

Purpose To list all RUNSTATS done in a database in the last three days, whether manual or automatic. Version Tested on 10.5. Should work on 10.1 and up. Statement select pid, tid, substr(eventtype, 1, 10), substr(objtype, 1, 30) as objtype, substr(objname_qualifier, 1, 20) as objschema, substr(objname, 1, 10) as objname, substr(first_eventqualifier, 1, 26) as event1, substr(second_eventqualifiertype, 1, 2) as event2_type,...