RE: Problem on using DDM and DRDA

["Weatherly, Howard" <Howard.Weatherly@xxxxxxxxxxxx>]

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.