Hi list,
I have DB2 under SLES8 and I am trying to be able to communicate with it
from my z/VM 4.4.
>From my DB2/SLES8 I am able to federate it with a DB2/VM database
perfectly.
The problem arises when I try to do the opposite step: Communicate VM
with my DB2/SLES8.
This is what I have done:
- I have updated my COMDIR NAMES file in accordance to my settings:
COMDIR NAMES B2 V 255 Trunc=72 Size=62 L
====>
|...+....1....+....2....+....3....+....4....+...
:nick.LNXP00 :service.50001
:host.197.10.1.8
:security.PGM
:userid.*****
:password.*****
:dbname.LNXP00
Then I execute the following sequence under CMS:
'vmlink tcpmaint 592 <592 B rr'
'set comdir file system comdir names B'
'set comdir file user comdir names B'
'set comdir reload both'
'CP det 193'
'pipe cp link sql089 193 193 rr' <-- This is where I have
CEEPIPI-CEEBPICI-CEEBINIT MODULES
'pipe cms acc 193 v' compiled as indicated in DB2/VM
7.3 Prog. Dir.
'CP det 195'
'pipe cp link sql089 195 195 rr'
'pipe cms acc 195 q'
'set language ameng (add ari user'
'sqlinit dbname(LNXP00) protocol(DRDA)'
and this is what I get:
DMSVML2060I TCPMAINT 592 linked RR as 0592 file mode B
ARI0717I Start SQLINIT EXEC: 04/04/05 17:04:03 EST.
ARI6042I Warning: Application server LNXP00 has not been
generated on this processor. Ignore this
message if the server has been defined as a
global resource on another processor.
ARI0320I The default server name is LNXP00.
ARI0796I End SQLINIT EXEC: 04/04/05 17:04:04 EST
Ready;
So far, everything OK. The problem comes NOW. The next step should be to
execute this:
SQLPREP ASM PP
(PREP=SQLDBA.ARIDSQL,BLOCK,ISOL(CS),NOPR,ERROR,NOPU,CTOKEN(NO)) IN
(ARIDSQLP MACRO V)
then I get
ARI0717I Start SQLPREP EXEC: 04/04/05 16:15:51 EST.
ARI0713I Preprocessor ARIPRPA
called with the following parameters:
........ PREP=SQLDBA.ARIDSQL,BLOCK,ISOL(CS),NOPR,ERROR,NOPU,CTOKEN(NO)
*ARI0562I - The following SQL error and/or warning conditions
* - occurred for the ASSEMBLER preprocessor initiated SQL
* - CONNECT statement.
ARI0503E An SQL error has occurred.
Value not supported for X'119C' parameter.
*ARI0505I SQLCODE = -30073 ROWCOUNT = 0
*ARI0504I SQLERRP: ARIRLC2 SQLERRD1: -8 SQLERRD2: 0
*ARI0547I - You did not declare any host variables in ARIDSQL.
*ARI0586I - Preprocessing ended with 1 errors and
* - 0 warnings.
*ARI0598I - The application server restored the package for
* - ARIDSQL or did not produce the package.
ARI0710E Errors occurred during SQLPREP EXEC processing.
ARI0796I End SQLPREP EXEC: 04/04/05 16:15:56 EST
What I really don't know is if there are still things pending to do in
DB2/SLES8 prior to the SQLPREP execution such as to create the necessary
catalog tables for DBSU. I just don't know. If so, HOW DO I ACHIEVE THIS
?
Any help will be very welcome.
Thanks in advance and greetings from Madrid
Saludos,
Jos� Ra�l Bar�n
Dpto. Sistemas
CALCULO S.A.
Tel. 91 330 86 44
e-mail: [EMAIL PROTECTED]
----------------------------------------------------------------------
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
