SAP ABAP Table DB2_VIEW_TS_DETAILS (DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_VIEW_TS_DETAILS	Table Relationship Diagram
Short Description	DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	GENERAL_DATA	☐	DB2_DB02_TS_GEN		STRU	0	0
2	SPACENAME	☐	DB2TSNAML		CHAR	24	0	DB2 TS Name
3	SPACE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
4	DBNAME	☐	DB2DBNAML		CHAR	24	0	DB2 DB Name
5	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
6	SPACE_TYPE	☐	DB2TSTYPE		CHAR	20	0	TS: Type of object
7	BPOOL	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
8	NTABLES	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
9	SEGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
10	ENCODING_SCHEME	☐	DB2_ENCODING		CHAR	20	0	DB2 Encoding
11	MAXROWS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
12	DSSIZE	☐	INT4	INT4	INT4	10	0	Natural number
13	MAXPARTITIONS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
14	BASE_TABLE_NAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
15	BASE_TABLE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
16	TAB_DETAILS	☐	DB2_DB02_TS_DETAILS		STRU	0	0
17	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
18	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
19	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
20	PGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
21	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
22	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
23	AVGROWLEN	☐	INT4	INT4	INT4	10	0	Natural number
24	MAXROWS	☐	DB2MROW	DB2MROW	INT2	5	0	Maximum number of rows that DB2 will place on a data page
25	DSSIZE	☐	INT4	INT4	INT4	10	0	Natural number
26	TAB_TABLES	☐	DB2_DB02_TS_TABLES		STRU	0	0
27	IT_TABLES	☐	DB2_T_TABLES		TTYP	0	0
28	TAB_HISTORY	☐	DB2_DB02_TS_HISTORY		STRU	0	0
29	FROM_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
30	TO_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
31	IT_TABLESPACES	☐	DB_T_TABHIST		TTYP	0	0
32	RANGE	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
33	RANGE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
34	COLLAPSED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
35	EXPANDED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
36	RANGE_PREV	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
37	HIST_KEEP_DAYS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
38	HIST_KEEP_WEEKS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
39	HIST_KEEP_MONTHS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
40	TAB_PARTITIONS	☐	DB2_DB02_TS_PARTITIONS		STRU	0	0
41	IT_PARTITIONS	☐	DB2TBPARTLIST		TTYP	0	0
42	TAB_PART_DETAILS	☐	DB2_DB02_TAB_PART_DETAILS		STRU	0	0
43	PARTNO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
44	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
45	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
46	PQTY	☐	INT4	INT4	INT4	10	0	Natural number
47	SQTY	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
48	STORNAME	☐	DB2STOGROUP		CHAR	128	0	Storage group
49	FARINDREF	☐	INT4	INT4	INT4	10	0	Natural number
50	NEARINDREF	☐	INT4	INT4	INT4	10	0	Natural number
51	PERCACTIVE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
52	LIMITKEY	☐	DB2LIMITKEY		CHAR	128	0	limitkey
53	FREEPAGE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
54	PCTFREE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
55	COMPRESS	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
56	PAGE_SAVE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
57	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
58	GBPCACHE	☐	DB2GBPCACHL		CHAR	8	0	Group buffer pool cache option
59	CARDF	☐	DB2DB02CARDF		DEC	19	0	cardf
60	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
61	DSNUM	☐	INT4	INT4	INT4	10	0	Natural number
62	EXTENTS	☐	INT4	INT4	INT4	10	0	Natural number
63	LOGICAL_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
64	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
65	AVGROWLEN	☐	INT4	INT4	INT4	10	0	Natural number
66	ROW_FORMAT	☐	DB2ROWFORMAT		CHAR	16	0	Row Format
67	REORG_LR_TS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
68	FREE_SPACE	☐	DB2SIZEKB		DEC	19	0	Size in KB
69	PCT_USED	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
70	LIST_VOL	☐	DB2VOLID	CHAR6	CHAR	6	0	Serial number of the volume
71	TAB_DATASETS	☐	DB2_DB02_TS_DATASETS		STRU	0	0
72	IT_DATASETS	☐	DB2DATASETS		TTYP	0	0
73	PARTLIST	☐	DBA_LISTBOX_LIST		TTYP	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	732