RE: [sqr-users] Illegal Instruction & Memory Fault (coredump)

[Christine Sessler <cms41@cornell.edu>]

Richard -

Here's the info from my DBAs:

OS: AIX
Version: 4.3.3
Database Version: 8.1.7.4
SQR Version:  SQR for PeopleSoft/8.18/IBM RS6000/AIX 4.3.3/Oracle 8.0.6/Jun 
05 2002

We ran into similar problems running the CR Conversion SQRs.  Those were 
reading in huge flat files.  Breaking the files up into chunks 
helped.  Seeing as this one doesn't read a flat file, I'm open to trying 
anything else.

Chris

At 10:48 AM 7/18/2003 -0500, you wrote:

>What's the OS and version.  Is this a memory leak?  Ask your DBA/sysadmin.
>
>Richard Knapp
>Database Programmer/Analyst
>Institutional Research and Planning
>University of Missouri System
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From: Christine Sessler [mailto:cms41@cornell.edu]
>Sent: Friday, July 18, 2003 9:59 AM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Illegal Instruction & Memory Fault (coredump)
>
>
>Folks -
>
>I'm looking for some help on resolving the coredump problem that I'm having
>with an SQR.
>
>The SQR is pretty basic with no complicated JOINS.  It selects about
>300,000+ Emplids and then goes through a series of selects to get Bio/Demo
>and Degree data for each person selected.  Ultimately, two output files
>will be created - one for Bio/Demo and one for Degree data - and these will
>be sent to a vendor.  It also inserts each row processed into a custom SQL
>table.  I'm committing after every 15K Emplids processed.
>
>I've commented out the WRITEs to the file and I'm still encountering the
>following coredump errors.  I've tried chunking the main SQL in batches of
>100,000 Emplids but that's when I got the "illegal instruction" error after
>it processed 124K Emplids.
>
>[...snip...]SQR_AVP601CU_115467/prcs_sqr[96]: 54986 Memory fault(coredump)
>[...snip...]SQR_AVP601CU_115478/prcs_sqr[96]: 75854 Illegal
>instruction(coredump)
>
>I'd really rather not have the operator have to run this job numerous
>times, running in batches of 100K Emplids from outside of the program but
>that's what I'm considering now.
>
>I expect that as we bring Contributor Relations into Production (scheduled
>for 7/28) and this interface is run in Production, that the number of
>EmplIds processed is going to continue to grow.
>
>Does anyone have any thoughts on how else to handle this situation?
>
>Thanks,
>Chris
>
>
>
>************************************************************
>Christine Sessler
>Cornell University
>CIT/Business Information Systems
>120 Maple Avenue
>Ithaca, NY  14850
>
>607.255.2816 - MARS Project
>607.255.8149  - Maple Ave
>607.255.6982  - Fax
>cms41@cornell.edu
>************************************************************
>"Live in such a way that you would not be ashamed to sell your parrot to
>the town gossip." - Will Rogers
>"If a dog jumps in your lap, it is because he is fond of you;
>but if a cat does the same thing, it is because your lap is warmer." -
>Alfred North Whitehead
>"When the eagles are silent, the parrots begin to jabber." - Sir Winston
>Churchill
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

************************************************************
Christine Sessler
Cornell University
CIT/Business Information Systems
120 Maple Avenue
Ithaca, NY  14850

607.255.2816 - MARS Project
607.255.8149  - Maple Ave
607.255.6982  - Fax
cms41@cornell.edu
************************************************************
"Live in such a way that you would not be ashamed to sell your parrot to 
the town gossip." - Will Rogers
"If a dog jumps in your lap, it is because he is fond of you;
but if a cat does the same thing, it is because your lap is warmer." - 
Alfred North Whitehead
"When the eagles are silent, the parrots begin to jabber." - Sir Winston 
Churchill  

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users