2837 Table being Fast/Multi Loaded; no data dumped

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.