Re: How to connect to UDB database under Linux from VSE batch job

New Message Reply Date view Thread view Subject view Author view Other groups

Subject: Re: How to connect to UDB database under Linux from VSE batch job
From: Tom Duerbusch (DuerbuschT@stlouiscity.com)
Date: Tue Jul 15 2008 - 11:20:47 EDT 

I didn't have any problem:

// EXEC PGM=ARIDBS,SIZE=ARIDBS,PARM='DBNAME(LINUX53)'  
CONNECT DB2INST1 IDENTIFIED BY xxxxx;                  

In the ARISDIRD:

TYPE=REMOTE             
DBNAME=SAMPLE           
ALIAS=LINUX53           
TCPPORT=50001           
TCPHOST=192.168.193.153 

Tom Duerbusch
THD Consulting


Law of Cat Acceleration

  A cat will accelerate at a constant rate, until he gets good and
  ready to stop.


>>> John Mycroft <johnm@csi-international.com> 7/14/2008 1:11 PM >>>
I want to run a program against a Linux UDB database, connecting from a VSE batch partition but my password gets rejected (-560 return code from 
CONNECT).  If I run ARIDBS with PARM='DBNAME(LUX1)' and say CONNECT "LUX1    "  IDENTIFIED BY PSWDXXXX, it works.  If my program issues EXEC  SQL 
CONNECT :ID IDENTIFIED BY :PW after I have put LUX1 (which is both the DBNAME and the userid) in the :ID local variable and PSWDXXXX in :PW (both 
:ID & :PW are 8 byte fields padded with spaces and I have them in the right case), I get the -560 dud password indication.  (If I supply a dud id, I 
get a dud id indication, in case that's relevant).

I've gotta be missing something here but I can't find anything in any manual to tell me how to specify that DBNAME parameter (if I need to).

Help!

John Mycroft

New Message Reply Date view Thread view Subject view Author view Other groups

This archive was generated by hypermail 2b25 : Tue Aug 19 2008 - 18:05:08 EDT