Filter
Top Products
· Routine definition date and time
· Routine comment definition
· Privilege information (only if -p is specified)
· Parameter information (parameter names, parameter types, modes)
· Related table information (schema name, table name, type)
· Name of a routine called by this routine, name of the schema to which the called routine belongs, and type of
routine
· Name of a routine that calls this routine, name of the schema to which the called routine belongs, and type of
routine
· Procedure routine definition statement
· Symbol name of the execution module that processes the function routine
· Path name of the execution module that processes the function routine
DSO specification
· DSO name
· Type (table DSO or index DSO)
· Name of database to which DSO belongs
· Related table information (schema name and table name)
· DSO creator
· DSO definition date and time
· Data structure type (SEQUENTIAL, RANDOM, OBJECT, or BTREE, page size for each part, information
[column names] about columns forming the cluster key, existence of NOT UNIQUE specification, storage order
assurance level, page reuse point, and contents of RULE specification)
· Base representation (BY ADDRESS or BY KEY)
· Split condition for subdividing into DSIs
· Index degeneration specification
· Information about columns making up the index (column name, data type)
· DSI information (DSI name)
DSI specification
· DSI name
· Type (table DSI or index DSI)
· Name of database to which DSI belongs
· Related table information (schema name and table name)
· Related DSO information (DSO name)
· Related table DSI name
· Related index DSI name
· DSI creator
· DSI definition date and time
· Split key value
· Page reuse point
· Index degeneration specification
· Database space allocation information (allocation part, database space name, allocation size)
· Alarm point and expansion specification information (expansion point, allocation size, allocation candidate
database space name)
· Name of the scope that limits DSI
SCOPE specification
· Scope name
· Name of database to which the scope belongs
· User ID of the user who defined the scope
· Scope definition date and time
· Name of DSI limited by scope
· User ID of the user to which the scope is applied
DBSPACE specification
· Database space name
· Name of database to be allocated
· Raw device name (for UNIX)
· File name
· Device type
· Database space creator
· Database space definition date and time
· Log group name of log environment used for database space
90