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
