Did you use the same userid that you set up the user mapping for ? Check to
see what the errors are at the source site .






"Ramakrishna
Reddy "
<db2udbdba-ezmlms To
hield-x12391739.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

04/25/2006 07:58 Subject
AM Error while creating the Nick names
on AIX










Hi Guru's,
The following error I'm getting while creating the nicknames.
OS:AIX
DB2:V8.1 FIXPACK 9

SQL1822N Unexpected error code "<error-code>" received from data
source "<data-source-name>". Associated text and tokens
are "<tokens>".

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

WHAT IS THE PROBLEM?can you provide me the solution?
thanks in advance.

Thanks & Regards,
RK



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page