Db2

Hi,

I have configured correctly my databases in the console, and I am currently viewing information in the different graphs. However, when looking at the different logs, I got this:

monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:exc =
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:Mymon MonitorCollectorRunnable::run: Monitor collector MonitorMetric{decription_name='null', isEventMonitorSetup=f alse, keep_result_for_mseconds=2419200000, isPersistIntoRepository=true, isCollect=true, metric_name='Utilities', order=0, propertis={numberlimitation=true, keepinmemory=660000, isopenedforcollect=true}} failed.
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy318.collect100504(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect110100(CommonDAO.java:163)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect110100(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect_version(CommonDAO.java:151)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect_version(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect(CommonDAO.java:31)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect(Unknown Source)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.collect(MonitorCollectorConsumer.java:669)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.run(MonitorCollectorConsumer.java:321)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:818)
Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at com.ibm.db2.jcc.am.b7.a(b7.java:800)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.ResultSet.completeSqlca(ResultSet.java:4266)
at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(ResultSet.java:4248)
at com.ibm.db2.jcc.t4.ab.a(ab.java:1642)
at com.ibm.db2.jcc.t4.ab.q(ab.java:1607)
at com.ibm.db2.jcc.t4.ab.l(ab.java:738)
at com.ibm.db2.jcc.t4.ab.d(ab.java:112)
at com.ibm.db2.jcc.t4.p.c(p.java:44)
at com.ibm.db2.jcc.t4.av.j(av.java:162)
at com.ibm.db2.jcc.am.k4.an(k4.java:2256)
at com.ibm.db2.jcc.am.k5.a(k5.java:4666)
at com.ibm.db2.jcc.am.k5.b(k5.java:4182)
at com.ibm.db2.jcc.am.k5.bg(k5.java:2880)
at com.ibm.db2.jcc.am.k5.execute(k5.java:2855)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 37 more

I do not know why I am getting a credential problem, if it is currently showing data.

------------------------------
Andres Gomez Casanova
IBM Champion 2015-2020
DBA senior
Bogota, Colombia
------------------------------

#Db2

Hello Andres,

Thank you for reporting this issue.  We need to investigate more first before getting back to you on the cause.

------------------------------
Jason Sizto
------------------------------

Original Message:
Sent: Thu June 04, 2020 04:14 PM
From: Andres Gomez Casanova
Subject: Security processing failed with reason "15" ("PROCESSING FAILURE")

Hi,

I have configured correctly my databases in the console, and I am currently viewing information in the different graphs. However, when looking at the different logs, I got this:

monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:exc =
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:Mymon MonitorCollectorRunnable::run: Monitor collector MonitorMetric{decription_name='null', isEventMonitorSetup=f alse, keep_result_for_mseconds=2419200000, isPersistIntoRepository=true, isCollect=true, metric_name='Utilities', order=0, propertis={numberlimitation=true, keepinmemory=660000, isopenedforcollect=true}} failed.
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy318.collect100504(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect110100(CommonDAO.java:163)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect110100(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect_version(CommonDAO.java:151)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect_version(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect(CommonDAO.java:31)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect(Unknown Source)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.collect(MonitorCollectorConsumer.java:669)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.run(MonitorCollectorConsumer.java:321)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:818)
Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at com.ibm.db2.jcc.am.b7.a(b7.java:800)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.ResultSet.completeSqlca(ResultSet.java:4266)
at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(ResultSet.java:4248)
at com.ibm.db2.jcc.t4.ab.a(ab.java:1642)
at com.ibm.db2.jcc.t4.ab.q(ab.java:1607)
at com.ibm.db2.jcc.t4.ab.l(ab.java:738)
at com.ibm.db2.jcc.t4.ab.d(ab.java:112)
at com.ibm.db2.jcc.t4.p.c(p.java:44)
at com.ibm.db2.jcc.t4.av.j(av.java:162)
at com.ibm.db2.jcc.am.k4.an(k4.java:2256)
at com.ibm.db2.jcc.am.k5.a(k5.java:4666)
at com.ibm.db2.jcc.am.k5.b(k5.java:4182)
at com.ibm.db2.jcc.am.k5.bg(k5.java:2880)
at com.ibm.db2.jcc.am.k5.execute(k5.java:2855)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 37 more

I do not know why I am getting a credential problem, if it is currently showing data.

------------------------------
Andres Gomez Casanova
IBM Champion 2015-2020
DBA senior
Bogota, Colombia
------------------------------

#Db2

Hello Andres,
I did some research, and I have found the following Db2 Technote:
https://www.ibm.com/support/pages/connection-error-sql30082n-return-code-15-connecting-database
Have you tried this?

------------------------------
Cintia Ogura
------------------------------

Original Message:
Sent: Thu June 04, 2020 04:14 PM
From: Andres Gomez Casanova
Subject: Security processing failed with reason "15" ("PROCESSING FAILURE")

Hi,

I have configured correctly my databases in the console, and I am currently viewing information in the different graphs. However, when looking at the different logs, I got this:

monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:exc =
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:Mymon MonitorCollectorRunnable::run: Monitor collector MonitorMetric{decription_name='null', isEventMonitorSetup=f alse, keep_result_for_mseconds=2419200000, isPersistIntoRepository=true, isCollect=true, metric_name='Utilities', order=0, propertis={numberlimitation=true, keepinmemory=660000, isopenedforcollect=true}} failed.
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy318.collect100504(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect110100(CommonDAO.java:163)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect110100(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect_version(CommonDAO.java:151)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect_version(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect(CommonDAO.java:31)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect(Unknown Source)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.collect(MonitorCollectorConsumer.java:669)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.run(MonitorCollectorConsumer.java:321)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:818)
Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at com.ibm.db2.jcc.am.b7.a(b7.java:800)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.ResultSet.completeSqlca(ResultSet.java:4266)
at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(ResultSet.java:4248)
at com.ibm.db2.jcc.t4.ab.a(ab.java:1642)
at com.ibm.db2.jcc.t4.ab.q(ab.java:1607)
at com.ibm.db2.jcc.t4.ab.l(ab.java:738)
at com.ibm.db2.jcc.t4.ab.d(ab.java:112)
at com.ibm.db2.jcc.t4.p.c(p.java:44)
at com.ibm.db2.jcc.t4.av.j(av.java:162)
at com.ibm.db2.jcc.am.k4.an(k4.java:2256)
at com.ibm.db2.jcc.am.k5.a(k5.java:4666)
at com.ibm.db2.jcc.am.k5.b(k5.java:4182)
at com.ibm.db2.jcc.am.k5.bg(k5.java:2880)
at com.ibm.db2.jcc.am.k5.execute(k5.java:2855)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 37 more

I do not know why I am getting a credential problem, if it is currently showing data.

------------------------------
Andres Gomez Casanova
IBM Champion 2015-2020
DBA senior
Bogota, Colombia
------------------------------

#Db2

Hello Andres,

I would like to follow up if you are still seeing this issue.  If so, can you check the connection profile that is complaining about this error?  What is the security mechanism set for the JCC Connection?  Thanks.

------------------------------
Jason Sizto
------------------------------

Original Message:
Sent: Thu June 04, 2020 04:14 PM
From: Andres Gomez Casanova
Subject: Security processing failed with reason "15" ("PROCESSING FAILURE")

Hi,

I have configured correctly my databases in the console, and I am currently viewing information in the different graphs. However, when looking at the different logs, I got this:

monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:exc =
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:Mymon MonitorCollectorRunnable::run: Monitor collector MonitorMetric{decription_name='null', isEventMonitorSetup=f alse, keep_result_for_mseconds=2419200000, isPersistIntoRepository=true, isCollect=true, metric_name='Utilities', order=0, propertis={numberlimitation=true, keepinmemory=660000, isopenedforcollect=true}} failed.
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
### The error may exist in com/ibm/aps/tools/monitor/collector/mybatis/mapper/UtilitiesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.dbpartitionnum , u.utility_id , u.utility_type , (u.utility_start_time - current timezone) as utility_start_time_timestamp , (p.progress_start_time - current timezone) as progress_start_tim e_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , null as reorg_end_timestamp , p.utility_state , u.utility_invoker_type , null as tabschema , null as tabname , null as dat a_partition_id , null as indschema , null as indname , null as reorg_type , u.utility_priority , null as reorg_phase , case when progress_total_units > 0 then (progress_completed_units * 100.0) / progress _total_units else null end as estimated_percent_complete , p.progress_completed_units , null as reorg_rowscompressed , null as reorg_rowsrejected , null as reorg_completion , p.progress_total_units , p.pro gress_description as progress_description , p.progress_work_metric , p.progress_seq_num --, u.progress_list_attr --, u.progress_list_cur_seq_num , u.object_type , u.object_schema , u.object_name , u.appli cation_name , u.application_handle from table(mon_get_utility(-2)) u left outer join table(snap_get_util_progress()) p on u.utility_id = p.utility_id and u.member = p.member -- where u.utility_dbname = curr ent server where u.utility_type!='REORG' union all select r.dbpartitionnum , u.utility_id , 'REORG' as utility_type , (r.reorg_start - current timezone) as utility_start_time_timestamp , (r.reorg_phase_sta rt - current timezone) as progress_start_time_timestamp , varchar(substr2(u.utility_detail, 0, 2048)) as utility_description , (r.reorg_end - current timezone) as reorg_end_timestamp , r.reorg_status as utilit y_state , u.utility_invoker_type , r.tabschema as tabschema , r.tabname as tabname , r.data_partition_id , i.indschema as indschema , i.indname as indname , r.reorg_type , u.utility_priority , r.reorg_ph ase , case when r.reorg_max_counter > 0 then 100.0 * float(r.reorg_current_counter) / float(r.reorg_max_counter) when r.reorg_status = 'COMPLETED' then float(100) else float(0) end as estimated_percent_co mplete , null as progress_completed_units , r.reorg_rowscompressed , r.reorg_rowsrejected , case when r.reorg_end is null then null else r.reorg_completion end as reorg_completion , null as progress_tot al_units , null as progress_description , null as progress_work_metric , null as progress_seq_num --, null as progress_list_attr --, null as progress_list_cur_seq_num , u.object_type , u.object_schema , u .object_name , u.application_name , u.application_handle from table(snap_get_tab_reorg(null,-2)) r left outer join table(mon_get_utility(-2)) u on u.object_schema=r.tabschema and u.object_name=r.tabname and u.member = r.member and u.utility_type='REORG' left outer join syscat.indexes i on i.tabschema=r.tabschema and i.tabname=r.tabname and i.iid=r.reorg_index_id
### Cause: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy318.collect100504(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect110100(CommonDAO.java:163)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect110100(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect_version(CommonDAO.java:151)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect_version(Unknown Source)
at com.ibm.aps.tools.monitor.base.dao.CommonDAO.collect(CommonDAO.java:31)
at java.lang.invoke.ReceiverBoundHandle.invokeExact_thunkArchetype_L(ReceiverBoundHandle.java:170)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.InvokeGenericHandle.invokeExact_thunkArchetype_X(InvokeGenericHandle.java:88)
at java.lang.invoke.SpreadHandle.invokeExact_thunkArchetype_X(SpreadHandle.java:100)
at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:483)
at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy318.collect(Unknown Source)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.collect(MonitorCollectorConsumer.java:669)
at com.ibm.aps.tools.monitor.collector.consumer.MonitorCollectorConsumer.run(MonitorCollectorConsumer.java:321)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:818)
Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: Security processing failed with reason "15" ("PROCESSING FAILURE").. SQLCODE=-30082, SQLSTATE=08001, DRIVER=4.26.14
at com.ibm.db2.jcc.am.b7.a(b7.java:800)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.ResultSet.completeSqlca(ResultSet.java:4266)
at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(ResultSet.java:4248)
at com.ibm.db2.jcc.t4.ab.a(ab.java:1642)
at com.ibm.db2.jcc.t4.ab.q(ab.java:1607)
at com.ibm.db2.jcc.t4.ab.l(ab.java:738)
at com.ibm.db2.jcc.t4.ab.d(ab.java:112)
at com.ibm.db2.jcc.t4.p.c(p.java:44)
at com.ibm.db2.jcc.t4.av.j(av.java:162)
at com.ibm.db2.jcc.am.k4.an(k4.java:2256)
at com.ibm.db2.jcc.am.k5.a(k5.java:4666)
at com.ibm.db2.jcc.am.k5.b(k5.java:4182)
at com.ibm.db2.jcc.am.k5.bg(k5.java:2880)
at com.ibm.db2.jcc.am.k5.execute(k5.java:2855)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 37 more

I do not know why I am getting a credential problem, if it is currently showing data.

------------------------------
Andres Gomez Casanova
IBM Champion 2015-2020
DBA senior
Bogota, Colombia
------------------------------

#Db2