I want to insert multiple records in a multi-thread function into DB and after inserting a specific amount of records i become always the following exception: Outermost stacktrace: com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000304, AND RESOURCE NAME X’0005AB8C’.X’02’. SQLCODE=-904, SQLSTATE=57011, DRIVER=4.31.10 at com.ibm.db2.jcc.am.b7.a(b7.java:815) at com.ibm.db2.jcc.am.b7.a(b7.java:66) at com.ibm.db2.jcc.am.b7.a(b7.java:140)… Read More com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90096

I was wondering if there is a proper way to check if one entrie contains all values of an other table. The exercise is described as followed: Get market numbers MNUM for markets supplied with at least all vegetables available from c1. This is the table containing all the deliveries. Here I get all the… Read More How to check if a Entrie of Table A, contains all Values of Table B

I have a table that store total account of a product every last day of a month. From that table, I want to calculate how much the account growing in percentage. My table looks like this PERIOD GROUP_PRODUCT ACCOUNT 2022-01-31 DEPOSITO 22860 2022-02-26 DEPOSITO 22848 2022-03-31 DEPOSITO 22555 2022-04-30 DEPOSITO 22297 2022-05-31 DEPOSITO 22281 And… Read More Calculate Growth Percentage Resulting in 0

Determine the max value of an attribute that has values like below, GROUPNAME A-1000 C-1001 A-1002 Expected Output 1002 I tried the below query, and it is giving the output as 1001 instead of 1002, the max value is based on the alphabet rather than the number, select max(groupname) from table where type in (‘A’,’C’)… Read More Find MAX value on ALN field with special characters in DB2

I have two tables: a WEEK_DATE DAY_NUMBER 8/17/2022 1 8/18/2022 2 8/19/2022 3 8/22/2022 4 8/23/2022 5 8/24/2022 6 8/25/2022 7 8/26/2022 8 8/29/2022 9 b START_DATE END_DATE PERSON 8/17/2022 8/18/2022 Jack 8/23/2022 8/29/2022 Jack I am trying to determine the week days that Jack missed, which would look like this: PERSON WEEK_DATE DAY_NUMBER Jack… Read More JOIN tables on a date range, but show the missing dates?

I have some queries which works correctly in PostgreSQL but I have to use them to make IBM DB2 queries. It seems like "FILTER" doesn’t work with DB2. My PGSQL query : SELECT CODACT, SUM(CUMCOL) FILTER(WHERE etasup > 20), SUM(CUMCOL) FROM gesupe WHERE typsup= ‘1’ AND (DATLIV = 20220428 OR DATLIV = 20220429) GROUP BY… Read More Using FILTER in IBM DB2 query

I have data as below Manager City Building Floor Number of Seats xxx BLR SA2 2F 2 xyz BLR SA2 2F 3 xya BLR SA2 3F 2 xjk BLR SA2 3F 1 Resulting data should be as below, grouping by manager or building and floor, need to generate series of number based on the number… Read More how generate a series of numbers by grouping the data in db2 or sql

Please, can someone help me find the SQL statement that select all records in TABLE_A except those whose combination of FIELD_1, FIELD_2 is not present in TABLE_B. (In DB2) >Solution : You can simply use NOT EXISTS: select * from table_a ta where not exists (select * from table_b tb where tb.field_1 = ta.field_1 and… Read More SQL select of records from table A but not in table B