bteq output taking lot of time

Database

bteq output taking lot of time

Hi,

In the following bteq command list, the query in the run file is executing in 17 seconds on bteq but then the output file is getting populated after 40 minutes. How come the output writing is taking so much time in bteq ? Is something wrong with the settings I am chosing

thanks

-Amit

.export data file = '/home/user/output.txt';

.set RECORDMODE OFF; 

.set width 65531;

.set titledashes off;

.set sidetitles OFF;

.set format off;

.SET RTITLE '';

.run file = '/home/user/input.txt'; 

.export reset

2 REPLIES
N/A

Re: bteq output taking lot of time

Hi Amit,

is this exported over a slow network?

Re: bteq output taking lot of time

Insert these commands ... it has worked perfectly for me. In my tests it has decreased more than 50% the export time.

 

.set session respbuflen max64
.set session tworespbufs on