DB2IXBACK is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2IXBACK in SAP.
- Table description : List of indexes that need a backup
- 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 DB2IXBACK 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 |
| IXCREA | DB2 creator name | DB2CREATOR | CHAR8 |
| IXNAM | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR18 |
| IXPART | Partition number | DB2PARTNRS | DB2SINT |
| .INCLUDE | Output List of index of CC/390 Stored Procedures | ||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| NAME | Index name | DB2INXNAME | CHAR18 |
| TBCREATOR | Authorization id of the owner of the table | DB2TBCREAT | DB2TBCREAT |
| TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR18 |
| UNIQUERULE | Whether the index is unique | DB2UNIQUE | DB2UNIQUE |
| INDEXTYPE | Index type | DB2IXTYPE | DB2IXTYPE |
| INDEXSPACE | Name of the indexspace that contains the index | DB2IXSPACE | CHAR8 |
| CLUSTERING | Whether CLUSTER was specified when the index was created | DB2CLUSTER | DB2YNFLAG |
| ERASERULE | Datasets are to be erased when dropped | DB2ERULE | DB2ERULE |
| CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | DB2CRULE |
| COLCOUNT | Number of columns in the table or view | DB2COLCNT | DB2SINT |
| DBID | DBID | DB2DBID | INT2 |
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| BPOOL | DB2/390: Buffer pool | DB2BUFPOOL | DB2BUFPOOL |
| PGSIZE | DB2 for OS/390 page size in KBytes | DB2PGSIZE | DB2PGSIZE |
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | DB2DPASS |
| PIECEIZE | Maximum size of a data set storage piece in KBytes | DB2PIECEI4 | |
| COPY | Index can be copied | DB2COPY | CHAR1 |
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | DB2PART |
| PARTNR | Partition number | DB2PARTNRS | DB2SINT |
| OPERATION | Date and time of last RUNSTATS | DB2STATSTM | DB2TMSTMP |
| NDAYS | Number of days since last invocation | DB2DAYS | DB2DAYS |
| LEAFDIST | 100 * avg number of leaf pages between successive leaf pages | DB2LEAFDIS | |
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | DB2EXTENT |
| REASON | Reason running utility is recommended | DB2REASON | DB2REASON |
DB2IXBACK related tables
| Table | Note |
|---|---|
| DB2IXBACK | List of indexes that need a backup |
| DB2TSBACK | List of tablespaces that need a backup |
| CNVTDMS_EC_GRDEL | Contains list of sel. groups,which need not be shown to user |
| GUPDLAYOUT | List of Table Layouts that Need to Be Updated |
| BBPD_TREX_INDEX | BBP TREX Indexes: Assign Business Object -> TREX Indexes |
| STRX_LPIXS | Assignment of Physical Indexes to Logical Indexes |
| CRMC_FS_NEEDCA_T | AO FS : Need Category Descriptions |
| CRMC_FS_NEEDTY_T | AO FS : Need Type Descriptions |
| CRMC_FS_NEED_CAT | AO FS : Maintain Need Categories |
| CRMC_FS_NEED_TYP | AO FS : Maintain Need Types |
| DDSHENTITY | Table of data elements which need the value table help |
| J_3RFOKOFREG | OKOF codes for assets wich need the state registration |
| T5M9D | PBS wage types that need activating. |
| CNV_20100_T004 | CNV backup copy for T004 (list of charts of accounts) |
| OCMHOMO_ARCH | Backup Table of Homogeneity List in Case of Archiving |
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