2,339 reputation
11236
bio website churchmutual.com
location Wisconsin
age 35
visits member for 3 years
seen yesterday

I am a Database Administrator at Church Mutual Insurance Company (http://www.churchmutual.com). In my past life I was a Development Engineer and worked with Java technologies, integration development, application architecture, and enterprise architecture. Now I get to play with DB2 all day and also get to be involved in the evolving BI tools that we are getting in place.

For hobbies, I enjoy walking, reading fiction (especially Ted Dekker, Bryan Davis, and other good science fiction and fantasy), some video games, and table top gaming (Warhammer 40K, StarCraft:The Board Game, and The Settlers of Catan are some of my favorites). I enjoy the Redemption TCG and the Star Wars LCG. And I love spending time with my wife and kids!

Find me on Linked In.

Also, check out the DB2NightShow. It's awesome!


2d
comment Reasons for db2 foreign key error (-667) despite all rows appearing sane?
I would assume you need the constraint enforced.
2d
answered Reasons for db2 foreign key error (-667) despite all rows appearing sane?
Apr
8
comment How do I compare two tables with the same column definitions in different schemas?
Are you asking for if the data changed? or if the DDL changed?
Apr
4
comment Is there a way to determine automatic storage table spaces?
FYI that what mustaccio found will only work on 9.7 FP 5 or higher. We are 9.7 FP 4, so I have to use what I found (the db2pd) But what mustaccio has recommended would be the correct answer. So leaving it.
Apr
4
comment Is there a way to determine automatic storage table spaces?
Wanted to add here, that in addition to mustaccio's answer, I discovered I can use db2pd -d <dbname> -tablespaces. There is a column 'AS' that if marked Y, shows the table is automatic storage. If found that on the db2commerce blog.
Mar
29
awarded  Yearling
Mar
25
comment DB2 9.7, create or replace tablespace possible?
Just a thought...if you are really going to follow continuous integration all the way, why not have it drop and re-create the database from scratch every time? We actually do that where I work. The same scripts we use to deploy a new instance of this database is used by our CI server to drop and rebuild the databases. It is probably overkill as Phil mentions. But it does work. In our case we script most everything with KSH and check it into Subversion. We use Jenkins to check things out and deploy and run them on our AIX development boxes.
Mar
20
comment Can we change DB config after db creation in DB2
You may also wish to see my answer on this question for tactics about how to change this: dba.stackexchange.com/questions/36686/…
Mar
11
comment How to use db2look to get the ddl of sequence?
@user35424 - I've not found a way yet. It appears to be somewhat ordered based on how things were accepted by DB2. So a full blown install of a database on one environment vs a base install and applied deltas tend to yield different orders. If I find a way to order it, I'll let you know.
Mar
3
comment db2 - after the reboot - database is restarting itself after some time (urgent help needed)
@Dejan you should post what it is as the answer.
Feb
26
comment DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?
I voted for Ian's answer. It is pretty thorough.
Feb
26
revised How to grant rights for a user in DB2 Express?
edited tags
Feb
26
comment How to grant rights for a user in DB2 Express?
@mustaccio - you should post your comments as an answer to this question.
Feb
13
comment DB2 users/ beginer questions
Yes, to what mustaccio says, plus with Windows based installs of DB2, the default instance owner tends to be DB2ADMIN unless otherwise specified.
Feb
11
awarded  Nice Answer
Feb
11
comment DB2 LUW Query Optimization - IXSCAN timerons greater than total timerons
Any traction on this?
Feb
3
awarded  Popular Question
Jan
28
comment Testing if temp table exists in iSeries SQL stored procedure
Awesome! Nice to have an iSeries DB2 person on the site!
Jan
20
comment cross database way to force join strategies
I believe having compound indexes, a star schema, and DB2 10.1 or higher allows for the new zig-zag join.
Jan
20
revised cross database way to force join strategies
[Edit removed during grace period]