Tuesday, February 16, 2010

List of SYSIBM tables

select * from sysibm.systables where CREATOR = 'SYSIBM' ;

DSNRLST01
INDOUBT
IPLIST
IPNAMES
JSPOUT
LOCATIONS
LULIST
LUMODES
LUNAMES
MODESELECT
SQLTABLETYPES
SQLTYPEINFO
SQTCOLPRIVILEGES
SQTCOLUMNS
SQTFOREIGNKEYS
SQTPRIMARYKEYS
SQTPROCEDURECOLS
SQTPROCEDURES
SQTSPECIALCOLUMNS
SQTSTATISTICS
SQTTABLEPRIVILEGES
SQTTABLES
SQTUDTS
SYSAUXRELS
SYSCHECKDEP
SYSCHECKS
SYSCHECKS2
SYSCOLAUTH
SYSCOLDIST
SYSCOLDISTSTATS
SYSCOLDIST_HIST
SYSCOLSTATS
SYSCOLUMNS
SYSCOLUMNS_HIST
SYSCONSTDEP
SYSCOPY
SYSDATABASE
SYSDATATYPES
SYSDBAUTH
SYSDBRM
SYSDUMMY1
SYSDUMMYA
SYSDUMMYE
SYSDUMMYU
SYSFIELDS
SYSFOREIGNKEYS
SYSINDEXES
SYSINDEXES_HIST
SYSINDEXPART
SYSINDEXPART_HIST
SYSINDEXSTATS
SYSINDEXSTATS_HIST
SYSJARCLASS_SOURCE
SYSJARCONTENTS
SYSJARDATA
SYSJAROBJECTS
SYSJAVAOPTS
SYSKEYCOLUSE
SYSKEYS
SYSLOBSTATS
SYSLOBSTATS_HIST
SYSOBDS
SYSPACKAGE
SYSPACKAUTH
SYSPACKDEP
SYSPACKLIST
SYSPACKSTMT
SYSPARMS
SYSPKSYSTEM
SYSPLAN
SYSPLANAUTH
SYSPLANDEP
SYSPLSYSTEM
SYSPRINT
SYSPSM
SYSPSMOPTS
SYSPSMOUT
SYSRELS
SYSRESAUTH
SYSROUTINEAUTH
SYSROUTINES
SYSROUTINES_OPTS
SYSROUTINES_SRC
SYSSCHEMAAUTH
SYSSEQUENCEAUTH
SYSSEQUENCES
SYSSEQUENCESDEP
SYSSTMT
SYSSTOGROUP
SYSSTRINGS
SYSSYNONYMS
SYSTABAUTH
SYSTABCONST
SYSTABLEPART
SYSTABLEPART_HIST
SYSTABLES
SYSTABLESPACE
SYSTABLES_HIST
SYSTABSTATS
SYSTABSTATS_HIST
SYSTRIGGERS
SYSUSERAUTH
SYSVIEWDEP
SYSVIEWS
SYSVLTREE
SYSVOLUMES
SYSVTREE
UINDEXES
USERNAMES





IPLIST (V8)
Associates multiple IP addresses to a given LOCATION

IPNAMES
Contains the LUs associated with other systems accessible to the local DB2 subsystem

LOCATIONS
Contains distributed location information for every accessible remote server

LULIST
Contains the list of LUNAMEs for a given distributed location (when multiple LUNAMEs are associated with a single location)

LUMODES
Information on distributed conversation limits

LUNAMES
Contains information for every SNA client or server that communicates with the DB2 subsystem

MODESELECT
Information assigning mode names to conversations supporting outgoing SQL requests

SYSAUXRELS
Information on the auxiliary tables required for LOB columns

SYSCHECKDEP
Column references for CHECK constraints

SYSCHECKS
CHECK constraint specifications

SYSCHECKS2 (V7)
Information about CHECK constraints on DB2 Catalog tables created for V7 or later

SYSCOLAUTH
The UPDATE privileges held by DB2 users on table or view columns

SYSCOLDIST
Cardinality, frequent value, and non-padded frequent value distribution statistics for the first key column of an index key

SYSCOLDIST_HIST (V7)
Column distribution statistics history

SYSCOLDISTSTATS
The non-uniform distribution statistics for the ten most frequently occurring values for the first key column in a partitioned index

SYSCOLSTATS
The partition statistics for selected columns

SYSCOLUMNS
Information about every column of every DB2 table and view

SYSCOLUMNS_HIST (V7)
Historical column statistics

SYSCONSTDEP
Information regarding columns that are dependent on CHECK constraints and user-defined defaults

SYSCOPY
Information on the execution of DB2 utilities required by DB2 recovery

SYSDATABASE
Information about every DB2 database

SYSDATATYPES
Information about the user-defined distinct types defined to the DB2 subsystem

SYSDBAUTH
Database privileges held by DB2 users

SYSDBRM
DBRM information only for DBRMs bound into DB2 plans

