473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Extenders don't support long names?

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-Verwaltungstoolumgebung
================================================== ==========
Stufe des DB2-Verwaltungstools:
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
================================================== ==========
Nov 12 '05 #1
3 1941
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
Nov 12 '05 #2
Knut Stolze <st****@de.ibm.com> wrote in message news:<co**********@fsuj29.rz.uni-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.
Nov 12 '05 #3
Rolf Schuster wrote:
Knut Stolze <st****@de.ibm.com> wrote in message
news:<co**********@fsuj29.rz.uni-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
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ken North | last post by:
Updated driver, provider and extender lists are now available at SQLSummit.com. The newest list is XQuery processors. XQuery engines (29) www.SQLSummit.com/XQueryProc.htm ODBC drivers (212)...
0
by: Ken North | last post by:
Updated driver, provider and extender lists are now available at SQLSummit.com. The newest list is XQuery processors. XQuery engines (29) www.SQLSummit.com/XQueryProc.htm ODBC drivers (212)...
0
by: wayne mcfadden | last post by:
Hi, I'm stumped. Our text extenders stopped working on one database. I think that i'm missing something simple here. The column is enabled... but when you do an index status it doesn't know...
0
by: Rolf Schuster | last post by:
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...
2
by: Vavel | last post by:
Hi! I'm looking for DB2 UDB Text Extender and DB2 UDB Audio Image and Video Extenders,but I can't download it from http://www-306.ibm.com/software/data/db2/extenders/support.html (error, document...
1
by: alexs | last post by:
Can someone tell me if the Audio/Image/Video extenders are available for the Linux version of db2 8.2.2.
6
by: Tommy Shore | last post by:
Does VC++.Net support C99 standard?
0
by: Allan Ebdrup | last post by:
Hi I'm thinking up a way to implement multilanguage controls in ASP.Net 2.0, My multilanguage texts lie in a database or resource files, they are accessed through a webservice where I specify a...
8
by: yoyo | last post by:
Ok, I think I just may be a moron, but where the heck are the Image extenders found? I've look all around, tried all the DB2 cd's I have, are they installed by default somewhere? Which install...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.