All Questions
6 questions
0
votes
1
answer
734
views
Creating a dynamic db2 reorg script with in-built delay for concurrency
So I'm new to db2, and some of the syntax and other execution restrictions give me trouble. My DB is using DB2 v11.1.2.2. I've created a reorg script which calls the REORGCHK_TB_STATS and ...
0
votes
1
answer
1k
views
How do I get DBeaver to do a DB2 UPDATE via Cursor
The following query works when run from the console via db2 command. But fails when running via DBeaver.
BEGIN NOT ATOMIC
FOR R AS C CURSOR WITH HOLD FOR
SELECT ROW_NUMBER() OVER() AS INDEX, ID
...
0
votes
2
answers
332
views
Overview of leaked/unclosed cursors/statements on DB2 LUW server?
We're encountering a "too many open cursors issue" on DB2/LUW.
Is there any way to get a (database-server-side) list of the corresponding SELECT statements related to these open cursors?
We're doing ...
3
votes
1
answer
938
views
DB2 Dynamic Load from cursor
We have to load a number of huge tables using Load From cursor. The query formed for the same is a dynamic query as the column names are to be specified. we do the same using the below code in a ...
1
vote
1
answer
2k
views
DB2 : Load from cursor Dynamic query
We need to move multiple tables using Load from cursor. But the number columns in the source and destination tables are not the same.
Also the tables structures can change so we need the same to ...
2
votes
1
answer
13k
views
How to loop through AS400 table with cursor
I have a AS400 table that contains multiple rows per person. Each row contains data concerning a transaction by the person including points assigned to each transaction. I read through all rows for ...