meta user
network profile
| bio | website | churchmutual.com |
|---|---|---|
| location | Wisconsin | |
| age | 34 | |
| visits | member for | 2 years, 1 month |
| seen | 8 hours ago | |
| stats | profile views | 87 |
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, Frank Peretti, 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 I love spending time with my wife and kids!
Find me on Linked In.
Also, check out the DB2NightShow. It's awesome!
|
Aug 17 |
comment |
Which graph database for search engine and gis? I'm not sure why you wouldn't think DB2 isn't performant? Like any database, it needs to be tuned properly based on the data it contains. Yes it is a relational database. The spatial extension allows it to work with geospatial information. IBM has other add-ons to allow DB2 to move into other areas like full text search etc. I am not personally familiar with using the spatial extender. I just know it exists and that some places use it. I wouldn't discount DB2 just because it is an RDBMS by default. And the version I pointed out is free. I just offer it as a suggestion. |
|
Aug 17 |
answered | Which graph database for search engine and gis? |
|
Aug 16 |
revised |
Commonly Used Acronyms by Database Administrators added 591 characters in body |
|
Aug 16 |
asked | Is there a way to create a re-usable base table definition in InfoSphere Data Architect? |
|
Aug 16 |
answered | Good tool for simulating many threads doing INSERTS UPDATES SELECTS and DELETES on an ODBC database? |
|
Aug 16 |
revised |
Commonly Used Acronyms by Database Administrators added 31 characters in body |
|
Aug 16 |
revised |
Commonly Used Acronyms by Database Administrators added 67 characters in body |
|
Aug 16 |
comment |
DB2: Is it good to create the index table space to use 32 KB data page Not actually sure. Would have to do some more digging on that one. Check out my post here: dba.stackexchange.com/questions/19894/…. So I'm not sure if that means a total of 4K (ie four indexes) and 28K of wasted space, or if DB2 utilizes the entire page. |
|
Aug 15 |
revised |
Commonly Used Acronyms by Database Administrators organized alphabetically and added a few of the ones voted on into the list. |
|
Aug 15 |
answered | DB2: Is it good to create the LONG table space to use 32 KB data page |
|
Aug 15 |
revised |
DB2: Is it good to create the index table space to use 32 KB data page added 630 characters in body |
|
Aug 15 |
answered | DB2: Is it good to create the index table space to use 32 KB data page |
|
Aug 15 |
answered | Commonly Used Acronyms by Database Administrators |
|
Aug 15 |
comment |
Speeding up COUNT(*) - WHERE clause slowing query You might also not want to pass everything to the count function. Depending on the database that may not be optimal. It may grab everything, then count it. It might be easier to do just a count(message_type_id). Should give you the same result, but helps the engine to cut off extra rows it doesn't need to care about. |
|
Aug 14 |
comment |
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl you should try db2move - that brings the DDL (minus tablespaces and bufferpools) + the data. Run a db2move <database-name> export. |
|
Aug 10 |
comment |
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl @WarrenT - ok you got me. :) I just am not familiar with Perl. So I can't speak to it. My experience has been mostly shell scripts. |
|
Aug 9 |
awarded | Excavator |
|
Aug 9 |
revised |
Reporting Database Considerations fix the question and retag |
|
Aug 9 |
comment |
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl Not sure about SQLServer on AIX. As for DB2 on Windows, the commands still hold true, you just have to switch to Windows Batch script or PowerShell or something else. |
|
Aug 9 |
suggested | suggested edit on Reporting Database Considerations |
