Skip to Content
0
Former Member
Dec 06, 2007 at 02:54 AM

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

44 Views

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

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