HPL脚本:
onpladm create object -F aaa.ini
onpladm create job aaa_load_job -d aaa_load -D $DATABASENAME -t bbb -flaN -n
onpladm run job aaa_load_job -fl
aaa.ini文件:
BEGIN OBJECT DEVICEARRAY aaa_load
BEGIN SEQUENCE
TYPE FILE
FILE "/apphome2/data/ajdk/aaa_1.unl"
TAPEBLOCKSIZE 0
TAPEDEVICESIZE 0
PIPECOMMAND
END SEQUENCE
...(一共16个数据文件)
执行时报错:
SHMBASE 0x0700000010000000
CLIENTNUM 0x0000000049010000
Session ID 1
Load Database -> easydb20
Load Table -> bbb
Device Array -> aaa_load
Record Mapping -> AUTO.1
Convert Reject -> /tmp/aaa_load_job.rej
Filter Reject -> /tmp/aaa_load_job.flt
Error occured at HPL failpoint: 12602
Cannot allocate shared memory
Error occured at HPL failpoint: 10828
Error occured at HPL failpoint: 19121
Onpload Job has aborted
Database Load Completed -- Processed 0 Records
Records Inserted-> 0
Detected Errors--> 0
Engine Rejected--> 0
Thu Feb 23 09:51:48 2017
Job Completed Unsuccessfully ... connection closed
onstat -g ses输出
Segment Summary:
id key addr size ovhd class blkused blkfree
17825805 52564801 700000010000000 26448576512 310377856 R 6457167 5
23068676 52564802 700000640000000 8388608000 98305888 V 61605 1986395
Total: - - 34837184512 - - 6518772 1986400
(* segment locked in memory)
服务器的内存是足够的,将aaa.ini里数据文件减到4个执行不报错。就是不能一次性执行成功。这是什么原因呢