| SYS_ID |
Database system ID |
SDBA_DBSID |
|
CHAR |
|
8 |
0 |
|
| OPER_ID |
Unique operation ID |
SDBA_OP_ID |
|
CHAR |
|
14 |
0 |
|
| TASKNAME |
Task Name |
SDBA_TASK |
|
CHAR |
|
30 |
0 |
|
| JOB_NR |
Unique Job Number in a Task |
SDBA_JOB |
|
NUMC |
|
10 |
0 |
|
| TRIAL |
Unique ID Number of the Suboperation |
SDBA_TRIAL |
|
CHAR |
|
10 |
0 |
|
| UTIL_NR |
Utility number within job step |
SDBA_UTNR |
|
NUMC |
|
10 |
0 |
|
| FUNC_ID |
DBA Function ID |
SDBA_FID |
|
CHAR |
|
3 |
0 |
|
| REC_NR |
Unique record number for file |
SDBA_RECNR |
|
CHAR |
|
4 |
0 |
|
| UPD_OP |
Update Time Stamp |
SDBA_UPD |
|
CHAR |
|
14 |
0 |
|
| DBF_ID |
File ID (Oracle) |
SDBA_FI_ID |
|
CHAR |
|
4 |
0 |
|
| TSP_NAME |
Tablespace name |
SDBA_TSP |
|
CHAR |
|
30 |
0 |
|
| TSP_STATUS |
Tablespace status |
SDBA_TSSTA |
|
CHAR |
|
1 |
0 |
Possible values
| N |
ONLINE |
| F |
OFFLINE |
| I |
INVALID |
| R |
READ ONLY |
|
| DBF_STATUS |
Data file status |
SDBA_FISTA |
|
CHAR |
|
1 |
0 |
Possible values
| N |
ONLINE |
| F |
OFFLINE |
| I |
INVALID |
| S |
SYSTEM TSP ONLINE |
| O |
SYSTEM TSP OFFLINE |
| R |
RECOVERY STATUS |
|
| TIME_BEG |
Data file backup start time |
SDBA_BEGBU |
|
CHAR |
|
14 |
0 |
|
| TIME_END |
End of data file backup |
SDBA_ENDBU |
|
CHAR |
|
14 |
0 |
|
| REDO_BEG |
Redo log number at start of data file backup |
SDBA_RDBEG |
|
CHAR |
|
8 |
0 |
|
| REDO_END |
Redo log number at end of data file backup |
SDBA_RDEND |
|
CHAR |
|
8 |
0 |
|
| VOLUME |
Name of backup volume |
SDBA_VOL |
|
CHAR |
|
10 |
0 |
|
| FILE_POS |
Position of file on storage device |
SDBA_FPOS |
|
NUMC |
|
4 |
0 |
|
| COMP_RATE |
Compression rate |
SDBA_COMPR |
|
CHAR |
|
10 |
0 |
|
| UTIL_BID |
SID of a backup file (using external backup program) |
SDBA_BID |
|
CHAR |
|
16 |
0 |
|
| FILE_NAME |
Complete path including file name |
SDBA_PATH |
|
CHAR |
|
255 |
0 |
|
| FILE_SIZE |
File size |
SDBA_FI_SI |
|
CHAR |
|
12 |
0 |
|
| INTERNAL |
For internal purposes |
SDBA_INT |
|
CHAR |
|
255 |
0 |
|
