Q&A BY TAG 'DB2'

You must sign in to ask a question. If you do not have an account, you can register here

DB2 enable query acceleration
answered 24-12-2020 01:33:24 -0500

I have a need to connect to DB2 by enabling query acceleration. I followed the IBM docs https://www.ibm.com/support/pages/enabling-query-acceleration-ibm-db2-analytics-accelerator-odbc-and-jdbc-applications-without-modifying-applications To enable qu...

Answers: 1

DB2

DB2 - firstdayofmonth with an Analytical function
answered 14-04-2020 15:25:18 -0400

Database: DB2 I created a view with a date compare in the where clause field1 >= addmonth(firstdayofmonth(current_date()), -2) Then used an analytical function in the same view row_number() OVER ( PARTITION BY field2, field3 ORDER BY field4 DES...

Answers: 1

DB2

DB2 - WITH UR
answered 14-04-2020 15:13:08 -0400

Database: DB2 We are having a performance issue with a query and our DBA suggested to use "With UR" clause at the end of the query. At this time, the view in Denodo is built using the UI and I am not able to add this in where clause and I don't see an...

Answers: 2

DB2

Joining Large Tables
answered 31-01-2020 19:35:22 -0500

There are 11 views in the join. Out of which, six views have rows in the range of 33 to 84 Million. 2 views in the range of 2 to 4 million and the remaining 3 in the range of 220 to 850K rows. It is all simple joins between tables, but due to the size,...

Answers: 1

DB2

DB2 on AS400
answered 18-11-2019 18:02:44 -0500

Connection established to DB2 on AS400 with jt400.jar. Query execution is failing with below error [JDBC ROUTE][ERROR] Received exception with message '(PWS9801) function rejected by user exit rpogram PUSEXTPGM in DPSMLIB The class name to register u...

Answers: 1

DB2

Query Simplification
answered 22-10-2019 09:05:11 -0400

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

Answers: 4

DB2 Query Simplification