CAF "CONNECT" failed when running arsdb

[2ma2]

Hi

I am upgrading to 8.5.0 from 8.4.0, but when I run this JCL it seems to miss the DB2 Name.
So where do I set this ?

STDOUT:
********************************* TOP OF DATA ****************************
 DB Error: ?DB2 FOR OS/390??ODBC DRIVER?  SQLSTATE=58004  ERRLOC=2:170:9 
   CAF "CONNECT" failed using DB2 system:XXXX                             
   RC=0c and REASON=00f30006 -- SQLSTATE=58004, SQLCODE=-99999           
 arsdb: Unable to connect to DB2 ARSPRGT database                         
******************************** BOTTOM OF DATA **************************
I assumed it was read from 
//DSNAOINI DD PATH='/ars/alt/V8R4M0/config/cliz.ini'       

cliz.ini:
********************************* Top of Data ******************************
?COMMON?                                                                   
MVSDEFAULTSSID=ZDB2                                                         
?ZDB2?                                                                     
PLANNAME=DSNACLI                                                           
******************************** Bottom of Data ****************************

JCL://IMN0001 JOB ...
//PROCESS   OUTPUT  DEFAULT=YES,CLASS=*,JESDS=ALL,OUTDISP=HOLD       
//STEP1    EXEC PGM=BPXBATCH,REGION=0M                               
//STEPLIB  DD DISP=SHR,DSN=SYS2.DB2.SDSNEXIT                         
//         DD DISP=SHR,DSN=SYS2.DB2.SDSNLOAD                         
//         DD DISP=SHR,DSN=SYS2.DB2.SDSNLOD2                         
//SYSPRINT DD SYSOUT=*                                               
//DSNAOINI DD PATH='/ars/alt/V8R4M0/config/cliz.ini'       
//SYSOUT   DD SYSOUT=*                                               
//STDERR   DD SYSOUT=*                                               
//STDOUT   DD SYSOUT=*                                               
//STDPARM  DD *                                                       
PGM /ars/alt/V8R4M0/bin/arsdb -u -I PRGTEST                           
/*                                                                   
//STDENV DD *                                                         
CLASSPATH=/usr/lpp/ars/V8R4M0/bin/xml/ODAdmin.jar:                   
          /usr/lpp/java/J1.4/lib/core.jar                             
LIBPATH=/usr/lpp/ars/V8R4M0/bin/xml:$LIBPATH                         
PATH=/usr/lpp/java/J1.4/bin:/usr/lpp/ars/V8R4M0/bin:$PATH             
/*                                                                   

[Ed_Arnold]

1. make sure everything STEPLIB'ed is APF authorized

2. Java 1.4 is out of support, suggest you use a newer java.

Ed

[Ed_Arnold]

If you have the time, I think it would be worth running the ODBC IVP:

http://www.odusergroup.org/forums/index.php?topic=614.0

Ed

[2ma2]

Thanks Ed

But there is no difference after I changed to Java 6.0.
And yes, alle STEPLIBS are APF autorized.

I just can't figure out where OnDemand fetches the DB2 System-ID if not in cliz.ini
It is though, an running OnDemand 8.4.0 system.
The Create Tablespaces went ok, so I only have to run the arsdb to be ready for 8.5.0

And I don't think I have the time or expertice to run the IVP.

Regards IB Marthin

[2ma2]

By the way, I get exactly the same result when I run from omvs.

[Ed_Arnold]

Recommend you open a PMR.

Ed

[2ma2]

Just did so thanks anyway :-)

[Ed_Arnold]

Hmmm - try using my JCL for running arsdb in batch:

http://www.odusergroup.org/forums/index.php?topic=690.0

Ed

[Ed_Arnold]

Just mentioning that I recently had a PMR where the user cd'ed to /usr/lpp/ars/V9R0M0/bin and then ran arsdb but got errors and unexpected results.

The problem was that their dot-profile was pointing to V7 of CMOD.

So even though they CD'ed to the V9 directory, they were still picking up the V7 arsdb.

Ed