Conference orarep::nomahs::dbintegrator_public_public

1107.0. "STRANSNAL problem DBI/RDB access for RMS" by ORAREP::ELIS::BAKKER () Thu Dec 05 1996 06:00

SQL> ATTACH 'FILENAME /TYPE=NSDS/PATHNAME=EDCMIINC$$C_PATH.TCMS'

SQL> SHOW TABLE
User tables in database with filename /TYPE=NSDS/PATHNAME=EDCMIINC$$C_PATH.TCMS
     TCMS$DB 
     TCMS$DETAIL 
     TCMS$INVCE 
SQL> SELECT * FROM TCMS$DB LIMIT TO 1 ROWS;
 TCMS_TRNSPRT_DSTNTN   TCMS_TRNSPRT_IFRWRDR   TCMS_TRNSPRT_NFRWRDR   
   TCMS_TRNSPRT_AWB   TCMS_TRNSPRT_CMR   TCMS_TRNSPRT_DDT   TCMS_TRNSPRT_ADT   
      TCMS_TRNSPRT_INIT_COST   TCMS_TRNSPRT_NAT_COST   TCMS_TRNSPRT_HANDL_COST  
         TCMS_TRNSPRT_RTICS_COST   TCMS_TRNSPRT_RTNCS_COST   TCMS_TRNSPRT_LMTR  
            TCMS_TRNSPRT_INT_ACCNT_NO   TCMS_TRNSPRT_NAT_ACCNT_NO   
               TCMS_TRNSPRT_SVC   TCMS_AIRWY_BILL_TYPE   TCMS_I_FRWRDR_CD   
                  TCMS_N_FRWRDR_CD   TCMS_FRWRDR_DOCMT_TYPE_ID   
                     TCMS_MODIFIED_DATE   
 HL                    PRIVE                  PRIVE                  
   77731406                              950502             950502             
          0.00                     0.00                    0.00                 
         0.00                      0.00                                         
            .                                                       
               NLBAU              H                      CHA                
                  CHA                TC                          
                     950523               
 
SQL> ROLLB;
SQL> ATTACH 'FILENAME EDCMIINC$$F_DBI_DWH_DB';
SQL> SHO LINK TCMSLINK
Information for link TCMSLINK
     Connection information: /type=nsds/path=edcmiinc$$c_path.tcms
     To database type: DB Access for RMS (NSDS)       
     State: Inactive
No proxies found

SQL> SHOW TABLE (LINK) TCMS_HEADER
Information for table TCMS_HEADER
 
 
Link TCMSLINK
   Link table: TCMS$DB
 
SQL> SELECT * FROM TCMS_HEADER LIMIT TO 
cont>  1 ROW;
%RDB-F-SYS_REQUEST, error from system services request
-DBI-E-UDBTXN_START, Error starting transaction in an underlying database
-DBI-I-LINK_INFO, Link name is 'TCMSLINK'
-RDB-E-STRANSNAL, distributed START TRANSACTION not allowed - some databases are
 not able to participate

Could somebody please help me. It always worked and now suddenly it stopped 
working.

I have the logical "SQL$DISABLE_CONTEXT" = "TRUE".

Regards,

Rob Bakker

    have you checked to see if DDTM is working on that node?
    
    
    has this owrked before or is it the first time?
    
    
    
    thanks
    
    steve