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
I guess the basic question first. Did you create the Tablespaces first before running arsdb -trsv?
Hi Greg
Good question. But yes the create Tablespaces ran ok. 42 TS created.
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.
Instead of PGM, could you try it as a shell script as per the example here:
http://ODUG.net/index.php?topic=1666.0 (http://odug.net/index.php?topic=1666.0)
Ed
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
Marthin - please try the ODBC IVP
http://ODUG.net/index.php?topic=614.0 (http://odug.net/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
Do your STEPLIB'ed datasets also include SDSNLOD2?
Ed
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.
Thanks for posting the eventual solution...that helps out the rest of us.
Ed