Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
I am trying to ensure that the work in my WLM configuration is going to the right place but my workload is always pointing to the same service class even though I know that I have a work action set to point the incoming statement to a different class. What am I missing?
I want to automatically set client information fields for Excel spreadsheets (and IIS connections) in our .net environment. How can I do this?
Over the years, I have found some useful developerWorks articles that I refer back to once in a while so I thought I would share them with you as an FYI and to help you build your own reference library.
I am finding it difficult to distinguish between the different connections because they either use the same authorization ID or come in through a middleware server like WebSphere or MicroStrategy. Is there any way that I can push more outside information into DB2?