Displays information about aliases for all attached databases.
    For each alias, SQL displays the path name or file name of the
    current default database, and the file specification for the
    database file.

    If you specify aliases by name, SQL displays information
    about whether or not multischema mode, snapshots, carry-over
    locks, adjustable lock granularity, global buffers, commit to
    journal optimization, and journal fast commit are enabled. SQL
    displays the character sets of the alias if the database default,
    national, or identifier character set differs from the session's
    default, national, or identifier character set. SQL also displays
    the journal fast commit checkpoint and transaction intervals, the
    lock timeout interval, the number of users, number of nodes,
    buffer size, number of buffers, number of recovery buffers,
    ACL-based protections, storage areas, and whether or not the
    repository is required.