×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

memory allocation error in informix 4gl program

memory allocation error in informix 4gl program

memory allocation error in informix 4gl program

(OP)
Database: Informix 11.50.FC3
Server: AIX 7.1 o/s with 64 GB of memory

We have an Informix 4GL program that runs in batch mode and creates an output file. The output file is an xml file. Recently, the program starting failing with the following error:

Program stopped at 'siebel_outleads_rev.4gl', line number 832.
SQL statement error number -406.
Memory allocation failed.
ERROR: siebel_outleads_rev.42r failed - aborting

Every time it gets this error, it fails on a different SQL statement where its building a cursor (DECLARE CURSOR) to fetch rows from the database with. This program has been running for several months and there have been no recent changes to it, so that’s why I'm confused as to why this is failing with this error all of a sudden.

The SQL error -406 refers to “memory not being available”.

Do we have to worry about allocating memory and freeing it when we open and close a cursor? I thought the database or operating system would handle that automatically. We open 12 cursors within this program.

RE: memory allocation error in informix 4gl program

(OP)
That's correct. The program hasn't changed in months, nor has the Informix version, nor has the database version changed. The only thing that i can see happening is that the program is now processing more data than it ever has before and the output files are larger.

We've even gone it and made sure to CLOSE and FREE cursors after using them...although the database does some of this automatically.

Any idea why we are getting this memory allocation error and how we can fix it in an Informix 4GL program?

RE: memory allocation error in informix 4gl program

(OP)
Does anyone know how i can check to see if this informix program has a memory leak?

SQL error -406 refers to "memory leak", but i'm not sure how i could tell.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close