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


Volta a página anterior

Volta ao Menu Principal


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


                 Nota: (1) Campo indexado na ordem decrescente

Volta ao Menu das SYSIBM

Volta ao Menu Principal