DB2 database schema introspection does not work on some schemas Follow

Answered

Created April 06, 2022 15:41

I'm using PyCharm Pro 2021.3.2 on Windows 10. I'm connected to a IBM Db2 LUW (ver. 11.1.46) database.

I've selected two schemas, FMSTPWEB and OMB. FMSTPWEB shows nothing under the schema.

I've refreshed the connection several times. I can query FMSTPWEB, and when I run this query I do get a list of tables:

select
       tabname,
       type,
       trim(base_tabschema) as base_tabschema,
       base_tabname,
       partition_mode,
       tableorg,
       clustered,
       pctfree,
       remarks
from syscat.tables
where tabschema = 'FMSTPWEB'

Why do I see nothing under the FMSTPWEB schema?

10 comments

Yuriy Vinogradov

Created April 07, 2022 10:19

Please right-click on schema -> Diagnostic -> Diagnostic refresh and upload received file here and provide me with upload id. also please include IDE log from help -> Collect logs and diagnostic data menu.

Luisdelatorre012

Created April 07, 2022 13:38

Thanks Yuriy. Upload ID is 2022_04_07_hJEHcFiRMWuG6RpC

Yuriy Vinogradov

Created April 07, 2022 15:12

Please right-click on data source -> Database tools -> Force refresh, wait until process finishes and let me know the results.

Luisdelatorre012

Created April 07, 2022 15:18

No change after Force refresh.

Yuriy Vinogradov

Created April 08, 2022 09:08

Please run this query

select
       tabname,
       type,
       trim(base_tabschema) as base_tabschema,
       base_tabname,
       partition_mode,
       tableorg,
       clustered,
       pctfree,
       remarks
from syscat.tables
where tabschema = 'FMSTPWEB'

and show me the result.