DB2 UDB & C runtime environment components

[Laurence]

Hi there,

I have already checked the URL http://www-306.ibm.com/software/data/db2/9/sysreqs.html.
There are no Operating System need to install C rumtime environment
components other than AIX before installing DB2 Server product. Is it
specific for AIX only?

By the way, the sentence "If you are installing the Application
Development Client, you must have a C compiler to build SQL Stored
Procedures". Does it mean for HP-UX and Solaris only?

In addition, if someone wants to build SQL Stored Procedures by CLP,
does he must to install Application Development Client? Or just
install a C compiler?
Thanks in advance,

Laurence

[Serge Rielau]

Laurence wrote:

I have already checked the URL http://www-306.ibm.com/software/data/db2/9/sysreqs.html.
There are no Operating System need to install C rumtime environment
components other than AIX before installing DB2 Server product. Is it
specific for AIX only?

By the way, the sentence "If you are installing the Application
Development Client, you must have a C compiler to build SQL Stored
Procedures". Does it mean for HP-UX and Solaris only?

In addition, if someone wants to build SQL Stored Procedures by CLP,
does he must to install Application Development Client? Or just
install a C compiler?

Starting with DB2 V8.2 there is no requirement for a C-compiler to build
and run SQL Procedures on any platform.
I'm not clear where you saw that statement in the DB2 9 docs...

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Laurence]

Thanks for the reply.

Links to http://publib.boulder.ibm.com/infoce...c/r0008857.htm
, and under Software considerations: "DB2 Version 9 requires the "IBM C
++ Runtime Environment Components for AIX" which includes xlC.rte
8.0.0.4."

Links to http://publib.boulder.ibm.com/infoce...c/r0008869.htm
, and under Software considerations: "If you are installing the
Application Development Client, you must have a C compiler to build
SQL Stored Procedures."

That's why I am confusing...

[Serge Rielau]

Laurence wrote:

Thanks for the reply.

Links to http://publib.boulder.ibm.com/infoce...c/r0008857.htm
, and under Software considerations: "DB2 Version 9 requires the "IBM C
++ Runtime Environment Components for AIX" which includes xlC.rte
8.0.0.4."

Links to http://publib.boulder.ibm.com/infoce...c/r0008869.htm
, and under Software considerations: "If you are installing the
Application Development Client, you must have a C compiler to build
SQL Stored Procedures."

OK, The statement on SQL Procedures is clearly outdated. I used the
feedback button of the page to request a fix.
Now in general IBM has tended to limit support when you write C Routines
or C programs with embedded SQL to a finite set of compilers (i.e.
compilers we test with ourselves). That is what the AIX statement is about.

Basically when you write your own C-Compiler and your C-UDF doesn't work
don't come to us unless you can prove it equally fails on a supported
compiler.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Laurence]

Thanks for the reply.

So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.

Am I right?

PS:
Reference for somebody who is interested, links to
http://publib.boulder.ibm.com/infoce...c/r0023467.htm
to check supported programming languages and compilers for database
application development.

[Serge Rielau]

Laurence wrote:

Thanks for the reply.

So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.

Am I right?

Correct.

>
PS:
Reference for somebody who is interested, links to
http://publib.boulder.ibm.com/infoce...c/r0023467.htm
to check supported programming languages and compilers for database
application development.

Yep, that's the one.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Ian]

Serge Rielau wrote:

Laurence wrote:

>Thanks for the reply.

So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.

Am I right?

Correct.

Are you sure? I was pretty sure that this is a requirement because IBM
compiles the engine code using the IBM C++ compiler. Therefore there
are dependencies on having the correct runtime, just to run the engine.

Or am I misunderstanding something?

[Liam Finnie]

On Apr 17, 11:05 pm, Ian <[e-mail]:

Serge Rielau wrote:

Laurence wrote:

Thanks for the reply.

So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.

Am I right?

Correct.

Are you sure? I was pretty sure that this is a requirement because IBM
compiles the engine code using the IBM C++ compiler. Therefore there
are dependencies on having the correct runtime, just to run the engine.

Or am I misunderstanding something?

Hi Ian,

You're correct - the specified C++ runtime is needed in order to run
DB2 (both clients, and servers). The actual compiler is only required
if you want to compile C UDFs.

Cheers,
Liam.

[Serge Rielau]

Liam Finnie wrote:

On Apr 17, 11:05 pm, Ian <[e-mail]:

>Serge Rielau wrote:

>>Laurence wrote:
Thanks for the reply.
So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.
Am I right?
Correct.

Are you sure? I was pretty sure that this is a requirement because IBM
compiles the engine code using the IBM C++ compiler. Therefore there
are dependencies on having the correct runtime, just to run the engine.

Or am I misunderstanding something?

Hi Ian,

You're correct - the specified C++ runtime is needed in order to run
DB2 (both clients, and servers). The actual compiler is only required
if you want to compile C UDFs.

Thanks for the clarification Liam.
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Serge Rielau]

Serge Rielau wrote:

Liam Finnie wrote:

>On Apr 17, 11:05 pm, Ian <[e-mail]:

>>Serge Rielau wrote:
Laurence wrote:
Thanks for the reply.
So, "IBM C ++ Runtime Environment Components for AIX" should be an
option but not a requirement while installing DB2 UDB on AIX, if
someone doesn't code C programs with embedded SQL.
Am I right?
Correct.
Are you sure? I was pretty sure that this is a requirement because IBM
compiles the engine code using the IBM C++ compiler. Therefore there
are dependencies on having the correct runtime, just to run the engine.

Or am I misunderstanding something?

Hi Ian,

You're correct - the specified C++ runtime is needed in order to run
DB2 (both clients, and servers). The actual compiler is only required
if you want to compile C UDFs.

Thanks for the clarification Liam.

Sev 2 defects have been raised against the docs.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab