1 / 22

Operations Navigator

Operations Navigator. Overview. Source of information. www.ibm.com/eserver/iseries/oper_nav www.ibm.com/eserver/iseries/sftsol/mgmtcentral.htm www.redbooks.ibm.com www.ibm.com/eserver/iseries/infocenter www.ibm.com/eserver/iseries/clientaccess. Goals of IBM’s Operation Navigator.

pembroke
Télécharger la présentation

Operations Navigator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Operations Navigator Overview

  2. Source of information • www.ibm.com/eserver/iseries/oper_nav • www.ibm.com/eserver/iseries/sftsol/mgmtcentral.htm • www.redbooks.ibm.com • www.ibm.com/eserver/iseries/infocenter • www.ibm.com/eserver/iseries/clientaccess

  3. Goals of IBM’s Operation Navigator • Modernize the user interface • Leverage th elatest user interface technology • Ease administration of systems in a network • Leverage user’s Windows skills • Reduce need to learn command interface • Productivity

  4. Printer Functions • Manage printers • Explore printer output • Start/Stop/Restart • Hold/Release • Make Available/Unavailable • Reply to messages • Properties • View printer output • Display properties

  5. Double click the Operations Navigator Icon

  6. Create Desktop Icons

  7. Icon on Desktop

  8. AFP Feature

  9. AFP Workbench Viewer – Full function viewer included with CA

  10. Click the + beside thunder.southeasttech.com

  11. Click the + beside Database

  12. Click the + beside Libraries

  13. Right click Libraries and select New Library

  14. Type on OO followed by userid for the library name. Click OK.

  15. Database Navigator • GUI for managing DB2/400 objects and performance • Create tables, views, aliases, indexes, functions, procedures, journals, data types • Quickview/edit tables • Collect SQL performance data • Manage permissions(authorities) on DB objects • Create, save, run SQL Scripts • Document editor interface associated to files of .SQL • Run all, selected, or single statements • SQL examples can be inserted and modified

  16. Table enhancements • Table Description: equal to Display File Description (DSPFD) command • Locked rows: shows locked rows, the locking job and its job log • View Executing SQL • List of active jobs with SQL statements running • Some job control (joblog, end job) • Can take the SQL statement running into the editor • Visual Explain • Pictorial view of query execution • Query developer can understand execution flow of the query and use this to do performance tuning

  17. Right click the new Library called OOxxxxxxxx, Select New, Select Table

  18. Name the table EMPLOYERS and give it a description. Click OK.

  19. Create Columns

  20. Table Created

  21. Right click, select Quick View

  22. Note that there are no contents in the table (yet!)

More Related