I have looked at this and approved it.  The question is mostly a jBASE 
issue and as such does belong here.

Rick

On Tuesday, September 4, 2012 9:13:28 AM UTC-4, vivek wrote:
>
> No T24 in this group please
>
> On Tuesday, 4 September 2012, DD wrote:
>
>> Dear all,
>>
>> We are migrating our application (T24) on jBASE from HP-UX to AIX. We are 
>> experiencing some strange behavior of SELECT (and COUNT) on large files 
>> (JPlus, >2GB). Apart from being slower on AIX (which may have to do with 
>> SAN), there is something else that I cannot explain.
>>
>> If I start the same COUNT from different ssh sessions, all finish at 
>> exactly the same time:
>>
>> jsh t24adm ~ -->date
>> Tue Aug 21 15:23:59 METDST 2012
>> jsh t24adm ~ -->COUNT FBNK.RE.CONSOL.SPEC.ENTRY
>>
>> 12482387 Records counted
>>
>> jsh t24adm ~ -->date
>> Tue Aug 21 *17:46:16* METDST 2012
>>
>> The above process took almost 2,5 hours. The below one I started much 
>> later on the same environment from another session, but they came back at 
>> the very same second:
>>
>> jsh t24adm ~ -->time COUNT FBNK.RE.CONSOL.SPEC.ENTRY
>>
>> 12482403 Records counted
>>
>> usr: 11.51   sys: 14.82   elapsed: 47m33.02s
>> jsh t24adm ~ -->date
>> Tue Aug 21 *17:46:16* METDST 2012
>>
>> This is not a coincidence, I saw it many times.
>> Any ideas?
>>
>>  -- 
>> -- 
>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>  
>> To post, send email to [email protected]
>> To unsubscribe, send email to [email protected]
>> For more options, visit this group at 
>> http://groups.google.com/group/jBASE?hl=en
>>  
>>  
>>  
>>
>
>
> -- 
> -- Vivek
>

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en



Reply via email to