SAP ABAP Table DB4SYSIXADV (iSeries: SQE Index Advised Information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4SYSIXADV	Table Relationship Diagram
Short Description	iSeries: SQE Index Advised Information

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	RECORD_NUMBER	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
2	TABLE_SCHEMA	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
3	TABLE_NAME	☐	TNAME	AS4TAB	CHAR	30	0	Table name	*
4	PARTITION_NAME	☐	DB4PARTNAME	DB4PARTNAME	CHAR	10	0	DB2/400: Name of a Table Partition
5	TIMES_ADVISED	☐	SDB4_INT8	SDB4_INT8	DEC	19	0	Alt. Type for INT8 (-9223372036854775808..922337203685476)
6	REASON_ADVISED	☐	CHAR24	CHAR24	CHAR	24	0	Character field length 24
7	MOST_EXP_QUERY	☐	INT4	INT4	INT4	10	0	Natural number
8	AVG_QUERY_EST	☐	INT4	INT4	INT4	10	0	Natural number
9	TABLE_SIZE	☐	SDB4_INT8	SDB4_INT8	DEC	19	0	Alt. Type for INT8 (-9223372036854775808..922337203685476)
10	LAST_ADVISED	☐	QQTIME	QQTIME	CHAR	26	0	iSeries: Record Creation Timestamp (Database Monitor)
11	MTI_CREATED	☐	INT4	INT4	INT4	10	0	Natural number
12	INDEX_TYPE	☐	CHAR14	CHAR14	CHAR	14	0	Text field length 14
13	KEY_COLS_ADVISED	☐			STRG	16000	0
14	AVG_QUERY_EST_MICR	☐	SDB4_INT8	SDB4_INT8	DEC	19	0	Alt. Type for INT8 (-9223372036854775808..922337203685476)

History

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