Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Team-Replicate
Contributor
Contributor

How is the value orig_db_id determined?

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

 
Labels (1)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist III
Specialist III

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

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

 

 

View solution in original post

3 Replies
Heinvandenheuvel
Specialist III
Specialist III

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

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

 

 

Team-Replicate
Contributor
Contributor
Author

Hello,

Thank you very much. That was very helpful.

 

JamieKay
Contributor II
Contributor II

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