15.00 - STATUS - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

STATUS

Purpose  

The STATUS command allows you to determine the status of Reconfiguration at any time during the process.

Syntax  

Usage Notes  

STATUS is available at any time during Reconfiguration and includes the status of the following:

  • Total number of tables processed for the redistribution, deletion, and NUSI phases
  • Total number of tables remaining to be processed for the redistribution, deletion, and NUSI phases
  • Completion percentage according to the total number of bytes processed
  • Status of each non-idle, parallel reconfiguration control task
  • Completion percentage and name of table being processed for each non-idle, parallel reconfiguration control task
  • Example  

    The following is an example of STATUS output during hash map calculation.

    Current reconfig phase: Hash Map Calculation

    Example  

    The following is an example of STATUS output during redistribution.

    Current reconfig phase: 
    Redistribution 
     Estimated time remaining: 00:19:21 
     Redistribution status - tables processed:             152
                             tables remaining:              26
                              70% of total bytes processed
      Deletion/NUSI status - tables processed:               0
                             tables remaining:             178
                               0% of total bytes processed
     
     Reconfig task  0 Processed  69% of RKPMED.SIW_XXXX_FB_12 (0000H 04C4H)
     Reconfig task  1 Processed  69% of RKPMED.SIW_XXXX_FB_7 (0000H 04BFH)
     Reconfig task  2 Processed  69% of RKPMED.SIW_XXXX_FB_11 (0000H 04C3H)
     Reconfig task  3 Processed  68% of RKPMED.SIW_XXXX_FB_15 (0000H 04C7H)
     Reconfig task  4 Processed  69% of RKPMED.SIW_XXXX_FB_8 (0000H 04C0H)
     Reconfig task  5 Processed  68% of RKPMED.SIW_XXXX_FB_13 (0000H 04C5H)
     Reconfig task  6 Processed  64% of RKPMED.SIW_XXXX_FB_14 (0000H 04C6H)
     Reconfig task  7 Processed  69% of RKPMED.SIW_XXXX_FB_9 (0000H 04C1H)
     Reconfig task  8 Processed  69% of RKPMED.SIW_XXXX_FB_6 (0000H 04BEH)
     Reconfig task  9 Processed  69% of RKPMED.SIW_XXXX_FB_10 (0000H 04C2H)

    Example  

    The following is an example of STATUS output during Deletion/NUSI rebuilding.

     
    Current reconfig phase: Deletion/NUSI Rebuild 
     
     Current estimates are based upon current number of tasks.
     
     Estimated redistribution time remaining: 0.00 hours.
     Estimated deletion time remaining: 0.42 hours.
     Redistribution status - tables processed:           1,427
                             tables remaining:               0
                             100% of total bytes processed
      Deletion/NUSI status - tables processed:           1,217
                             tables remaining:             210
                              27% of total bytes processed
     
    Reconfig task 0 Processed 48% of RP_31864.tbl_col20_1_src (0000H 0BFAH)
    Reconfig task 1 Processed 43% of RP_31864.tbl_col20_74_src (0000H 0BFBH)
    Reconfig task 2 Processed 28% of RP_31864.tbl_col20_7 (0000H 0BFEH)
    Reconfig task 3 Processed  7% of RP_31864.tbl_col20_69_src (0000H 0C01H)
    Reconfig task 4 Processed  9% of RP_31864.tbl_col20_51_src (0000H 0C00H)
    Reconfig task 5 Processed 52% of RP_31864.tbl_col20_82_src (0000H 0BF9H)
    Reconfig task 6 Processed  2% of RP_31864.tbl_col20_86_src (0000H 0C02H)
    Reconfig task 7 Processed 26% of RP_31864.tbl_col20_61_src (0000H 0BFFH)
    Reconfig task 8 Processed  0% of RP_31864.tbl_col20_66_src (0000H 0C03H)
    Reconfig task 9 Processed 42% of RP_31864.tbl_col20_71_src (0000H 0BFCH)