DB2CCHOUR is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2CCHOUR in SAP.
- Table description : List of TS/IXS needing utility treatment (DSNACCOR Hourly)
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU2
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DB2CCHOUR Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| DATE_ANA | Date of the last check | DB2BCKDATE | DATUM |
| TIME_ANA | Time of the last check | DB2BCKTIME | TIME |
| DBNAM | Database name | DB2DBNAME | D2DBNAME |
| TSNAM | Name of the tablespace | DB2TSNAME | CHAR8 |
| TSPART | Partition number | DB2PARTNRS | DB2SINT |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| IXNAME | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR18 |
| .INCLUDE | Output List of Table-/Indexspace of DB2 SP DSNACCOR | ||
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
| PARTI | Data set number or partition number | DB2CCPART | DB2PART |
| OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR2 |
| OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | DB2CCOBJS | CHAR36 |
| COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | DB2CCCPYR | CHAR3 |
| RUNSTREC | RUNSTATS Recommendation: YES or NO | DB2CCSREC | CHAR3 |
| EXTENTS | Extentlimit was exceeded: YES or NO | DB2CCEXTL | CHAR3 |
| REORGREC | REORG Recommendation: YES or NO | DB2CCOREC | CHAR3 |
| EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | DB2CCEXCL | CHAR40 |
| ASSOCTS | Associated tablespace for indexspace | DB2CCASSTS | DB2TSNAME |
| COPYTIME | Timestamp of last full image COPY | DB2CCCTIME | DB2TMSTMP |
| LOADREPLTI | Timestamp of last LOAD REPLACE | DB2CCLTIME | DB2TMSTMP |
| REBUILDTIM | Timestamp of last REBUILD INDEX | DB2CCRTIME | DB2TMSTMP |
| FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | DB2CCUPDPG | |
| FCCHGPCT | Full/Inc. Copy: Changed rows in percent | DB2CCCCHGS | |
| FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | |
| FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | |
| REORGTIME | Timestamp of last REORG | DB2CCOTIME | DB2TMSTMP |
| RTINSDELUP | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | |
| RTUNCLUST | REORG TS: Unclustered inserts in percent | DB2CCUNCLU | |
| RTLOBPCT | REORG TS: Disorganized LOBs in percent | DB2CCLOB | |
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | |
| RTINDREF | REORG TS: Indirect references (overflow records) in percent | DB2CCIND | |
| RIINSDEL | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | |
| RIAPPINS | REORG Index: Appended rows (with greater key) in percent | DB2CCAPP | |
| RIPSEUDODE | REORG Index: Pseudo deletes in percent | DB2CCPSEUD | |
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | |
| RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | DB2CCLEAF | |
| RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | |
| RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | DB2TMSTMP |
| STINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | |
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP |
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | |
| SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | |
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP |
| SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | |
| EXTENT_NO | Number of physical extents in TS, IS or partition | DB2CCEXTNO | INT2 |
| RTINSDELUPABS | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | |
| RTACTIVEPAGES | REORG TS/IX: Number of active pages | DB2CCRROWS |
DB2CCHOUR related tables
| Table | Note |
|---|---|
| DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) |
| DB2CCDAILY | List of TS/IXS needing utility treatment (DSNACCOR Daily) |
| DB2CCDAILYX | List of TS/IXS needing utility treatment (DSNACCOX Daily) |
| DB2CCACCOR | Parameters of Control Center stored procedure DSNACCOR |
| SPROXXSLQ | Queue with objects needing generation of stylesheets |
| DSWPHOURLYSRV | DSWP: Hourly Services |
| T5B05 | Function SI Hourly Paid Employee without Regulation (B) |
| T5B0E | Text Table Function SI Hourly Paid without Regulation (B) |
| T5C3C | HR-CH: Share of Hourly Wages |
| BGPROT | DB utility log |
| DB2CCMO_OBJERR | DSNACCMO: History of failed utility executions |
| DBAML | Job / Job Step Utility View |
| DSWP_SYSTEM_REPL | Utility Table for Analysis Method Error Analysis |
| EKONG | Franchise Contributions by Customer/Utility Co. |
| ESALES_PRODUCTT | Utility Product Texts |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP