DB2_ACCOX_PROFILE SAP (Structure to store input parameter of DB2 SP DSNACCOX) Structure details

Dictionary Type: Structure
Description: Structure to store input parameter of DB2 SP DSNACCOX




ABAP Code to SELECT data from DB2_ACCOX_PROFILE
Related tables to DB2_ACCOX_PROFILE
Access table DB2_ACCOX_PROFILE




Structure field list including key, data, relationships and ABAP select examples

DB2_ACCOX_PROFILE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure to store input parameter of DB2 SP DSNACCOX" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2_ACCOX_PROFILE TYPE DB2_ACCOX_PROFILE.

The DB2_ACCOX_PROFILE table consists of various fields, each holding specific information or linking keys about Structure to store input parameter of DB2 SP DSNACCOX data available in SAP. These include PROFILE (Name of profile, so different configurations are supportable), FCUPDPGS (Full Copy: Updated pages in percent), FCUPDPGSABS (Full Copy: Updated pages absolut), FCCHGPCT (Full Copy: Changed rows in percent).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DB2_ACCOX_PROFILE structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PROFILE Name of profile, so different configurations are supportable0
FCUPDPGS Full Copy: Updated pages in percent0
FCUPDPGSABS Full Copy: Updated pages absolut0
FCCHGPCT Full Copy: Changed rows in percent0
FCDAYSCOPYFull Copy: Number of days since last COPY DB2CCCDAYSINT410
ICUPDPGS Inc. Copy: Updated pages in percent0
ICUPDPGSABS Inc. Copy: Updated pages absolut0
ICCHGPCT Inc. Copy: Changed rows in percent0
FCINDEXSIZFull Copy: Minimum size of index in pages (NACTIVE) DB2CCISIZEINT410
RTINSPCT REORG TS: Inserted rows in percent0
RTINSABS REORG TS: Inserted rows absolut0
RTDELPCT REORG TS:Deleted rows in percent0
RTDELABS REORG TS:Deleted rows absolut0
RTUNCLUST REORG TS: Unclustered inserts in percent0
RTLOBPCT REORG TS: Disorganized LOBs in percent0
RTDATASPRAT REORG TS: Ration between RTS SPACE and RTS DATASIZE0
RTMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RTINDREF REORG TS: Indirect references (overflow records) in percent0
RIINSPCT REORG IX: Inserted rows in percent0
RIINSABS REORG IX: Inserted rows absolut0
RIDELPCT REORG IX: Deleted rows in percent0
RIDELABS REORG IX: Deleted rows absolut0
RIAPPINS REORG IX: Appended rows (with greater key) in percent0
RIPSEUDODE REORG IX: Pseudo deletes in percent0
RIMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RILEAFLIM REORG IX: Pages phys. far away (INDEXPART.LEAFFAR) percent0
RINUMLEVELREORG Index: Change to number of index tree levels absolute DB2CCLEVELINT410
STINSDELP RUNSTATS TS: Changed rows in percent0
STINSDELA RUN.:Changed rows (insert, delete or update) absolute number0
STMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
SIINSDELP RUNSTATS IX: Changed rows in percent0
SIINSDELA RUN.:Changed rows (insert, delete or update) absolute number0
SIMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
EXTENTSNumber of allowable dataset extents DB2CCEXTINT410
CHKLVL Specifies the types of checking that DSNACCOX performs0

Key field Non-key field



How do I retrieve data from SAP structure DB2_ACCOX_PROFILE using ABAP code?

As DB2_ACCOX_PROFILE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2_ACCOX_PROFILE as there is no data to select.

How to access SAP table DB2_ACCOX_PROFILE

Within an ECC or HANA version of SAP you can also view further information about DB2_ACCOX_PROFILE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!