I received an e-mail from a reader asking an interesting question. She wanted to know if any of the DB2 unload utilities are able to include the column names in the same file as the unload output data. This was a requirement because one of the applications her company was planning to use takes the column headings and dynamically creates tables.My initial reaction was that she could write a program that take the output file and reads the system catalog to gather the appropriate column names. That would work, but she actually came up with a better...
Friday, 27 January 2006
Saturday, 21 January 2006
My DB2 Articles
Posted on 15:31 by Unknown
I've written a lot about DB2 over the years and I try to keep most everything I've written up and available over the web. If you are ever interested in finding a DB2 article of mine that you've read but can't find try the following link:http://www.craigsmullins.com/art_db2.htmThat page contains links to all of the DB2 articles that I've written. It is in reverse chronological order...
Sunday, 15 January 2006
Design Guidelines for High Performance and Availability
Posted on 21:54 by Unknown
Just a short blog entry this week to alert everyone to a newly published IBM redbook titled "DB2 UDB for z/OS: Design Guidelines for High Performance and Availability." This redbook is an essential read for anyone who is interested in squeezing the highest levels of availability and optimum performance from a mainframe DB2 application.In just under 500 pages the authors share a wealth of tuning techniques that all DB2 shops should have access to. Download the manual (SG24-7134) for free from the web by clicking he...
Monday, 9 January 2006
Basic DB2 Buffering and Memory Guidelines
Posted on 21:30 by Unknown
One of the most important areas for tuning DB2 subsystem performance is memory usage. DB2 for z/OS uses memory for buffer pools, the EDM pool, RID pool and sort pools to cache data and structures in memory. The better memory is allocated to these structures, the better DB2 will perform.When allocating DB2 buffer pools, keep these rules of thumb in mind: Don't allocate everything to a single buffer pool (e.g., BP0); use a multiple buffer pool strategy. Explicitly specify a buffer pool for every table space and index. Isolate the DB2 Catalog in BP0;...
Subscribe to:
Posts (Atom)
