Resource types
Type codes are associated with particular types of resources.
The following table describes the type of resource associated with the type codes. The
abbreviations in the Name, Content, Format
column are explained in Table 2.
TYPE Code | Type of Resource | Name, Content, Format |
---|---|---|
00000100 | Database | DB |
00000200 | Table space | DB.SP |
00000201 | Index space | DB.SP |
00000202 | Table space | RD.DB.TS |
00000205 | Compression Dictionary | DB.SP |
00000210 | Partition | DB.SP.PT |
00000220 | Data set | DSN |
00000230 | Temporary file | SZ |
00000240 | Database procedure | DBP |
00000300 | Page | DB.SP.PT.PG |
00000301 | Index minipage | DB.SP.PG.MP |
00000302 | Table space page | DB.SP.PG |
00000303 | Index space page | DB.SP.PG |
00000304 | Table space RID | DB.SP.RID |
00000305 | Index access/table space RID | DB.SP.RID |
00000306 | Index access/table space page | DB.SP.PG |
00000307 | Index space EOF | DB.SP.01 |
00000308 | Table space page | DB.SP.PT.PG |
00000309 | Index space page | DB.SP.PT.PG |
0000030A | Table space RID | DB.SP.PT.RID |
00000400 | ICF catalog | IC |
00000401 | Authorization function | |
00000402 | Security Server | SAF/RACF® return/reason codes |
00000500 | Storage group | SG |
00000602 | EDM DBD Space | |
00000603 | EDM DYNAMIC STATEMENT Space | |
00000604 | EDM skeleton storage | |
00000605 | EDM above-the-bar storage | |
00000606 | EDM below-the-bar storage | |
00000700 | Buffer pool space | BP |
00000701 | Group buffer pool | GBP |
00000800 | Plan | PL |
00000801 | Package |
COLLECTION.PACKAGE.-
CONTOKEN |
00000802 | BINDLOCK01 through BINDLOCK20 | BINDLOCK01 through BINDLOCK20 |
00000803 | Package and thread |
COLLECTION.PACKAGE.-
CONTOKEN.THREADTOKEN.- MEMBERNAME |
00000804 | Package |
COLLECTION.PACKAGE.(VERSION)
|
00000900 | 32KB data area | |
00000901 | Sort storage | |
00000903 | Hash anchor | DB.SP.PG.AI |
00000904 | RIDLIST storage | |
00000905 | IRLM storage | |
00000906 | Db2 | MEMBER |
00000907 | LOB storage | |
00000908 | Basic Floating Point Extensions Facility | |
00000909 | Extended Time-of-Day (TOD) Clock | |
0000090A | XML storage | |
00000A00 | Table | RD.CR.TB |
00000A10 | Alias | RELDEP. OWNER. ALIAS. RD.CR.AL |
00000A11 | Distinct type | SC.DT |
00000A12 | User-defined function | SC.SN |
00000A13 | Stored procedure | SC.SN |
00000A14 | Sequence | |
00000A16 | Role | |
00000A17 | Trigger | |
00000B00 | View | RD.CR.VW |
00000C00 | Index | RD.CR.IX |
00000C01 | Index | CR.IX |
00000D00 | DBID/OBID | RD.DI.OI |
00000D01 | DBID/OBID | DI.OI |
00000D02 | OBID | OI |
00000E00 | SU limit exceeded | CN |
00000F00 | Auxiliary column | DI.OI. ROWID. COLN or DI.OI. DOCID. COLN |
00000F01 | LOB lock | DIX.PIX. ROWID. VRSN |
00000F81 | XML lock | DIX.PIX. DOCID |
00001000 | DDF | LOCATION or SUBSYSTEM ID |
00001001 | System conversation | LU.MODE. RTNCD. FDBK2. RCPRI. RCSEC. SENSE |
00001002 | Agent conversation | LU.MODE. RTNCD. FDBK2. RCPRI. RCSEC. SENSE |
00001003 | CNOS processing | LU. MODE. RTNCD. FDBK2. RCPRI. RCSEC. SENSE |
00001004 | CDB (Communication database) | LOCATION. AUTHORIZATION ID. PL |
00001005 | DB access agent | LOCATION |
00001006 | DRDA-related error | |
00001007 | TCP/IP domain name | LINKNAME. DOMAIN. ERRNO |
00001008 | TCP/IP service name | LOCATION. SERVICE. ERRNO |
00001080 | ACCEL | SERVER.DOMAIN |
00001102 | Bootstrap data set (BSDS) | MEMBER |
00001202 | Dynamic Statement Cache | MEMBER.STMTID |
00002000 | Table space CS-claim class | DB.SP |
00002001 | Table space RR-claim class | DB.SP |
00002002 | Table space write-claim class | DB.SP |
00002003 | Index space CS-claim class | DB.SP |
00002004 | Index space RR-claim class | DB.SP |
00002005 | Index space write-claim class | DB.SP |
00002006 | Table space partition CS-claim class | DB.SP.PT |
00002007 | Table space partition RR-claim class | DB.SP.PT |
00002008 | Table space partition write-claim class | DB.SP.PT |
00002009 | Index space partition CS-claim class | DB.SP.PT |
00002010 | Index space partition RR-claim class | DB.SP.PT |
00002011 | Index space partition Write-claim class | DB.SP.PT |
00002100 | Table space DBET entry | DB.SP |
00002101 | Index space DBET entry | DB.SP |
00002102 | Table space partition DBET entry | DB.SP.PT |
00002103 | Index space partition DBET entry | DB.SP.PT |
00002104 | Logical partition DBET entry | DB.SP.PT |
00002105 | DBET hash chain lock timeout | INTERNAL LOCK NN DP.SP, DBID.PSID, or none |
00002200 | Routine parameter storage | DBP |
00002201 | Debug agent storage | DBP |
00002300 | ICSF encryption and decryption facilities | |
00003000 | Code (release maintenance_level or system parameter) | REL, APAR, ZPARM |
00003002 | Number of Stored Procedures | |
00003072 | Index | |
00003073 | Index | |
00003328 | Release dependency | |
00003329 | DBID/OBID | DI.OI |
00003330 | OBID limit exceeded | |
00003840 | LOB column | |
00004000 | Profile exception threshold exceeded | PID.PTYPE.PNAME |
00004001 | Access list entry | ALET |
The following table contains the definitions for the acronyms provided for the Name, Content,
Format
column of the preceding table, Table 1.
Where | Stands for |
---|---|
AI | Hash anchor ID |
ALIAS | Alias owner |
APAR | APAR number |
AUTHORIZATION ID | Db2 authorization identifier |
BP | Buffer pool identifier |
CN | Column name |
COLLECTION | Collection-ID of the package |
COLN | Column number within the base table of the LOB column that has been marked invalid. |
CONTOKEN | Consistency token of the package |
CR | Creator of the object |
DB1 | Database name |
DBP | Database procedure name |
DI | DBID in decimal of resource |
DIX | DBID in hexadecimal |
DOMAIN | TCP/IP domain name or IP address |
DSN | Data set name |
FDBK2 | VTAM® secondary return code |
GBP | Group buffer pool name |
IC | ICF catalog alias name |
IX | Index name |
LOCATION | Location in which the specified resource is not available |
LU | Logical unit name |
MEMBER | Group member name |
MODE | Logical unit mode name |
MP | Hexadecimal mini-page number |
NN | Decimal number of the hash chain |
OI | OBID in decimal of resource |
OWNER | Alias owner |
PACKAGE | Package identifier |
PG | Hexadecimal page number |
PID | Profile ID |
PIX | PSID in hexadecimal |
PL | Plan identifier |
PNAME | The name of the profile filtering scope |
PT | Decimal partition number |
PTYPE | The type of the profile filtering scope |
RCPRI | APPC primary return code |
RCSEC | APPC secondary return code |
RD2 | Db2 release dependency mark |
REL | Db2 release name |
RELDEP | Db2 release dependency mark |
RID | Record Identifier |
RTNCD | VTAM primary return code |
SENSE | SNA sense codename |
SERVER | Accelerator server name |
SG | Storage group name |
SP | Space name |
STMTID | The identifier of the statement in the dynamic statement cache. |
SZ | Temporary file page size |
ST | Space allocation type in work file database. This type is used when the value of the WFDBSEP subsystem parameter is YES. When this type (ST) is used with resource type 00000100 and reason code 00C90084, message DSNT501I specifies the missing resource name as When this type (ST) is used with resource type 00000200 and reason code 00E7009A, SQLCODE -904 specifies the missing resource name as For more information, see: |
TB | Table name |
TS | Table space name |
VERSION | Version identifier of the package |
VW | View name |
- DB can also refer to DI or ST. SP, TS, and TB can also refer to OI. TS can also refer to ST. Db2 sometimes does not have access to resource names, and uses DBID or OBID instead.
- RD can be represented as a white space or blank to indicate no release dependency, or Y or N to indicate whether it is IBMREQD.