(Peter Schurr) This article describes the impact of large row IDs (RIDs) on the row compression feature in DB2 for Linux, UNIX, and Windows. Both large RIDs and row compression features were introduced in DB2 9. Row compression can significantly reduce the average row size, but when not using large
Other News
Mutually dependent dropdown lists in ADF Faces – leveraging ADF BC Bind Parameters and ADF Faces Partial Page Rendering
(Lucas Jellema) This week we were having a session in which we had to estimate the effort required for a new ADF project. The application we have to develop will support a large chain of shows specializing in interior decorating. One of the functions in the application is to create the plan for deco
Watching for Disk Based Tables being created
(Ronald) I didn’t know you could actually do this before addressing this problem in a benchmark using 5.0.36.
SQL Server CDP, Snapshop Replication and More
Featured Article(s) Tips for using SQL Server 2005 Snapshot Replication (Part 1) Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication. Data Compare, for SQL Server Express? Yes. And free too. If you’re working with SQL Server Express, building applications, moving them out to your users and needing to make sure you catch all […]
Call the Key Master! (Encryptions keys that is)
Featured Article(s) Risk Management — Prevention is better than cure [Part I] No risk no gain – an old proverb but not an obsolete one. You can have gains attained at the cost of risks taken; this is true and a universal reality. Whatever your venture is, you have to face many risks on your path. Sometimes it is anticipated […]
XML merging made easy
(Laurent Bovet) Sometimes it seems you spend more time manipulating XML files than you do writing Java code, so it makes sense to have one or two XML wranglers in your toolbox. In this article, Laurent Bovet gets you started with XmlMerge, an open source tool that lets you use XPath declarations to
Let’s talk CPU usage and DB2 Version 8 one more time
(Willie Favero) It’s an issue I have discussed in different ways to different extents in a few of my previous blog entries. However, I still get questions and still see comments on different forums and list about ways to reduce the amount of CPU being used by DB2 for z/OS Version 8. Today I want to
Create a sidebar using an Atom service document
(Nicholas Chase) An Atom service document is for more than just telling readers where to find a site’s feeds. This article shows you how to use this introspection document to create a sidebar that provides a window into everything your server has to offer. This article uses the Blogapps server, whic
About Table(XMLSequence()) and XMLTable
(Marco Gralike) A customer asked me how this XMLTable XML function works… Until now they had to use the TABLE(XMLSEQUENCE()) constructor.
Inside the Mind of a Hacker
(Lisa Vaas) During the 2004 presidential campaign, Jeremy Poteet watched as the candidate’s site he had worked to secure went up. Just 16 minutes later, the site was attacked.