Thanks for that, appreciate
Other startup parameters on the db are currently as below:
-Mn 15, -Mm 32600, -maxport 10,000 -n 75, -Mqb 15, -pinshm, -lruskips 100, -lru2skips 100, -bistall, -bithold 6144, -bibufs 50, -pica 8192
Linux OS has 4096 blocksize - db blocksize is 8192
AI is not enabled on this db.
64-bit Windows Server 2012R2, 8Gb RAM with 2 cores each 2.7 GHz
I haven't seen any srt files on the -T (progress11\temp folder or anywhere else)
OE Service Pack 11.7.4.0
Unfortunately all the processing is on the Windows box.
Client parameters: -inp 32000, -s 100, -rand 2, -Mm 32600 -D 300, -mmax 5500, -cpstream ISO8859-1, -T c:\progress11\temp, -noincwarn
The data from the data file is imported into temp-tables and gets filled into prodataset/ datasource - this part completes without issues, displaying the temp-table data for chosen columns in a browse.
Update of the Main-record with an Ex-lock and its subsidiary records in a transaction, from within a For-Each of ttMain-record Block where field Found=Yes on the ttMain record.
Next, Insert of those Main-records and their subsidiary-records from within a For-each ttMain-record, where field Found=No. These get a Batch record against them, so that the entire batch could be deleted, if not needed, via a separate Submission process.
Just attempted an import of 50,000 lines of data - it got stuck on Line 46454, while creating a new record - no errors, just not moving any forward from there- connection is still present.
Structure file (similar dos version) is as below, BI Files are located in a separate mount point
#
b c:\db\folder-name\bi\ldb_name.b1 f 2000000
b c:\db\folder-name\bi\ldb_name.b2
#
d "Schema Area":6,64;1 c:\db\folder-name\SchemaArea\ldb_name.d1 f 50048
d "Schema Area":6,64;1 c:\db\folder-name\SchemaArea\ldb_name.d2
#
d "S128-512C":7,128;512 c:\db\folder-name\S128-512C\ldb_name_7.d1 f 2097024
d "S128-512C":7,128;512 c:\db\folder-name\S128-512C\ldb_name_7.d2
#
d "S128-8N":8,128;8 c:\db\folder-name\S128-8N\ldb_name_8.d1 f 100096
d "S128-8N":8,128;8 c:\db\folder-name\S128-8N\ldb_name_8.d2 f 100096
d "S128-8N":8,128;8 c:\db\folder-name\S128-8N\ldb_name_8.d3 f 100096
d "S128-8N":8,128;8 c:\db\folder-name\S128-8N\ldb_name_8.d4
#
d "S16-512C":9,16;512 c:\db\folder-name\S16-512C\ldb_name_9.d1 f 2097024
d "S16-512C":9,16;512 c:\db\folder-name\S16-512C\ldb_name_9.d2
#
d "S16-8N":10,16;8 c:\db\folder-name\S16-8N\ldb_name_10.d1 f 50048
d "S16-8N":10,16;8 c:\db\folder-name\S16-8N\ldb_name_10.d2
#
d "S256-512C":11,256;512 c:\db\folder-name\S256-512C\ldb_name_11.d1 f 2097024
d "S256-512C":11,256;512 c:\db\folder-name\S256-512C\ldb_name_11.d2
#
d "S256-8N":12,256;8 c:\db\folder-name\S256-8N\ldb_name_12.d1 f 50048
d "S256-8N":12,256;8 c:\db\folder-name\S256-8N\ldb_name_12.d2
#
d "S32-512C":13,32;512 c:\db\folder-name\S32-512C\ldb_name_13.d1 f 2097024
d "S32-512C":13,32;512 c:\db\folder-name\S32-512C\ldb_name_13.d2
#
d "S32-8N":14,32;8 c:\db\folder-name\S32-8N\ldb_name_14.d1 f 50048
d "S32-8N":14,32;8 c:\db\folder-name\S32-8N\ldb_name_14.d2
#
d "S64-512C":15,64;512 c:\db\folder-name\S64-512C\ldb_name_15.d1 f 2097024
d "S64-512C":15,64;512 c:\db\folder-name\S64-512C\ldb_name_15.d2
#
d "S64-8N":16,64;8 c:\db\folder-name\S64-8N\ldb_name_16.d1 f 50048
d "S64-8N":16,64;8 c:\db\folder-name\S64-8N\ldb_name_16.d2 f 50048
d "S64-8N":16,64;8 c:\db\folder-name\S64-8N\ldb_name_16.d3
#
d "SmallIndexes":17,1;8 c:\db\folder-name\SmallIndexes\ldb_name_17.d1 f 50048
d "SmallIndexes":17,1;8 c:\db\folder-name\SmallIndexes\ldb_name_17.d2 f 50048
d "SmallIndexes":17,1;8 c:\db\folder-name\SmallIndexes\ldb_name_17.d3 f 50048
d "SmallIndexes":17,1;8 c:\db\folder-name\SmallIndexes\ldb_name_17.d4
#
d "LargeIndexes":18,1;64 c:\db\folder-name\LargeIndexes\ldb_name_18.d1 f 2097024
d "LargeIndexes":18,1;64 c:\db\folder-name\LargeIndexes\ldb_name_18.d2
Kind regards
Shail