[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbstars

Title:DBSTARS Conference
Moderator:BROKE::BASTINE
Created:Wed Feb 02 1994
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:791
Total number of notes:1521

787.0. "Final - sent to Mem 5/20/97" by BROKE::BITHER () Tue May 20 1997 15:56

From:	BROKE::BITHER       "Please reply to [email protected]" 20-MAY-1997 14:54:50.78
To:	MEMORMAN
CC:	BITHER
Subj:	New Stars Article

TITLE:      -RMS-E-DDTM_ERR Using Rdb Transparent Gateway to RMS

PRODUCT:    Rdb Transparent Gateway to RMS

OP/SYS:     OpenVMS VAX, OpenVMS AXP

SOURCE:     Oracle Worldwide Customer Support


PROBLEM:

The following error stack can be generated by executing a query in a 
read/write transaction when Run Unit Journaling is enabled and either the
logical SQL$DISABLE_CONTEXT or NSDS$DISABLE_CONTEXT is defined.

SQL> select * from foo ;
%RDB-F-SYS_REQUEST, error from system services request
-NSDS-E-REWINDFAIL, Could not rewind data relation
-RMS-E-DDTM_ERR, error returned by Digital Distributed Transaction Manager
-NONAME-W-NOMSG, Message number 00000000


SOLUTION:

To prevent this remove one of the following conditions:

  o Make the transaction READ ONLY.

    OR

  o Deassign SQL$DISABLE_CONTEXT and NSDS$DISABLE_CONTEXT.

    OR

  o Disable Run Unit Journaling.


\
\ CONTRIBUTORS:
\
\       Technical: Diane Bither
T.RTitleUserPersonal
Name
DateLines
787.1pls revokeBROKE::BITHERWed May 21 1997 10:501
Asked Mary to revoke. (5/21/97)