473,597 Members | 2,364 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

federation windows-aix

By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda
(LIBRARY LIBDB2DRDA.a not available in windows box)
2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA"
AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' );
3. If the above steps are through, probably user mapping/nicknames are
straight forward.
The create server step is failing as drda is not valid for aix.
What steps should be followed, please elaborate with examples.
Database abc on windows has same tables on aix, should be able to
flip/flop between both located on different servers(windows/aix), db2
is version 8.1.

Nov 12 '05 #1
8 5052
SQL1822N Unexpected error code "-30082" received from data
source "AIX". Associated text and tokens are
"func="DriverCo nnect" msg=" SQL30082N Attempt to establ".

Explanation:

While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.

Possible error codes include:

o 4901 Trying to open more than 15 cursors

o 4902 Row size exceeds 32K limit

This error might also be returned if the data source is not
available.

User Response:

Ensure the data source is available, then identify and correct
the root cause of the problem by locating the appropriate message
text and corrective action for the specified error at the data
source.

sqlcode : -1822

sqlstate : 560BD

Nov 12 '05 #2
What's your FEDERATED parameter set to in your dbm cfg?

Can you successfully access the remote database from your Federated
server using the DB2 client by issuing a DB2 Connect ?

Larry Edelstein

hi****@gmail.co m wrote:
By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda
(LIBRARY LIBDB2DRDA.a not available in windows box)
2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA"
AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' );
3. If the above steps are through, probably user mapping/nicknames are
straight forward.
The create server step is failing as drda is not valid for aix.
What steps should be followed, please elaborate with examples.
Database abc on windows has same tables on aix, should be able to
flip/flop between both located on different servers(windows/aix), db2
is version 8.1.


Nov 12 '05 #3
DBM parameter is set to a YES for federated.

We do not have DB2 connect, do we need it?
I am able to federate between different servers running on windows.
From Windows-unix, or unix-windows, I am not able to.

Larry wrote: What's your FEDERATED parameter set to in your dbm cfg?

Can you successfully access the remote database from your Federated
server using the DB2 client by issuing a DB2 Connect ?

Larry Edelstein

hi****@gmail.co m wrote:
By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda
(LIBRARY LIBDB2DRDA.a not available in windows box)
2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA"
AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' );
3. If the above steps are through, probably user mapping/nicknames are straight forward.
The create server step is failing as drda is not valid for aix.
What steps should be followed, please elaborate with examples.
Database abc on windows has same tables on aix, should be able to
flip/flop between both located on different servers(windows/aix), db2 is version 8.1.


Nov 12 '05 #4
You don't need DB2 Connect. But you do need to be able to connect from
the machine that you are issuing the commands on (i.e. the Federated
Server) and the machine that you are trying to access (the backend data
source). The first thing you should do before doing anything else is
attempt to CONNECT from the Federated Server to the backend data source
without Federated support to see if you can establish connectivity and a
CONNECT. Can you ping it? And can you CONNECT to it (you need to
establish the proper catalog entries in order to CONNECT to it those
being the NODE and DB catalog entries ... you can do this at the command
line or use the Configuration Assistant)? If you can, then it proves
connectivity and then you'll need to do further analysis to find out
what the problem is. If you cannot, then post the exact error msg and
perhaps someone can help.

Larry Edelstein

hi****@gmail.co m wrote:
DBM parameter is set to a YES for federated.

We do not have DB2 connect, do we need it?
I am able to federate between different servers running on windows.
From Windows-unix, or unix-windows, I am not able to.

Larry wrote:
What's your FEDERATED parameter set to in your dbm cfg?

Can you successfully access the remote database from your Federated
server using the DB2 client by issuing a DB2 Connect ?

Larry Edelstein

hi****@gmail. com wrote:

By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda
(LIBRARY LIBDB2DRDA.a not available in windows box)
2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA"
AUTHORIZATIO N xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' );
3. If the above steps are through, probably user mapping/nicknames
are
straight forward.
The create server step is failing as drda is not valid for aix.
What steps should be followed, please elaborate with examples.
Database abc on windows has same tables on aix, should be able to
flip/flop between both located on different servers(windows/aix),
db2
is version 8.1.



Nov 12 '05 #5
hi****@gmail.co m wrote:
SQL1822N Unexpected error code "-30082" received from data
source "AIX". Associated text and tokens are
"func="DriverCo nnect" msg=" SQL30082N Attempt to establ".


