I have a connection setup between VSE/ESA 2.5 with DB2 7.3 to act as a
client to DB2/UDB V8.2 (64 bit) on SLES9.
Some minor problems. But I can select tables on the UDB side and I can
create tables on the UDB side (both from the VSE side). But DATALOADER
seems to be a problem. I almost think it is a package problem.
However, I did load the packages for the DBSU and ISQL over on the UDB
side which allowed me to run the ARIDBS job step (the batch utility
program).
When I try to load the full table (that is all columns defined in the
table), I get:
ARI2906I The only valid isolation level is CS
when the DRDA protocol is used.
Isolation level CS is now in effect.
------> CONNECT "DB2INST1" IDENTIFIED BY ********;
ARI8004I User DB2INST1 connected to server SAMPLE.
ARI0500I SQL processing was successful.
ARI0505I SQLCODE = 0 SQLSTATE = 00000 ROWCOUNT = 0
------> DATALOAD TABLE (STL01.PRCL)
------> "PRCL_CITY_BLOCK" 001-006 CHAR
------> "PRCL_PARCEL_NO" 007-011 CHAR
------> "PRCL_LAST_UPDATE" 012-021 CHAR
ARI0859E Invalid column reference.
------> "PRCL_LAND_USE_CD" 022-025 CHAR
Which looks like a bad column reference. But when I take all but the
first column out of the dataload, I get:
ARI0505I SQLCODE = 0 SQLSTATE = 00000 ROWCOUNT = 0
------> DATALOAD TABLE (STL01.PRCL)
------> "PRCL_CITY_BLOCK" 001-006 CHAR
------> INFILE (SDSKIN PDEV(DASD) RECSZ(383) BLKSZ(7660) RECFM(FB));
ARI0852I DATALOAD TABLE processing started.
ARI0512E An error has occurred.
SQLCODE -517 is received from the application server.
Product = OS/2 EE DB Level = V08R02M0
SQLERRP = SQLR
SQLSTATE = 07
SQLERRD(1) = -2146303891 SQLERRD(2) = 0 SQLERRD(3) = 0
SQLERRD(4) = 0 SQLERRD(5) = 0 SQLERRD(6) = 0
SQLWARN0 = ' ' SQLWARN1 = ' ' SQLWARN2 = ' '
SQLWARN3 = ' ' SQLWARN4 = ' ' SQLWARN5 = ' '
SQLWARN6 = ' ' SQLWARN7 = ' ' SQLWARN8 = ' '
SQLWARN9 = ' ' SQLWARNA = ' '
SQLERRM = IC001
ARI0857E DATALOAD processing unsuccessful.
So, for any of you that have done a VSE client to UDB, is DATALOAD
supported?
I can go to the UDB side, and access the VSE tables, and copy data from
a VSE table to the UDB table, but that is somewhat hard to put in a VSE
jobstream<G>.
I just don't know how bleeding edge I'm getting myself into.
Thanks
Tom Duerbusch
THD Consulting
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
