SYSIBM - TABLE SPACES AND INDEXES

SQL - SYSIBM - TABLE SPACES AND INDEXES - www.cadcobol.com.br

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

Tabelas SYSIBM

Nome das tabelas

INDEX SYSIBM

Colunas dos índices

Table Space DSNDB06 - SYSCOPY

SYSCOPY	DSNUCH01	DBNAME, TSNAME, START_RB (1), TIMESTAMP (1)
	DSNUCX01	DSNAME

Table Space DSNDB06 - SYSDBASE

SYSCOLAUTH
SYSCOLUMNS	DSNDCX01	TBCREATOR, TBNAME, NAME
SYSFIELDS
SYSFOREIGNKEYS
SYSINDEXES	DSNDXX01	CREATOR, NAME
	DSNDXX02	DBNAME, INDEXSPACE
	DSNDXX03	TBCREATOR, TBNAME, CREATOR, NAME
SYSINDEXPART	DSNDRX01	IXCREATOR, IXNAME, PARTITION
	DSNDRX02	STORNAME
SYSKEYS	DSNDKX01	IXCREATOR, IXNAME, COLNAME
SYSRELS	DSNDLX01	REFTBCREATOR, REFTBNAME
SYSSYNONYMS	DSNDYX01	CREATOR, NAME
SYSTABAUTH	DSNATX01	GRANTOR
	DSNATX02	GRANTEE, TBCREATOR, TTNAME, GRANTEETYPE, UPDATECOLS, ALTERAUTH, DELETEAUTH, INDEXAUTH, INSERTAUTH, SELECTAUTH, UPDATEAUTH, CAPTUREAUTH, REFERENCESAUTH, REFCOLS, TRIGGERAUTH
	DSNATX03	GRANTEE, GRANTEETYPE, COLLID, CONTOKEN
SYSTABLEPART	DSNDPX01	DBNAME, TSNAME, PARTITION
	DSNDPX02	STORNAME
SYSTABLES	DSNDTX01	CREATOR, NAME
	DSNDTX02	DBID, OBID, CREATOR, NAME
SYSTABLESPACE	DSNDSX01	DBNAME, NAME

Table Space DSNDB06 - SYSDBAUT

SYSDATABASE	DSNDDH01	NAME
	DSNDDX02	GROUP_MEMBER
SYSDBAUTH	DSNADH01	GRANTEE, NAME
	DSNADX01	GRANTOR, NAME

Table Space DSNDB06 - SYSDDF

IPNAMES	DSNFPX01	LINKNAME
LOCATIONS	DSNFCX01	LOCATION
LULIST	DSNFLX01	LINKNAME, LUNAME
	DSNFLX02	LUNAME
LUMODES	DSNFMX01	LUNAME, MODENAME
LUNAMES	DSNFNX01	LUNAME
MODESELECT	DSNFDX01	LUNAME, AUTHID(1), PLANNAME(1)
USERNAMES	DSNFEX01	TYPE, AUTHID(1), LINKNAME(1)

Table Space DSNDB06 - SYSGPAUT

SYSRESAUTH	DSNAGH01	GRANTEE, QUALIFIER, NAME, OBTYPE
	DSNAGX01	GRANTOR, QUALIFIER, NAME, OBTYPE

Table Space DSNDB06 - SYSGROUP

SYSSTOGROUP	DSNSSH01	NAME
SYSVOLUMES

Table Space DSNDB06 - SYSGRTNS

SYSROUTINES_OPTS	DSNROX01	SCHEMA, ROUTINENAME, BUILDDATE, BUILDTIME
SYSROUTINES_SRC	DSNRSX01	ROUTINENAME
	DSNRSX02	SCHEMA, ROUTINENAME, BUILDDATE, SEQNO

Table Space DSNDB06 - SYSHIST

SYSCOLDIST_HIST	DSNHFX01	TBOWNER, TBNAME, NAME, STATSTIME
SYSCOLUMNS_HIST	DSNHEX01	TBCREATOR, TBNAME, NAME, STATSTIME
SYSINDEXES_HIST	DSNHHX01	TBCREATOR, TBNAME, NAME, STATSTIME
	DSNHHX02	CREATOR, NAME
