FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle

#1

For those of you busily enabling those Oracle applications to DB2 things
are getting (even) easier:
1. DBMS_DDL.WRAP() and DBMS_DDL.CREATE_WRAPPED()
Provide obfuscation for your PL/SQL (and SQL PL) procedures,
functions, triggers, ..
2. NCHAR, NVARCHAR2, NCLOB support with related functions
(e.g. TO_NCHAR)
3. DEFAULT parameters for functions
CREATE FUNCTION FOO(arg1 INT DEFAULT 7) ...
4. Named parameter invocation for functions
SELECT FOO(arg=>7) FROM DUAL
5. BULK COLLECT got faster
6. Various CLPPlus enhancements
....

All features (except BULK COLLECT) are of course available to "regular"
DB2 as well.

Enjoy
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

#2

About the "Databases can be restored using transportable sets" news:
Are transportable sets architecture-independent, so that they can be used
to transport a database from - e.g. - AIX64 to Linux x86_64?

--
Troels

#3

On 5/29/2010 4:13 AM, Troels Arvin wrote:

Quote:

About the "Databases can be restored using transportable sets" news:
Are transportable sets architecture-independent, so that they can be used
to transport a database from - e.g. - AIX64 to Linux x86_64?

I do not think so. In the end the technology is based on restore. So the

same rules apply.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

#4

On 29 mei, 14:28, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:

Quote:

On 5/29/2010 4:13 AM, Troels Arvin wrote:> About the "Databases can be restored using transportable sets" news:
Are transportable sets architecture-independent, so that they can be used
to transport a database from - e.g. - AIX64 to Linux x86_64?

I do not think so. In the end the technology is based on restore. So the
same rules apply.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

I assume it has the same limitations as a tablespace restore with
regards to HADR (ie. not possible). Am I correct?

Kind regards,

Frederik

#5

On 5/29/2010 9:17 AM, Frederik Engelen wrote:

Quote:

On 29 mei, 14:28, Serge Rielau<srie... (AT) ca (DOT) ibm.com> wrote:
On 5/29/2010 4:13 AM, Troels Arvin wrote:> About the "Databases can be restored using transportable sets" news:
Are transportable sets architecture-independent, so that they can be used
to transport a database from - e.g. - AIX64 to Linux x86_64?

I do not think so. In the end the technology is based on restore. So the
same rules apply.
I assume it has the same limitations as a tablespace restore with
regards to HADR (ie. not possible). Am I correct?
That I do not know....

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle

comp.databases.ibm-db2 comp.databases.ibm-db2

FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle - 05-28-2010 , 04:34 PM

Re: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle - 05-29-2010 , 03:13 AM

Re: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle - 05-29-2010 , 07:28 AM

Re: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle - 05-29-2010 , 08:17 AM

Re: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle - 05-29-2010 , 08:28 AM