Inventory

15 pts.
Tags:
Administration and maintenance
AS/400
File management programs
Hi, we acquired AS400 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:
AS400
ASKED: January 6, 2010  5:55 PM
UPDATED: April 7, 2010  8:28 PM

Answer Wiki

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

Here’s the <a href=”http://www.as400tutorials.com/quick-as400-tutorial/”>5 minute tutorial</a>, and a <a href=”http://www.as400tutorials.info/”>good tutorial site</a>.

============================================================

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.

Here is an example IBM site with <a href=”http://www-03.ibm.com/servers/enable/site/education/ibo/view.html?all”>a collection of papers and some tutorials</a>. One example is the <a href=”http://www-03.ibm.com/servers/enable/site/education/abstracts/208e_abs.html”>CL programming exercise</a>.

<ul>
<li><i>Note:</i> IBM has apparently made the ‘Collection’ page disappear. The individual internal pages are still accessible.</li>
</ul>

On that exercise abstract page are links to other papers, tutorials and exercises.

Two good ones from there for beginners are <a href=”http://www-03.ibm.com/servers/enable/site/education/abstracts/techintro_abs.html”>Introduction to the IBM System i family</a> and the <a href=”http://www-03.ibm.com/servers/enable/site/education/abstracts/e822_abs.html”>IBM i5/OS text interface</a>. Most beginners need most of what’s in those as a foundation for everything else.

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

Tom

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.

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
  • Meandyou
    BTW - Your new AS/400 is a mid-range computer system, not a mainframe.
    5,220 pointsBadges:
    report
  • 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:
    report
  • 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:
    report
  • Splat
    Glfuentes, simplest method is to execute the DSPOBJD command, sending the results to an output file.
    6,255 pointsBadges:
    report
  • Splat
    DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*FILE) ASPDEV(*ALLAVL) OUTPUT(*OUTFILE) OUTFILE(USERNAME/OUTPUT)
    6,255 pointsBadges:
    report
  • 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)};
     SYSTEM=###.###.###.###;
     DBQ=*USRLIBL;
     NAM=1; 
     CONNTYPE=0; 
     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: CHatmaker@CarlisleCarrier.com 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,610 pointsBadges:
    report
  • 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:
    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