128 reputation
5
bio website churchmutual.com
location Wisconsin
age 35
visits member for 1 year, 7 months
seen Apr 7 at 19: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!


Sep
26
accepted Capture screen content for error parsing
Dec
31
comment Capture screen content for error parsing
I'll try to give it a shot and see what happens. May take a bit with my other DBA activities I have to take care of....Will post back my results.
Dec
31
comment Capture screen content for error parsing
I actually need it for both. I need it during runtime for analysis of return codes from DB2 (which are printed to the console) in order to know if I need to terminate the job (ie, exit 1) to notify the enterprise job scheduler of an issue. I also need to retain the log of the job (ie, offline) so a DBA can look at the "job log" and try to figure out why there was an issue and correct it. Make sense?
Dec
31
comment Capture screen content for error parsing
Actually...I do need to do analysis offline and after-the-fact.
Dec
28
comment Capture screen content for error parsing
do if i did db2 -v drop table mytable 2 > &1 > resultsFile &, That will write to the console AND the file?
Dec
28
comment Capture screen content for error parsing
Output is text and message codes.
Dec
28
comment Capture screen content for error parsing
@Karlson - I am not disagreeing with you. I've read blogs from another DBA about switching from ksh to Perl and the power that brings. Again, the challenge is all the tasks we are facing for go live, plus I'd have to learn Perl, plus teach it to the other DBAs. Like I said, that gets tricky with go live a month away. Ultimately, we may switch to Perl, but I don't think I can do that in a month. Not when I have to help manage 100+ databases....
Dec
28
comment Capture screen content for error parsing
I think Perl is definitely a possible choice. The trick here is I am up against having to write these scripts with a month before "go live" of a piece of software. I am one of the first three DBA's our company has. So I may not have the time to learn Perl before go live. After go live, I may have the time to look into that.
Dec
27
revised Capture screen content for error parsing
added 2 characters in body
Dec
27
asked Capture screen content for error parsing
Dec
14
awarded  Scholar
Dec
14
accepted Regex for phrase matching with case statement in ksh
Dec
13
answered Regex for phrase matching with case statement in ksh
Dec
8
awarded  Editor
Dec
8
revised Regex for phrase matching with case statement in ksh
added 246 characters in body
Dec
7
awarded  Student
Dec
7
asked Regex for phrase matching with case statement in ksh
Aug
31
awarded  Autobiographer
Aug
31
awarded  Supporter