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