SAP Knowledge Base Article - Preview

3261472 - DB6: SQL2038N system error "0x850f000c" during BLU table import using CLI LOAD

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.