Question

Failing to run ingest utility. db2diag.log shows the following entry: 2017-08-17-11.37.33.382189-240 E5184731A1393 LEVEL: Error (OS) PID : 17956880 TID : 772 PROC : db2bp INSTANCE: XXXXXXXX NODE : 000 HOSTNAME: XXXXXX EDUID : 772 FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100 CALLED : OS, -, malloc OSERR : ENOMEM (12) "There is not enough memory available now." MESSAGE : Private memory and/or virtual address space exhausted, or data ulimit exceeded DATA #1 : Soft data resource limit, PD_TYPE_RLIM_DATA_CUR, 8 bytes 134217728 DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 266240 DATA #3 : Current set size, PD_TYPE_SET_SIZE, 8 bytes 130613248 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x09000000172D2DA8 pdLogSysRC + 0x140 [1] 0x0900000016E14740 sqloLogMemoryCondition + 0x1B0 [2] 0x09000000173543F8 sqlogmblkEx + 0x132C [3] 0x090000001760B7D8 sqludiGetFieldSetBufFromFreeQ__FRC18SqludiThreadParamsP24SqludiQueueElementHandle + 0x414 [4] 0x090000001760CC54 sqludiGetFieldSetBufFromFreeQ__FRC18SqludiThreadParamsP24SqludiQueueElementHandle + 0x1890 [5] 0x090000001760E69C sqludiBroadcastEOB__FRC18SqludiThreadParamsb + 0x830 [6] 0x0900000016954A80 sqludiFormatterEntry + 0x15E0 [7] 0x090000000054DE10 _pthread_body + 0xF0 [8] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 2017-08-17-11.37.33.383002-240 E5186125A594 LEVEL: Warning PID : 17956880 TID : 772 PROC : db2bp INSTANCE: XXXXXXXX NODE : 000 HOSTNAME: XXXXXX EDUID : 772 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30 DATA #1 : Out of memory failure for Persistent Private Heap. Requested block size : 1187 bytes. Physical heap size : 120324096 bytes. Configured heap size : 1099511627776 bytes. Unreserved memory used by heap : 0 bytes. Unreserved memory left in set : 0 bytes. 2017-08-17-11.37.33.383251-240 I5186720A1286 LEVEL: Error PID : 17956880 TID : 772 PROC : db2bp INSTANCE: XXXXXXXX NODE : 000 HOSTNAME: XXXXXX EDUID : 772 FUNCTION: DB2 UDB, Ingest utility, SqludiErrorInfo::sqludiLogNonCliError, probe:20 DATA #1 : String, 161 bytes Ingest utility error information: (2) Error handling message (3) Source file name (4) Line number (5) SQLCA (6) DB2 ZRC error code (7) OSS (ECF) error code name DATA #2 : String, 116 bytes The utility did not report the following error to the user because the utility already reported a terminating error. DATA #3 : File name, 89 bytes /view/db2_v105fp8_aix64_s160901/vbs/engn/squdi/./utilities/SqludiFieldSetOverflowMemory.C DATA #4 : Source file line number, 8 bytes 148 DATA #5 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -10003 sqlerrml: 0 sqlerrmc: sqlerrp : SQL10058 sqlerrd : (1) 0x8B0F0000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 57011 DATA #6 : ZRC, PD_TYPE_ZRC, 4 bytes 0x8B0F0000 DATA #7 : String, 2 bytes OK