iSeries Navigator database tasks

 

You can perform many database tasks with iSeries™ Navigator, including creating, modifying, and deleting various database objects. In addition to the tasks described in Getting started with iSeries Navigator, there are many other ways to use iSeries Navigator with your DB2^® UDB for iSeries. With iSeries Navigator, you can perform a task in the following ways:

• In iSeries Navigator, right-click an object and then select the appropriate function from the context menu.

• In the iSeries Navigator Web interface, select the appropriate function from an object context menu.

• In iSeries Navigator, use an iSeries Navigator utility, such as the Run SQL Scripts window. Note that most of the iSeries Navigator utilities are not available from the Web interface.

• Database objects creation tasks
  This table shows how you can create various database objects in iSeries Navigator.

• Database objects operation tasks
  This table shows how you can work with various database objects in iSeries Navigator.

• Database performance optimization tasks
  This table shows how you can access various tools in iSeries Navigator to optimize your database performance.

• Mapping your database
  Database Navigator is an iSeries Navigator function that enables you to visually represent the relationships of database objects on your system. This representation is called a map. In essence, a Database Navigator map is a snapshot of your database and the relationships that exist among all of the objects in the map.

• Querying your database by running SQL scripts
  You can create, edit, run, and troubleshoot scripts of SQL statements in the Run SQL Scripts window of iSeries Navigator. When you finish working with the scripts, you can save the statements to your PC.

• Managing check pending constraints
  You can view and change constraints that the system has placed in a check pending state.

• Importing and exporting data
  iSeries Navigator provides Import and Export wizards for you to import and export data between files and database tables. These wizards use the Copy from Import File (CPYFRMIMPF) and Copy to Import File (CPYTOIMPF) commands to process the requests.

 

Parent topic:

Database overview

 

Related tasks

Getting started with iSeries Navigator
Defining public authority using iSeries Navigator
Setting a default public authority for new files
Examining debug messages in the job log
Working with journals