Accessing iSeries files from within an Oracle application: "We recently had an in-house contractor accessing iSeries files from within an Oracle application. One or two record requests took 10-15 seconds; a 50-record request took 10-15 minutes.
His code showed that he was requesting the records via primary key. But a trace at the iSeries level (actually, just using OpsNav to show current SQL) showed that not all the WHERE clause entries were being passed to the iSeries optimizer and he was doing full table scans.
Eventually, we narrowed it down to the fact that he had defined a work variable used in the WHERE clause as VAR CHAR, a common practice in Oracle. Once that was changed to plain CHAR, the individual requests were processed in less than a second; the request for 50 records was returned in less than two seconds. "
Monday, January 24, 2005
Subscribe to:
Post Comments (Atom)
Popular Posts
- as400 Iseries Tips
- What is QZHQSSRV job?
- Creating an as400 Query
- Using QCLRDTAQ to clear data queues in CL and RPG
- Contact Us
- Recover or reset QSECOFR passwords
- AS400 Job Scheduler
- Daniel Dan Carter Beard's Outdoor Handy Book or American Boy's Book of Sport - October 15, 1896
- Hiding Email Addresses on Your Web Page - MC Press Online
- iReport - OpenSource Java Reporting Tool
No comments:
Post a Comment