Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace IBM i
Created by Guest
Created on Jan 16, 2019

Modernize host server by IP routing functionality

I would like to see the older capability to route by IP address modernized and enhanced.

In i7.3 (and TRs for 7.1 and 7.2), new functionality was added to route host server jobs by the user name, managed entirely using SQL Stored Procedures. (Reference: http://www-01.ibm.com/support/docview.wss?uid=nas8N1021000) This appears to be much more admin-friendly than the way the IP-based rules are managed.

Documentation for the host server IP routing as it stands now: N1021000 Routing Connections to Subsystems Based On User ID, https://www-01.ibm.com/support/docview.wss?uid=nas8N1019587

First Requirement: Add procedures to manage and maintain entries for routing to host servers by IP via SQL.
Currently, there is no way to manage the host server IP routing outside of Navigator. This leaves no way to script the entries to apply them on multiple partitions - they all have to be entered manually. UX is very poor for this feature, with a very limited list view regardless of browser area, subnet masks displayed in CIDR notation on the list but entered and displayed in dotted notation on the edit screens. Being able to list (and sort and filter!) these entries via SQL would be very helpful.

Second Requirement: Change the rule definition to be consistently a combination of network address + subnet
Currently, these rules confusingly specify an "IP address" or "IP address range", both requiring a subnet mask, Common practice for IP configuration is to either specify absolute ranges, or to specify a network address and subnet, but not either/both. ADDTCPRTE for example takes a single address and subnet mask.

Third Requirement: Make the rules consistently apply using most-specific rule first
Document N1015862 Host Server Customization Requirements for TCP/IP Address and Subnet Mask, https://www-01.ibm.com/support/docview.wss?uid=nas8N1015862, explains the how the subnet masks work. At the bottom of this document, it indicates that "the order that the entries ad added to the list will also affect the outcome." The problem here is Navigator always displays the entries sorted by IP Address, with the "IP address" entries first, followed by the "IP address range" entries -- there is no way to see what order they were actually added in. I would suggest a better way to do this is to take the most-specific match. Example: For rule A = 192.168.1.0/24 and rule B = 192.168.1.32/30, the addresses 192.168.1.32 - 192.168.1.35 would use rule A, and addresses 192.168.1.0 - 192.168.1.31 or 192.168.1.36 - 192.168.1.255 would use rule B, regardless of what order they were added.

Fourth Requirement: Store this data in a reliable fashion
The notes in the "How it All Works" section of the N1021000 document state "user index objects are not particularly stable and have been known to be damaged by an IPL". This is not the level of confidence or reliability that I expect from IBM products.


Use Case:

Allow scripting IP address routing for host servers (especially QZDASOINIT) to deploy across multiple systems. Reduce training burden by removing ambiguity and confusing combinations of address ranges and subnets. Remove need to save user index object after every change. Remove need to restore user index object at every IPL.


Idea priority Low
  • Guest
    Reply
    |
    Nov 21, 2019

    The SET_SERVER_SBS_ROUTING SQL procedure has been extended to allow you to configure the subsystem for a specific IP address, range of addresses, or change the default subsystem used by all incoming IP addresses.
    Additionally, the new SERVER_SBS_CONFIGURATION view can be used to return subsystem routing information for several IBM i servers.

    These new SQL services can be used to programmatically set and view the subsystem routing information previously only available via the IBM Navigator for i interface.
    This new function is available now in 7.3 TR7 and 7.4 TR1. See the following links in DeveloperWorks for more details on the PTF group number.
    https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.SET_SERVER_SBS_ROUTING%28%29%20-%20procedure

    https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.SERVER_SBS_CONFIGURATION%20View

    The documentation for the SQL services can also be found in the IBM i Knowledge Center:
    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqprocsetrouting.htm
    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqviewserversbsconfig.htm

  • Guest
    Reply
    |
    Oct 30, 2019

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Work Management and Messaging
    Operating system - IBM i
    Source - None

    For recording keeping, the previous attributes were:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Core OS
    Operating system - IBM i
    Source - None

  • Guest
    Reply
    |
    Feb 1, 2019

    I was reviewing this with a colleague, and realized my example in requirement #3 is backwards. It should be:

    192.168.1.0 - 192.168.1.31 = Rule A (192.168.1.0/24)
    192.168.1.32 - 192.168.1.35 = Rule B (192.168.1.32/30) because it is the more "most-specific" match
    192.168.1.36 - 192.168.1.255 = Rule A (192.168.1.0/24)

    Apologies for missing this during my initial review and submission!

  • Guest
    Reply
    |
    Jan 30, 2019

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Core OS
    Operating system - IBM i
    Source - None

    For recording keeping, the previous attributes were:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Networking
    Operating system - IBM i
    Source - None

  • Guest
    Reply
    |
    Jan 16, 2019

    Attachment (Description): Screenshot showing the sort is by entry type and numeric address, and does not indicate the order the rules were entered at all.