Select data from sap tables DB6P

Display SAP table details
  



DB6PARAM_DESCR - Parameter Description

DB6PDDIAG - CCMS: PD Log Message

DB6PM1ST4 - Initial Screen of Transaction ST04

DB6PMACTION_STEP - Binding of Action Step to Screen Number

DB6PMADVIX - CCMS: ADVISE_INDEX Explain Table Structure

DB6PMADVIX_FILTER - Filter for Index Advisor ADVISE_INDEX Records

DB6PMADVIX_GUI - CCMS: Index Advisor GUI Table (View Options)

DB6PMADVWL - CCMS: ADVISE_WORKLOAD Explain Table Structure

DB6PMBPCFG - Buffer Pools: System Catalog Info

DB6PMCCNT - Tablespace Container Configuration Data (Calculated)

DB6PMCD - Configuration Database

DB6PMCD2 - Database Configuration

DB6PMCD_DB2 - Structure of GET_DB_CONFIG Result Set

DB6PMCD_PAR - Database Configuration Parameters

DB6PMCD_VIEW - Database Configuration Parameters

DB6PMCF - File System Configuration

DB6PMCF1 - Structure to Display File System Configuration

DB6PMCF_PARAM - Parameters of Table Function DB6PMCF

DB6PMCG - Protocol Table for Logfile-Related Operations

DB6PMCG_FILTER - Filter for History File Access

DB6PMCIDX - Configuration of All Indexes of a Table

DB6PMCIST - Index Structure in DB and Dictionary

DB6PMCK - All Backups of History File

DB6PMCKOV - Overview of Backup History

DB6PMCK_FILTER - Filter for History File Access

DB6PMCK_P - DB6: All Backed Up Tablespaces of History File

DB6PMCM1 - Configuration Database Manager (Part 1)

DB6PMCM2 - Configuration Database Manager (Part 2)

DB6PMCMT - Mount Information from SAPTOOLS.MOUNT_INFO

DB6PMCM_PAR - DBM Configuration Parameters

DB6PMCM_VIEW - DBM Parameter View

DB6PMCN - Configuration Nodes (Partitions)

DB6PMCP - Configuration Tablespace

DB6PMCR - Configuration Container

DB6PMCTAB - Table Configuration

DB6PMCTBS - Tablespace Configuration Data (Calculated)

DB6PMCTCT - Tablespace Contents (Configuration)

DB6PMCTOV - Configuration of All Tables - Overview

DB6PMCTST - Table Structure

DB6PMDB02 - Initial Screen of DB02 - Overview

DB6PMDBCFG_EEE - CCMS: EEE DB CFG Table

DB6PMDBPATH - DB Paths

DB6PMDLCH - CCMS: Event Monitor - Connection Header

DB6PMDLCTL - CCMS: Event Monitor - Monitor Control Information

DB6PMDLLK - CCMS: Event Monitor - Held Locks

DB6PMDLLK_FILTER - Filter for Deadlock Lock Records

DB6PMDLOV - CCMS: Event Monitor - Deadlock Overview

DB6PMDLSH - CCMS: Event Monitor - Deadlock Statement History

DB6PMDLSH_CMPLENV_PARAM - Parameters for COMPILATION_ENV

DB6PMDLSH_FILTER - Filter für Deadlock Statement History

DB6PMDLSV - DB6 CCMS: Event Monitor - Deadlock Statement History Values

DB6PMDLTR - DB6 CCMS: Event Monitor - Deadlock involved transactions

DB6PMENVINST - Instance Information (Short)

DB6PMHCDM - DB6: Database and Database Manager Parameter Changes

DB6PMHCDM_STRU - DB6: Database and Database Manager Parameter Changes

DB6PMHISTFILE - DB6: Table Reorg Status from History File

DB6PMHISTFILE_FILTER - DB6: Filter for Index Advisor ADVISE_INDEX Records

DB6PMHIS_BACKUP - DB6: History Entry for Backups

DB6PMHIS_BACKUP_FILTER - DB6: Filter for Backup History Access

DB6PMHIS_BACKUP_V82 - DB6: History Entry for Backups

DB6PMHPTAB_GUI - parameter history for screen display

DB6PMHSB - DB6: Buffer Pool Statistics History

DB6PMHSD - DB6: Database Performance Statistics History

DB6PMHST - DB6: Snapshot Table History

DB6PMHT - DB6: Detail Record of Table and Index Space Statistics

DB6PMHT_HD - DB6: Summary Record of Table and Index Space Statistics

DB6PMHXP - DB6: Detail Record of Tablespace and DB Space Statistics

DB6PMHXPHD - DB6: Summary Record of Tablespace And DB Space Statistics

DB6PMHXT - DB6: Detail Record of Tablespace and DB Table/Index Stats

DB6PMHXTHD - DB6: Summary Rec. of Tablespace and DB Table/Index Stats

DB6PMINSPECT - Result of INSPECT_TABLE_ROWCOMPESTIMATE

DB6PMINSPECT_PARAM - DB6: Parameters for Inspect Table

DB6PMLCKWT - DB6: Data of DB2 UDB Lock Waits

DB6PMLFAX - DB6: Data of DBAML (lfa, lfx) for Display in DB12

DB6PMMSGWIN - DBA Cockpit: Message Window view structure

DB6PMPARTMAP - DB6: Structure for Partion Groups - Partitions Matrix

DB6PMPARTMAP_CHG - DB6: Matrix to hold changes in partitioning map