SYSINDEXPART_HIST	DSNHGX01	IXCREATOR, IXNAME, PARTITION, STATSTIME
SYSINDEXSTATS_HIST	DSNHIX01	OWNER, NAME, PARTITION, STATSTIME
SYSLOBSTATS_HIST	DSNHJX01	DBNAME, NAME, STATSTIME
SYSTABLEPART_HIST	DSNHCX01	DBNAME, TSNAME, PARTITION, STATSTIME
SYSTABLES_HIST	DSNHDX01	CREATOR, NAME, STATSTIME
SYSTABSTATS_HIST	DSNHBX01	OWNER, NAME, PARTITION, STATSTIME

Table Space DSNDB06 - SYSJAVA

SYSJARCONTENTS	DSNJCX01	JARSCHEMA, JAR_ID
SYSJAROBJECTS	DSNJOX01	JARSCHEMA, JAR_ID
SYSJAVAOPTS	DSNJVX01	JARSCHEMA, JAR_ID

Table Space DSNDB06 - SYSJAUXA LOB

SYSJARDATA

DSNJDX01

JAR_DATA

Table Space DSNDB06 - SYSJAUXB LOB

SYSJARCLASS

DSNJSX01

CLASS_SOURCE

Table Space DSNDB06 - SYSOBJ

SYSAUXRELS	DSNOXX01	TBOWNER , TBNAME
	DSNOXX02	AUXTBOWNER , AUXTBNAME
SYSCONSTDEP	DSNCCX01	BSCHEMA, BNAME, BTYPE
	DSNCCX02	DTBCRATOR, DTBNAME
SYSDATATYPES	DSNODX01	SCHEMA, NAME
	DSNODX02	DATATYPEID (1)
SYSKEYCOLUSE	DSNCUX01	TBCREATOR, TBNAME, CONSTNAME, COLSEQ
SYSPARMS	DSNOPX01	SCHEMA, SPECIFICNAME, ROUTINETYPE, ROWTYPE, ORDINAL
	DSNOPX02	TYPESCHEMA, TYPENAME, ROUTINETYPE, CAST_FUNCTION, OWNER, SCHEMA, SPECIFICNAME
	DSNOPX03	TYPESCHEMA, TYPENAME
SYSROUTINEAUTH	DSNOAX01	GRANTOR, SCHEMA, SPECIFICNAME, ROUTINETYPE, GRANTEETYPE, EXECUTRAUTH
	DSNOAX02	GRANTEE, SCHEMA, SPECIFICNAME, ROUTINETYPE, GRANTEETYPE, EXECUTRAUTH, GRANTEDTS
	DSNOAX03	SCHEMA, SPECIFICNAME, ROUTINETYPE
SYSROUTINES	DSNOFX01	NAME, PARM_COUNT, ROUTINETYPE, PARM_SIGNATURE, SCHEMA, PARM1, PARM2, PARM3, PARM4, PARM5, PARM6, PARM7, PARM8, PARM9, PARM10, PARM11, PARM12, PARM13, PARM14, PARM15, PARM16, PARM17, PARM18, PARM19, PARM20, PARM21, PARM22, PARM23, PARM24, PARM25, PARM26, PARM27, PARM28, PARM29, PARM30
	DSNOFX02	SCHEMA, SPECIFICNAME, ROUTINETYPE
	DSNOFX03	NAME, SCHEMA, CAST_FUNCTION, PARM_COUNT, PARM_SIGNATURE, PARM1
	DSNOFX04	ROUTINE_ID (1)
	DSNOFX05	SOURCESCHEMA, SOURCESPECIFIC, ROUTINETYPE
	DSNOFX06	SCHEMA, NAME, ROUTINETYPE, PARM_COUNT
	DSNOFX07	NAME, PARM_COUNT, ROUTINETYPE, SCHEMA, PARM_SIGNATURE, PARM1, PARM2, PARM3, PARM4, PARM5, PARM6, PARM7, PARM8, PARM9, PARM10, PARM11, PARM12, PARM13, PARM14, PARM15, PARM16, PARM17, PARM18, PARM19, PARM20, PARM21, PARM22, PARM23, PARM24, PARM25, PARM26, PARM27, PARM28, PARM29, PARM30
	DSNOFX08	JARSCHEMA, JAR_ID
