IBM DB2 UDB 10.5 Security -> Create Groups, Roles and Users gives SqlSyntaxErrorException
1. Navigate to DB2 UDB 10.5 Security Node
2. Try to Create a Group, User or Role
3. Once the Visual Editor for Create appears, under view error log following exception is noted
com.ibm.db2.jcc.am.SqlSyntaxErrorException: No authorized routine named "SNAPSHOT_TBS_CFG" 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 \\...\\ .\\हिñçêČάй語简�?한\\.eꀒꍐ⣪ᠩ double throw.G(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.eꀒꍐ⣪ᠩ double throw.ab(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.jꉴꋈ⠅ꎬ.j(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.G᠂ꑫ⡎ꇼ 5.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.G᠂ꑫ⡎ꇼ 5.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.kꌹꏥꂓ⣾ assert.di(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I̿ꃙᝃꁬ void char.success(Unknown Source)
at com.common.ui.util.BackgroundThread$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
extraction fixed... SNAPSHOT_TBS_CFG has been removed. As of 10.5 we are using SYSIBMADM.SNAPTBSP_PART system view to extract the data parts