Db2 Experts on a Data Science Quest
RFE stands for “Request for Enhancement”. IBM has this program for a number of products, but until late 2016, the RFEs for DB2 on LUW were not publicly available to vote on. Now they are, and we’re seeing action on them.… Read the rest
Continue reading »
I am consistently shocked and appalled at how few clients actually do load testing. Many pay it lip service, but few actually engage in real, meaningful performance and load testing. I understand that load testing of an application can be difficult and expensive.… Read the rest
Continue reading »
I learned a nifty little trick while troubleshooting a connection issue, and thought I would share. It can be useful in getting information out of the db2 diagnostic log.
The DB2 diagnostic log has a wealth of information.… Read the rest
Continue reading »
There are plenty of things that I want to try in a sandbox VM before I let them anywhere near even a development environment. Even if I didn’t use it constantly for blogging, I would still need it for trying things to see how they work before advising clients.… Read the rest
Continue reading »
I ran into an interesting problem installing 11.1, fix/mod pack 1 on Ubuntu, and thought I would share. Please read to the bottom before trying anything, as this entry goes through things I tried that did not work before I got to what did work.… Read the rest
Continue reading »
Some applications are really good at continually trying to re-establish connections to a database. This can be useful when I want to quickly bounce the database and have the app reconnect without also having to bounce the app. It is problematic when I need DB2 to be down and stay down, but still allow me to work with it.… Read the rest
Continue reading »
Since DB2 9.7, you have been able to reduce the size of tablespaces using the statement:
ALTER TABLESPACE USERSPACE1 REDUCE MAX
Using this functionality, however, requires that the tablespace uses automatic storage and that it was created with the reclaimable storage attribute.… Read the rest
Continue reading »
I can’t say that I work with federation on a daily basis. I have, however, set up federation for an Oracle data source from top to bottom, and support at least one system on a daily basis that uses federation to access Oracle, Informix, and DB2 for AS/400.… Read the rest
Continue reading »
There have been a few times in my career when DB2 has blown me away with an ability to stay up when I would have given really good odds that it should be unavailable. It’s been a few years since the last time that happened, and this was an interesting lesson in transaction logging.… Read the rest
Continue reading »
UPDATE, 10/21/2015: Please see the comment from IBM at the end stating that despite the information they gave Jim via PMR, this compression does not cause a lack of license compliance even if you are not licensed for compression.
Abby Rosmarin said, “Hard work, determination and talent are key for any successful venture.… Read the rest
Continue reading »
It’s a question I hear frequently – How can I speed up backups? I thought I’d share some details on doing so.
Any backup cannot be faster than it takes to back up the largest tablespace. Parallelism is essentially done on the tablespace level – meaning one thread per tablespace.… Read the rest
Continue reading »I thought I’d share some issues with STMM that I’ve seen on Linux lately. I’ve mostly been a fan of STMM, and I still am for small environments that are largely transaction processing and have only one instance on a server.… Read the rest
Continue reading »