Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unanswered: What is New in DB2 9.5

    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,

  2. #2
    Join Date
    Mar 2009
    Posts
    3
    Forgot to add, IBM DB2 UDB Enterprise Edition V9.5

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Mar 2009
    Posts
    3
    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.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    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).
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Good luck Pete
    Quote Originally Posted by Peter.Vanroose
    (or come to my presentation at IDUG Rome, if it gets accepted)
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Jan 2003
    Posts
    1,605
    Quote Originally Posted by Peter.Vanroose
    here's my list of new features
    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

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Wasn't this a feature in 8.2 base version ?

    5. Include log files in backup image
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  10. #10
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by grofaty
    5. Include log files in backup image
    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".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •