IBM i Global

 View Only

  • 1.  PRTSYSINF. But what else?

    Posted 23 days ago

    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 23 days ago
    Edited by Satid S 23 days ago

    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?

    IBM Champion
    Posted 23 days ago
    Edited by 矢作 英幸 23 days ago

    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?

    IBM Champion
    Posted 23 days ago

    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 23 days ago

    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 23 days ago

    Michael,
    Thanks for the blog page. 



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

    Original Message


  • 7.  RE: PRTSYSINF. But what else?

    Posted 23 days ago

    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?

    IBM Champion
    Posted 23 days ago

    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?

    IBM Champion
    Posted 23 days ago

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



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

    Original Message