473,796 Members | 2,544 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"User mapping missing" when accessing FEDERATED nickname

aj
DB2 WSE LUW 8.1 Fixpak 5
Red Hat AS 2.1

I'm trying to set up a federated view from one DB2 database to
another in the same instance on the same server.

I do a:
create server <SERVER> type DB2/UDB version 8.1 wrapper DRDA
authorization <INSTANCE_OWNER > password "<PASSWD>" options
(NODE 'LOCAL',DBNAME '<DBNAME>',FOLD _ID 'N',FOLD_PW 'N')

then I create a nickname against that remote db.

Everything goes fine, but when I try to access the nickname or
view in the CLP, I get:

SQL1822N Unexpected error code "User mapping missing" received
from data source "". Associated text and tokens are "".

My DBM cfg AUTHENTICATION setting is SERVER, and the 2 databases
are in the same instance, so I thought a user mapping was not
necessary.

The weird part is that, while logged in as the instance owner
in CC, I can right-click on the nickname, and successfully sample
the contents.

Any ideas?

aj
Nov 12 '05 #1
0 1814

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

Similar topics

0
3236
by: Vance Kessler | last post by:
Yes, yes, I know why are we using Crystal 7 under Windows 2003. Well we have to for now. We had a website that was working just fine under Windows 2000 then we re-staged the boxes upgraded to Windows 2003 and now we are having problems with Crystal 7. The thing is that this works on development machines also running the same version of Windows 2003. We are not running in IIS 5 compatibility mode nor do we want to. The problem is...
3
2247
by: Tamir Khason | last post by:
I have unmanaged COM wich is ActiveX I want to use it as signed interop user control so doing aximp MyComActiveX.dll /keyfile:MyKey.snk it builds MyComActiveLibX.dll wich is signed and AxMyComActiveXLib.dll wich is interoped ActiveX control. This one Ax... DOES NOT SIGNED !!! and when using it inside the form I recieve "Assembly generation failed -- Referenced assembly 'AxMyComActiveXLib' does not have a strong name What is the...
1
2117
by: fl | last post by:
I am running ASPNET on my local machine. I have a problem when I try to connect to a SQL server database table. The data looks good when I right click SqlDataAdapter1 to preview the data. When F5 to run it, I get this error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection..." Here is my code (they are all generated by the wizard): Public Class WebForm1 Inherits System.Web.UI.Page
1
1754
by: platinumbay | last post by:
Sometimes when I run or build (or save I think) one of several VB .NET CE applications I get the above error. I then get a 'save file as' option to change the 'myapp.vbdproj' file. If you keep the same name you get an 'already exists' error. If you choose to overwrite you get: The file Pms_myapp.vbdproj has changed since you opened it. Would you like to save the version you have open over the changes on disk? You then get the following...
0
1562
by: Sean Quilty | last post by:
Help! We are getting the following errors on a slave server: 060304 7:42:03 Error reading packet from server: Could not find first log (server_errno=65535) 060304 7:43:03 Slave: Failed reading log event, reconnecting to retry, log 'wcassp801.2514' position 76 060304 7:43:03 Slave: reconnected to master 'repl@10.20.10.10:3306',replication resumed in log 'wcassp801.2514' at position 76 We are running mysql v3.23.58-max-log on a...
1
1545
by: geri.gan | last post by:
I have C API just like this: enum void getinfor(const struct inputinfor *a, const struct outputinfor ** b) i use p/invok to translate it to internal static extern void getinfor(ref inputinfor a, ref
1
4544
by: contact.morrison | last post by:
Hello, I'm very new to Python, and unsure how to handle this runtime error below. Pointers in the right direction (RTFM here ... etc) most appreciated. I have an object, called article, that when printed has the following structure: {'title': 'wbk', 'entries': }('http://wbk.opendarwin.org/blog/?p=51', 1)
0
6696
by: godsmustbcrazy | last post by:
Here is my problem. Brand new SQL Server 2005 Installation 1. Create a database "Test" 2. Create a database user "Domain\user" and set user mapping to "Test" with datareader, datawriter permissions 3. Look at Test ->Properties->Permissions activate "Domain\user" and click effective permissions and I get this error message
1
4288
by: BobPaul | last post by:
I'm following code out of a howto book and this is really bugging me. This header file was created by VStudio 6.0 when I did a "Right Click: Add Member Function" CLine is a class I wrote (per the book's instructions) and Line.h in included in Day10Doc.cpp Here is the contents of Day10Doc.h #if !defined(AFX_DAY10DOC_H__16736853_CB29_49E7_A8ED_C912CAE666EC__INCLUDED_) #define AFX_DAY10DOC_H__16736853_CB29_49E7_A8ED_C912CAE666EC__INCLUDED_ ...
0
9680
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10456
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
9052
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
7548
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
6788
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5442
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
5575
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4118
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3731
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.