SQL1224N, error installing NW on Linux (for System z) + DB2 for z/OS

[Former Member]

Hi all, help please ... I am installing SAP NW on Linux for System z with DB2 for z/OS as a database.

In step 8 of 17 (Import ABAP) of the SAPINST, it stopped after successfully loading many of the z/OS tables, 14 of the 18 load steps finished successfully and I checked DB2 on z/OS and found most tables to be created and loaded successfully. I found the following error in the SAPAPPL0.Log

DbSl Trace: DB2 Call 'SQLExecDirect' Error: sqlcode = -1224 : [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032

DbSl Trace: DB2--1224 occured; SQL statement is ==>

DbSl Trace: [dbdb2dic.c 1532] DDIC ERROR rc=99,sqlcode=-1224: CREATE AUX TABLE "#CONTENTMRM" IN A030X999.LIACTDVF STORES "IACTL_C1" COLUMN "CONTENT"

DbSl Trace: [dbdb2dic.c 1534] DDIC ERROR msg: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown

DbSl Trace: [dbdb2dic.c 1726] DDIC ERROR rc=99,sqlcode=-1224: ExecDDL failed (DB error)

DbSl Trace: [dbdb2dic.c 3150] DDIC ERROR LOB create procedure of table IACTL_C1 failed --> dropping table

DbSl Trace: DB2 Call 'SQLEndTran' Error: sqlstate = 08003 : [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003

On the host (z/OS) I found this error:

DSNL027I -DSN8 SERVER DISTRIBUTED AGENT WITH 640

LUWID=G952183D.O52D.071205035059=95

THREAD-INFO=R3USER:dalbilnx:r3user:DEVGEN000

RECEIVED ABEND=0C4

FOR REASON=00000000

DSNL028I -DSN8 G952183D.O52D.071205035059=95 641

ACCESSING DATA FOR

LOCATION 9.82.24.61

IPADDR 9.82.24.61

Since Reason =00000000 I doubt the error is coming from the host, in addition I tried the failed SQL directly on the host and it worked fine. I googled the error and searched SAP, I found some hints on DB2 Connect environment variable EXTSHM=ON. I turned it on for <sid>adm, root (I am installing from root on Linux), and db2inst1 (instance owner of DB2 Connect). Also, changed DB2 Connect variable db2set DB2ENVLIST=EXTSHM. All of that did not help.

By the way I am using DB2 Connect V8 FixPak 14, which I think should be OK according to SAP Notes.

what else should I check? any setting needed for DB2 Connect? or anything else? any help will be highly appreciated. Thanks.

-- Ashraf Kamel

[Former Member]

I got to do some changes to the zParms to get it to work.

Siddhesh, you helped a lot by making me think DB2 z/OS, I was under the impression error was coming from DB2 Connect. Here are the zParms that worked for reference.

DSN6ENV MVS=XA 00370000

DSN6SPRM RESTART, X00370001

ALL, X00370002

ABEXP=YES, X00370003

ABIND=YES, X00370004

AEXITLIM=10, X00370005

AUTH=YES, X00370005

AUTHCACH=1024, X00370006

BINDNV=BINDADD, X00370007

BMPTOUT=4, X00370008

CACHEDYN=YES, X00370009

CACHEPAC=102400, X00370010

CACHERAC=102400, X00370011

CATALOG=DSNC810, X00370012

CDSSRDEF=1, X00370013

CHGDC=NO, X00370014

CONTSTOR=YES, X00370015

DBACRVW=NO, X00370016

DECDIV3=NO, X00370017

DEFLTID=IBMUSER, X00370018

DESCSTAT=YES, X00370019

DISABSCL=NO, X00370020

DLITOUT=6, X00370021

DSMAX=10000, X00370022

EDMBFIT=NO, X00370023

EDMDBDC=109428, X00370024

EDMPOOL=92000, X00370025

EDMSTMTC=300000, X00370026

EDPROP=NO, X00370027

EVALUNC=NO, X00370028

HOPAUTH=BOTH, X00370029

IRLMAUT=YES, X00370030

IRLMPRC=DSN8IRLM, X00370031

IRLMSID=IRLH, X00370032

IRLMRWT=60, X00370033

IRLMSWT=300, X00370034

LEMAX=20, X00370035

LRDRTHLD=0, X00370036

MAINTYPE=SYSTEM, X00370037

MAXRBLK=20000, X00370038

MAXKEEPD=8000, X00370039

MAX_NUM_CUR=500, XJ151X005

MAX_ST_PROC=2000, XJ151X005

MINDVSCL=NONE, X00370040

MINSTOR=YES, X00370041

NPGTHRSH=0, X00370042

NUMLKTS=10000, X00370043

NUMLKUS=50000, X00370044

OPTHINTS=NO, X00370045

PADIX=NO, X00370046

PARAMDEG=0, X00370047

PARAPAR1=YES, X00370047

PARTKEYU=YES, X00370048

RECALL=NO, X00370050

REFSHAGE=0, X00370051

RECALLD=120, X00370052

RELCURHL=YES, X00370053

RETLWAIT=0, X00370054

RETVLCFK=NO, X00370055

RGFCOLID=DSNRGCOL, X00370056

RGFDBNAM=DSNRGFDB, X00370057

RGFDEDPL=NO, X00370058

RGFDEFLT=ACCEPT, X00370059

RGFESCP=, X00370060

RGFFULLQ=YES, X00370061

RGFINSTL=NO, X00370062

RGFNMORT=DSN_REGISTER_OBJT, X00370063

RGFNMPRT=DSN_REGISTER_APPL, X00370064

RRULOCK=NO, X00370065

SECLCACH=255, X00370066

SEQCACH=BYPASS, X00370067

SEQPRES=NO, X00370068

SITETYP=LOCALSITE, X00370069

SJMXPOOL=20, X00370069

SJTABLES=10, X00370070

SRTPOOL=2000, X00370071

STARJOIN=DISABLE, X00370072

STATHIST=NONE, X00370073

STATROLL=NO, X00370074

STATSINT=15, X00370075

SUPERRS=YES, X00370076

SYSADM=JLIANG, X00370077

SYSADM2=SYSADM1, X00370078

SYSOPR1=SYSOPR, X00370079

SYSOPR2=SYSADM1, X00370080

TRKRSITE=NO, X00370081

UTIMOUT=6, X00370082

VOLTDEVT=SYSDA, X00370083

XLKUPDLT=NO 00370084

DSN6ARVP ALCUNIT=BLK, X00370085

ARCWRTC=(1,3,4), X00370086

ARCWTOR=YES, X00370087

ARCPFX1=DSNC810.ARCHLOG1, X00370088

ARCPFX2=DSNC810.ARCHLOG2, X00370089

ARCRETN=9999, X00370090

BLKSIZE=28672, X00370091

CATALOG=NO, X00370092

COMPACT=NO, X00370093

PRIQTY=4320, X00370094

PROTECT=NO, X00370095

QUIESCE=5, X00370096

SECQTY=540, X00370097

SVOLARC=NO, X00370098

TSTAMP=NO, X00370099

UNIT=TAPE, X00370100

UNIT2= 00370101

DSN6LOGP DEALLCT=(0), X00370102

MAXARCH=1000, X00370103

MAXRTU=2, X00370104

OFFLOAD=NO, X00410092

OUTBUFF=4000, X00370105

TWOACTV=NO, X00370106

TWOARCH=NO, X00370107

ARC2FRST=NO 00370108

DSN6SYSP ACCUMACC=NO, X00370109

AUDITST=NO, X00370110

BACKODUR=5, X00370111

CHKFREQ=500000, X00370112

CONDBAT=10000, X00370113

CTHREAD=1000, X00370114

DBPROTCL=DRDA, X00370115

DLDFREQ=5, X00370116

DSSTIME=5, X00370117

DSVCI=YES, X00370123

EXTRAREQ=100, X00370124

EXTRASRV=100, X00370125

EXTSEC=YES, X00370120

IDBACK=100, X00370121

IDFORE=40, X00370122

IDXBPOOL=BP3, X00370123

IXQTY=0, X00370123

LBACKOUT=AUTO, X00370124

LOBVALA=100000, X00370125

LOBVALS=51200, X00370126

LOGAPSTG=100, X00370127

MAXDBAT=390, X00370128

MON=NO, X00370129

MONSIZE=262144, X00370130

PCLOSEN=5, X00370131

PCLOSET=10, X00370132

RLF=NO, X00370133

RLFTBL=01, X00370134

RLFERR=NOLIMIT, X00370135

RLFAUTH=SYSIBM, X00370136

ROUTCDE=(1), X00370137

SMFACCT=(1,2,3), X00370138

SMFSTAT=YES, X00370139

STATIME=15, X00370140

STORMXAB=0, X00370141

STORPROC=DSN8SPAS, X00370142

STORTIME=180, X00370143

SYNCVAL=NO, X00370144

TBSBPOOL=BP2, X00370145

TRACSTR=NO, X00370146

TRACTBL=16, X00370147

TSQTY=0, X00370147

UIFCIDS=NO, X00370148

URCHKTH=0, X00370149

URLGWTH=0, X00370150

WLMENV=DSN8ENV 00370151

DSN6FAC DDF=AUTO, X00370152

CMTSTAT=INACTIVE, X00370153

IDTHTOIN=0, X00370154

RESYNC=2, X00370155

RLFERRD=NOLIMIT, X00370156

TCPALVER=NO, X00370157

MAXTYPE1=0, X00370158

TCPKPALV=120, X01339000

POOLINAC=120 00370160

DSN6GRP DSHARE=NO, X00370161

GRPNAME=, X00370162

MEMBNAME=, X00370163

COORDNTR=NO, X00370164

ASSIST=NO, X00370165

IMMEDWRI=NO 00370166

END 01370000

[former_member185954]

glad i could help ashraf, good luck with your work

cheers,

Siddhesh

[former_member185954]

<b><< IGNORE THE POST >></b>

Also check the following note and ensure that your OS is upto the correct patch level.

<i>Wrong Note deleted</i>

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[former_member185954]

Hi Ashraf,

Although the following note doesn't apply , please have a look:

Note 868938 - DB6: SQL1224N when creating indexes

Regards,

Siddhesh