Exploring database summary
About this task
You can view overall information about a database and database objects.
Procedure
To explore the database summary:
- Access the console.
- From the navigation menu, select Admin > Database schema.
-
Click on the database name that you want to work on.
Following are the options provided on this page:
Options Additional information Information View general information about a database like owner, locale of the database and dbspace in which database exists. Stored Procedures and Functions View information about the stored procedures and functions in a database. Sequences View information about the sequences in a database. User Defined Types View information about user-defined data types (UDTs) in a database. Privileges View information about database privileges. DataBlade modules View a list of the DataBlade modules in a database. It extends the capabilities of IBM® Informix® with user-defined objects. Aggregates View information about the user-defined aggregates in a database. It extends the functionality of the database server by performing aggregate computations. Casts View information about the casts in a database.
A cast is a mechanism that converts a value from one data type to another data type. By using casts, you can make comparisons between values of different data types or substitute a value of one data type for a value of another data type.
Operator Classes View information about the operator classes in a database.
An operator class tells the database server which data types it can index using a secondary-access method. It is a group of functions that allow the secondary-access method to store and search for values of a particular data type.