SQL - SYSIBM.SYSSTOGROUP - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSSTOGROUP

Contains one row for each storage group.

Nome da coluna Tipo de dados Descrição Uso
 NAME  CHAR(8) NOT NULL  Name of the storage group. G
 CREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the storage group. G
 VCATNAME  CHAR(8) NOT NULL  Name of the integrated catalog facility catalog. G
 VPASSWORD  CHAR(8) NOT NULL  Password for the integrated catalog facility catalog. G
 SPACE  INTEGER NOT NULL  Number of kilobytes of DASD storage allocated to the storage group as  determined by the last execution of the STOSPACE utility. G
 SPCDATE  CHAR(5) NOT NULL  Date when the SPACE column was last updated, in the form yyddd. G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM)  tape:

 N    No
 Y    Yes
G
 CREATEDBY  CHAR(8) NOT NULL
 WITH DEFAULT
 Primary authorization ID of the user who created the storage group. G
 STATSTIME  TIMESTAMP NOT NULL
 WITH DEFAULT
 If STOSPACE utility was executed for the storage group, date and time  when last executed. G
 CREATEDTS  TIMESTAMP NOT NULL
 WITH DEFAULT
 Time when the CREATE statement was executed for the storage group. G
 ALTEREDTS  TIMESTAMP NOT NULL
 WITH DEFAULT
 Time when the most recent ALTER STOGROUP statement was executed  for the storage group. If no ALTER STOGROUP statement has been  applied, ALTEREDTS has the value of CREATEDTS. G


© Copyright IBM Corp.