Extenders don't support long names?

[Rolf Schuster]

On Windows XP SP2, I am trying to create and enable a table for use by
an AIV extender.
In the extender command line processor (db2ext), I do

db2ext => enable database for db2image

without a problem. However, when I do

db2ext => enable table <mytable> for db2image

I get the following error:

DMB0031E: The table cannot be enabled for the "db2image" extender.
RC = -10220.
DMB0495E: This version of AIV Extenders doesn't support long
names.

Can anybody tell me what this means, and how I can rectify
the situation?

=============== =============== =============== ===============
Informationen zur DB2-Verwaltungstool umgebung
=============== =============== =============== ===============
Stufe des DB2-Verwaltungstool s:
Produkt-ID SQL08020
Aktualitäts-ID 03010106
Stufe DB2 v8.1.7.664
Buildstufe s040914
PTF WR21342
=============== =============== =============== ===============
Java Development Kit (JDK):
Stufe IBM Corporation 1.4.1
=============== =============== =============== ===============

[Knut Stolze]

Rolf Schuster wrote:

On Windows XP SP2, I am trying to create and enable a table for use by
an AIV extender.
In the extender command line processor (db2ext), I do

db2ext => enable database for db2image

without a problem. However, when I do

db2ext => enable table <mytable> for db2image

I get the following error:

DMB0031E: The table cannot be enabled for the "db2image" extender.
RC = -10220.
DMB0495E: This version of AIV Extenders doesn't support long
names.

Can anybody tell me what this means, and how I can rectify
the situation?

When the AIV extenders were developed (DB2 V5), DB2 only supported table
names of up to 18 bytes. That restriction was inherited by the extenders
and has not been lifted since then.

You might want to choose a shorter table name.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Rolf Schuster]

Knut Stolze <st****@de.ibm. com> wrote in message news:<co******* ***@fsuj29.rz.u ni-jena.de>...

Rolf Schuster wrote:

On Windows XP SP2, I am trying to create and enable a table for use by
an AIV extender.
In the extender command line processor (db2ext), I do

db2ext => enable database for db2image

without a problem. However, when I do

db2ext => enable table <mytable> for db2image

I get the following error:

DMB0031E: The table cannot be enabled for the "db2image" extender.
RC = -10220.
DMB0495E: This version of AIV Extenders doesn't support long
names.

Can anybody tell me what this means, and how I can rectify
the situation?

When the AIV extenders were developed (DB2 V5), DB2 only supported table
names of up to 18 bytes. That restriction was inherited by the extenders
and has not been lifted since then.

You might want to choose a shorter table name.

This came to my mind too, but infact the name of my table is "mytab"
which should be short enough. The name of the database and the name of
the column are shorter than 18 bytes, too. Can you think of any other
solution/workaround?

I even tried to use the older version 7 of DB2 and AIV Extender, but
the extender command line processor crashed everytime at startup. I
used the current fixpack. I guess that this version is not compatible
with Windows XP SP2, because it runs perfectly on a Windows XP SP1
system. Maybe someone has a solution for version 7.

[Knut Stolze]

Rolf Schuster wrote:

Knut Stolze <st****@de.ibm. com> wrote in message
news:<co******* ***@fsuj29.rz.u ni-jena.de>...

Rolf Schuster wrote:

> On Windows XP SP2, I am trying to create and enable a table for use by
> an AIV extender.
> In the extender command line processor (db2ext), I do
>
> db2ext => enable database for db2image
>
> without a problem. However, when I do
>
> db2ext => enable table <mytable> for db2image
>
> I get the following error:
>
> DMB0031E: The table cannot be enabled for the "db2image" extender.
> RC = -10220.
> DMB0495E: This version of AIV Extenders doesn't support long
> names.
>
> Can anybody tell me what this means, and how I can rectify
> the situation?

When the AIV extenders were developed (DB2 V5), DB2 only supported table
names of up to 18 bytes. That restriction was inherited by the extenders
and has not been lifted since then.

You might want to choose a shorter table name.

This came to my mind too, but infact the name of my table is "mytab"
which should be short enough. The name of the database and the name of
the column are shorter than 18 bytes, too. Can you think of any other
solution/workaround?

I even tried to use the older version 7 of DB2 and AIV Extender, but
the extender command line processor crashed everytime at startup. I
used the current fixpack. I guess that this version is not compatible
with Windows XP SP2, because it runs perfectly on a Windows XP SP1
system. Maybe someone has a solution for version 7.

You might want to contact IBM support in this case. I agree that XP SP2
broke something and that effects the AIV extender.

p.s: What exactly do you want to do with the extender?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena