SQL1651N exporting to/from db2 v8.1

[hmh]

Hello,

I recently installed DB2 v8.1 on a linux box, among other things I was
planning to use that box to connect to various other DB2 servers (NB.
all are DB2 version 7.1) and export few tables for backup purposes.
I have no problem cataloging/connecting/selecting to the remote nodes
and databases, but when I execute the export command from the v8.1
server I get this error:

---------------
SQL1651N The request cannot be executed because the DB2 server
version does not support this functionality.

Explanation:
Some new functionality is not supported against older DB2 server
versions. Another possible cause of this error could be the
request referenced objects with qualifiers of length that exceeds
the support of the server version.

User Response:
Execute the request against a DB2 server where the latest DB2
server version has been installed, or upgrade the server to the
latest DB2 server version.
----------------

Ok, I fully understand this error but found it very surprising because
I had done similar things between versions 7.x and 6.x.

Is it possible to install a client from the 7.x family and have it
co-exist with the v8.1 server and do my connections from that client
envirionment?

Any comments appreciated.

Regards,
Skyr

[Blair Adamache]

Re: SQL1651N exporting to/from db2 v8.1

You might have to configure the v7 server as a DRDA Server - the client
interfaces got rewritten in v8 to use DRDA exclusively. See the release
notes under "Back-level DB2 server support" for restrictions and the
DRDA workaround.

hmh wrote:
[color=blue]
> Hello,
>
> I recently installed DB2 v8.1 on a linux box, among other things I was
> planning to use that box to connect to various other DB2 servers (NB.
> all are DB2 version 7.1) and export few tables for backup purposes.
> I have no problem cataloging/connecting/selecting to the remote nodes
> and databases, but when I execute the export command from the v8.1
> server I get this error:
>
> ---------------
> SQL1651N The request cannot be executed because the DB2 server
> version does not support this functionality.
>
> Explanation:
> Some new functionality is not supported against older DB2 server
> versions. Another possible cause of this error could be the
> request referenced objects with qualifiers of length that exceeds
> the support of the server version.
>
> User Response:
> Execute the request against a DB2 server where the latest DB2
> server version has been installed, or upgrade the server to the
> latest DB2 server version.
> ----------------
>
> Ok, I fully understand this error but found it very surprising because
> I had done similar things between versions 7.x and 6.x.
>
> Is it possible to install a client from the 7.x family and have it
> co-exist with the v8.1 server and do my connections from that client
> envirionment?
>
> Any comments appreciated.
>
> Regards,
> Skyr[/color]

[Ian]

Re: SQL1651N exporting to/from db2 v8.1

hmh wrote:
[color=blue]
> Ok, I fully understand this error but found it very surprising because
> I had done similar things between versions 7.x and 6.x.[/color]

The incompatibiliti es between V7 and V8 code are documented in the Quick
Beginnings guide.
[color=blue]
> Is it possible to install a client from the 7.x family and have it
> co-exist with the v8.1 server and do my connections from that client
> envirionment?[/color]

On a Linux (or Solaris/AIX/HPUX) environment, it is not a problem to have
both V7 and V8 code installed on the same server. Just make sure that you
have the correct environment configured (i.e. sourcing the right db2profile).


Good luck,




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----