Skip to Main Content
Digital Business Automation Ideas


This is an IBM Automation portal for Digital Business Automation products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Please use the following category to raise ideas for these offerings for all environments (traditional on premises, containers, on cloud):
  • Cloud Pak for Automation - including Business Automation Studio, Business Automation Insights

  • Business Automation Workflow (BAW) - including BAW, Business Process Manager, Workstream Services, Business Performance Center, Advanced Case Management

  • Content and Capture Services - including Filenet, Automation Document Processing, Daeja, Navigator, Content Collector, Enterprise Records, Business Automation Content Analyzer, Datacap, Automation Mobile Capture, Content Manager OnDemand, IBM Content Manager

  • Automation Decision Services (ADS) - including ADS, Operational Decision Manager

  • Robotic Process Automation

  • Robotic Process Automation with Automation Anywhere

  • IBM Blueworks Live


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.


Status Future consideration
Created by Guest
Created on Apr 3, 2019

lower() DB function renders idex on LSW_BPD_INSTANCE ineffective

Description of the issue; we started seeing “SQLCODE=-905, SQLSTATE=57014”. At that time, process instance creation was successful but all fetch operation failed. See ticket number - TS002094734; this ticket number failed the PMR validation above.

[3/28/19 15:57:10:482 EDT] 0000dedf ProgrammaticT W CWLLG2103W: The retry limit of 5 was exceeded in ProgrammaticTransactionSupport.
[3/28/19 15:57:10:483 EDT] 0000dedf wle E CWLLG2229E: An exception occurred in an EJB call. Error: PreparedStatementCallback; SQL [
SELECT i.EXECUTION_STATUS, COUNT(*) AS INSTANCE_COUNT
FROM LSW_BPD_INSTANCE i
WHERE LAST_MODIFIED_DATETIME<=? AND
(lower(i.INSTANCE_NAME) LIKE ? ESCAPE '\')
GROUP BY i.EXECUTION_STATUS
WITH UR
]; DB2 SQL Error: SQLCODE=-905, SQLSTATE=57014, SQLERRMC=ASUTIME;000000000007;000000500000;SYSTEM PARAMETER, DRIVER=4.21.29; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-905, SQLSTATE=57014, SQLERRMC=ASUTIME;000000000007;000000500000;SYSTEM PARAMETER, DRIVER=4.21.29
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [
SELECT i.EXECUTION_STATUS, COUNT(*) AS INSTANCE_COUNT
FROM LSW_BPD_INSTANCE i
WHERE LAST_MODIFIED_DATETIME<=? AND
(lower(i.INSTANCE_NAME) LIKE ? ESCAPE '\')

GROUP BY i.EXECUTION_STATUS
WITH UR
]; DB2 SQL Error: SQLCODE=-905, SQLSTATE=57014, SQLERRMC=ASUTIME;000000000007;000000500000;SYSTEM PARAMETER, DRIVER=4.21.29; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-905, SQLSTATE=57014, SQLERRMC=ASUTIME;000000000007;000000500000;SYSTEM PARAMETER, DRIVER=4.21.29
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105)
.
.
.
[3/28/19 15:57:10:485 EDT] 0000dedf RestHelper W Unexpected database exception
com.lombardisoftware.core.TeamWorksException: Unexpected database exception
at com.ibm.bpm.rest.util.RestHelper.getExceptionResponse(RestHelper.java:473)
at com.ibm.bpm.rest.util.RestHelper.getExceptionResponse(RestHelper.java:444)
at com.ibm.bpm.rest.impl.process.ProcessesResource.getProcessInstances(ProcessesResource.java:1579)
at sun.reflect.GeneratedMethodAccessor935.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)

Workaround:
Up DB2 SQL CPU allotment from 7 seconds to 32 seconds. The above query now runs within 32 seconds but that is not acceptable.

Recommendation By DB2 DBA:

I would get them to fix the app so the lower() function wasn't necessary.
Barring that, add column function to the table and place that column in an index. Expression on index became available in db2 v10.
Create index xxxxx on LSW_BPD_INSTANCE (LAST_MODIFIED_DATETIME, lower(i.INSTANCE_NAME, execution_status)
So this would be my recommendation for ibm to add to the product.
SELECT i.EXECUTION_STATUS, COUNT(*) AS INSTANCE_COUNT
FROM LSW_BPD_INSTANCE i
WHERE LAST_MODIFIED_DATETIME<=? AND
(lower(i.INSTANCE_NAME) LIKE ? ESCAPE '\')
GROUP BY i.EXECUTION_STATUS

Idea priority High
RFE ID 131706
RFE URL
RFE Product IBM Business Process Manager