Displays information about the specified databases. For each
    database, SQL displays the alias, the type of database, any
    defined collating sequence, and the file specification for the
    database file.

    If the database was declared using a repository path name, SQL
    also displays that path name. If you do not specify any aliases
    with the SHOW DATABASES statement, SQL displays this information
    about all declared databases.

    SQL displays the character sets of the database if the default,
    national, or identifier character set differs from the session's
    default, national, or identifier character set.

    If you do specify an alias, SQL also displays information
    about whether or not multischema mode, snapshots, carry-over
    locks, adjustable lock granularity, global buffers, commit to
    journal optimization, journaling, and journal fast commit are
    enabled. SQL also displays the journal fast commit checkpoint
    and transaction intervals, the lock timeout interval, the number
    of unused storage areas, the number of unused journal files, 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.