I-series Navigator Database access

225 pts.
Tags:
iSeries database
iSeries Navigator
V5R4
V5R4M5
I have Client access loaded on my Laptop and have recently loaded the Database facility into Navigator. It loaded okay with no errors, Client Access is V5R4M0 and the I-series is V5R4M5.

My Problem is that when I go into Navigator and connect to the I-series and try to expand the database tree it does nothing. I have all the necessary authority and can expand the File Systems but not the Database.  Help!

Specifically, I am busy learning Web Query and I was to add Referential Integrity to the files I am accessing.



Software/Hardware used:
i-series Database Navigator V5R4M5
ASKED: January 7, 2010  12:00 AM
UPDATED: November 9, 2011  6:14 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Does the tree have the + sign next to it when you try to expand? What displays when you click on the Databases icon? Did you also install the latest iNav service pak (SI35856 or the prior release SI35287)?

Discuss This Question: 26  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RobertHart
    The + is there but nothing happens when I click on it. If I click on Databases the panel to the right clears but that is all. I have checked our PTF's and we have no SIxxxx's, is this the right place to look?
    225 pointsBadges:
    report
  • Whatis23
    Click on the IBM iSeries Access for Windows icon (should be on your desktop when you installed) then click on the iSeries Access for Windows Properties icon. You will see the current Service Level under the General tab.
    5,665 pointsBadges:
    report
  • TomLiotta
    It's also possible that you'll need to re-install the service pack on your PC if it shows as being at a recent service level. You added a pretty significant new component -- that component probably needs some updates from the service pack. Tom
    125,585 pointsBadges:
    report
  • RobertHart
    Okay, Thanks for that. I have downloaded and applied the fixes to bring us up to date. That hasn't helped, but now I realize when I click on the + it says 0 objects! Now why would that be?
    225 pointsBadges:
    report
  • DanD
    Are you sure these are true SQL package created database? Enter wrkrdbdire and verify you do have relational database entries.
    2,865 pointsBadges:
    report
  • RobertHart
    Hi Dan. I'm not skilled with SQL at all. I have checked the 400 using that command and there is one entry on the list. Is that enough?
    225 pointsBadges:
    report
  • DanD
    Does the entry have a Remote Location of *Local? Ops Nav usually only shows the *Local entry since it can't really get information on true remote databases. Make sure you have a *LOCAL entry, usually the system name.
    2,865 pointsBadges:
    report
  • RobertHart
    Under my connections it has the IP for our system and under that it has Databases, which reports 0 entries and under that is File Systems which happily branches out to the IFS and File Shares. Do we need something else loaded on the i-series?
    225 pointsBadges:
    report
  • DanD
    If you have a local db described you will see it with a remote location of *Local usning the WRKDBRDIRE command. If not create it.
    2,865 pointsBadges:
    report
  • RobertHart
    That is there, it is the entry I referred to in an earlier reply. The entry name is S6566FC2, remote location is *LOCAL, Text "Entry added by system".
    225 pointsBadges:
    report
  • pdraebel
    Are any PTF's applied on the iSeries ? (I have checked our PTF’s and we have no SIxxxx’s, is this the right place to look?) Make sure at least on Cum PAck and the necessary group PTF's are applied.
    2,380 pointsBadges:
    report
  • RobertHart
    Pdraebel wrote "Are any PTF’s applied on the iSeries ? (I have checked our PTF’s and we have no SIxxxx’s, is this the right place to look?) Make sure at least on Cum PAck and the necessary group PTF’s are applied." The SI's go on the PC and I have loaded all these. We're not at the lastest CUM on the I-series but are waiting on a window at the moment. Somehow I don't think this will affect my problem though.
    225 pointsBadges:
    report
  • RobertHart
    whatis23 wrote "Does the tree have the + sign next to it when you try to expand? What displays when you click on the Databases icon? Did you also install the latest iNav service pak (SI35856 or the prior release SI35287)?" The tree does have the + but nothing happens when I click on it as I stated on the 7th. Since then I have brought us up to SI35856 but nothing changed. wrkrdbdire on the i-series says I have a local entry.
    225 pointsBadges:
    report
  • Hamad
    tell me about a databes
    10 pointsBadges:
    report
  • pdraebel
    Maybe some service is blocked on iSeries. Normally your remote database works with *DRDA (check WRKDBDIRE for settings) this would be Port 446. Doing NETSTAT and using option 3 check for an entry that states a listen on port DRDA.
    2,380 pointsBadges:
    report
  • RobertHart
    Pdraebel wrote "Maybe some service is blocked on iSeries. Normally your remote database works with *DRDA (check WRKDBDIRE for settings) this would be Port 446. Doing NETSTAT and using option 3 check for an entry that states a listen on port DRDA." I have checked and all this appears to be open and going. The entries are certainly present and listening.
    225 pointsBadges:
    report
  • Whatis23
    "The entry name is S6566FC2" Text “Entry added by system" Can you confirm S6566FC2 is your system name? Type STRSQL, you will get the message "Current connection is to relational database ???" where ??? should match S6566FC2. If not, that's your issue.
    5,665 pointsBadges:
    report
  • RobertHart
    Whatis23 wrote "Can you confirm S6566FC2 is your system name? Type STRSQL, you will get the message “Current connection is to relational database ???” where ??? should match S6566FC2. If not, that’s your issue." Yes, ??? is S6566FC2. However that is not our system name. Should I put an alias in somewhere? If so, where? I tried putting it into WRKRDBDIRE but it didn't like it.
    225 pointsBadges:
    report
  • RobertHart
    Okay, extra Info. I happened to right click on our system name in iNav and it brought up some interesting Options which I hadn't seen before. Wondering if they might help I clicked on "Inventory" then "Collect" and it said it would need to connect to gather info and that this might take a while. Soon after it came up with an M/S error msg "cwbunnav.exe has encountered a problem..." with the options to send a report or not, either option then ends iNav. Maybe there is something in this problem that is stopping us?
    225 pointsBadges:
    report
  • TomLiotta
    First, the *LOCAL database name in the relational database directory does indeed have to exist, but it doesn't have to match the system name. If the *LOCAL entry exists, that's all you need to know about it. Also, don't be concerned about the "Inventory" and other options on the context menu for your connection. Those won't be related to your problem. However, the rest of this might be difficult if all you have available under your Connection are Databases and File systems. You will also need to have the Network node available in order to determine if the proper server functions are even started on your host system. For all we know, the database server hasn't even been started yet. Although it's easy to start through green-screen command lines, getting status info can be very tricky without the right tools. Are you sure that Databases and File systems are the only two nodes under your Connection? Finally, SIxxxxxx PTFs might go on either your host system or your PC. Some even can go on both. But the question would be -- did you simply put it on your PC or did you also install it? (I hope that isn't an insult. It has to be asked.) Tom
    125,585 pointsBadges:
    report
  • RobertHart
    Hi Tom, The Tree is, simplified, as follows My Connections - 10.42.1.42 (Our Systems Private IP) + Databases - File Systems + Integrated File systems + File Shares Yes I have applied the SI's on the PC. It shows in the "i-series for windows properties" We haven't applied any on the i-series itself. And no I'm not insulted. I often have to ask what could be perceived as the "blonde" questions myself. it always pays to check as I have had times when that has proved to be the answer. Like "Is the power on?!!!"
    225 pointsBadges:
    report
  • Whatis23
    If you manually create a relational database name, you can certainly use any naming convention, not just the system name. However if the system creates it (Entry added by system), it will pull the system name from the DSPNETA command: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/ddp/rbal1rdbdir.htm
    5,665 pointsBadges:
    report
  • RobertHart
    Hmmm, Okay, the RDBDIRE shows S6566FC2 as the entry name and it is system created but when I look at DSPNETA it does not show that name anywhere. I went, carefully, to look at replacing the RDB entry but it is in use with other systems so that would be bad. Any further ideas?
    225 pointsBadges:
    report
  • TomLiotta
    My Connections
    - 10.42.1.42 (Our Systems Private IP)
    + Databases
    - File Systems
    + Integrated File systems
    + File Shares
    I'm not sure what all might be lost by having only those options -- Databases and File systems. It definitely complicates tracking the issue down. (I'm fortunate to always have all options installed plus plenty authority.) Are there other PCs that you can access that can provide the Network node along with the two that you have? Mostly, you will only need the status of the Network host (iSeries Access) servers. E.g., is the Remote Command host server running? Is the Server Mapper host server running? Are relevant servers showing joblog messages? (If there is a firewall beyond your PC, does it have the appropriate ports open?) The status of the host servers is critical to know. There are also times when some of the TCP/IP servers are necessary, but there's no point in those if one of the host servers is an issue. Without knowing host servers status, there's no good way to interpret results. Tom
    125,585 pointsBadges:
    report
  • RobertHart
    Thanks Tom. I've been busy hence not replying but today I went through and loaded everything in the Client Access Stable. This then opened up the Database chain. I will now need to find out what it was that was the critical component as we will be giving some of this to clients and we don't want to release everything to them. To dangerous given our environment. Thanks to everyone else who contributed.
    225 pointsBadges:
    report
  • naresh1984
    Hi .. In the navigator panel.Select the system. Just give a right click the system .Click on properties. Then you must see recovery tab.Select it and check all the option( history log..eg) and click start Recovery .then you must see a screen need to check every day .Just click .then You might get one more screen select yes.then restart the navigator. you wont get the alert. I have try the same issue for one of client today .Its work.
    365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following