SYSSCHEMAAUTH	DSNSKX01	GRANTEE, SCHEMANAME
	DSNSKX02	GRANTOR
SYSTABCONST	DSNCNX01	TBCREATOR, TBNAME, CONSTNAME
	DSNCNX02	IXOWNER, IXNAME
SYSTRIGGERS	DSNOTX01	SCHEMA, NAME, SEQNO
	DSNOTX02	TBOWNER, TBNAME
	DSNOTX03	SCHEMA, TRIGNAME

Table Space DSNDB06 - SYSPACKAGE

SYSPACKAGE	DSNKKX01	LOCATION, COLLID, NAME, VERSION
	DSNKKX02	LOCATION, COLLID, NAME, CONTOKEN
SYSPACKAUTH	DSNKAX01	GRANTOR, LOCATION, COLLID, NAME
	DSNKAX02	GRANTEE, LOCATION, COLLID, NAME, BINDAUTH, COPYAUTH, EXECUTEAUTH>
	DSNKAX03	LOCATION, COLLID, NAME
SYSPACKDEP	DSNKDX01	DLOCATION, DCOLLID, DNAME, DCONTOKEN
	DSNKDX02	BQUALIFIER, BNAME, BTYPE
	DSNKDX03	BQUALIFIER, BNAME, BTYPE, DTYPE
SYSPROCEDURES	DSNKCX01	PROCEDURE, AUTHID(1), LUNAME(1)
SYSPACKLIST	DSNKLX01	LOCATION, COLLID, NAME
	DSNKLX02	PLANNAME, SEQNO, LOCATION, COLLID, NAME
SYSPACKSTMT	DSNKSX01	LOCATION, COLLID, NAME, CONTOKEN, SEQNO
SYSPKSYSTEM	DSNKYX01	LOCATION, COLLID, NAME, CONTOKEN, SYSTEM, ENABLE
SYSPLSYSTEM	DSNKPX01	NAME, SYSTEM, ENABLE

Table Space DSNDB06 - SYSPLAN

SYSDBRM
SYSPLAN	DSNPPH01	NAME
SYSPLANAUTH	DSNAPH01	GRANTEE, NAME, EXECUTEAUTH
	DSNAPX01	GRANTOR
SYSPLANDEP	DSNGGX01	BCREATOR, BNAME, BTYPE
SYSSTMT

Table Space DSNDB06 - SYSSEQ

SYSSEQUENCES	DSNSQX01	SCHEMA, NAME
	DSNSQX02	SEQUENCEID (1)

Table Space DSNDB06 - SYSSEQ2

SYSSEQUENCESDEP

DSNSRX01

DCREATOR, DNAME, DCOLNAME

Table Space DSNDB06 - SYSSTATS

SYSCOLDIST	DSNTNX01	TBOWNER, TBNAME, NAME
SYSCOLDISTSTATS	DSNTPX01	TBOWNER, TBNAME, NAME,PARTITION
SYSCOLSTATS	DSNTCX01	TBOWNER, TBNAME, NAME, PARTITION
SYSINDEXSTATS	DSNTXX01	OWNER, NAME, PARTITION
SYSLOBSTATS	DSNLNX01	DBNAME, NAME
SYSTABSTATS	DSNTTX01	OWNER, NAME, PARTITION

Table Space DSNDB06 - SYSSTR

SYSSTRINGS	DSNSSX01	OUTCCSID, INCCSID, IBMREGD
SYSCHECKS	DSNSCX01	TBOWNER, TBNAME, CHECKNAME
SYSCHECKS2	DSNCHX01	TBOWNER, TBNAME, CHECKNAME
SYSCHECKDEP	DSNSDX01	TBOWNER, AME, CHECKNAME, COLNAME

Table Space DSNDB06 - SYSUSER

SYSUSERAUTH	DSNAUH01	GRANTEE, GRANTEDTS
	DSNAUX02	GRANTOR

Table Space DSNDB06 - SYSVIEWS

SYSVIEWDEP	DSNGGX02	BCREATOR, BNAME, BTYPE
	DSNGGX03	BSCHEMA, BNAME, BTYPE
SYSVIEWS	DSNVVX01	CREATOR, NAME, SEQNO, TYPE