Hi All,

I am new to this forum, i would like to know the new features that are added to the DB2 9.5 release or the features that are enhanced from DB2 9.1 version.

It would be very much helpful if you guys can provide the features list which are on Table level like New Data types, Enhancements to the existing Data types, New tables etc,

Thanks in Advance,

Forgot to add, IBM DB2 UDB Enterprise Edition V9.5

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

After going through the document i could not able to figure out the features which are on Table level. I am new to DB2 UDB, Actually i am not a DBA. Actually i have to certify our product againest DB2 UDB, Our product deals with Tables, Partitions, Tablespaces.
If any new features/Data types that are added in Table levle then please kindly list them out.

Here is the What's New manual:
ftp://ftp.software.ibm.com/ps/produc.../db2q0e951.pdf

With the risk to forget important improvements, here's my list of new features which could be important at the level of tables and datatypes:

• Identifier length limits have increased (often to 128 bytes)
  like column name, schema name, trigger name.
  (Note that it's bytes, not characters; e.g., when using UTF-8 encoding for the catalog, "normal", non-accented letters are 1 byte but accented letters, Greek, Cyrillic etc. are 2 bytes and characters from most other alphabets are 3 (and sometimes 4) bytes.)
• The "SET" statement can now be used "anywhere", esp. in a prepared statement, possibly even with parameter markers.
• DECFLOAT is a new datatype. Great stuff, check it out!
  (or come to my presentation at IDUG Rome, if it gets accepted)
• Some new (names for existing) scalar functions, for Oracle compatibility, like NVL and DECODE, and new scalar functions for bit operations (BITAND() etc).

Good luck Pete

Pete, here is my list of new functionalities:
1. XML support added for non-UTF8 code pages
2. Table partitioning new options
3. Compress table (like zipping files in file system)
4. Self memory tuning has new features to set automatically
5. Include log files in backup image
6. Change data types, sample char(10) to char(11)) with alter table command
7. Oracle function supported:
NVL -> COALESCE, VALUE
DECODE -> CASE
TO_CHAR -> VARCHAR_FORMAT
TO_DATE() -> TIMESTAMP_FORMAT
Regards

Wasn't this a feature in 8.2 base version ?

Caught my eye too. This EXCELLENT feature has been around for some time.
What they should add is the possibility to pass this kind op parameters (also COMPRESS) to the backup-command generated by the"autmatic maintanance".