#11923: IBM DB2 UDB 10.5 Session Manager - No authorized routine named "SNAPSHOT_APPL"

tariqrahiman reported 2014-04-22T21:11:30Z · last modified 2015-02-20T22:51:13Z

IBM DB2 UDB 10.5 Session Manager - No authorized routine named "SNAPSHOT_APPL"

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	DBA-T - DB2 - Session Mngr
Version	15.0

Version: 15.0.0-dev-247

Build #: 37464

Build Date: 2014-Apr-22 07:36:33 AM

IBM DB2 UDB 10.5 Session Manager gives SqlSyntaxErrorException

1. Navigate to DB2 UDB 10.5 DBA Tools-> Session Manager

2. There are no information visible in the Session Manager

Under View -> Help Logs you get:

com.ibm.db2.jcc.am.SqlSyntaxErrorException: No authorized routine named "SNAPSHOT_APPL" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.61.75

at com.ibm.db2.jcc.am.ed.a(ed.java:676)

at com.ibm.db2.jcc.am.ed.a(ed.java:60)

at com.ibm.db2.jcc.am.ed.a(ed.java:127)

at com.ibm.db2.jcc.am.gn.c(gn.java:2554)

at com.ibm.db2.jcc.am.gn.d(gn.java:2542)

at com.ibm.db2.jcc.am.gn.a(gn.java:2034)

at com.ibm.db2.jcc.t4.cb.g(cb.java:140)

at com.ibm.db2.jcc.t4.cb.a(cb.java:40)

at com.ibm.db2.jcc.t4.q.a(q.java:32)

at com.ibm.db2.jcc.t4.rb.i(rb.java:135)

at com.ibm.db2.jcc.am.gn.gb(gn.java:2005)

at com.ibm.db2.jcc.am.gn.a(gn.java:3029)

at com.ibm.db2.jcc.am.gn.a(gn.java:667)

at com.ibm.db2.jcc.am.gn.executeQuery(gn.java:651)

at \\...\\ .\\हिñçêČάй語简�?한\\.Kᚩᡀᚣꃨ 3 native.executeQuery(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.H⠣ꍛꑜꄿ.ao(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.H⠣ꍛꑜꄿ.aP(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.S̈́ꂧ᛫ꍴ.c(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.uꌫᠪꆷꄆ super do.run(Unknown Source)

at java.lang.Thread.run(Thread.java:744)

1 attachment

Screen Shot 2014-04-22 at 2.11.14 PM.png

2014-04-22T21:11:38Z

132 KB

All Comments (5) Change History

ivangron 2014-05-14T22:54:28Z

removed usage of the following if version 10.1 or greater:

SNAPSHOT_LOCK

SNAPSHOT_APPL

SNAPSHOT_APPL_INFO

replaced with usage of:

MON_GET_LOCKS

MON_GET_CONNECTION

MON_GET_TABLE

MON_GET_TABLESPACE

ivangron 2014-05-14T22:57:08Z

There was no perfect solution to this and hopefully things work well enough. We may want to think about rebuilding the dba tools for db2 10.5 and above to use there whole new sets of system procedures that provide much more and different information then they used to

tariqrahiman 2014-05-16T18:37:38Z

Verified in ADS v15.0.0-dev-285

ivangron 2015-01-28T17:19:33Z

need to port code back to version 14

ivangron 2015-01-28T17:22:31Z

backed ported code from version 15 to 14. needs a build made and testing

Search Tips

Aqua Data Studio / nhilam

IBM DB2 UDB 10.5 Session Manager - No authorized routine named "SNAPSHOT_APPL"

1 attachment

Issue #11923

Completion

3 issue links

Issue #5083

Issue #12000

Issue #12864

Search Tips

Aqua Data Studio / nhilam

Title

IBM DB2 UDB 10.5 Session Manager - No authorized routine named "SNAPSHOT_APPL"

1 attachment

Issue #11923

Completion

3 issue links

Issue #5083

Issue #12000

Issue #12864