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.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 |
| 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 |
| 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 |
| 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 | DBET hash chain lock timeout | INTERNAL LOCK NN |
| 00002105 | Logical partition DBET entry | DB.SP.PT |
| 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 |
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 DB2-MANAGED SPACE WITHOUT SECONDARY ALLOCATION OR USER-MANAGED SPACE. This resource name implies either an segmented (non-universal) table space that is managed by DB2 and has a SECQTY value of 0 or any user-managed table space. When this type (ST) is used with resource type 00000200 and reason code 00E7009A, SQLCODE -904 specifies the missing resource name as DB2-MANAGED SPACE WITH SECONDARY ALLOCATION. This resource name implies either a partition-by-growth table space regardless of the SECQTY value or a table space that is segmented (non-universal) with a non-zero value for SECQTY. Related information:
|
| TB | Table name |
| TS | Table space name |
| VW | View name |
Notes:
- 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.