You could try enabling the database for autodefer, as:
Log on as database creator, then
:dbutil
enable databaserootfilenamefor for autodefer
exit
This will effectively detach the database from the transaction manager.
You will run the risk (a very small one, I would
think) of data base corruption in the event of a system failure.
You could mitigate the risk by ensuring you have
a good backup of this database prior to the
execution of this high transaction volume batch job.
To later reverse the transaction manager detachment if you wish, simply
:dbutil
disable databaserootfilename for autodefer
exit
At 07:21 PM 2007/01/20, Blanchard L. Carter wrote:
>Does anyone know of a way to allow large
>transactions on the MPE HP3000 system? I am
>getting an error message because the
>transactions I am trying to put to the Turbo
>Image database must exceed the 4MB limit of the
>transaction manager (XM article below).
>
>The article mentions using the
>DBXBegin/DBXEnd. I would appreciate any help from the HP experts out there.
>
>--------------------------------------------------------------------------------------
>(http://docs.hp.com/en/30216-90291/ch05s01.html)
>Large Transactions for IMAGE Users
>
>By B T Vikram Kumar, B S Jyoti, Shobha Pradeep
>Commercial Systems Division
>
>Background
>
>Of late many of the users of TurboIMAGE and
>IMAGE/SQL have the requirement of transaction
>sizes larger than is currently possible today (4
>MB). This is true, especially for users who run
>applications involving bulk puts/ deletes
>/updates. The situation becomes more difficult
>with the limitation of the size of the
>Transaction Manager (XM) userlog, if the
>transactions are on the same volume set. This
>integrated solution involving TurboIMAGE/iX, XM,
>IMAGE/SQL and ALLBASE/SQL addresses these
>problems. The following sections discuss these
>issues, and various options available to the
>users to overcome these issues, as a result of this solution.
>
>Current Limitations
>
>Version C.03.00 of TurboImage introduced the
>concept of dynamic transaction, meaning the
>application can rollback a transaction at
>runtime. Later when the Transaction Manager
>started handling the dynamic transactions, some
>customers used to see the stalled transaction
>message due to the limit on the size of the transaction.
>--------------------------------------------------------------------------------------
>-------------- Original message --------------
>From: [log in to unmask]
>
>Has anyone ever had this happen during a Cobol
>run on the HP3000 MPE system. I am not sure
>what this error pertains to. If anyone can help
>me I would greatly appreciate it. I am not sure
>if this is a I/O based error or a MPE O/S based
>error. It looks like a File system based error.
>
>At the time the program was doing a data load to
>the Turbo Image dataset in our database. Yet Suprtool reads the dataset fine/.
>
> :RUN BCHPROVX.emblc.AIHTEST
> BCHPROVS - Beechstreet Provider load program
> v 1.0
> Trans date: 20070119
> TIN is all zeroes or spaces, using SSN
>.
>.
>.
> **** STALLED TRANSACTION: EXCEEDED ACCUMULATED LOG DATA THRESHOLD
>Ð
> WARNING ** One or more entries on the error stack have been overwritten.
>Ð
> HPE Error Management message 205
>Ð
>ÐWARNING ** Message set 185, Error number 1030
>was not found in the system catalog.
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
>ÐSpecifying the LONG MAPPED OPTION (item# 21) for this file type is invalid.
> (FILE OPEN ERROR -299)
>Ð
> File System message 299
>Ð
>ÐSpecifying the LONG MAPPED OPTION (item# 21) for this file type is invalid.
> (FILE OPEN ERROR -299)
>Ð
> File System message 299
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
> Intrinsic layer; an access violation occurred.
>Ð
> File System message 3
>Ð
>ÐIntrinsic layer; the operation could not be completed because a nonexistent
> file was specified.
>Ð
> File System message 38
>Ð
> FLABELINFO intrinsic.
>Ð
> SUBSYS_INTRIN_ID message 25
> ABORT: BCHPROVX.EMBLC.AIHTEST
> NM SYS a.010 061ec dbg_abort_trace+$28
> NM USER 11e.00e9a378 PROC'EXIT000442+$78
> NM PROG 151.0002a084 bchprovs$001$+$4238
>
> Program terminated in an error state. (CIERR 976)
> REMAINDER OF JOB FLUSHED.
> CPU sec. = 2924. elapsed min. = 70. FRI, JAN 19, 2007, 4:02 PM.
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.432 / Virus Database: 268.17.1/640
>- Release Date: 2007/01/19 4:46 PM
-------------------------------------------------------------------------------------------------
Gilles Schipper
GSA Inc.
HP System Administration Specialists
300 John Street, Box 87651 Thornhill, ON Canada L3T 7R4
Voice: 905.889.3000 Fax: 905.889.3001
email: [log in to unmask] web: http://www.gsainc.com
-------------------------------------------------------------------------------------------------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|