Topic
  • 3 replies
  • Latest Post - ‏2013-01-25T16:28:44Z by SystemAdmin
Kirsi
Kirsi
1 Post

Pinned topic after DB2 for z/os v10 CM installation, currentFunctionPath returns error

‏2012-01-17T14:40:19Z |
Hi,

In WAS7 we have an application using stored procedures.

In Database Connection Custom Properties currentFunctionPath was defined as:
"TEST","SYSIBM","SYSFUN","SYSPROC"
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:
without: TEST,SYSIBM,SYSFUN,SYSPROC
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?

Br,
Kirsi
Updated on 2013-01-25T16:28:44Z at 2013-01-25T16:28:44Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1731 Posts

    Re: after DB2 for z/os v10 CM installation, currentFunctionPath returns error

    ‏2012-02-07T17:34:34Z  
    did you try setting it using the bind command?
  • SystemAdmin
    SystemAdmin
    1731 Posts

    Re: after DB2 for z/os v10 CM installation, currentFunctionPath returns error

    ‏2013-01-18T21:56:06Z  
    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?
  • SystemAdmin
    SystemAdmin
    1731 Posts

    Re: after DB2 for z/os v10 CM installation, currentFunctionPath returns error

    ‏2013-01-25T16:28:44Z  
    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?
    Slimm, 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.