DB6PMPART_PKEY - DB6: structure for viewing ascertained partitioning keys

DB6PMPOV - DB6: Partition Overview

DB6PMPROT - DB6: Protocol Table for DBA Actions

DB6PMREGVAR - Registry Variables

DB6PMREORGCHK_IDX - DB6: REORGCHK Results of Table

DB6PMREORGCHK_PARAM - DB6: Filter for REORGCHK results

DB6PMREORGCHK_TAB - DB6: REORGCHK Results of Table

DB6PMREORGH - DB6 Helpstructure for DB6_PM_TABLE1

DB6PMSA - DB6: Application Snapshot

DB6PMSAGENT - DB6: Agent Snapshot

DB6PMSAGENT_MEMORY_POOL - DB6: Agent Memory Snapshot

DB6PMSAPP - DB6: Application Snapshot

DB6PMSA_AG - DB6: Application Agents Snapshot

DB6PMSA_APPL_INFO - DB6: application info snapshot part of DB6PMSA

DB6PMSA_LW - DB6: Application Lock Wait Snapshot

DB6PMSA_SS - DB6: Application Subsections Snapshot

DB6PMSA_ST - DB6: Application Statement Snapshot

DB6PMSB - DB6: Buffer Pool Snapshot

DB6PMSBP - DB6: Calculated Buffer Pool Snapshot Data

DB6PMSD - DB6: Database Snapshot

DB6PMSD_STOR - DB6: Automatic Storage Paths

DB6PMSL_AP - DB6: Application Lockst. Snapshot

DB6PMSL_DB - DB6: Snapshot Locks Database

DB6PMSL_LK - DB6: Snapshot Locks Application Locks

DB6PMSL_LW - DB6: Snapshot Locks Application Lock Waits

DB6PMSM - DB6: Database Manager Snapshot

DB6PMSM_FC - DB6: Snapshot Database Manager FCM (Fast Comm. Manager)

DB6PMSM_FN - DB6: Snapshot Database Manager FCM Nodes

DB6PMSOV - DB6: System Overview with load sharing

DB6PMSP - DB6: Tablespace Snapshot

DB6PMSP_HD - DB6: Tablespace Header Snapshot

DB6PMSQ - DB6: Snapshot SQL Cache

DB6PMSQC - DB6: SQL Cache Snapshot and Percentage Columns

DB6PMSQ_DBS - DB6: Temporary database store for SQL Cache

DB6PMSQ_FILTER - DB6: Filter for SQL Cache Records

DB6PMSQ_HD - DB6: Header Information of SQL snapshot

DB6PMSR - DB6: Table Reorg Snapshot

DB6PMSR_ONL - Online Table Reorgs

DB6PMST - DB6: Snapshot Table

DB6PMSTAB - Table Snapshot Data

DB6PMSTBS - Tablespace Snapshot Data

DB6PMSTMT - DB6: Application Snapshot Statements

DB6PMST_FILTER - DB6: Filter for table snapshot history SNAP_GET_TAB_V91

DB6PMST_HD - DB6: Snapshot Table Header

DB6PMSU - Utilities Snapshot

DB6PMSU_PROGRESS - Utilities Phases Progress

DB6PMSYS - DB6: Overall System Check

DB6PMTAB_INFO - ADMIN_GET_TAB_INFO

DB6PMTAB_INFO_COMMON - DB6: Table Information

DB6PMTAB_INFO_PARAM - DB6: Parameters for Table Info

DB6PMTBS_CONT - structure for viewing tablespaces of certain partition group

DB6PMTBS_REDIST - structure for viewing tablespaces of certain partition group

DB6PMTSLST - DB6: List of Tablespaces to Display the Content of

DB6PMVOV - DB6: Statistics information from SYSCAT and DBSTATC

DB6PM_ALRTLSTSEL - DB6 Alert Monitor: List Selection

DB6PM_ALRTMSGSEL - DB6 Alert Message Log - Selection

DB6PM_CDM - DB6: DB and DBM Parameter Changes for Display

DB6PM_CLN - DB6: Cleanup of History Tables

DB6PM_CLN_STRU - DB6: Cleanup of History Tables

DB6PM_CLP - DB6: CLP Command Output

DB6PM_CLP_PARAM - DB6: Parameters of EXEC_CLP table function

DB6PM_DLK - DB6: Table to Store the Output of Detected Deadlocks

DB6PM_HISTCHARTSEL - DB6 History Chart - Selection

DB6PM_LST - DB6: Sysout Listing (Standard Output of an Executable)

DB6PM_LST_PARAM - DB6: Parameters of table function DB6PM_LST

DB6PM_SD - DB6: Database Performance History Display

DB6PM_ST - DB6: Snapshot Table History Display

DB6PM_T - DB6: Detail Record of Table/Index Space Stats with Calc

DB6PM_TIME - DB6: Protocol Record of Statistical Data Collection

DB6PM_TPHD - Cumulated Table-Specific Snapshot Data

DB6PM_T_HD - DB6: Detail Record of Table/Index Space Stats with Calc

DB6PM_XP - DB6: Detail Record of Tablespace and DB Space Stats Calc

DB6PM_XPHD - DB6: Tablespace and DB Space Statistics with Calculations

DB6PM_XT - DB6: Detail Tablespace and DB Table/Index Stats with Calc

DB6PM_XTHD - DB6: Tablespace and DB Table/Index Stats with Calculations

DB6PSEUDOTAB - DB6 Pseudo Table

Return Table index