Another useful new feature debuting in V9 is the ability to compress indexes. We’ve been able to compress DB2 data in table spaces for a long time now, either through an exit routine or with the COMPRESS table space parameter (added in DB2 V3). But before V9 we’ve never been able to compress index data.Why would you want to compress index data? Well, some types of applications require very large indexes on very large tables - - data warehousing applications are one good example. Sometimes, the storage required for indexes to support your data warehouse...
Tuesday, 24 July 2007
Monday, 16 July 2007
CLONE Tables [DB2 9 for z/OS]
Posted on 12:53 by Unknown
This new feature in DB2 V9 might sound like an old monster movie (Invasion of the Clone Tables!!!), but it is actually a nifty new capability for managing DB2 data availability. Cloning is basically a method of entirely refreshing all of the rows of a table while maintaining availability to the table.OK, so how does it work? Basically, you will create a table with the exact same attributes as a table that already exists at the current server, except that it is empty of data. It is created using the ALTER TABLE SQL statement with the ADD CLONE parameter....
Thursday, 12 July 2007
New Data Types [DB2 9 for z/OS]
Posted on 11:36 by Unknown
As we continue our blog series on the new features and functionality of DB2 9 for z/OS, today we examine the four (OK, five) new data types introduced in this version of DB2.BIGINTFirst up, we have the BIGINT data type. A BIGINT is an exact numeric data type capable of representing 63-bit integers. This is the third integer data type now available to DB2 and it offers the ability to store the largest range of values:SMALLINT values can range from -32768 to 32767INTEGER values can range from -2147483648 to 2147483647BIGINT values can range from...
Monday, 9 July 2007
New Built-in Functions [DB2 9 for z/OS]
Posted on 13:19 by Unknown
DB2 9 for z/OS introduces a bevy of new built-in functions (BIFs) for programmers to use in their SQL statements. It is important to keep track of the BIFs available in DB2 because BIFs simplify your coding and development. Invoking a function is always easier than trying to write the equivalent functionality in your host language code. And the BIF will work properly, whereas you cannot always be so sure about your own (sometimes buggy) code.So, what new function functionality do we get with DB2 9 for z/OS? First of all, we get some new ASCII and...
Subscribe to:
Posts (Atom)
