Thanks to all, An update: I seem to be able to reproduce the same effect on our current HP-UX system (I must admit, I have not tried before). Therefore, it is not an AIX-specific issue as stated in the subject, though still interesting.
We are on jBASE 5, files in-question are not (yet) distributed. No selection criteria was used, plain COUNT. Current system: System : HP-UX ######## B.11.23.U ia64 RELEASE Information : Major 09.0 , Minor 0.5 , Patch (Change 85861) New system: System : AIX ######## 1.6 000BE5EAD400 OS Release : 6.1.6.0 RELEASE Information : Major 09.0 , Minor 0.19 , Patch (Change 96166) Kind regards, Dmitry On Tuesday, September 4, 2012 10:57:53 AM UTC+2, 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
