2,534 reputation
11341
bio website churchmutual.com
location Wisconsin
age 35
visits member for 3 years, 8 months
seen Nov 24 at 13:54

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!


Nov
24
comment db2_install do not have write permission on the directory or file
In our case we have permissions 750 and the folder permissions set at root:system. See if that helps.
Nov
20
accepted Indicators for right balance of the number of DB2 instances per AIX LPAR
Nov
19
answered Has some command that lists the privileges of a user in db2?
Nov
19
answered How can i give SECADM to instance owner in DB2?
Nov
12
comment Get a specific row from a TSQL common table expression
What about converting it to a function that returns a table? Then you could use a parm and pass it in.
Nov
12
comment How to access another db from a stored procedure in db2
Mustaccio is spot on. (In fact he should post that as an answer.) I have supported databases where developers did this exact thing (including federation to databases both local to the same instance and remote from the instance).
Nov
10
comment Indicators for right balance of the number of DB2 instances per AIX LPAR
Are there still any guidelines that one can follow or using as a going in position and then deviate as needed?
Nov
6
asked Indicators for right balance of the number of DB2 instances per AIX LPAR
Oct
30
comment DB2 Commands — Different ways of stopping database
Modified answer to reflect discussion about TERMINATE
Oct
29
comment create table and insert to tablespaces
Yes, you should be able to verify syntax at the IBM Knowledge Center for DB2 LUW www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/…
Oct
29
revised DB2 Commands — Different ways of stopping database
deleted 26 characters in body
Oct
28
comment DB2 Commands — Different ways of stopping database
I would disagree with the "have no effect on the DB2 server". On occasion we had our instance go wierd on us and say "not accepting any more database commands" in the diagnostic log. This has even happened on issuance of db2stop/db2start. A simple issue of db2 terminate appears to resolve the issue and allow the instance to continue. Why? I have no clue. This is now why I issue terminate after db2stop and terminate after db2start.
Oct
28
answered DB2 Commands — Different ways of stopping database
Oct
28
awarded  Popular Question
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?