× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Both systems are configured to require a password. When I use CONNECT in
SQL, a user name and password prompt are displayed. Not with DSPPFM

John McKee

On Tue, Dec 23, 2014 at 3:06 PM, <rob@xxxxxxxxx> wrote:

Message ID . . . . . . . . . : CPF9190
Recovery . . . : Correct the problem indicated by the reason code if
possible, and attempt to connect again. A common cause for reason code
17
is that the server requires a password but the client sends only a user
ID,
or the server requires an encrypted password and the client did not send
an
encrypted password. The DRDA/DDM TCP/IP server can be configured to not

require a password or an encrypted password by using the CHGDDMTCPA CL
command.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: John McKee <jmmckee@xxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/23/2014 04:01 PM
Subject: Re: Access remote system file as if local
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



V5R4 system, PWDRQD has *NO, *YES, *ENCRYPTED, *VLDONLY, *KERBEROS, and
*SAME

CPF9190 - Authorization failure.....


Just about ready to leave for Christmas. Hope everybody has a Merry
Christmas!

John McKee

On Tue, Dec 23, 2014 at 2:15 PM, <rob@xxxxxxxxx> wrote:

CHGDDMTCPA AUTOSTART(*YES) PWDRQD(*USRIDPWD) ENCALG(*DES)

Might help to see that message id also.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: John McKee <jmmckee@xxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/23/2014 02:59 PM
Subject: Re: Access remote system file as if local
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I added relational database entry for remote system. That allows SQL to
function.

My most recent command:

CRTDDMF FILE(SVBBADPLPP) RMTFILE(BSYDTAA/BaDPLPP) RMTLOCNAME(xxxhis *IP)

No errors

dsppfm svbbadplpp

Authorization failure on DDM TCP/IP connection attempt. Reason code 17
-
The security mechanism requested by the client is not supported or
allowed
at the server.

I do not see parms for user and password, Why did yours work? Same
user
id/password on both systems?

John McKee

On Tue, Dec 23, 2014 at 12:55 PM, <rob@xxxxxxxxx> wrote:

And *NONSTD is probably for unlike systems, NOT IBM i to IBM i.

From my source IBM i (GDISYS) to a different lpar of IBM i (GDIHQ)

CRTDDMF FILE(QTEMP/LOOKIE) RMTFILE(ERPLXF/RCO) RMTLOCNAME(GDIHQ *IP)
DSPPFM QTEMP/LOOKIE
*...+....1....+....2....+....3....+....4....+....5.
A ??GROUP DEKKO 6928 N 400 E
A ??GRUPO DEKKO MEXICO S.A. DE C.VHENEQUEN NO. 1107
A ??Dekko Global Enterprise 6928 N 400 E
A ?|Group Dekko Holding
A ??Dekko Acquisition Parent 6928 N 400 E
****** END OF DATA ******

Operations ARE limited.
DSPPFM works.
RUNQRY QRYFILE(QTEMP/LOOKIE) does not.
RPG with RLA works fine
RPG with imbedded SQL is probably better served by the CONNECT TO
statement of SQL
STRSQL then SELECT * FROM QTEMP/LOOKIE does not work.
CPYTOIMPF fails asking you to fill in some non supplied SYSTEM
parameter.
Once again, my 'favorite' command falls flat on it's face.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Charles Wilt <charles.wilt@xxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 12/23/2014 12:36 PM
Subject: Re: Access remote system file as if local
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Yes, DDM is probably what you want..

But the systems ahve to be configured to talk to each other





http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/ddp/rbae5prepddm.htm




From a security standpoint look here





http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/ddp/rbal1secdb.htm




HTH,
Charles

On Tue, Dec 23, 2014 at 12:19 PM, John McKee <jmmckee@xxxxxxxxxxxxxx>
wrote:

Several files on the remote 520 (v5r3) ned to be accessed. I had
the
wild,
and possibly incorrect, notion that a file could be created on the
local
system that pointed to the remote system file. I >thought< this was
a
DDM
file. But, my efforts are't working. My first question is how
would
authentication for user be accomplished, as neither the CRTDDMF or
CHGDDMF
on the local (v5r4) system have user name and password parameters.

This the command I started with:

CRTDDMF FILE(SOURCE/SALES) RMTFILE(*NONSTD 'SALES.REMOTE')
RMTLOCNAME(NEWYORK)

Does what I want to do not work tis way?
Is this an issue where user and password

must be same on both systems? PLPP) RMTFILE(libray / file)
RMTLOCNAME(xxxx *IP)

Actual library and file names used in command. The xxxx was the
remote system name defined in the host table.

Is it possible? Am I using the right command?

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


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


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


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


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


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


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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.