Solved

Domino for AS/400 DECS

Posted on 2000-04-28
7
615 Views
Last Modified: 2008-02-01
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
Comment
Question by:roosterup
  • 4
  • 2
7 Comments
 
LVL 1

Expert Comment

by:jodo741309
ID: 2767877
You may have to ADDRDBDIRE to add the AS/400 into the Relational DataBase DIRectory (Entry).
0
 
LVL 1

Author Comment

by:roosterup
ID: 2769432
I have had a relational database directory with a rmtlocname of "*local".
0
 
LVL 1

Author Comment

by:roosterup
ID: 2777074
Adjusted points from 5 to 30
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:roosterup
ID: 2777075
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
 
LVL 1

Author Comment

by:roosterup
ID: 2778487
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
 
LVL 1

Expert Comment

by:jodo741309
ID: 2778543
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
 

Accepted Solution

by:
BERRY2K earned 30 total points
ID: 2788606
In DECS admin, turn on data journaling to create the sql packages.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now