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


3h
revised infosphere-data-architect wiki description
added 145 characters in body
3h
revised infosphere-data-architect wiki excerpt
added 145 characters in body
6h
wiki created infosphere-data-architect description
6h
wiki created infosphere-data-architect excerpt
6h
suggested suggested edit on infosphere-data-architect tag wiki
6h
suggested suggested edit on infosphere-data-architect tag wiki excerpt
6h
revised Is there a way to create a re-usable base table definition in InfoSphere Data Architect?
Added a tag for the product.
2d
revised How to apply a regex on a column fetched from DB
edited tags
2d
comment How to apply a regex on a column fetched from DB
I would vote that the function is run FENCED since it calls out to a library. If the library ever crashes it has the possibility of endangering the DB2 engine if it is running NOT FENCED.
Aug
21
comment DB2 Trigger for EVENT and ARCHIVE TABLE
I think you may need to take a crack shot at it first. Then if you are having difficulties, post the code here and we can gently point you in the right direction.
Aug
19
awarded  Popular Question
Aug
13
revised DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?
Moved text into a code block.
Aug
13
awarded  Popular Question
Aug
12
revised Why doesn't DELETE + REORG free diskspace (DB2)?
Added in an edit regarding older tablespaces.
Aug
8
comment How do tablespaces differ in DB2 from databases in MySQL or SQL Server?
Although a Database in SQL Server can have schemas as well.
Aug
6
comment Split comma separated entries to rows
@mustaccio, might not hurt to copy that answer over here.
Aug
4
accepted Does anyone use modules in DB2 LUW?
Aug
4
comment Does anyone use modules in DB2 LUW?
Yes, I understand that. I was attempting to address your final bullet point that while a person could modularize stored procedures you cannot prevent direct access to the modular ones due to permissioning. The only way to restrict access is via using a module.
Jul
31
comment Does anyone use modules in DB2 LUW?
Although if Proc B calls into Proc A, and I grant execute on B, but not A, I am assuming that when Proc B calls A, it will fail?
Jul
30
asked Does anyone use modules in DB2 LUW?