2,554 reputation
21341
bio website churchmutual.com
location Wisconsin
age 36
visits member for 3 years, 8 months
seen yesterday

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!


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)
Dec
11
awarded  Famous Question
Dec
10
comment How Do I Get DB2 NoSQL User-Defined Functions to Work
You probably need to grant EXECUTE permission on certain packages. You can use SYSCAT.ROUTINES and SYSCAT.PACKAGES to locate packages. Another option might be to grant BINDADD on database to the particular user ID you are looking for.
Dec
5
comment How to Start DB2 10.5 HADR on the Standby Database
So, then it appears that logging should be changed from circular to archivable (ie, LOGARCHMETH1) to use HADR.
Dec
4
comment How to Start DB2 10.5 HADR on the Standby Database
Usually when you restore you do not rollforward to end of backup or end of logs on the standby. You do not want to perform that step. What I'm wondering though....are you using archivable logging (ie, is LOGARCHMETH1 set to something other than OFF)? Wondering if that is affecting HADR? Because a circular logging database has no need to rollforward and that may be what is messing things up here?
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