Database objects operation tasks

This table shows how you can work with various database objects in System i® Navigator.

Table 1. Working with database objects
Tasks Objects whose context menu supports the task Available from object context menus in the Web interface System i Navigator utilities
Add a comment to a database object All database objects Yes  
Build SQL scripts with SQL Assist    
  • 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  
Clear data from a table
  • A table object
  • A table partition
 Yes  
Copy data from a table
  • A table object
  • A table partition
  • A view object
 Yes  
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 and object folders 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
 Yes  
Manage tables being altered     Database Maintenance folder for a database→Table Alters window
Manage check pending constraints     Database Maintenance folder for a database→Check Pending Constraints window
Manage indexes being built     Database Maintenance folder for a database→Index Builds window
Manage indexes being rebuilt     Database Maintenance folder for a database→Index Rebuilds window
Manage table reorganizations     Database Maintenance folder for a database→Table Reorganizations window
Manage text search indexes being built     Database Maintenance folder for a database→Text Index Builds window
Modify the definition of a table A table object Yes
  • A Database Navigator map
  • Visual Explain
  • An SQL performance monitor analysis report
Reset usage counts for indexes
  • One or more index objects
  • One or more table objects
  • One or more indexes, constraints, keyed logical files, and keyed physical files in the Show Indexes window
 Yes The Show Indexes window
Reset usage counts for materialized query tables One or more materialized query table objects Yes The Show Materialized Query Tables window
Run an SQL script1 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 indexes for all tables in a schema The Tables folder Yes  
Show indexes for a specific table A table object Yes  
Show locked rows
  • A table object
  • A table partition
  • A job that locks some rows in the Work Management folder2
 Yes  
Show materialized query tables for all tables in a schema The Tables folder Yes  
Show materialized query tables for all views in a schema The Views folder Yes  
Show materialized query tables for a specific table A table object Yes  
Show materialized query tables for a specific view A view object Yes  
Show partitions of a table A partitioned table Yes  
Show transaction information
  • The Database Transactions folder
  • The Global Transactions folder
 Yes  
Specify the JDBC settings     The Run SQL Scripts window
View lock holders
  • An alias object
  • An index object
  • A table object
  • A view object
 Yes  
Notes:

1 You can start the Run SQL Scripts window by double-clicking an SQL file.

2 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.