topic Re: How is the value orig_db_id determined? in Qlik Replicate

How is the value orig_db_id determined?

Team-Replicate — Fri, 09 Feb 2024 08:35:50 GMT

Hello,

the value orig_db_id is determined.

Source: db2 LUW 11.5.8 and newer

In the dump of dynamic_metadata.sqlite, for example:

{

"name": "XX_XXXXXXXXXXXXXXXXXXXX",

"owner": "XXXXXXXXXXXXXXXXXXXXXX",

"id": 1,

"orig_db_id": 2359394,

"version": 1,

In the database, the table:

TABLEID: 98

TABSPACEID: 36

In the past, according to my observations, it was the combination of the hex values of the two values. This seems to have changed.
Do you have a hint for me?

Thank you very much

Re: How is the value orig_db_id determined?

Heinvandenheuvel — Fri, 09 Feb 2024 09:23:14 GMT

perl -e "printf q(%2x%04x %x), 36, 98, 2359394
240062 240062

perl -e "printf q(%d %d), 2359394 / 0x10000, 2359394 % 0x10000
36 98

Re: How is the value orig_db_id determined?

Team-Replicate — Fri, 09 Feb 2024 09:47:54 GMT

Hello,

Thank you very much. That was very helpful.

Re: How is the value orig_db_id determined?

JamieKay — Tue, 11 Mar 2025 15:17:10 GMT

Is there a way to determine this using SQL on the database itself? I don't have access to the db server.

Thanks!

Jamie Kay