python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - db2-luw

Db2 rollforward "to end of backup" vs. "to end of logs"?

On Db2 Enterpise Server Edition v11.1 single patitioned database on Linux/Intel using LOGARCHMETH1 I executed backup and restore commands: db2 "backup database mydb online to /path/to/backup incl...
test-img

folow

db2

database-backups

db2-luw

database-restore

roll-forward

Votes: 0

Answers: 2

Latest Answer

to end of backup and stop: it will apply only the transaction logs backuped during the online backup (it will apply only the log generated during the backup to have a coherent database). to end of log...
test-img

mshabou

creating sql function implemented in java via flyway

I'm trying to create a function like: --#SET TERMINATOR @ CREATE OR REPLACE FUNCTION NYA.QUINT_2_UINT( I VARCHAR(11)) RETURNS INTEGER RETURNS NULL ON NULL INPUT FENCED THREADSAFE DETERMINISTIC...
test-img

Lennart - Slava Ukraini

db2

flyway

db2-luw

Votes: 0

Answers: 1

Latest Answer

I think I have found what caused the problem, atleast I can now create the function without a problem. The root cause is that Flyway appears to: SET CURRENT_SCHEMA = <variable assigned via property...
test-img

Lennart - Slava Ukraini

DB2 Update cursor issue

Whats wrong with the below cursor. It works well with oracle, but with db2 gives error "The FOR UPDATE clause is not allowed because the table specified by the cursor cannot be modified.. SQLCODE...
test-img

stacky

db2

db2-luw

Votes: 0

Answers: 1

Latest Answer

Did you look up the error message? On the database manager, the result table is read-only if the cursor is based on a VALUES statement or the SELECT statement contains any of the following: The DIST...
test-img

Charles

DB2 LUW MERGE using same table to update a different row

My table data looks like this My poorly attempted SQL is this... MERGE INTO PRINT target USING ( select ID,PDF_FILE from PRINT where date(PRINTED) = '2022-01-06' and PD...
test-img

simadams3

sql

merge

db2-luw

Votes: 0

Answers: 1

Latest Answer

The idea is to enumerate target rows and update only the 1-st one. MERGE INTO ( SELECT ID, PDF_FILE, ROW_NUMBER () OVER (PARTITION BY ID ORDER BY PRINTED DESC) AS RN_ FROM PRINT WHERE -- Below is an...
test-img

Mark Barinstein

Posts

Questions

Blogs

Jobs