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, 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
DSNL028I -DSN8 G952183D.O52D.071205035059=95 641
ACCESSING DATA FOR
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