AS/400 Inventory on IBM mainframe

15 pts.
File management
Hi, we acquired AS/400 on IBM mainframe, we need to know all processes set and developed, objects and files, I'm newbie in this mainframe does anyone knows a simply tutorial? Thanks in advance.

Software/Hardware used:

Answer Wiki

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

Here’s the 5 minute tutorial.


I’m favorably impressed by the tutorial site mentioned above. Bare simplicity is an excellent introduction. On the other hand, the huge volume of information from IBM covers (almost) every conceivable detail. It takes time to find the nuggets that can be useful in the beginning.

Two good ones from there for beginners are Introduction to the IBM System i family.

I suspect that any one of us who visits the links pages there will find something they want to review.


Discuss This Question: 7  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.
  • Meandyou
    BTW - Your new AS/400 is a mid-range computer system, not a mainframe.
    5,220 pointsBadges:
  • Glfuentes
    Thanks a lot, that was very informative, now I learn more. But I need how to get a list or inform about all files, can I get this with one command? RPG code?
    15 pointsBadges:
  • JennyMack
    Thanks for posting those tutorial links Mshen, and I'm glad to hear it was helpful Glfuentes! Feel free to post your latest question as a new one, so more users can see it. Thanks, Jenny Community Manager
    4,280 pointsBadges:
  • Splat
    Glfuentes, simplest method is to execute the DSPOBJD command, sending the results to an output file.
    12,895 pointsBadges:
  • Splat
    12,895 pointsBadges:
  • Craig Hatmaker
    Another method is to use command: RTVDSKINF (click link to learn more) This will build file QUSRSYS/QAEZDISK containing all objects in your iSeries. You can query the contents of this file using the command: STRSQL then typing the SQL Statement: Select * From QUSRSYS/QAEZDISK and prompting with F4 to see field names and alter the SQL Statement as you wish. You can also query QUSRSYS/QAEZDISK using any ODBC compliant query tool such as the one included MS Excel. For information on using MS Excel to query databases like this see my blog: Beyond Excel An example connection string is:
    "DRIVER={Client Access ODBC Driver (32-bit)};
     TRANSLATE =1;"
    Where: ###.###.###.### is the IP address of your iSeries. This connection string is for ADO and sets up your query to use OS/400's naming convention (with slashes not dots between library and table name) so it is easy to copy any SQL statement from the STRSQL session to your ODBC compliant query tool. For a copy of an Excel Spreadsheet that is setup to Query QAEZDISK, send me an e-mail: BTW: You may want to have RTVDSKINF run every week. To do this, add it to the job scheduler using: ADDJOBSCDE JOB(DISKINFO) CMD(QSYS/RTVDSKINF) FRQ(*WEEKLY) SCDDATE(*NONE) SCDDAY(*SAT) SCDTIME('02:00:00') A tool you may want to consider is ABSTRACT which provides "Where used" information and a whole lot more.
    1,860 pointsBadges:
  • TomLiotta
    If RTVDSKINF is used, it might be important also to use RTVDIRINF (see Accessing the data of RTVDIRINF and its 'Related information'). Nowadays, systems can have far more in the directory structures than in the library structures that are the focus of RTVDSKINF. Tom
    125,585 pointsBadges:

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.

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


Share this item with your network: