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.