KevinOD
Member
Hi list,
Is anyone out there successfully running a Table
Converter on the AS/400 Enterprise Server connecting
to a SQL Server 2000 database .
I have successfully run this Locally and all works fine.
Locally this has been setup as an ODBC connection.
Running on the Server I get the following errors.
3287 Tue Jan 28 04:36:14 2003
runbatch.c382
INITIALIZING RUNBATCH job: 99559
3287 Tue Jan 28 04:36:14 2003
ipcpub.c3121
process 3287 <B7334SYS/PRINTUBE>
registered in entry 11
3287 Tue Jan 28 04:36:14 2003
runbatch.c632
Startup for User=KEVINO9, Env=DV7333,
Job#=99559
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90701 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90704 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90703 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
combined.c344
RDEL0000045 - Could not open tables for
reliable event delivery (F90703 and F90704). Reliable
event delivery will be disabled
3287 Tue Jan 28 04:36:17 2003
runbatch.c1124
RUNBATCH: Remote CP=1252, Remote
OS=5, Local CP=37, ConvertToASCII=0
3287 Tue Jan 28 04:36:20 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed
3287 Tue Jan 28 04:36:20 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment
3287 Tue Jan 28 04:36:20 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test
3287 Tue Jan 28 04:36:20 2003
jtp_cm.c283
JDB9909003 - Could not init connect.
3287 Tue Jan 28 04:36:20 2003
jtp_tm.c960
JDB9909100 - Get connect info failed:
Transaction ID =
3287 Tue Jan 28 04:36:20 2003
jdb_rq1.c1797
JDB3100013 - Failed to get connectinfo
3287 Tue Jan 28 04:36:21 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed
3287 Tue Jan 28 04:36:21 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment
3287 Tue Jan 28 04:36:21 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test
3287 Tue Jan 28 04:36:21 2003
jtp_cm.c283
JDB9909003 - Could not init connect.
I have been looking at the following How to Knowledge
Garden documents.
These seems to say that this is possible and that the
connection is done using JDBNET as the Connector. So
we have set up the Data Source as connecting via
JDBNET.
Ott- 99-0045 Table Conversion/- Preparing a Foreign
Table at a Source
Ott-01-0111 What DLL to use on a OW Database Data
Source when preparing a Table Conversion to use a
Foreign Table
Also Chapter 20 of the below link RedBook
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg24
5195.pdf
Can anyone tell us if we are missing anything that is not
in the above How TO documents? I am still studying the
Rednbook.
Confirm that they are successfully using the above
process of running Table Converters………………
Confirm that OW Services need to be running on the
Remote Intel Server
(this is the next step we need to try)
Your help will be much appreciated .
Thanks in Advance
KOD
Platform:JDE OW XE/SP20/AS400 V4R5M0
Is anyone out there successfully running a Table
Converter on the AS/400 Enterprise Server connecting
to a SQL Server 2000 database .
I have successfully run this Locally and all works fine.
Locally this has been setup as an ODBC connection.
Running on the Server I get the following errors.
3287 Tue Jan 28 04:36:14 2003
runbatch.c382
INITIALIZING RUNBATCH job: 99559
3287 Tue Jan 28 04:36:14 2003
ipcpub.c3121
process 3287 <B7334SYS/PRINTUBE>
registered in entry 11
3287 Tue Jan 28 04:36:14 2003
runbatch.c632
Startup for User=KEVINO9, Env=DV7333,
Job#=99559
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90701 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90704 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90703 not found
3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST
3287 Tue Jan 28 04:36:17 2003
combined.c344
RDEL0000045 - Could not open tables for
reliable event delivery (F90703 and F90704). Reliable
event delivery will be disabled
3287 Tue Jan 28 04:36:17 2003
runbatch.c1124
RUNBATCH: Remote CP=1252, Remote
OS=5, Local CP=37, ConvertToASCII=0
3287 Tue Jan 28 04:36:20 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed
3287 Tue Jan 28 04:36:20 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment
3287 Tue Jan 28 04:36:20 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test
3287 Tue Jan 28 04:36:20 2003
jtp_cm.c283
JDB9909003 - Could not init connect.
3287 Tue Jan 28 04:36:20 2003
jtp_tm.c960
JDB9909100 - Get connect info failed:
Transaction ID =
3287 Tue Jan 28 04:36:20 2003
jdb_rq1.c1797
JDB3100013 - Failed to get connectinfo
3287 Tue Jan 28 04:36:21 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed
3287 Tue Jan 28 04:36:21 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment
3287 Tue Jan 28 04:36:21 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test
3287 Tue Jan 28 04:36:21 2003
jtp_cm.c283
JDB9909003 - Could not init connect.
I have been looking at the following How to Knowledge
Garden documents.
These seems to say that this is possible and that the
connection is done using JDBNET as the Connector. So
we have set up the Data Source as connecting via
JDBNET.
Ott- 99-0045 Table Conversion/- Preparing a Foreign
Table at a Source
Ott-01-0111 What DLL to use on a OW Database Data
Source when preparing a Table Conversion to use a
Foreign Table
Also Chapter 20 of the below link RedBook
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg24
5195.pdf
Can anyone tell us if we are missing anything that is not
in the above How TO documents? I am still studying the
Rednbook.
Confirm that they are successfully using the above
process of running Table Converters………………
Confirm that OW Services need to be running on the
Remote Intel Server
(this is the next step we need to try)
Your help will be much appreciated .
Thanks in Advance
KOD
Platform:JDE OW XE/SP20/AS400 V4R5M0