Domino for AS/400 DECS

I'm trying to implement DECS for domino as/400.  I have a couple of examples and several red and yellow books. When I try and create a new connection for DB2 the DECS administrator displays a message "browsing server" and hangs up. This happens when I click on the arrow for choosing an Owner under the Table Selection fields. I have added a relational database directory entry. How can I get DECS working or where can I look for good documentation on implementing DECS?
LVL 1
roosterupAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BERRY2KConnect With a Mentor Commented:
In DECS admin, turn on data journaling to create the sql packages.
0
 
jodo741309Commented:
You may have to ADDRDBDIRE to add the AS/400 into the Relational DataBase DIRectory (Entry).
0
 
roosterupAuthor Commented:
I have had a relational database directory with a rmtlocname of "*local".
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
roosterupAuthor Commented:
Adjusted points from 5 to 30
0
 
roosterupAuthor Commented:
I finally got this to quit hanging up, but ran directly into another problem.  The DB/2 files I'm trying to access are not on the Domino/400 server.  I added a Relational Database Directory Entry for our production 400,and recieved this error message when trying to create a connection in DECS Admin:

Error: SQL package QSQCLIPKGN in QGPL not found at DRDA Server, Connector
'db2' Method -Connect (-805)

Anyone know what that means or have and advice for getting my 400's to talk to each other using DECS?
0
 
roosterupAuthor Commented:
I know my 400's can talk to each other. The DECS administrator is looking for an sql package QSQCLIPKGN in QGPL. How do I create this?
0
 
jodo741309Commented:
If you have SQL installed (licensed program 5769-ST1), can you connect to the production AS/400 via:

1. STRSQL
2. connect to <production AS/400 RDBDIRE name>
3. select * from <some file on the production AS/400>

This ensures that a DRDA connection can be established between the two machines.

another test is to create a DDM file on the Domino machine that points to the production machine and then try to DSPPFM <DDM file> to see if a connection can be made.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.