Symptom
System copy fails with SQL2038N error during ABAP import phase using CLI LOAD for BLU tables.
sapinst_dev.log
A2 ETSK 000 Starting import for object "/BIC/B0000118000" of type "table" #20221013164700
A1 EDMP 003 Export data is unsorted.
A1 EFLD 009 Using LOAD API for table /BIC/B0000118000
A1EEFLD 000 [IBM][CLI Driver][DB2/LINUXX8664] SQL2038N A database system error "0x850f000c" occurred during processing.
A1EEIMP 008 Task failed with error: (DBS) 'DBExeFastload' failed
db2diag.log
2022-10-13-16.44.07.587119+330 E546046E979 LEVEL: Error
PID : 50125 TID : 140650469123840 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-824 APPID: *LOCAL.db2abc.221013110633
UOWID : 9 ACTID: 1
AUTHID : SAPabc HOSTNAME: abcdefghi
EDUID : 294 EDUNAME: db2lmr 0
FUNCTION: DB2 UDB, database utilities, sqluCDECheckSafetyGap, probe:1725
DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
LOADID: 270.2022-10-13-16.36.31.487052.0 (10;6)
DATA #2 : String, 380 bytes
Writing to a LOAD temporary file failed due to insufficient file system space.
Path: /db2/abc/db2abc/NODE0000/SQL00001/load/DB20000A.PID/DB200006.OID
Required space: Load temporary file size (the minimum of load input file size and 128GB) plus a 1GB reservation for non-load use.
Please increase the file system above to accommodate the reserved space plus the load temporary file
2022-10-13-16.44.07.587452+330 E547026E537 LEVEL: Error
PID : 50125 TID : 140650469123840 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-824 APPID: *LOCAL.db2abc.221013110633
UOWID : 9 ACTID: 1
AUTHID : SAPabc HOSTNAME: abcdefghi
EDUID : 294 EDUNAME: db2lmr 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:769
MESSAGE : Media controller -- Error writing BLU staging file
2022-10-13-16.44.07.587626+330 E547564E551 LEVEL: Error
PID : 50125 TID : 140650469123840 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-824 APPID: *LOCAL.db2abc.221013110633
UOWID : 9 ACTID: 1
AUTHID : SAPabc HOSTNAME: abcdefghi
EDUID : 294 EDUNAME: db2lmr 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:769
MESSAGE : SQL2038N A database system error "" occurred during processing.
Read more...
Environment
- IBM Db2 for LUW 10.5 FP4 or higher
- SAP BW system with BLU enabled
Keywords
SQL2038N, "0x850f000c", LOAD temporary file, BLU staging file , KBA , BC-DB-DB6-INS , Installation SAP System , 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