practical DBA month continues with an article by Eddy Coppens on “Comparing Databases

Kurt Struyf

practical DBA month continues with an article by Eddy Coppens on “Comparing Databases

#IDUG ’s practical DBA month continues with an article of Eddy Coppens on “Comparing Databases in #Db2 using #SQL”

 http://www.idug.org/p/bl/ar/blogaid=710

Walter Janißen

AW: practical DBA month continues with an article by Eddy Coppens on “Comparing Databases
(in response to Kurt Struyf)
Hi

Many years ago there was a presentation at IDUG about table-fingerprints. We implemented that idea, which means, we developed an algorithm, basically a sophisticated SQL-statement, which generates a 9-digit-number. We store these numbers for every table for every Db2-subsystem in one central table. This table is updated on a daily basis. So we can easily see, if tables are in all subsytems and if the structure is not different, because if the fingerprint is different in a subsystem, then the table-structure is not the same in all subsystems. If the numbers are equal it is vey likely that the structures are the same. So the result of one of our queries is as follows:

' DTLG DDLG DILG DWLG DPLG DB2F
Qualifier (vom) (vom) (vom) (vom) (vom) (vom)
--------- ---------- ---------- ---------- ---------- ---------- ----------
DB2 214215 214215 214215 214215 214215 -
15.04.2015 16.04.2015 22.04.2015 20.07.2015 25.05.2015

S$00103 - 214215 - - - -
20.01.2016

S$00104 - 214215 - - - -
04.02.2016

S$00111 - 214215 - - - -
11.01.2017

V$00010 214215 214215 - - - -
15.04.2015 17.04.2015

V$00011 214215 214215 - - - -
15.04.2015 17.04.2015


Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Kurt Struyf [mailto:[login to unmask email]
Gesendet: Montag, 15. Januar 2018 15:23
An: [login to unmask email]
Betreff: [DB2-L] - practical DBA month continues with an article by Eddy Coppens on “Comparing Databases


#IDUG ’s practical DBA month continues with an article of Eddy Coppens on “Comparing Databases in #Db2 using #SQL”

http://www.idug.org/p/bl/ar/blogaid=710

-----End Original Message-----
Attachments

  • image001.png (2.6k)