SYSIBM.SPTR table
The SPTR table stores skeleton package table (SKPT) information. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| SPTLL | INTEGER | The length of the record. | S |
| SPTLOCID | VARCHAR(128) | Package location. | S |
| SPTCOLID | VARCHAR(128) | Package collection ID. | S |
| SPTNAME | VARCHAR(128) | Package name. | S |
| SPTCONID | CHAR(8)
FOR BIT DATA |
Package consistency token. | S |
| SPTRESV | CHAR(2)
FOR BIT DATA |
Internal use only. | I |
| SPTSEC | CHAR(4)
FOR BIT DATA |
Section number. | S |
| SPTSEQ | CHAR(2)
FOR BIT DATA |
Sequence number within the section. | S |
| SPTBODY | VARCHAR(1) | Reserved for future IBM® use. | I |
| SPTVER | VARCHAR(64) | Package version. | S |
| SPT_ROWID | ROWID | ROWID that Db2 creates for the LOB columns in this table. | S |
| SPT_DATA | BLOB(2G) | Internal use only. | I |
| SPT_EXPLAIN | BLOB(2G) | Internal use only. | I |