Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 06:03 AM
hmh
Guest
 
Posts: n/a
Default SQL1651N exporting to/from db2 v8.1

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
  #2  
Old November 12th, 2005, 06:03 AM
Blair Adamache
Guest
 
Posts: n/a
Default 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]

  #3  
Old November 12th, 2005, 06:03 AM
Ian
Guest
 
Posts: n/a
Default 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 incompatibilities 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! =-----
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,248 network members.