Select data from sap tables DB4
Display SAP table details
DB4AVGSPC - iSeries: Avarage Growth Rate per Table
DB4BACKUP - Store DB4 Backup Data
DB4BD_ACCESSOR - DB4: Backend accessor
DB4BD_COLUMN_MAP - DB4: Backend column mapping
DB4BD_CONSTANT - DB4: Backend constant
DB4BD_OPTION - DB4: Backend access option
DB4BD_TASK_EXECUTOR - DB4: Backend task executor
DB4BD_VIRTUAL_TABLE - DB4: Backend virtual table
DB4DBJOBS - iSeries: Database Jobs
DB4DBMACTP - iSeries: Database Monitor Activity per Process (DB Jobs)
DB4DBMCFG - iSeries: For Memory-Resident DB Monitor Configuration
DB4DBMON - iSeries: Database Monitor Header Info for ST04
DB4DLTREC - DB2 UDB for iSeries: Deleted Records
DB4FLESTAT - iSeries: File Statistics
DB4HISTSPC - iSeries: Space Statistics
DB4IDA0100 - iSeries: Database Performance: Advised Indexes (Main screen)
DB4IDA0200 - iSeries: Database Performance: Advised Indexes (Detail scr.)
DB4IDA0300 - iSeries: Database Performance: List of Advised Indexes
DB4IDC0100 - iSeries: Database Performance: Created Indexes (Main screen)
DB4IDC0200 - iSeries: Database Performance: Created Indexes (Detail scr.)
DB4IDU0100 - iSeries Database Performance: Used Indexes (Main screen)
DB4IDU0200 - iSeries Database Performance: Used Indexes (Detail screen)
DB4IDULST - iSeries: LIB/TABLE/CST Structure for ST04_DB4_GET_IDU_INFO
DB4INDEX_HIST - History of Index Sizes in the Database
DB4INDEX_STAT - Index Sizes in the Database
DB4IS - DB2/400: Index Parameters
DB4IXKEYLIST - List of key fields in an index
DB4JOBDATA - iSeries: Qualified Jobname
DB4JOBLCKS - iSeries: Jobs Holding/Waiting for a Database Record Lock
DB4JOBLOG - iSeries: Job Log
DB4LCKLST - iSeries: Database Jobs of all Instances of an SAP System
DB4LCKSTAT - iSeries: DB Record Locks Held by a Job
DB4OX - iSeries: CCMS Object Existence Check
DB4PKGLIB - iSeries: Libraries Containing SQL Packages
DB4PKGTXT - iSeries: Content of one SQL Package
DB4QQPAR - Fields for Parameter References (DBMon for iSeries)
DB4SIZE - DB2 UDB for iSeries: Database Size
DB4SPLFLST - iSeries: Structure for List of Spool Files
DB4SQLNAM - iSeries: SQL Names
DB4SQLPKG - iSeries: SQL Packages
DB4SQR0100 - iSeries Database Performance: SQL Requests/Top 50
DB4SRT0100 - iSeries Database Performance: Sorts
DB4SRVLST - iSeries: List of Active Application Servers
DB4ST4RFC - iSeries: Performance Overview (RFC Destinations)
DB4SYSIXADV - iSeries: SQE Index Advised Information
DB4TABLE_HIST - History of Table Sizes in the Database
DB4TABLE_STAT - Table Sizes in the Database
DB4TABLST - iSeries: LIB/TABLE Structure for ST04_DB4_GET* Functions
DB4TMF0100 - iSeries Database Performance: Temp. File Creates (Main Scr.)
DB4TS - DB2/400 Table Parameters
DB4TSC0100 - iSeries Database Performance: Table Scans
DB4TSC0200 - iSeries Performance: Table Scans (Detail Screen)
DB4TSTAMP - DB2 UDB for iSeries: Timestamp
DB4WAITSTS - Wait Statistics for DB2 UDB for iSeries
DB4WTSTS_I - iSeries: Wait Statistics Cumulated per Instance
DB4WTSTS_P - iSeries: Wait Statistics per Process (Database Jobs)
DB4WTSTS_S - iSeries: Wait Statistics Cumulated over all Instances
DB4_CLUSTER - iSeries: Temporary Statistics Data
DB4_DBMACT - iSeries: Database Monitor Activity per Process (DB Jobs)
DB4_EXPLAIN - iSeries: Database Monitor
DB4_FILE - iSeries: Structure for LIbrary/File
DB4_HISTIM - iSeries Database Performance: Avail. DBMonitor History Info
DB4_IPL_INFO_ENTRY - DB4: IPL Info
DB4_JOBLCK - iSeries: Jobs Holding/Waiting for a Database Record Lock
DB4_JOBSTS - iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB)
DB4_RCDLCK - iSeries: DB Record Locks Held by a Job
DB4_SQ1000 - iSeries: SQL Information (Database Monitor)
DB4_SQ3000 - iSeries: Table Scans (Database Monitor)
DB4_SQ3001 - iSeries: Used Indexes (Database Monitor)
DB4_SQ3002 - iSeries: Created Indexes (Database Monitor)
DB4_SQ3003 - iSeries: Sorts (Database Monitor)
DB4_SQ3004 - iSeries: Temporary Files (Database Monitor)
DB4_SQ3007 - iSeries: Optimizer Timed Out (Database Monitor)
DB4_SQ3008 - iSeries: Subqueries (Database Monitor)
DB4_SQHVAR - iSeries: Host Variable Values for Most Exp. Exec. of a Stmt.
DB4_SQTEXT - iSeries: SQL Statement Text (Database Monitor)
DB4_TIMESTAMP - iSeries: Timestamp
DB4_VIEW_CLTREGS_OVERVIEW - DB4: View data for Client Registers SQL Statements overview
DB4_VIEW_CONFIG - DB4: View data for Peformance Collector Configuration
DB4_VIEW_CPU_DATA_HIST - DB4: View data for CPU_DATA history
DB4_VIEW_DBSPC_HDR - DB4: View data for Space Screens - Header
DB4_VIEW_DBSPC_TAB - DB4: View data for Space Screens - Tables
DB4_VIEW_DBSPC_TIME - DB4: View data for Space Screens - Time
DB4_VIEW_DISK_DATA_HIST - DB4: View data for DISK_DATA history
DB4_VIEW_DISK_SPACE_OVERVIEW - DB4: View data for space on disk overview
DB4_VIEW_DLTROWS_OVERVIEW - DB4: View data for deleted rows
DB4_VIEW_DMGOBJ_OVERVIEW - DB4: View Damaged objects
DB4_VIEW_IDXADV_DETAIL - DB4: View data for index advised - Detail
DB4_VIEW_IDXADV_OVERVIEW - DB4: View data for index advised overview
DB4_VIEW_IDXCREA_DETAIL - DB4: View data for index created - Detail
DB4_VIEW_IDXCREA_OVERVIEW - DB4: View data for index created overview
DB4_VIEW_OBJECTS_GROWTH - DB4: View data for objects growth
DB4_VIEW_OBJECTS_HIST - DB4: View data for objects history (tables/indexes)
DB4_VIEW_OBJECTS_OVERVIEW - DB4: View data for objects (tables/indexes)
DB4_VIEW_OBJECTS_SIZE - DB4: View data for objects size
DB4_VIEW_OBJECTS_STORAGE - DB4: View data for objects storage
DB4_VIEW_OBJSTATS_OVERVIEW - DB4: View data for object statistics detail
DB4_VIEW_PERF_OVERVIEW - DB4: View data for performance overview
DB4_VIEW_POOL_DATA_HIST - DB4: View data for POOL_DATA history
DB4_VIEW_PRC_WAIT_DATA - DB4: View data for CPU_DATA history
DB4_VIEW_SCHEDULE - DB4: View data for Peformance Collector Schedule
DB4_VIEW_SORTS_OVERVIEW - DB4: View data for SQL Statements overview
DB4_VIEW_SPACE_OVERVIEW - DB4: Structure for Space Overview screen
DB4_VIEW_SQEINDEX_OVERVIEW - DB4: View SQE indexes advised
DB4_VIEW_SQLPKG_HIST - DB4: View data for PACKAGEINFO history
DB4_VIEW_SQLPLC_CLTREGS - DB4: View data for SQL Plan Cache Client Register filters
DB4_VIEW_SQLPLC_DMP - DB4: View data for SQL Plan Cache Records
DB4_VIEW_SQLPLC_HDR - DB4: View data for SQL Plan Cache general information
DB4_VIEW_SQLPLC_TAB - DB4: View data for SQL Plan Cache filter on table
DB4_VIEW_SQLPLC_TIME - DB4: View data for SQL Plan Cache filter on time
DB4_VIEW_STMTS_HIST - DB4: View data for SQL statements history
DB4_VIEW_STMTS_OVERVIEW - DB4: View data for SQL Statements overview
DB4_VIEW_TABLE_SCANS_ENTRY - DB4: Table Scans Overview Entry
DB4_VIEW_TMPBMP_OVERVIEW - DB4: View data for temporary bitmaps overview
DB4_VIEW_TMPFLS_OVERVIEW - DB4: View data for temporary files overview
DB4_VIEW_TMPTHT_OVERVIEW - DB4: View data for temporary hash tables overview
DB4_VIEW_TSCANS_DETAIL - DB4: View data for table scans detail
DB4_VIEW_TSCANS_OVERVIEW - DB4: View data for table scans overview
DB4_XCHG_COMMON - DB4: Table Scans Overview Entry
DB4_XCHG_EXPL - DB4: Exchange structure for explain
DB4_XCHG_STMT - DB4: Exchange structure for statements
Return Table index