Hi ALL,

I have 40000 records to load from a file. I have around 200 columns.
Of which atleast 20 columns have DATE conversion logic on them.

At present this job takes 3 minutes if I dont give this parameter ROWS=10000 BINDSIZE=20000000 READSIZE=20000000.

Now it take 52 seconds

I am just pasting a part of the log file.

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 10000 rows, maximum of 20000000 bytes
Continuation: none specified
Path used: Conventional

Table IPDR_3G_REL2_TMP, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect


Table IPDR_3G_REL2_TMP:
39962 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 19973898 bytes(742 rows)
Read buffer bytes:20000000

Total logical records skipped: 0
Total logical records read: 39962
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Mon Nov 07 11:57:33 2005
Run ended on Mon Nov 07 11:58:25 2005

Elapsed time was: 00:00:51.90
CPU time was: 00:00:23.32

Thanks in advance.

Cheers