ca.portal.admin

Re: [IDMSVENDOR-L] COMMIT question

Discussion created by ca.portal.admin on Mar 4, 2009
We have a batch program (CV mode) that repeatedly calls an SQL
procedure. = The SQL procedure does not do any IDMS I/O, but instead
calls an external w= eb service that updates a DB2 database on another
platform. The more updat= es it does, the more storage it uses. =20

I was wondering if a COMMIT would release some of the storage. But I am
co= nfused about the different types of COMMIT (regular, task, and SQL)
and whe= re to put it (called or calling program).

I guess my other option would be turn the storage limit off for this
progra= m, but I don't like to that. Turning limits off usually comes
back to bite= us later.

Outcomes