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
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
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
Might the version 2.4 Beta address this issue.
Would SQLPREPARE - SQLEXECUTE -
SQLDISPOSE deal with the memory issue.
Any help would be appreciated.