Solution:
1. Check the SKIPPED table list
2. Run checktable on the tables listed in SKIPPED table
3. Release the pending job.
Fastload pending -- DROP TABLE
Multiload pending -- if it is work or temp table, DROP TABLE
If it data table then do "release mload ..."
Example:
In Backup Server:
1. Check the SKIPPED table list
# dsc list_job_history -name TestDBT
Data Stream Controller Command Line 16.20.00.03
Command parameters:
-name : TestDBT
Connected to DSC version 16.20.00.03
Listing job history...
There are "2" buckets. Use the bucket parameter to specify which bucket to display.
Current bucket displayed is "1".
Job history for "TestDBT"
JOB EXECUTION ID START END DURATION STATUS OBJECTS SOURCE TARGET
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
200661 06/12/19 04:36:43 AM 06/12/19 04:47:07 AM 00:10:24 COMPLETED_ERRORS 636 TestDB EBSTargetGroup
100333 05/17/19 04:28:41 AM 05/17/19 04:36:24 AM 00:07:43 COMPLETED_SUCCESSFULLY 615 TestDB EBSTargetGroup
……..
……..
……..
# dsc job_status_log -name TestDBT -I 200661 -E
Data Stream Controller Command Line 16.20.00.03
Command parameters:
-name : TestDBT
-job_execution_id : 200661
-full_export : true
Connected to DSC version 16.20.00.03
Getting Job Status Log...
Job Status log was exported in full to this path on the DSC Server: /var/opt/teradata/dsa/export/TestDBT_200661.csv
# cat /var/opt/teradata/dsa/export/TestDBT_200661.csv|grep SKIPPED
2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2,NO_PI_TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,
2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2_ET,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,
2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2_UV,NO_PI_TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,
2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd_UV,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,
2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd_ET,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,
In database server:
2. Run checktable on the tables listed in SKIPPED table
# cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
> start checktable
start checktable
Started 'checktable' in window 3
at Wed Jun 12 09:46:50 2019
Input Supervisor Command:
> ^C
# cnsterm 3
Attempting to connect to CNS...Completed.
Hello
========================================================================
End of session state report
Please enter a logical host id (? for help):
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|
Release 16.20.24.01 Version 16.20.24.01
CHECK TABLE Utility (April 08)
CHECKTABLE will run in Workload Def: WD-Default
Enter a command, "QUIT;", "HELP;" or F7 for interactive help:
> CHECK TestDBT AT LEVEL PENDINGOP;
CHECK TestDBT AT LEVEL PENDINGOP;
Checktable defaults to concurrent mode
on non-quiescent system with logons enabled.
Check beginning at 09:48:08 19/06/12.
CHECKTABLE will run from Host: 0 Session: 348,27351
>
"TESTDBT"."ASSOCIATE_LABOR_DETALS" was just processed. Processed 100 tables till now.
"TESTDBT"."COUPON_OFFER_DETAILS_B" was just processed. Processed 200 tables till now.
Table: "TESTDBT"."FINANCIAL_INFO_FROMPROD2" checking at 09:48:33 19/06/12.
Map No 1025, Table id 00FFH 3574H, Database id 0000H 0782H, Fallback.
Table check bypassed due to pending FastLoad.
Table Result: Skipped
Table: "TESTDBT"."FINANCIAL_INFO_FROMPROD2_ET" checking at 09:48:33 19/06/12.
Map No 1025, Table id 00FFH 35B7H, Database id 0000H 0782H, Fallback.
Table check bypassed due to pending FastLoad.
Table Result: Skipped
Table: "TESTDBT"."FINANCIAL_INFO_FROMPROD2_UV" checking at 09:48:33 19/06/12.
Map No 1025, Table id 00FFH 35B8H, Database id 0000H 0782H, Fallback.
Table check bypassed due to pending FastLoad.
Table Result: Skipped
Table: "TESTDBT"."FINANCIAL_INFO_FROMPROD_ET" checking at 09:48:33 19/06/12.
Map No 1025, Table id 00FEH E133H, Database id 0000H 0782H, Fallback.
Table check bypassed due to pending FastLoad.
Table Result: Skipped
Table: "TESTDBT"."FINANCIAL_INFO_FROMPROD_UV" checking at 09:48:33 19/06/12.
Map No 1025, Table id 00FEH E134H, Database id 0000H 0782H, Fallback.
Table check bypassed due to pending FastLoad.
Table Result: Skipped
"TESTDBT"."JOURNAL_ENTRY_LINE" was just processed. Processed 300 tables till now.
"TESTDBT"."MINUTE_OF_DAY" was just processed. Processed 400 tables till now.
"TESTDBT"."PROMOTION_OFFER_VENDOR_FUND" was just processed. Processed 500 tables till now.
"TESTDBT"."TENDER_TRANS_COUPON" was just processed. Processed 600 tables till now.
Summary:
633 table(s) checked.
633 fallback table(s) checked.
0 non-fallback table(s) checked.
2 no primary-index table(s) checked.
5 table(s) bypassed due to pending FastLoad.
0 table(s) failed the check.
Check completed at 09:49:04 19/06/12.
Error file is '/var/opt/teradata/tdtemp/CheckTableErrors20190612094808'.
Enter a command, "QUIT;", "HELP;" or F7 for interactive help:
3. Release the pending job.
Fastload pending -- DROP TABLE
Multiload pending -- if it is work or temp table, DROP TABLE
If it data table then do "release mload ..."
Please visit http://www.nazmulhuda.info/release-mload-in-teradata to check how to release multiload.