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?
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:06ZThis is the accepted answer. This is the accepted answer.We 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:44ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK