Yep, it is there.
At first I was wondering if DATALOAD would work (may have been a
restriction).
But then it dawned on me that some documentation shows it working. So
if it is not working, it may be a reportable problem.
I'll open it up with DB2/VSE folks first.
Tom Duerbusch
THD Consulting
>>> [EMAIL PROTECTED] 4/4/2006 2:58 AM >>>
Tom,
Did you define table SQLDBA.DBSOPTIONS. We had to define this table to
have
all work well when executing loads from vse towards udb/linux.
Try executing following jcl if you haven't done this already :
// EXEC PGM=ARIDBS,SIZE=AUTO,PARM='PROMPTS(NO),DBNAME(xxxxxxx)'
CONNECT user IDENTIFIED BY password;
SET ERRORMODE CONTINUE;
CREATE TABLE SQLDBA.DBSOPTIONS
(SQLOPTION VARCHAR (18) NOT NULL,
VALUE VARCHAR (18) NOT NULL);
CREATE UNIQUE INDEX SQLDBA.DBSINDEX
ON SQLDBA.DBSOPTIONS (SQLOPTION,VALUE);
INSERT INTO SQLDBA.DBSOPTIONS
VALUES ('RELEASE','7.3.0');
COMMIT WORK;
/*
Johan Bruyneel
Securex - Belgium
Tom Duerbusch
<[EMAIL PROTECTED]
iscity.com>
To
Sent by: Linux on [email protected]
390 Port
cc
<[EMAIL PROTECTED]
IST.EDU>
Subject
DB2 Dataloaded VSE to UDB
03/04/2006 17:30
Please respond to
Linux on 390 Port
<[EMAIL PROTECTED]
IST.EDU>
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
- Confidentiality Notice -
This communication and the information it contains is intended (a) for
the person(s) or organization(s)
named above and for no other person or organization, and (b) may be
confidential, legally privileged and
protected by law. Unauthorized use, copying or disclosure of any of it
may be unlawful! If you receive
this communication in error, please notify us immediately, destroy any
copies and delete it from your
computer system. Please consult our disclaimer on our site
www.securex.be
Thank you.
----------------------------------------------------------------------
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
----------------------------------------------------------------------
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
