Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 627
  • Last Modified:

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?
0
roosterup
Asked:
roosterup
  • 4
  • 2
1 Solution
 
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
 
roosterupAuthor Commented:
Adjusted points from 5 to 30
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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
 
BERRY2KCommented:
In DECS admin, turn on data journaling to create the sql packages.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now