Hello listeners,
I am having trouble setting up federated databases on an NT server running
UDB version 7.2. I've created two instances; one on NT "development' and
one for a connection to DB2/OS390 version 6.1.2 development. Both are
accessable via Control Centre. Now we want to "connect" the NT database
with DB2/OS390 to do some ETL for our datawarehouse. After creation of the
wrapper DRDA the creation of the server fails constantly, whatever we
specify.
The problem occurs when I run the following "Create Server" command in
UDB/NT:
CREATE SERVER "DB2TFED"
TYPE DB2/390
VERSION 6.1
WRAPPER "DRDA"
AUTHID MFid
PASSWORD MFpw
OPTIONS(NODE '{servername of the NT server}', DBNAME '{location name of DB2
on OS390}')
Via Control Centre it's only possible to select the {servername of the NT
server}; no other nodes are listed.
This command fails with the following message:
During SQL processing it returned: SQL1822N Unexpected error code "-1096"
received from data source
"DB2TFED". Associated text and tokens are "".
I have been unable to find any documentation on error code -1096. Has
anyone seen this before?
Thanks in advance,
Hessel Rus
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
