Cette requête SQL permet de mettre en évidence les différences de niveaux entre 2 bibliothèques : SELECT
a.SYSTEM_TABLE_NAME as fichier,
a.SYSTEM_TABLE_SCHEMA as bib1, a.FORMAT_LEVEL_ID as niv1,
b.SYSTEM_TABLE_SCHEMA as bib2, b.FORMAT_LEVEL_ID as niv2,
(a.FORMAT_LEVEL_ID <> b.FORMAT_LEVEL_ID) as upgraded
FROM sysfiles a , sysfiles b
WHERE
a.system_table_schema = 'MABIB1' and
b.system_table_schema = 'MABIB2' and
a.native_type = 'PHYSICAL' and
a.SYSTEM_TABLE_NAME = b.SYSTEM_TABLE_NAME

Pour n’afficher que les fichiers qui ont changé de niveau :SELECT
a.SYSTEM_TABLE_NAME as fichier,
a.SYSTEM_TABLE_SCHEMA as bib1, a.FORMAT_LEVEL_ID as niv1,
b.SYSTEM_TABLE_SCHEMA as bib2, b.FORMAT_LEVEL_ID as niv2
FROM sysfiles a , sysfiles b
WHERE
a.system_table_schema = 'MABIB1' and
b.system_table_schema = 'MABIB2' and
a.native_type = 'PHYSICAL' and
a.SYSTEM_TABLE_NAME = b.SYSTEM_TABLE_NAME and
a.FORMAT_LEVEL_ID <> b.FORMAT_LEVEL_ID
