Early this month, DB2 10.1 Fix Pack 2 was released. This fix pack includes a big bunch of new SQL compatibility features, enhancements on data movements, monitoring as well as several enhancements on maintaining your database.
Here's the key compatibility features:
Here's the key compatibility features:
- Distinct type now supports sub-typesm: although there was a workaround for this feature, I'm glad that it's added. It was used by customers extensively.
- PIPE-lined table functions.
- Line number for runtime errors: The long waited for feature.
- You can now monitor routines and debug them much faster with data studio. The debugger has order of magnitude speed-up.
- LTRIM, RTRIM and MOD scalar functions" LTRIM & RTRIM has a second parameter that can be used to specify which character to trim. MOD now goes beyond integers and supports all numeric data types.
- ARRAY_AGG of rows: this is the faster answer for customer running into performance trouble with BULK COLLECT.
No comments:
Post a Comment