RE: Problem on using DDM and DRDA

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
You may also need to do the sql commands SET CONNECTION RESET ans RELEASE
ALL SQL. You may need to reconnect to your local DB CONNECT TO S10A0031 <or
whatever you local DB is called> and somewhere in there depending on you SQL
options you may need to do a COMMIT or ROLLBACK.

-----Original Message-----
From: Chris Yuen [mailto:yuen_chris@hotmail.com]
Sent: Wednesday, August 14, 2002 11:20 PM
To: midrange-l@midrange.com
Subject: Problem on using DDM and DRDA



Basically, performance of DDM was quite smooth in our system.  Recently, I
tried to use DRDA by setting up entry in Relational Database Directory
(WRKRDBDIRE), and used the ¡¥CONNECT TO¡¦ command in SQL to connect to
target system.  Data in the system was successfully retrieved.
After all these procedure, the following messages displayed when I
performed DDM operation.
¡¥Database TCP/IP or local socket connection ended.¡¦
¡¥Authorization failure on DDM TCP/IP connection attempt.¡¦
¡¥Cannot assign of release DDM file(s).¡¦

If I manually set up connection between the systems by using the ¡¥CONNECT
TO¡¦ command in SQL, DDM operation can be performed.  But the problem
occurred again when the DDM server was being reset.

It is interesting that before I try the DRDA, it doesn¡¦t need the ¡¥
CONNECT TO¡¦ command for DDM operation. I¡¦ve removed the entry in
Relational Database Directory, the problem still occurred.

I cannot find a way to set it back to the original status, any help in this
issue is highly appreciated.  Thanks!



_________________________________________________________________
¨Ï¥Î¥þ²y³Ì¦h¤H¨Ï¥Îªº¹q¤l¶l¥óªA°È MSN Hotmail¡Ghttp://www.hotmail.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.