UDADTS Problem

Hi everyone,

I'm trying to migrate from Ingres SPARC SOLARIS Version II 2.5/0011 to
Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1.
In the current installation we use some udadts and they work very well.

In the new installation we tried, as a first step to use the demo udadts.

We compiled the .c files using gcc.

The iilink completed without any error.

Ingres is up and running. Everything seams to work well, but Ingres fails to
recognize any demo udadts.

Any suggestions?

Thanks in advance.

Michael Maliappis
Ingres DBA administrator
Agricultural University of Athens, Greece

Hello Michael,

The DBMS needs to be stopped and restarted. That is the way I have
always linked the demo udadts into the Ingres DBMS. I have always
followed this procedure:

1. ingstop
2. iilink
3. ingstart

The Ingres Object Management Extension User Guide also suggests the
above install steps. I have never seen the DBMS recognize the udadts
unless the DBMS was bounced.

- Denise
_______________________________________________
Info-Ingres mailing list
Info-Ingres-at-kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres

-----Original Message-----
From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of
Michael Maliappis
Sent: Friday, October 10, 2008 6:37 PM
To: info-ingres-at-kettleriverconsulting.com
Subject: [Info-Ingres] UDADTS Problem

Hi everyone,

I'm trying to migrate from Ingres SPARC SOLARIS Version II 2.5/0011 to
Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1.
In the current installation we use some udadts and they work very well.

In the new installation we tried, as a first step to use the demo
udadts.

We compiled the .c files using gcc.

The iilink completed without any error.

Ingres is up and running. Everything seams to work well, but Ingres
fails to
recognize any demo udadts.

Any suggestions?

Thanks in advance.

Michael Maliappis
Ingres DBA administrator
Agricultural University of Athens, Greece


_______________________________________________
Info-Ingres mailing list
Info-Ingres-at-kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres

On Oct 10, 2008, at 7:36 PM, Michael Maliappis wrote:
>
> The iilink completed without any error.
>
> Ingres is up and running. Everything seams to work well, but Ingres
> fails to
> recognize any demo udadts.
>
> Any suggestions?
>

The problem is most likely in the link. As I recall, Solaris merges the
udt's into the iimerge.o object, so there's no easy way to examine
the output to make sure that your udt code actually made it into
the result. I'd be tempted to find the link command in iilink and
execute it by hand, just to verify that it's picking up your
UDT code.

Solaris is a hybrid installation, and the server will be running in
64-bit mode on any modern Sun. Make sure that you've compiled
your UDT in 64-bit mode, and make sure that iilink is picking it
up for the 64-bit server (the one in $II_SYSTEM/ingres/bin/lp64).

Karl