arsdb: Unable to initialize environment

[ibmarthin]

Though I have an open PMR, I try this channel too.

Has anyone seen this before?
I am having trouble with arsdb  -trsv when installing OnDemand 9.5.0 on a new zOS system.

ARS0013E DB Error: Warning:  Unexpected SQL_NO_DATA -- SQLSTATE=N/A, SQLCODE=100, File=arsmvsie.c, Line=1048
arsdb: ARS4012E Unable to initialize environment. The return code is 6 

Same result when using arsdb –u

I can’t find an explanation to “Return code is 6” from arsdb.
I know it reads the right cli.ini file, since it fails to connect to DB2 system xxx, when I omit the DSNAOINI


The JCL                                                                       
//Z6IMN00T JOB (I9302),'MARTHIN',CLASS=A,MSGCLASS=X,NOTIFY=&SYSUID 
//**************************************************************       
//PROCESS   OUTPUT  DEFAULT=YES,CLASS=*,JESDS=ALL,OUTDISP=HOLD         
//STEP1    EXEC PGM=BPXBATCH,REGION=0M                                 
//SYSPRINT DD SYSOUT=*                                                 
//SYSOUT   DD SYSOUT=*                                                 
//STDERR   DD SYSOUT=*                                                 
//STDOUT   DD SYSOUT=*                                                 
//STDPARM  DD *                                                       
PGM /usr/lpp/ars/V9R5M0/bin/arsdb -trsv                               
    -I ARCHIVE -v -1 /u/z6imn/arsdb2.trc -2 ALL=15                     
//*                                                                   
//STDENV DD *                                                         
DSNAOINI=/usr/lpp/ars/config/cli.ini                                   
STEPLIB=DSNX.DSNB10.SDSNEXIT.B2:SYS1.TEST.SDSNLOAD.EXTRA2         
CLASSPATH=/usr/lpp/ars/V9R5M0/bin/xml/ODAdmin.jar:                     
          /usr/lpp/java/J1.4/lib/core.jar                             
LIBPATH=/usr/lpp/ars/V9R5M0/bin/xml:ÅLIBPATH                           
PATH=/usr/lpp/ars/config:/usr/lpp/ars/V9R5M0/bin:ÅPATH                 
/*         

ars.cfg:
ARS_NUM_LICENSE=5         
ARS_LANGUAGE=DAN           
ARS_CODEPAGE=277           
ARS_ORIGINAL_CODEPAGE=277 
ARS_NUM_DBSRVR=4           
ARS_TMP=ars/tmp           
ARS_PRINT_PATH=ars/tmp     
DB_ENGINE=DB2             
ARS_NUM_OAMSRVR=3         
ARS_OAM_DB2SSID=DB2A       
ARS_OAM_PLAN=CBRIDBS       

cli.ini - the clitrace.trc is empty
[COMMON]
MVSDEFAULTSSID=DB2A                     
[DB2A]                                 
PLANNAME=DSNACLI                       
APPLTRACEFILENAME=/tmp/clitrace.trc     
APPLTRACE=1                             
TRACETIMESTAMP=3                       
TRACEPIDTID=1   

[Greg Ira]

I guess the basic question first.  Did you create the Tablespaces first before running arsdb -trsv?

[ibmarthin]

Hi Greg
Good question. But yes the create Tablespaces ran ok. 42 TS created.

[Greg Ira]

Interesting. Only reason I asked was one of our guys got a similar message when they forgot the TS step.  From the messages it does seem to be connecting to DB2 but can't find whatever it's looking for. Everything else looks right.  Hopefully the PMR finds the issue.

[Ed_Arnold]

Instead of PGM, could you try it as a shell script as per the example here:

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

Ed

[ibmarthin]

Thanks for the input Greg and Ed.

ED: I tried this with same result:
//**************************************************************           
//PROCESS   OUTPUT  DEFAULT=YES,CLASS=*,JESDS=ALL,OUTDISP=HOLD             
//STEP1    EXEC PGM=BPXBATCH,REGION=0M                                     
//STDPARM DD *                                                             
SH                                                                         
export DSNAOINI=/usr/lpp/ars/config/cli.ini;                               
export STEPLIB=DSNX.DSNB10.SDSNEXIT.KMD.B2:SYS1.TEST.SDSNLOAD.EXTRA2;       
/usr/lpp/ars/V9R5M0/bin/arsdb  -trsv                                       
    -I ARCHIVE -v -1 /u/z6imn/arsdb3.trc -2 ALL=15;                         
/*                                                                         
//STDOUT   DD SYSOUT=*                                                     
//STDERR   DD SYSOUT=*   

The output in the arsdb3.trc is attached. I am suspicious about the ODBC connection, though it seems that it connects ok
                                                 

[Ed_Arnold]

Marthin - please try the ODBC IVP

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

It's something every CMOD administrator should have in their JCL library to run anytime there's major DB2 work.

Ed

[Ed_Arnold]

Do your STEPLIB'ed datasets also include SDSNLOD2?

Ed

[ibmarthin]

Thanks for the input.
The solution was in the ars.ini where I misread the parameter SRVR_INSTANCE which should be name of Database and not ARCHIVE
After changing to SRVR_INSTANCE=ARSDBASE the arsdb -trsv executed ok.

[Ed_Arnold]

Thanks for posting the eventual solution...that helps out the rest of us.

Ed