SYSDUMMY1
Contains no information; this table is for use in SQL statements requiring a table reference without regard to data content

SYSFIELDS
Information on field procedures implemented for DB2 tables

SYSFOREIGNKEYS
Information about all columns participating in foreign keys

SYSINDEXES
Information about every DB2 index

SYSINDEXES_HIST (V7)
Historical index statistics

SYSINDEXPART
Information about the physical structure and storage of every DB2 index

SYSINDEXPART_HIST (V7)
Historical index partition statistics

SYSINDEXSTATS
Partitioned index statistics by partition

SYSINDEXSTATS_HIST (V7)
Historical partitioned index statistics by partition

SYSJARCONTENTS (V7)
Java class source for installed JAR

SYSJARDATA (V7)
Auxiliary table for the BLOB data from SYSJAROBJECTS

SYSJAROBJECTS (V7)
The contents of the installed JAR

SYSJARCLASS_SOURCE (V7)
Auxiliary table for the CLOB data from SYSJARCONTENTS

SYSKEYCOLUSE (V7)
Columns that participate in unique constraints (primary key or unique key) from the SYSTABCONST table

SYSKEYS
Information about every column of every DB2 index

SYSLINKS
Information about the links between DB2 Catalog tables

SYSLOBSTATS
Statistical information for LOB table spaces

SYSLOBSTATS_HIST (V7)
Historical LOB statistics

SYSPACKAGE
Information about every package known to DB2

SYSPACKAUTH
Package privileges held by DB2 users

SYSPACKDEP
A cross-reference of DB2 objects required for DB2 packages

SYSPACKLIST
The package list for plans bound specifying packages

SYSPACKSTMT
All SQL statements contained in each DB2 package

SYSPARMS
Parameters for defined routines

SYSPKSYSTEM
The systems (such as CICS, IMS, or batch) enabled for DB2 packages

SYSPLAN
Information about every plan known to DB2SYSPLANSYSPLANAUTHPlan privileges held by DB2 users

SYSPLANDEP
A cross-reference of DB2 objects required by DB2 plans

SYSPLSYSTEM
The systems (such as CICS, IMS, or batch) enabled for DB2 plans

SYSPROCEDURES
The stored procedures available to the DB2 subsystem

SYSRELS
The referential integrity information for every relationship defined to DB2

SYSRESAUTH
Resource privileges held by DB2 users

SYSROUTINEAUTH
Privileges held by DB2 users on routines

SYSROUTINES
Information about every routine (that is, user-defined functions and stored procedures) defined to the DB2 subsystem

SYSROUTINES_OPTS (V7)
Information about the options used by DB2-generated routines

SYSROUTINES_SRC (V7)
The source code for routines generated by DB2

SYSSCHEMAAUTH
Schema privileges granted to users

SYSSEQUENCEAUTH (V8)
Privileges held by DB2 users on SEQUENCE objects

SYSSEQUENCES (V7)
Information about identity columns and SEQUENCE objects

SYSSEQUENCESDEP (V8)
Records the dependencies of identity columns on tables

SYSSTMT
All SQL statements contained in each DB2 plan bound from a DBRM

SYSSTOGROUP
Information about every DB2 storage group

SYSSTRINGS
Character conversion information

SYSSYNONYMS
Information about every DB2 synonym

SYSTABAUTH
Table privileges held by DB2 users

SYSTABCONST (V7)
Information about every unique constraint (primary key or unique key) created in DB2 V7 or later

SYSTABLEPART
Information about the physical structure and storage of every DB2 table space

SYSTABLEPART_HIST (V7)
Historical table space partition statistics

SYSTABLES
Information about every DB2 table

SYSTABLES_HIST (V7)
Table statistics history

SYSTABLESPACE
Information about every DB2 table space

SYSTABSTATS
Partitioned table space statistics by partition

SYSTABSTATS_HIST (V7)
Historical partitioned table space statistics by partition

SYSTRIGGERS
Information about every trigger defined to the DB2 subsystem

SYSUSERAUTH
System privileges held by DB2 users

SYSVIEWDEP
A cross-reference of DB2 objects required by DB2 views

SYSVIEWS
The SQL CREATE VIEW statement for every DB2 view

SYSVLTREE
A portion of the internal representation of complex or long views

SYSVOLUMES
A cross-reference of DASD volumes assigned to DB2 storage groups

SYSVTREE
The first 4000 bytes of the internal representation of the view; the remaining portion of longer or complex views is stored in SYSVLTREE

USERNAMES
Outbound and inbound ID translation information



selEct GRANTEE ,TTNAME , GRANTOR, INSERTAUTH, SELECTAUTH, UPDATEAUTH, DELETEAUTH,
GRANTEETYPE , DBNAME, SCREATOR, STNAME , TCREATOR
from sysibm.SYSTABAUTH where TTNAME ='VRECON_DETAIL' AND TCREATOR = 'SIDC3008' ;

No comments: