2,584 reputation
31342
bio website churchmutual.com
location Wisconsin
age 36
visits member for 3 years, 10 months
seen 1 hour ago

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!


Jan
27
comment How to convert DECIMAL to DATE in DB2 for iSeries SQL
I'm going to guess your library path isn't set up correctly. You probably need access to the right library so you can call that function. Talk to your iSeries or Ops Admin.
Jan
23
comment Remove all records with duplicates in db2. (Not just the duplicate records)
Nice! I was stumped myself on trying to figure this one out. Having tested it, I can say it works.
Jan
23
comment DB2 does not start
++ with mustaccio. Plus did you run ./db2iupdt to your instance afterwards? Sometimes that is needed to set correct permissions on files.
Jan
19
comment Best approach to maintain a single set of DDLs and DMLs for multiple database type
Agreed. Don't disagree with you there.
Jan
19
answered Best approach to maintain a single set of DDLs and DMLs for multiple database type
Jan
17
awarded  Famous Question
Jan
16
revised DB2 Commands — Different ways of stopping database
added 138 characters in body
Jan
9
comment What's worse, too many entities or too many tables?
Sometimes the most awesome flexible design has terrible performance issues. We had a vendor that had a parent table with 60 children tables (one for each specific subtype). The performance of that many joins was horrid. So they collapsed it all down into one table. So the point being, performance test your design too. That is where you may make choices regarding normalizing or de-normalizing.
Jan
9
answered Which size is correct?
Jan
8
comment How to ignore sql errors in stored procedure ? (Not handle)
You should accept your answer (once you can).
Dec
30
awarded  Popular Question
Dec
23
comment Does DB2 order data by the primary key
@Reaces tables in DB2 are usually "clustered" on the primary key by default, unless a clustering index is specified.
Dec
17
comment Recovery model of current database
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
Dec
16
comment DB2 9.5 - Shrink Tablespace
@mustaccio Maybe it has more to do with having migrated to DB2 9.7 from a DB2 9.5 install...but I can say that I could not reduce tablespace sizes either as DMS nor as converted to automatic storage due to the reclaimable storage bit issue.
Dec
15
answered DB2 9.5 - Shrink Tablespace
Dec
15
answered Schema copy from 9.5 V to 10.5
Dec
12
answered DB2: What's the fast way to drop a big partitioned table?
Dec
11
comment How Do I Get DB2 NoSQL User-Defined Functions to Work
You can tell who owns what by checking out the SYSCAT.xAUTH views where x is the item or object being considered. Example to query DB level, SYSCAT.DBAUTH, tables are SYSCAT.TABAUTH, etc.
Dec
11
comment How Do I Get DB2 NoSQL User-Defined Functions to Work
But you are on Windows..... Interestingly enough, you can be attached to the instance as the instance owner and it can create the database under the ID of the user currently logged into Windows. You may need to log in as that ID and grant BINDADD or DBADM and what not back to db2admin. db2admin may currently have authority due to SYSADM_GROUP (ie, DB2ADMNS group in Windows groups).
Dec
11
answered DB2 database -> does it continue to be platform-specific? (iSeries, LUW, z/OS)