Exploring database summary

About this task

You can view overall information about a database and database objects.

Procedure

To explore the database summary:

  1. Access the console.
  2. From the navigation menu, select Admin > Database schema.
  3. Click on the database name that you want to work on.
    Exploring database summary
    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.