This view provides the end user a way to access the ReconfigTableStatsTbl. Users with the appropriate privileges can SELECT or DELETE from the base table using the view. User DBC must grant only SELECT or DELETE privileges to users.
A table stored in persistent storage in the Block File System (which is accessible only on the primary cluster) can use any table-level attributes. A table stored in the Object File System (which can be accessed from the primary cluster or the compute cluster) does not follow the same conventions as a table stored on the Block File System. Object File System tables have default settings for the following attributes, which you cannot change:
- BLOCKCOMPRESSION
- CHECKSUM
- DATABLOCKSIZE
- FREESPACE
- MERGEBLOCKRATIO
The NO FALLBACK attribute is ignored.
DBlockSize
The default value for DBlockSize is zero.
Possible Values for FallBackFlag
| Value | Description |
|---|---|
| Y | Fallback table (default) |
| N | Non-fallback table |
Possible Values for Phase
| Value | Description |
|---|---|
| R | Redistribution phase |
| D | Deletion/rebuild NUSI phase |
Possible Values for Status
| Value | Description |
|---|---|
| 0 | Not completed |
| 1 | Completed |
| 2 | Retry |