Tabelas SYSIBM

Nome da coluna	Tipo do dado	Descrição	Uso
NAME	CHAR(8) NOT NULL	Database name.	G
CREATOR	CHAR(8) NOT NULL	Authorization ID of the owner of the database.	G
STGROUP	CHAR(8) NOT NULL	Name of the default storage group of the database; blank for a system database.	G
BPOOL	CHAR(8) NOT NULL	Name of the default buffer pool of the database; blank for a system database.	G
DBID	SMALLINT NOT NULL	Internal identifier of the database.	G
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine-readable material (MRM) tape: N No Y Yes E V2R3 dependency indicator; not from MRM tape G V4 dependency indicator; not from MRM tape	G
CREATEDBY	CHAR(8) NOT NULL WITH DEFAULT	Primary authorization ID of the user who created the database.	G
ROSHARE	CHAR(1) NOT NULL WITH DEFAULT	Whether this database is shared, through shared read-only data, with other DB2 subsystems. Value can be: blank Not shared O Shared. Local DB2 subsystem is the owner. R Shared. Local DB2 subsystem is a read-only user.	G
TIMESTAMP	TIMESTAMP NOT NULL WITH DEFAULT	The time the database became shared on the owning system the database is not shared, the value is 0001-01-01-00.00.00.000000	G
TYPE	CHAR(1) NOT NULL WITH DEFAULT	Type of database. blank Database is not a work file database. W Database is a work file database. The database is DSNDB07 or it was created with the WORKFILE clause and used as a work file database by a member of a DB2 data sharing group.	G
GROUP_MEMBER	CHAR(8) NOT NULL WITH DEFAULT	The DB2 data sharing member name of the DB2 subsystem that uses this work file database. This column is blank if the work file database was not created in a DB2 data sharing environment, or if The database is not a work file database as indicated by the TYPE COLUMN.	G
CREATEDTS	TIMESTAMP NOT NULL WITH DEFAULT	Time when the CREATE statement was executed for the database. For DSNDB04 and DSNDB06, the value is '1985-04-01.00.00.00.000000'.	G
ALTEREDTS	TIMESTAMP NOT NULL WITH DEFAULT	Time when the most recent ALTER DATABASE statement was applied. If no ALTER DATABASE statement has been applied, ALTEREDTS has the value of CREATEDTS.	G
ENCODING_SCHEME	CHAR(1) NOT NULL WITH DEFAULT 'E'	Default encoding scheme for the database. E EBCDIC A ASCII blank For DSNDB04 and work file databases.	G
SBCS_CCSID	INTEGER NOT NULL WITH DEFAULT	Default SBCS CCSID for the database. For databases created in a DB2 release prior to Version 5, the value is 0.	G
DBCS_CCSID	INTEGER NOT NULL WITH DEFAULT	Default DBCS CCSID for the database. For databases created in a DB2 release prior to Version 5, the value is 0.	G
MIXED_CCSID	INTEGER NOT NULL WITH DEFAULT	Default mixed CCSID for the database. For databases created in a DB2 release prior to Version 5, the value is 0.	G