Database objects operation tasks

Database objects operation tasks

This table shows how you can work with various database objects in iSeries™ Navigator.

Table 1. Working with database objects
Tasks Objects whose context menu supports the task Available from object context menus in the Web interface iSeries Navigator utilities

Build SQL scripts with SQL Assist N/A No

The Run SQL Scripts window

The Create SQL Trigger window

The New Materialized Query Table window

Capture information about your database with the Database Health Center A database folder Yes N/A
Clear data from a table

A table object

A table partition
No N/A
Copy data from a table

A table object

A table partition

A view object
No N/A
Delete a database object Most objects Yes A database navigator map
Export data from a table or a view

A table object

A table partition

A view object
Yes Taskpad
Generate SQL statements for existing database objects Most objects Yes

A database navigator map

The Run SQL Scripts window

Import data into a table A table object Yes Taskpad
Initialize data in a table

A table object

A table partition
No N/A
Manage check pending constraints A database folder No N/A
Manage index rebuilds A database folder No N/A
Modify the definition of a table A table object Yes

A database navigator map

Visual Explain

An SQL performance monitor analysis report

Run an SQL script¹ A database folder No Taskpad
Select schemas to be displayed in the Schemas folder The Schemas folder Yes Taskpad
Show database objects relations A table object Yes A database navigator map
Show locked rows

A table object

A table partition

A job that locks some rows in the Work Management folder²
Yes N/A
Show partitions of a table A partitioned table Yes N/A
Show transaction information

The Database Transactions folder

The Global Transactions folder
No N/A
Specify the JDBC settings N/A No The Run SQL Scripts window
Notes:
¹ You can start the Run SQL Scripts window by double-clicking an SQL file.
² To show the locked rows of an object from the Work Management folder, right-click a job in the Work Management folder and select Details > Locked objects. You can then right-click the locked object and show the locked rows of that object.

Parent topic:
iSeries Navigator database tasks

Related tasks

Building SQL statements with SQL Assist
Importing and exporting data
Generating SQL for existing objects
Copying a file
Moving a file
Displaying information with Database Health Center
Managing check pending constraints
Managing index rebuilds
Determining unnecessary indexes
Displaying locked rows
Mapping your database
Displaying attributes for a file (table)
Reorganizing a table using iSeries Navigator
Deleting database objects

Related reference

iSeries Navigator URL parameters and available Web tasks

Tasks	Objects whose context menu supports the task	Available from object context menus in the Web interface	iSeries Navigator utilities
Build SQL scripts with SQL Assist	N/A	No	The Run SQL Scripts window The Create SQL Trigger window The New Materialized Query Table window
Capture information about your database with the Database Health Center	A database folder	Yes	N/A
Clear data from a table	A table object A table partition	No	N/A
Copy data from a table	A table object A table partition A view object	No	N/A
Delete a database object	Most objects	Yes	A database navigator map
Export data from a table or a view	A table object A table partition A view object	Yes	Taskpad
Generate SQL statements for existing database objects	Most objects	Yes	A database navigator map The Run SQL Scripts window
Import data into a table	A table object	Yes	Taskpad
Initialize data in a table	A table object A table partition	No	N/A
Manage check pending constraints	A database folder	No	N/A
Manage index rebuilds	A database folder	No	N/A
Modify the definition of a table	A table object	Yes	A database navigator map Visual Explain An SQL performance monitor analysis report
Run an SQL script¹	A database folder	No	Taskpad
Select schemas to be displayed in the Schemas folder	The Schemas folder	Yes	Taskpad
Show database objects relations	A table object	Yes	A database navigator map
Show locked rows	A table object A table partition A job that locks some rows in the Work Management folder²	Yes	N/A
Show partitions of a table	A partitioned table	Yes	N/A
Show transaction information	The Database Transactions folder The Global Transactions folder	No	N/A
Specify the JDBC settings	N/A	No	The Run SQL Scripts window
Notes: ¹ You can start the Run SQL Scripts window by double-clicking an SQL file. ² To show the locked rows of an object from the Work Management folder, right-click a job in the Work Management folder and select Details > Locked objects. You can then right-click the locked object and show the locked rows of that object.