Symptom
Migration step fails with R3load IMPORT reporting an error with a table activity.
A1EEGEN 000 (IMP) Cannot delete on target database with native 'WHERE' condition
A1EEGEN 000X(IMP) Table name is 'TABNAME'
A1EEGEN 026 Exit code: "12"
A1 EGEN 005 /swrep/tmplog_<SID>/sapinst_instdir/NW750/DB6/COPY/SYSTEM/DISTRIBUTED/AS-ABAP/DB/R3load: END OF LOG: 20260729130913
The db2diag.log does not report the table name, however for the timestamp we see that a table was in a restricted state when Db2 attempted to access it.
2026-07-29-13.09.13.730971+120 I7083846E1018 LEVEL: Severe
PID : 000000 TID : 139677868746432 PROC : db2sysc 0
INSTANCE: db2xxx NODE : 000 DB : XXX
APPHDL : 0-0000
UOWID : 0 ACTID: 0
AUTHID : SAPXXX HOSTNAME: XXXXXXX
EDUID : 16201 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, catalog services, sqlrltt0, probe:10
MESSAGE : ZRC=0x8004002E=-2147221458=SQLD_ACCESSRESTRICTED
"ACCESS TABLE WHEN IN RESTRICTED STATE"
DIA8070C Attempt to access a table in a restricted state.
CALLED : <0>, <0>, <10>
RETCODE : ZRC=0x8004002E=-2147221458=SQLD_ACCESSRESTRICTED
"ACCESS TABLE WHEN IN RESTRICTED STATE"
DIA8070C Attempt to access a table in a restricted state.
DATA #1 : String, 11 bytes
file token
DATA #2 : unsigned integer, 2 bytes
XXX
DATA #3 : String, 7 bytes
ttoken
DATA #4 : unsigned integer, 2 bytes
XXX
Read more...
Environment
Db2 LUW IBM
Product
Keywords
DB2, DIA8070C, SQLD_ACCESSRESTRICTED, ZRC=0x8004002E, restricted state, check pending, load pending, reorg pending, SET INTEGRITY, LOAD QUERY, cannot delete, native WHERE condition, SAP, db2diag.log, ACCESS TABLE WHEN IN RESTRICTED STATE , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview