2,467 reputation
11340
bio website churchmutual.com
location Wisconsin
age 35
visits member for 3 years, 7 months
seen 16 hours 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!


Oct
7
revised Auditing AS 400 DB2 library user access
added tag
Sep
25
accepted Is my understanding of Fact table granularity correct?
Sep
25
revised Is my understanding of Fact table granularity correct?
Edit to provide clarity to the situation beyond the original question.
Sep
23
comment Is my understanding of Fact table granularity correct?
So you are proposing that the two values be broken out into two facts, one additive and one non-additive? (This is actually what I was leaning toward.) Even so, can you provide a reason for this? Does Kimball even say not to mix additive and non-additive values in a fact?
Sep
23
revised Is my understanding of Fact table granularity correct?
added 4 characters in body
Sep
23
asked Is my understanding of Fact table granularity correct?
Sep
11
answered DB2 - how to safely blow away database on linux?
Sep
10
comment DB2 developers can't create table in own schema but SQL and Oracle devs can. Justified?
You are also talking DB2 on either i5/OS or z/OS rather than DB2 Linux, Unix, Windows. Mainframe DB2 functions a little bit differently. While I work with DB2 LUW, I can understand the answer given by your DBA as we also have DB2 for i at our shop. Perhaps Walter G can better address if this is a "limitation" of mainframe DB2 or is purely policy like Ian mentions? Speaking of which, is the "mainframe" DB2 you are discussing i or z?
Sep
9
awarded  Popular Question
Sep
5
answered DB2 importing/replacing fields from a file that contains XML
Sep
4
comment How we can make database resumable in perl script
If you are using the IMPORT or LOAD process, there are ways to get it to continue. Please see the documentation for those two processes in the IBM Knowledge Center for your version of DB2.
Sep
3
answered How we can make database resumable in perl script
Aug
28
revised infosphere-data-architect wiki description
added 145 characters in body
Aug
28
revised infosphere-data-architect wiki excerpt
added 145 characters in body
Aug
28
wiki created infosphere-data-architect description
Aug
28
wiki created infosphere-data-architect excerpt
Aug
28
suggested suggested edit on infosphere-data-architect tag wiki
Aug
28
suggested suggested edit on infosphere-data-architect tag wiki excerpt
Aug
28
revised Is there a way to create a re-usable base table definition in InfoSphere Data Architect?
Added a tag for the product.
Aug
26
revised How to apply a regex on a column fetched from DB
edited tags