In WAS7 we have an application using stored procedures.
In Database Connection Custom Properties currentFunctionPath was defined as:
and it worked fine until:
After DB2 for z/os v10 CM installation connection succeeds but it gets an error:
00000026 SystemOut O DBUtil.writeToLog1 com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-725, SQLSTATE=42721, SQLERRMC=CURRENT PATH(*PRIOR FAILURE*);MYINSTANCE, DRIVER=3.53.70
After -725 it rejects all the following sql statements.
We tried the list also without any brackets, with brackets only in the beginning and the end, but it did not help:
beginning and end "TEST,SYSIBM,SYSFUN,SYSPROC"
In the end with having only one schema "in the list", it worked
Only one: TEST
I suppose this is not so problematic at the moment, when they have only default once following this TEST -schema, but do you know is it possible to add other values somehow to the list, if we need to add them in some point?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2013-01-25T16:28:44Z by SystemAdmin
Pinned topic after DB2 for z/os v10 CM installation, currentFunctionPath returns error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-25T16:28:44Z at 2013-01-25T16:28:44Z by SystemAdmin
Re: after DB2 for z/os v10 CM installation, currentFunctionPath returns error2013-01-18T21:56:06Z in response to KirsiWe experienced almost the exact same symptom immediately after migration to V10 CM. We cannot easily modify the sql because it is embedded in a distributed IBM Websphere IBM Content Manager function. Work-around is to disable that particular Content Manager function, and that alleviates the -725 error, but permanent function disablement is not an option.
Only thing that changed was DB2/zos. So we assume something new in DB2 caused this sql to break but we (or IBM support) have not yet determined the root cause.
Did you determine a root cause and resolution?
Re: after DB2 for z/os v10 CM installation, currentFunctionPath returns error2013-01-25T16:28:44Z in response to SystemAdminSlimm, any update? We also have content manager eclient and have the same problem. We are working with IBM but it's been a week and we haven't gotten an answer yet.