IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only
Back to discussions
Expand all | Collapse all

PRTSYSINF. But what else?

  • 1.  PRTSYSINF. But what else?

    Posted Tue June 11, 2024 12:39 PM

    Hello, the prtsysinf command gives a lot of information about the partition, but it does not give information about TCPIP or its communication lines, you have to go one by one by giving F6 to the screens or a printkey for each of the configurations of the different TCPIP services Is there a more practical way to collect this information? Is there any other command that you suggest to me to have as much information as possible about my partition? In case of a disaster recovery it would be important to have this information at hand, greetings.



    ------------------------------
    Miguel Peralta
    ------------------------------


  • 2.  RE: PRTSYSINF. But what else?

    Posted Tue June 11, 2024 09:06 PM
    Edited by Satid S Tue June 11, 2024 09:08 PM

    Dear Miguel

    In your situation, think of "Retrieve" commands.  There are many of them provided by IBM i :  https://www.ibm.com/docs/en/i/7.4?topic=product-i-commands#R.      

    For TCP info,, use RTVTCPINF command ( https://www.ibm.com/support/pages/retrieve-tcpip-information-rtvtcpinf ). 

    For configuration objects, use RTVCFGSRC command  ( https://www.ibm.com/docs/en/i/7.4?topic=ssw_ibm_i_74/cl/rtvcfgsrc.html  and  https://www.itjungle.com/2006/04/12/fhg041206-story03/  ).



    ------------------------------
    Satid S
    ------------------------------

    Original Message


  • 3.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 03:08 AM
    Edited by Hideyuki Yahagi Wed June 12, 2024 03:08 AM

    If your goal is to document IBM i TCP/IP information, my GitHub Pages (https://guricat.github.io/GuriPages/Infra/) may be helpful. The information is written in Japanese, but can be translated by Chrome functions, etc. as follows.

    Hope this helps.

    ----

    Infrastructure collection information

    A list of key information that can be collected from IBM i during migration or construction. Select based on project requirements and access restrictions. For IBM i 7.1 and later, we recommend using IBM i Service (SQL) to obtain PTF information and TCP/IP settings.



    ------------------------------
    Hideyuki Yahagi
    ------------------------------

    Original Message


  • 4.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 04:07 AM

    Hello Miguel,

    IBM made the life of a sys admin so much easier with the introduction of the IBM I Services. One of the best implementation of these SQL services is Navigator for i. 

    When looking at Navigator for i => Network Interfaces => TCP/IP Configurations => Interfaces you will see the information you are looking for. 
    Once you see that information press the SQL button in the upper right corner. This will result in a window being opened showing you the SQL statement used to present the data shown. 

    This approach can be used to get acquainted with the IBM I Services and will help you to develop your SQL skills. 

    I can only hope this helps



    ------------------------------
    Rudi Van Helvoirt
    ------------------------------

    Original Message


  • 5.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 08:05 AM

    There's also SYSSNAP from the IBM i MGTOOLKIT. I have info for it listed on my IBM i Reference Pages Blog @ The IBM i Reference Pages Blog

    It's located on the "More Helpful Tips by Category Page.

    Ibmireference remove preview
    The IBM i Reference Pages Blog
    IBM i Reference
    View this on Ibmireference >

    .... 



    ------------------------------
    Michael Mayer
    IBM i on Power System Admin
    ERMCO-ECI
    Dyersburg, Tennessee 38024
    731.676.4318
    2024 IBM Badge Advocate, Contributor and Influencer.
    Blog: https://ibmireference.blogspot.com
    ------------------------------

    Original Message


  • 6.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 08:40 AM

    Michael,
    Thanks for the blog page. 



    ------------------------------
    Patrick Conner
    ------------------------------

    Original Message


  • 7.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 08:34 AM

    This has already been mentioned, but I'll throw in my two cents:
    SELECT * FROM QSYS2.NETSTAT_ROUTE_INFO;
    select * from qsys2.tcpip_info;



    ------------------------------
    Patrick Conner
    ------------------------------

    Original Message


  • 8.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 08:54 AM

    To add to what others have suggested, these are great as well:

    select * from QSYS2.NETSTAT_INTERFACE_INFO;

    select * from qsys2.tcpip_info;

    select * from QSYS2.SECURITY_INFO;



    ------------------------------
    Steven Riedmueller
    Certified IBM i Admin
    Speaker, Mentor, and Advocate
    ------------------------------

    Original Message


  • 9.  RE: PRTSYSINF. But what else?

    Posted Wed June 12, 2024 08:56 AM

    See also:  https://www.ibm.com/support/pages/ibm-i-services-sql



    ------------------------------
    Robert Berendt IBMChampion
    ------------------------------

    Original Message


  • 10.  RE: PRTSYSINF. But what else?

    Posted Tue January 21, 2025 12:28 PM

    Maybe this is a reach but perhaps the RTVTPCINF command could be an alternative.

    CRTLIB RTVTCPINF (example).

    Run command RTVTCPINF.

    Review SAVF's that are created.



    ------------------------------
    Michael Mayer
    IBM i on Power System Admin
    ERMCO-ECI
    Dyersburg, Tennessee 38024
    518.641.8906
    2024 IBM Badge Advocate, Contributor and Influencer.
    Blog: https://ibmireference.blogspot.com
    ------------------------------

    Original Message


  • 11.  RE: PRTSYSINF. But what else?

    Posted Tue January 21, 2025 03:06 PM

    Miguel my friend...You need to get very familiar with SQL Services. They are your 'best' friend for many issues / challenges. 

    IBM i Services (SQL)

    A lot of what you are looking for this will be under 'communication services'

    An example of one of the ones you will likely want to use is NETSTAT_INTERFACE_INFO view - IBM Documentation

    Hope this helps! - Rich



    ------------------------------
    Rich Malloy
    ------------------------------

    Original Message


Related Content