[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | The Replication Option for Rdb |
| Notice: | Product renamed to Replication Option for Rdb |
| Moderator: | BROKE::PROTEAU |
|
| Created: | Wed Mar 02 1994 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 287 |
| Total number of notes: | 1231 |
281.0. "%DDAL-E-BADDBINFO in extraction from "trans gateway to PC DATA"" by rdb4me.au.oracle.com::DLAWLER (Press any key to continue or any other key to quit...) Wed Apr 23 1997 04:40
Hi,
I've cross posted this in Rdb, Data Distributor and DBI conferences.
A high profile customer is currently evaluating the Rdb Transparent Gateway
for PCData and is attempting a Data Distributor extraction from a MS SQLServer
database on an NT/intel box. The transfer is failing with %DDAL-E-BADDBINFO.
I've included the transfer log file for the failed extraction and another for
a successful extraction from an Rdb database on the same system.
Respective products and versions are:
NT/intel 3.51
MS SQLServer 6.5
VAX/Vms 6.1
Rdb 6.0-15
DDal 6.0-7
Rdb Transparent Gateway for PCDATA 7.0.
The customer is anxious about this as they intended to go live soon and this
could be a show stopper.
Any help will be appreciated.
Cheers,
Dennis.
HV3> TY GATE_EXTRACTION.LOG
%SYSTEM-W-NOTALLPRIV, not all requested privileges authorized
%SET-W-NOTSET, error modifying MBA6797:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%SET-W-NOTSET, error modifying MBA6797:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%DCL-I-DEFKEY, DEFAULT key PF4 has been defined
%DCL-I-DEFKEY, DEFAULT key F20 has been defined
$ SHOW = "SHOW"
$ RUN = "RUN"
$ LOGOUT = "LOGOUT"
$ SHOW PROCESS
22-APR-1997 14:07:57.33 User: DICKSONA Process ID:
2023025C
Node: HV3 Process name:
"DDAL_COPY_01 "
Terminal: MBA6797:
User Identifier: [DBA,DICKSONA]
Base priority: 4
Default file spec: DBA:[DICKSONA]
$ DEFINE DDAL$CP_CONTINUE "SUCCESS"
$ DEFINE/TRANS=TERMINAL DDAL$TRANSFER_NAME GATE_EXTRACTION
$ DDAL$CP_ACTION :== E
$ DDAL$CP_RETRY_ITERATION == 00
$ RUN DDAL$COPY_PROCESS
Product version: DEC Data Distributor V6.0-7
----- 22-APR-1997 14:07:57.79 ----- Process
-----------------------
--
Process name: DDAL_COPY_01 Priority: 4
Username: DICKSONA UIC: [DBA,DICKSONA]
Nodename: HV3 PID: 2023025C
Privileges currently enabled:
CMKRNL, SYSNAM, DETACH, PRMMBX, PSWAPM, ALTPRI, TMPMBX, WORLD,
OPER,
EXQUOTA, NETMBX, VOLPRO, SYSGBL, SYSPRV, BYPASS, SYSLCK, READALL
Image privileges:
SYSPRV, BYPASS, SYSLCK, SECURITY
Image name:
DSA0:[SYS0.SYSCOMMON.][SYSEXE]DDAL$COPY_PROCESS.EXE
Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name = GATE_EXTRACTION
Transfer option = E (Extraction transfer)
14:07:57 %DDAL-I-READTRDEF, reading the transfer definition from the
transfer database
14:08:00 %DDAL-I-ATTACHSDB, attaching to source database
/TYPE=ODBC/NODE=HCOHQ314.HQ.AUSTPOST.COM.AU/DATABASE=ALANSTESTGATE
----- 22-APR-1997 14:08:18.44 ----- Error
-----------------------
--
%DDAL-E-BADDBINFO, invalid information returned from
Rdb$DATABASE_INFO call
$ LOGOUT
DICKSONA job terminated at 22-APR-1997 14:08:19.33
Accounting information:
Buffered I/O count: 465 Peak working set size:
7259
Direct I/O count: 114 Peak page file size:
27793
- Page faults: 7487 Mounted volumes:
0
=========================================================================
SQL> $ty dba:[dicksona.gate]test_vmsddal.log;
%SYSTEM-W-NOTALLPRIV, not all requested privileges authorized
%SET-W-NOTSET, error modifying MBA4621:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%SET-W-NOTSET, error modifying MBA4621:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%DCL-I-DEFKEY, DEFAULT key PF4 has been defined
%DCL-I-DEFKEY, DEFAULT key F20 has been defined
$ SHOW = "SHOW"
$ RUN = "RUN"
$ LOGOUT = "LOGOUT"
$ SHOW PROCESS
22-APR-1997 16:53:35.43 User: DICKSONA Process ID:
2021C8E8
Node: HV3 Process name:
"DDAL_COPY_01 "
Terminal: MBA4621:
User Identifier: [DBA,DICKSONA]
Base priority: 4
Default file spec: DBA:[DICKSONA]
$ DEFINE DDAL$CP_CONTINUE "SUCCESS"
$ DEFINE/TRANS=TERMINAL DDAL$TRANSFER_NAME TEST_VMS_DDAL
$ DDAL$CP_ACTION :== E
$ DDAL$CP_RETRY_ITERATION == 00
$ RUN DDAL$COPY_PROCESS
Product version: DEC Data Distributor V6.0-7
----- 22-APR-1997 16:53:35.99 ----- Process
-----------------------
--
Process name: DDAL_COPY_01 Priority: 5
Username: DICKSONA UIC: [DBA,DICKSONA]
Nodename: HV3 PID: 2021C8E8
Privileges currently enabled:
CMKRNL, SYSNAM, DETACH, PRMMBX, PSWAPM, ALTPRI, TMPMBX, WORLD,
OPER,
EXQUOTA, NETMBX, VOLPRO, SYSGBL, SYSPRV, BYPASS, SYSLCK, READALL
Image privileges:
SYSPRV, BYPASS, SYSLCK, SECURITY
Image name:
DSA0:[SYS0.SYSCOMMON.][SYSEXE]DDAL$COPY_PROCESS.EXE
Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name = TEST_VMS_DDAL
Transfer option = E (Extraction transfer)
16:53:36 %DDAL-I-READTRDEF, reading the transfer definition from the
transfer d
atabase
16:53:38 %DDAL-I-ATTACHSDB, attaching to source database
DBA:[DICKSONA.GATE]TES
T_VMS_GATE.RDB
16:53:39 %DDAL-I-CRETARGDB, creating target database
DBA:[DICKSONA.GATE]TEST_DD
AL.RDB
16:53:58 %DDAL-I-ATTACHTDB, attaching to target database
DBA:[DICKSONA.GATE]TES
T_DDAL.RDB
- 16:53:58 %DDAL-I-STADATTRM, starting data transfer/modification
%DDAL-I-DEFGBLFLD, defining global field
RDB$VINTAGE_TIMESTAMP
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TSER
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_ADDR
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_NODE
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_BUSY
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_ID
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_NAME
16:53:59 %DDAL-I-DEFINEREL, defining relation RDB$VINTAGE
16:54:01 %DDAL-I-LOARELDAT, loading data for relation RDB$VINTAGE
%DDAL-I-DEFGBLFLD, defining global field POST_CODE
%DDAL-I-DEFGBLFLD, defining global field
POST_CODE_ALLOC_STATE_CODE
%DDAL-I-DEFGBLFLD, defining global field
NATIONAL_PRESORT_CODE
%DDAL-I-DEFGBLFLD, defining global field REGION_ORG_UNIT_ID
%DDAL-I-DEFGBLFLD, defining global field
POST_CODE_STATUS_CODE
%DDAL-I-DEFGBLFLD, defining global field
NXT_POST_CODE_LOCALITY_SEQ_NB
R
16:54:05 %DDAL-I-DEFINEREL, defining relation EXPORT_POST_CODE
16:54:05 %DDAL-I-LOARELDAT, loading data for relation
EXPORT_POST_CODE
16:54:05 %DDAL-I-RELATSTAT, RELATION EXPORT_POST_CODE
%DDAL-I-RECFRMSRC, 0 records copied from
DBA:[DICKSONA.GATE]T
EST_VMS_GATE.RDB
%DDAL-I-RECTOTARG, 0 records copied into
DBA:[DICKSONA.GATE]T
EST_DDAL.RDB
16:54:05 %DDAL-I-LOARELDAT, loading data for relation RDB$VINTAGE
16:54:06 %DDAL-I-SUMRYSTAT, SUMMARY STATISTICS
%DDAL-I-RECFRMSRC, 0 records copied from
DBA:[DICKSONA.GATE]T
EST_VMS_GATE.RDB
%DDAL-I-RECTOTARG, 0 records copied into
DBA:[DICKSONA.GATE]T
EST_DDAL.RDB
16:54:06 %DDAL-I-ENDDATTRM, ending data transfer/modification
16:54:06 %DDAL-I-COPY_EXIT, normal copy process termination
$ LOGOUT
DICKSONA job terminated at 22-APR-1997 16:54:07.10
Accounting information:
Buffered I/O count: 288 Peak working set size:
10014
Direct I/O count: 1295 Peak page file size:
27789
Page faults: 11912 Mounted volumes:
0
Charged CPU time: 0 00:00:08.16 Elapsed time: 0
00:00:36.81
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 281.1 | They need DDAL 7.0, not 6.0 | BROKE::PROTEAU | Jean-Claude Proteau | Wed Apr 23 1997 22:00 | 8 |
|
Nowhere in the DDAL 6.0 literature is it stated that the PC Data
Gateway is supported. There's a list of supported gateways I think in
a table in chapter 1 of the DDAL 6.0 handbook.
Support for the PC Data Gateway was added in DDAL, that is, the
Replication Option for Rdb, version 7.0. And if they decide to install
ROR 7.0, they must upgrade to either Rdb 6.1 or 7.0.
|