Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Mass load utility 'db2' returned fatal response code 8" while rebuilding indexes in IIR
Problem Description
In Identity Resolution (IIR), the following error occurs while running LoadIDT:

loadit> ErrorLog: [420130240 4] Mass load utility 'db2' returned fatal response code 8
Cause
The issue is caused when the db2 environment variable is not initialized correctly.
Solution
To resolve this issue, set the environment variable using the following command:

db2cmd -i -w db2clpsetcp
idsup
More Information
​Stack trace:

3:0379 MG4193 060000 20200420130240
loadit> Error: Load IDT 'SampleIDT' failed
loadit> ErrorLog: [420130240 4] loadit > It is now 20200420130240
loadit> ErrorLog: [420130240 4] loadit.c 5256 rc 3 905140314*100
loadit> ErrorLog: [420130240 4] error in writer_thread
loadit> ErrorLog: [420130240 4] loadit.c 3967 rc 14 9051403*100
loadit> ErrorLog: [420130240 4] loadit.c 4609 rc 3 60090514*100
loadit> ErrorLog: [420130240 4] loader_thread: process_loader_queue failed
loadit> ErrorLog: [420130240 4] loadit.c 4297 rc 14 90600905*100
loadit> ErrorLog: [420130240 4] loadit.c 4199 rc 5 20906009*100
loadit> ErrorLog: [420130240 4] Load IDT 'SampleIDT' failed
loadit> ErrorLog: [420130240 4] Load IDT 'SampleIDT' failed
loadit> ErrorLog: [420130240 4] dbldr.c 5362 rc 9 208020906*1000
loadit> ErrorLog: [420130240 4] dbops.c 5479 rc 6 2080209*100
loadit> ErrorLog: [420130240 4] ssaodbc.c 28000 rc 9 20802*100
loadit> ErrorLog: [420130240 4] ssadb8_ssaxld_record: Running DBMS loader failed -20802
loadit> ErrorLog: [420130240 4] ssaodbc.c 1666 rc 2 208*100
loadit> ErrorLog: [420130240 4] udb.c 3411 rc 8 2*100
loadit> ErrorLog: [420130240 4] udb.c 1739 rc 2
loadit> ErrorLog: [420130240 4] Mass load utility 'db2' returned fatal response code 8
3:0156 MU2867 060000 20200420130240
loadit> Error:..................................exit code -403021124
3:0157 MU2439 060000 20200420130240
loadit> ErrorLog: [420130240 2] loadit > It is now 20200420130240
3:0158 MU2439 060000 20200420130240
loadit> ErrorLog: [420130240 2] exit code -403021124
3:0159 MU2439 060000 20200420130240
loadit> ErrorLog: [420130240 2] loadit.c 5887 rc 24 314030211*100
0:0035 MU2867 060000 20200420130241
init> Error: exit code -232
0:0036 MU2439 060000 20200420130241
init> ErrorLog:...............................[420130241 1] init > It is now 20200420130241
0:0037 MU2439 060000 20200420130241
init> ErrorLog: [420130241 1] exit code -232
0:0038 MU2439 060000 20200420130241
init> ErrorLog: [420130241 1] init.c 1565 rc 32 2*100
0:0039 MU2439 060000 20200420130241
init> ErrorLog: [420130241 1] Spawned task #3 failed with error -2. Check the task's messages​
Applies To
Product: Identity Resolution
Problem Type: Configuration
User Type: Data Steward; Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/1/2020 10:05 PMID:621807
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)