8 Data Dictionary for Oracle Database Provider for DRDA
Oracle enhanced its data dictionary to enable Oracle Database Provider for DRDA.
Data Dictionary Emulation in Oracle Database Provider for DRDA
Many applications use a subset of DB2 system catalogs. Oracle Database Provider for DRDA supports three major sets of catalogs. While all three have some common structures among them, there are many distinct differences.
These catalogs may be implemented as overlays, or views, of existing Oracle data dictionary tables and views.
The catalog described in this section is for “DB2 for z/OS”.
Related Topics
DB2 for z/OS
DB2 for z/OS includes the following catalog tables. Please see IBM's DB2 for z/OS SQL Reference manual for description of these views.
-
SYSIBM.SYSCOLUMNS
-
SYSIBM.SYSDUMMY1
-
SYSIBM.SYSFOREIGNKEYS
-
SYSIBM.SYSINDEXES
-
SYSIBM.SYSKEYCOLUSE
-
SYSIBM.SYSKEYS
-
SYSIBM.SYSPACKAGE
-
SYSIBM.SYSPACKSTMT
-
SYSIBM.SYSPARMS
-
SYSIBM.SYSPLAN
-
SYSIBM.SYSRELS
-
SYSIBM.SYSROUTINES
-
SYSIBM.SYSSYNONYMS
-
SYSIBM.SYSTABCONST
-
SYSIBM.SYSTABLES
-
SYSIBM.SYSVIEWS
Data Dictionary Views for Oracle Database Provider for DRDA
Oracle Database Provider for DRDA has uses several data dictionary views:
ALL_DRDAASPACKAGE Data Dictionary View
Table 8-1 contains the list of currently bound DRDA packages. It is owned by user SYSIBM
. Users must be granted either the DRDAAS_USER_ROLE
or the DRDAAS_ADMIN_ROLE
in order to access this view; see “DRDAAS_USER_ROLE
” and “DRDAAS_ADMIN_ROLE
”.
Table 8-1 ALL_DRDAASPACKAGE data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
collection ID of Pkg (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
version name of package (VRSNAM) |
|
|
|
Not |
consistency string of package (PKGCNSTKN) |
|
|
Not |
userid that owns package |
|
|
Not |
userid that created/bound package |
|
|
Not |
time package is created |
|
|
Not |
time of the last binding of package |
Related Topics
ALL_DRDAASPACKAUTH Data Dictionary View
Table 8-2 contains the set of user ids, DRDA package names, and privileges granted to the user for each package. It is owned by user SYSIBM
. Users must be granted either the DRDAAS_ADMIN_ROLE
or the DRDAAS_ADMIN_ROLE
in order to access this view; see “DRDAAS_USER_ROLE
” and “DRDAAS_ADMIN_ROLE
”.
Table 8-2 ALL_DRDAASPACKAUTH data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
userid of user who granted privileges |
|
|
Not |
userid of user who received privileges |
|
|
Not |
time privileges were created |
|
|
Not |
collection ID of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
Not |
privilege |
Related Topics
ALL_DRDAASPACKSIDE Data Dictionary View
Table 8-3 shows side attributes for the DRDA package. It is owned by user SYSIBM
. Users must be granted either the DRDAAS_ADMIN_ROLE
or the DRDAAS_ADMIN_ROLE
in order to access this view; refer “DRDAAS_USER_ROLE
” and “DRDAAS_ADMIN_ROLE
”.
Table 8-3 ALL_DRDAASPACKSIDE data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
collection ID (Schema) of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
Not |
side item |
|
|
Not |
side keyword |
|
|
Not |
side value |
Related Topics
DBA_DRDAASPACKAGE Data Dictionary View
Table 8-4 contains the DRDA package definition data. It is owned by user SYSIBM
. Users must be granted the DRDAAS_ADMIN_ROLE
in order to access this view; see “DRDAAS_ADMIN_ROLE
”.
Table 8-4 DBA_DRDAASPACKAGE data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
collection ID (Schema) of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
version name of package (VRSNAM) |
|
|
|
Not |
consistency string of package (PKGCNSTKN) |
|
|
Not |
userid that owns package |
|
|
Not |
userid that created package |
|
|
Not |
time package is created |
|
|
Not- |
time of the last binding of package |
|
|
default schema of package (DFTRDBCOL) |
|
|
|
Not |
number of sections in the package (MAXSCTNBR) |
|
|
Not |
package valid state; |
|
|
Not |
|
|
|
|
|
|
|
|
|
|
|
default DBCS codepage (PKGDFTCC(CCSIDSBC)) |
|
|
|
Default DBCS codepage (PKGDFTCC(CCSIDDBC)) |
|
|
|
Default MBCS codepage (PKGDFTCC(CCSIDMBC)) |
|
|
|
Default XML codepage (PKGDFTCC(CCSIDXML)) |
|
|
|
Degree of parallel I/O (DGRIOPRL) |
|
|
|
Date Format, 1=USA, 2=EUR, 3=ISO, 4JIS, 5=LOCAL |
|
|
|
Time Format, 1=USA, 2=EUR, 3=ISO, 4JIS, 5=LOCAL |
|
|
|
Decimal Delimiter (STTDECDEL) |
|
|
|
String Delimiter (STTSTRDEL) |
|
|
|
Decimal Precision (DECPRC) |
|
|
|
Character Subtype (PKGDFTCST) |
|
|
|
Future usage (PKGATHRUL) |
|
|
|
Future usage (PRPSTTKP) |
Related Topics
DBA_DRDAASPACKAUTH Data Dictionary View
Table 8-5 contains the set of userids and RDA package names, as well as privileges granted to the user for each package. It is owned by user SYSIBM
. Users must be granted the DRDAAS_ADMIN_ROLE
in order to access this view; see “DRDAAS_ADMIN_ROLE
”.
Table 8-5 DBA_DRDAASPACKAUTH data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
authorization ID of user who grants package privileges |
|
|
Not |
authorization ID of user who has package privileges |
|
|
Not |
collection ID (Schema) of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
Not |
version name of package (VRSNAM) |
|
|
Not |
granted privilege |
Related Topics
DBA_DRDAASPACKSIDE Data Dictionary View
Table 8-6 shows side attributes for the DRDA package. It is owned by user SYSIBM
. Users must have DRDAAS_ADMIN_ROLE
in order to access this view.
Table 8-6 DBA_DRDAASPACKSIDE data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
collection ID (Schema) of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
Not |
side item |
|
|
Not |
side keyword |
|
|
Not |
side value |
DBA_DRDAASPACKSTMT Data Dictionary View
Table 8-7 contains the DRDA package body data. It is owned by user SYS
. Users must be granted the DRDAAS_ADMIN_ROLE
in order to access this view; see “DRDAAS_ADMIN_ROLE
”.
Table 8-7 DBA_DRDAASPACKSTMT data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
collection ID (Schema) of DRDA package (RDBCOLID) |
|
|
Not |
name of DRDA package (PKGID) |
|
|
version name of package (VRSNAM) |
|
|
|
Not |
consistency string of package (PKGCNSTKN) |
|
|
Not |
Statement Assumptions (BNDSTTADM) |
|
|
Not |
statement number (SQLSTTNBR) |
|
|
Not |
section number (PKGSN) |
|
|
Not |
statement text length |
|
|
Not |
statement text |
Related Topics
DBA_DRDAASTRACE Data Dictionary View
“DRDAASPATRACE
data dictionary view description contains trace entry from the DBMS_DRDAAS
and DBMS_DRDAAS_ADMIN
package functions. It is owned by user SYSIBM
.Users must be granted either the DRDAAS_ADMIN_ROLE
or the DRDAAS_ADMIN_ROLE
in order to access this view.
This is a debugging feature only.
Table 8-8 DBA_DRDAASPATRACE data dictionary view description
Column Name | Datatype | Null? | Description |
---|---|---|---|
|
|
Not |
userid of user who wrote the trace record |
|
|
Not |
function that is traced |
|
|
argument 2 |
|
|
|
argument 1 |
|
|
|
argument 3 |
|
|
|
argument 4 |
|
|
|
argument 5 |
|
TS |
|
Not- |
timestamp of trace entry |
Related Topics
USER_DRDAASPACKAGE Data Dictionary View
The view only returns rows that match the current SQL user ID in the creator
or owner
column and have EXECUTE_PRIVILEGE
granted to the userid in DBA_DRDAASPACKAUTH
matching the package COLLID
and name
.
The view USER_DRDAASPACKAGE
maps onto DBA_DRDAASPACKAGE
table. It is owned by user SYSIBM
. Users must have the DRDAAS_USER_ROLE
in order to select from this view; see “DRDAAS_USER_ROLE
”.
This view has the same column definition as the DBA_DRDAASPACKAGE
table; see “DBA_DRDAASPACKAGE data dictionary view description.”
Related Topics
USER_DRDAASPACKAUTH Data Dictionary View
This view only return rows that match the current SQL user ID in the grantee
column.
The view USER_DRDAASPACKAUTH
maps on top of DBA_DRDAASPACKAUTH
. It is owned by user SYSIBM
. Users must have the DRDAAS_USER_ROLE
in order to select from this table; see “DRDAAS_USER_ROLE
”.
This view has the same column definition as the DBA_DRDAASPACKAUTH
table; see “DBA_DRDAASPACKAUTH
data dictionary view description”.
Related Topics
USER_DRDAASPACKSIDE Data Dictionary View
This view is used internally by the Application Server.
The view USER_DRDAASPACKSIDE
maps on top of DBA_DDRDAASPACKSIDE
. It is owned by user SYSIBM
. Users must have the DRDAAS_USER_ROLE
in order to select from this table; see “DRDAAS_USER_ROLE
”.
This view has the same column definition as the DBA_DRDAASPACKSIDE
table; see “DBA_DRDAASPACKSIDE
data dictionary view description”.
Related Topics
USER_DRDAASPACKSTMT Data Dictionary View
The view only returns rows that match the current SQL user ID in the creator
or owner
column, and have EXECUTE_PRIVILEGE
granted to the userid in DBA_DRDAASPACKAUTH
matching the package COLLID
and name
.
The view USER_DRDAASPACKSTMT
maps onto of DBA_DRDAASPACKSTMT
table. It is owned by user SYSIBM
. Users must have the DRDAAS_USER_ROLE
in order to select from this table; see “DRDAAS_USER_ROLE
”.
This view has the same column definition as the DBA_DRDAASPACKSTMT
table; see “DBA_DRDAASPACKSTMT
data dictionary view description.”
Related Topics
USER_DRDAASTRACE Data Dictionary View
The view returns only the rows that match the userid of the current user.
This is a debugging feature only.
The view USER_DRDAASTRACE
maps onto DBA_DRDAASTRACE
view. It is owned by user SYSIBM
. Users must be granted the DRDAAS_USER_ROLE
in order to access this view; see “DRDAAS_USER_ROLE
”.
This view has the same column definition as the USER_DRDAASTRACE
view, with the exception of the caller
column. See “DBA_DRDAASPATRACE
data dictionary view”.
Related Topics