$ db2 "? sql30082"
SQL30082N Attempt to establish connection failed with security
reason "<reason-code>" ("<reason-string>").

As Larry guessed, you can't connect to the remote data source/DB2 instance.
(The exact error message is probably in the db2diag, depending on your
DIAGLEVEL.)

Is your user-name/password case-sensitive? If it is, you might want to
enclose it in double-quotes.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #6
aix node/db is already cataloged in the windows server.

In windows db,
1. There is only option to choose wrapper library db2drda.dll
2. While creating server on windows, there is no errors if I create as
Type DB2/UDB
3. If I do as above, and create username mapping--here I specify
userid/password for aix. and then nickname, while I issue a
select-still I get sqlcode 30082.
4. If I give the username/pass used in windows for this db, it works
well and accesses windows. If I give the aix username/pass, I get
sqlcode 30082.

I can do successfully -Ping, connect to db etc

Error message is

hik...@gmail.co m Feb 14, 2:30 pm show options

Newsgroups: comp.databases. ibm-db2
From: hik...@gmail.co m - Find messages by this author
Date: 14 Feb 2005 14:30:50 -0800
Local: Mon, Feb 14 2005 2:30 pm
Subject: Re: federation windows-aix
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

SQL1822N Unexpected error code "-30082" received from data
source "AIX". Associated text and tokens are
"func="DriverCo nnect" msg=" SQL30082N Attempt to establ".
Explanation:
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.
Possible error codes include:
o 4901 Trying to open more than 15 cursors
o 4902 Row size exceeds 32K limit
This error might also be returned if the data source is not
available.
User Response:
Ensure the data source is available, then identify and correct
the root cause of the problem by locating the appropriate message
text and corrective action for the specified error at the data
source.
sqlcode : -1822
sqlstate : 560BD

Nov 12 '05 #7
30082 is a security error. Is there a complete SQL30082N msg with reason
code in your db2diag.log? It is likely related to the userid or pw being
passed to the backend server and whether the backend server considers
them valid or not. This can also happen due to the fact that UNIX is
case-sensitive.

Larry Edelstein

hi****@gmail.co m wrote:
aix node/db is already cataloged in the windows server.

In windows db,
1. There is only option to choose wrapper library db2drda.dll
2. While creating server on windows, there is no errors if I create as
Type DB2/UDB
3. If I do as above, and create username mapping--here I specify
userid/password for aix. and then nickname, while I issue a
select-still I get sqlcode 30082.
4. If I give the username/pass used in windows for this db, it works
well and accesses windows. If I give the aix username/pass, I get
sqlcode 30082.

I can do successfully -Ping, connect to db etc

Error message is

hik...@gmail.co m Feb 14, 2:30 pm show options

Newsgroups: comp.databases. ibm-db2
From: hik...@gmail.co m - Find messages by this author
Date: 14 Feb 2005 14:30:50 -0800
Local: Mon, Feb 14 2005 2:30 pm
Subject: Re: federation windows-aix
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

SQL1822N Unexpected error code "-30082" received from data
source "AIX". Associated text and tokens are
"func="DriverCo nnect" msg=" SQL30082N Attempt to establ".
Explanation:
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.
Possible error codes include:
o 4901 Trying to open more than 15 cursors
o 4902 Row size exceeds 32K limit
This error might also be returned if the data source is not
available.
User Response:
Ensure the data source is available, then identify and correct
the root cause of the problem by locating the appropriate message
text and corrective action for the specified error at the data
source.
sqlcode : -1822
sqlstate : 560BD


Nov 12 '05 #8
Finally I resolved this by:
1. properly specifying remote server's credentials while running
"create server"
2. I had another issue(30082 error ) while I tried to "create nickname"
from control center. I tried running the same command from CLP and it
went fine.

Thanks Larry for your replies!!

Larry wrote:
30082 is a security error. Is there a complete SQL30082N msg with reason code in your db2diag.log? It is likely related to the userid or pw being passed to the backend server and whether the backend server considers them valid or not. This can also happen due to the fact that UNIX is
case-sensitive.

Larry Edelstein

hi****@gmail.co m wrote:
aix node/db is already cataloged in the windows server.

In windows db,
1. There is only option to choose wrapper library db2drda.dll
2. While creating server on windows, there is no errors if I create as Type DB2/UDB
3. If I do as above, and create username mapping--here I specify
userid/password for aix. and then nickname, while I issue a
select-still I get sqlcode 30082.
4. If I give the username/pass used in windows for this db, it works well and accesses windows. If I give the aix username/pass, I get
sqlcode 30082.

I can do successfully -Ping, connect to db etc

Error message is

hik...@gmail.co m Feb 14, 2:30 pm show options

Newsgroups: comp.databases. ibm-db2
From: hik...@gmail.co m - Find messages by this author
Date: 14 Feb 2005 14:30:50 -0800
Local: Mon, Feb 14 2005 2:30 pm
Subject: Re: federation windows-aix
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse

SQL1822N Unexpected error code "-30082" received from data
source "AIX". Associated text and tokens are
"func="DriverCo nnect" msg=" SQL30082N Attempt to establ".
Explanation:
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.
Possible error codes include:
o 4901 Trying to open more than 15 cursors
o 4902 Row size exceeds 32K limit
This error might also be returned if the data source is not
available.
User Response:
Ensure the data source is available, then identify and correct
the root cause of the problem by locating the appropriate message
text and corrective action for the specified error at the data
source.
sqlcode : -1822
sqlstate : 560BD


Nov 12 '05 #9

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

Similar topics

2
1605
by: RavenCross | last post by:
we are in need of a game developer rather quickly. Candidates will be responsible in assisting in all coding from marketing, developing new games, maintaining and updating existing games in the Space Federation. Interested candidates can apply and start work anytime with us.we mostly need still mech pictures. Space Federation is an endeavor to bring free internet games to the public. With over 290,708 registered players playing daily, we...
14
4329
by: spencer | last post by:
My client is going through a large project to replace existing data warehouse physical infastructure which is running DB2 8.1.6. In the past we had a much more distributed environment where we had certain portions of the data warehouse on a physically different server. We utilized federation to allow the joining of tables on seperate instances. We found that this worked ok in situations where the tables were not that large say under...
3
1850
by: BobTheDatabaseBoy | last post by:
can't find in the RedBook, or scouring this NG, a simple yes/no answer to the question: given mountains of existing COBOL programs which have read/written to multiple schemas, but in one z/OS(v7) instance, whether Information Integrator exists for that platform, and would allow reading/writing to schemas in multiple instances. the doc reads (to me) like II sends all data through an LUW instance.
3
3229
by: Baski | last post by:
Hi, I have few questions, 1) I have DB2 8.2 ESE, with a db2 instance and a few databases. Is it posiible to create and configure a federated server. what are the things/steps required to do so. For federation server should I have additional tool called Information Integrator or can I do without it? Does the Wrapper to connect to
5
1944
by: BobTheDataBaseBoy | last post by:
A client has 390/V7 and UDB/V8. It would be useful to use row_number() when selecting from 390, but that's not supported. It occurs to me (I'm not in CubeLand, and anyway we upgraded to V8 on z/OS) that federation (on UDB/V8) might support functions on those 390/V7 tables. Is this known? thanks
0
2039
by: vbace2 | last post by:
Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that the...
5
5938
by: mitrofun63 | last post by:
Hi, All In the first place sorry for mu english. I'm trying to integrate DB2 9.1.3 (with WebSphere Federation Server Relational Wrappers installed) and PostgreSQL 7.4 on SLES9 box I have configured the unixODBC library for access to Postgre database, is worked normal (test connect and select from test table via tool / usr/bin/isql is fine)
1
1644
by: biexplorer | last post by:
Hi, I am new to DB2. We recently migrated from Oracle to DB2. And now, I want to setup what we call a DB link (in Oracle) in DB2. I have done some research / read some posts in this forum already. And I came to know that we need to setup federated access, create wrappers, create servers and then nicknames. My question is: I enabled federation using the command
1
2824
by: dif1754 | last post by:
My Windows DB2 Server 9.x is connected, via federation, to a remote AS/ 400 system: I created several nicknames to remote tables and I can query them. Problem is, during the night, my remote AS/400 is rebooted and DB2 Server cannot connect back to it. Is there any DB2 parameter I must set to reconnect automatically to the remote federated AS/400.
1
2333
by: Kozy | last post by:
Hello everyone, I have a problem with federation between Oracle and DB2. Once every few weeks my DB2 federation request "dies". What happens is DB2 thinks it is still geting information from oracle, but on Oracle there is nothing executing. This connection then stays active for undefined amount of time ( 5 days was the last accurance). Killing the process doesnt work, all I can do to remove it is to restart the server. Db2stop force...
0
7884
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8258
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6681
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5844
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3880
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3921
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1493
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1229
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.