Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#2 Rexx/SQL Running out of memory in Win2K

open
Mark Hessling
None
5
2004-06-15
2002-07-23
Fred Schuff
No

I am running Rexx/SQL Ver 2.3 and Regina Rexx 2.2 on
a Windows 2000 Server to eccess a SqlServer 2000
Database using the W32-ODBC interface.

The ODBC drivers are ver: 2000.80.380.0 (SQL Server
2000).

The programs seem to be running fine except that they
get to a point where the DOS window terminates. I
started tracking free-memory and there is an excessive
use of memory - 130 MB to process about 2000
database requests. The input data is a total of 3MB for
20,000 records. The database requests are mainly
INSERT of relatively short rows (average 250
characters). The number of records processed before
the failure is very consistent -- about 2100.

The program logic cill INSERT from 1 to 300 rows and
then do the Commit.

We changed the code from SQLCOMMAND
(s1,"commit") to SQLCOMMIT(s1). No change.

We added a SQLDISPOSE() statement but that did no
good. I think the SQLDISPOSE goes with
SQLPREPARE, anyway.

We tried to DROP the Rexx variables (filled by the SQL
statement) after the SQL statements. No Change.

Do you have any idea why we are sucking up so much
memory.

Might the version 2.4 Beta address this issue.

Would SQLPREPARE - SQLEXECUTE -
SQLDISPOSE deal with the memory issue.

Any help would be appreciated.

Discussion

  • Mark Hessling
    Mark Hessling
    2004-06-15

    • assigned_to: nobody --> rexx