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


2d
comment who are the group people in db2 and who are the users db2luw
Other permissions based things that you may wish to read up on are label-based access control (LBAC), role-based access control (RBAC) introduced in 9.7, and row and column access control (RCAC) introduced in 10.5 or 10.1 (pretty sure it is 10.5 though).
2d
revised DB2 (LUW) equivalent for Oracle “drop user cascade”
added 8 characters in body
Jul
16
comment configure client ibm_db2 for php
If you are looking for how to set up the DB2 environment, this was answered in another question: dba.stackexchange.com/questions/31336/adding-user-access-to-db2
Jul
15
comment The query result changes in remote and local database
It may also be that security is limiting the rows returned. I would say that is a high likelihood with RCAC, but you are not on DB2 10.5. And I am not familiar enough with LBAC to verify. Mustaccio?
Jul
15
answered The query result changes in remote and local database
Jul
2
awarded  Curious
Jun
30
comment DB2 LOAD: Poor performance while loading table with large BLOBs
I believe LOAD is a utility? If so, you could modify the UTIL_HEAP_SZ to give it more memory.
Jun
26
answered Equivalent SQL Server's Backup COPY ONLY in DB2
Jun
20
comment SYSPROC.ADMIN_MOVE_TABLE procedure error
Generally it is a good idea to define each table's data, indexes, and LOBs in separate tablespaces. This assists with both REORGs as well as recovery of data. If you do not define them, whatever is not defined defaults to wherever the table defaults to (or is defined to for data).
Jun
20
comment Create new Read Only user on DB2 on the whole database
Kudos to the use of roles. Much easier than trying to just grant priveleges to IDs directly.
Jun
12
comment DB2 Linked Server on SQL Server 2012 - Grant Access to Users
True. and ++ to the SQLCODE thing. Hard to troubleshoot without that.....
Jun
12
comment DB2 Linked Server on SQL Server 2012 - Grant Access to Users
Do you know the version and edition and OS of DB2 you are trying to connect to? (ie, iSeries or Unix or Windows for OS), version 9.7? version 8.1? Enterprise Edition? Express-C? Also, do you know what the security is set up on the client end and on the server end? Ie, is the DB2 server set up for SERVER authentication? CLIENT? KERBEROS? other?
Jun
12
comment DB2 Linked Server on SQL Server 2012 - Grant Access to Users
True. But SYSADM should have CONNECT implicitly, and the error we see above seems to imply an issue with connecting.
May
28
revised DB2 - how to track IOPS statistics?
edited tags
May
25
awarded  Notable Question
May
23
comment Adding a column to the view which shows the date in format YYYYMM
You wouldn't even need sysdummy1. Just do a select column1, column2,....... (YEAR(CURRENT DATE) * 100 + MONTH(CURRENT DATE)) CURRENT_MONTH_DATE from view_irs1
May
23
revised How to grant all privileges on all tables in a schema to a user in IBM DB2?
deleted 14 characters in body
May
20
comment Way to ensure just one connection to a DB2 database
Deleted my answer and throwing my vote behind Ian as it is the best overall answer.
May
19
revised DB2 Defining remote database alias
Fixed/clarified some points.
May
9
answered IBM DB2 9.7 and latest 10 version compatibility