Level Pendingop Checks (Find Pending Mload or FastLoad) in Teradata

Level-pendingop checks table headers and displays a message if a table is in any of the following states:

•Pending FastLoad

•Pending Restore

•Pending Reconfig

•Pending Rebuild

•Pending Replicate copy

•Pending MultiLoad

•Number of primary index (PI) tables, if any, with and without column partitioning

•Number of usable primary AMP index (PA) tables, if any, with column partitioning.

•Number of unusable primary AMP index (PA) tables, if any, with column partitioning. These are tables that need to be altered to NoPI tables before they can be used because they were restored from archives to a differently-configured system.

•Number of NoPI tables, if any, with and without column partitioning.

 

Example 1:

SMP001-01:~ # cnsterm 6

Attempting to connect to CNS...Completed.

Hello

Input Supervisor Command:

> start checktable

start checktable

Started 'checktable' in window 1


SMP001-01:~ # cnsterm 1

>check all tables at level pendingop;

…..

…..

…..

Table:  "ST2AXCRMBI"."WT_W_LOY_TRANSACTION_ID_DS" checking at 16:52:34 17/11/27.

  Table id 0041H 73AAH, Database id 0000H 0652H, Fallback.

  Table check bypassed due to pending MultiLoad.

  Table Result:  Skipped

 

Table:  "ST2AXCRMBI"."WT_W_PARTY_PER_DS" checking at 16:52:34 17/11/27.

  Table id 0041H 737BH, Database id 0000H 0652H, Fallback.

  Table check bypassed due to pending MultiLoad.

  Table Result:  Skipped

 

"ST2AXCRMBI"."W_BNFT_PLAN_DS" was just processed. Processed 9000 tables till now.

 

"ST2AXCRMBI"."W_GEO_D" was just processed. Processed 9100 tables till now.

….

…..

…….

 

Table:  "SYSUDTLIB"."XMLUDT_CONSTRUCTORVARCHAR" checking at 16:56:49 17/11/27.

  Table id 0000H 082EH, Database id 0000H 03F0H

  Table is a fastpath UDM and will not be checked.

  Table Result:  Skipped

 

Table:  "SYSUDTLIB"."XSLTTRANSFORM" checking at 16:56:49 17/11/27.

  Table id 0000H 0835H, Database id 0000H 03F0H

  Table is a fastpath UDM and will not be checked.

  Table Result:  Skipped

 

"TDSTATS"."SELECTFROMOBJECTLIST" was just processed. Processed 12300 tables till now.

 

"TD_SYSFNLIB"."ARRAY_LE_2" was just processed. Processed 12400 tables till now.

 

…..

….

….

Summary:

 

         19,915 table(s) checked.

         19,915 fallback table(s) checked.

              0 non-fallback table(s) checked.

             33 no primary-index table(s) checked.

 

             24 table(s) bypassed due to pending MultiLoad.

             44 table(s) bypassed due to pending Restore.

 

              0 table(s) failed the check.

 

Check completed at 17:06:52 17/11/27.

Error file is '/var/opt/teradata/tdtemp/CheckTableErrors20171127164046'.

 

Enter a command, "QUIT;", "HELP;" or F7 for interactive help:

 

In the following file we can check if the table is any pending states

 

SMP001-01:~ # less /var/opt/teradata/tdtemp/CheckTableErrors20171127164046

Table:  "ITAXCRMBI"."WT_WC_CAMP_HIST_FS" checking at 16:43:36 17/11/27.

  Table id 0074H C816H, Database id 0000H 0733H, Fallback.

  Table check bypassed due to pending MultiLoad.

  Table Result:  Skipped

 

Table:  "ITAXCRMBI"."WT_W_CAMP_HIST_FS" checking at 16:43:36 17/11/27.

  Table id 0074H C82BH, Database id 0000H 0733H, Fallback.

  Table check bypassed due to pending MultiLoad.

  Table Result:  Skipped

….

To recheck again the failed table:

> CHECK AGAIN /var/opt/teradata/tdtemp/CheckTableErrors20171127164046 AT LEVEL PENDINGOP;

 

Example 2:

SMP001-01:~ # cnsterm 6

Attempting to connect to CNS...Completed.

Hello

 at Fri May 25 10:04:36 2018

 

Input Supervisor Command:

> start checktable

start checktable

 

Started 'checktable' in window 1

 at Mon Jul  2 11:15:58 2018

 

SMP001-01:~ # cnsterm 1

Attempting to connect to CNS...Completed.

Hello

 _______

    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

 

    Release 15.10.07.11 Version 15.10.07.11

    CHECK TABLE Utility (April 08)

 

CHECKTABLE will run in Workload Def: WD-Default

 

Enter a command, "QUIT;", "HELP;" or F7 for interactive help:

> CHECK ITStgACNT AT LEVEL PENDINGOP;

CHECK ITStgACNT AT LEVEL PENDINGOP;

 

Checktable defaults to concurrent mode

  on non-quiescent system with logons enabled.

 

Check beginning at 11:18:22 18/07/02.

CHECKTABLE will run from Host: 0  Session: 40,27295

 

Table:  "ITSTGACNT"."INFA_ET1_66946152202322" checking at 11:18:22 18/07/02.

  Table id 00B0H 6920H, Database id 0000H 074EH, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

Table:  "ITSTGACNT"."INFA_ET2_66946152202322" checking at 11:18:22 18/07/02.

  Table id 00B0H 6921H, Database id 0000H 074EH, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

Table:  "ITSTGACNT"."S2_ACN_SESFF_PROD" checking at 11:18:24 18/07/02.

  Table id 009EH D976H, Database id 0000H 074EH, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

 

Summary:

 

             26 table(s) checked.

             26 fallback table(s) checked.

              0 non-fallback table(s) checked.

 

              3 table(s) bypassed due to pending FastLoad.

 

              0 table(s) failed the check.

 

Check completed at 11:18:24 18/07/02.

Error file is '/var/opt/teradata/tdtemp/CheckTableErrors20180702111822'.

 

Enter a command, "QUIT;", "HELP;" or F7 for interactive help:

 

> QUIT;

QUIT;

 

CheckTable terminated.

> ^C

 

Other Options Example:

Check <database> AT LEVEL PENDINGOP;

Example:

> CHECK  ITAXCRMBI AT LEVEL PENDINGOP;

> CHECK  ITAXCRMBI EXCLUDE WC% AT LEVEL PENDINGOP;

> CHECK ST2Cntl,ITAchv,UV1Achv AT LEVEL PENDINGOP;

> CHECK ALL TABLES EXCLUDE UV% AT LEVEL PENDINGOP;

> check all tables at level pendingop in parallel tables=3;

TABLES=n clause option to specify the number of tables to check simultaneously in parallel mode. 

Comments