DB2 database schema introspection does not work on some schemas

已回答

创建于 2022年04月06日 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 条评论

Yuriy Vinogradov

创建于 2022年04月07日 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

创建于 2022年04月07日 13:38

Thanks Yuriy. Upload ID is 2022_04_07_hJEHcFiRMWuG6RpC

Yuriy Vinogradov

创建于 2022年04月07日 15:12

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

Luisdelatorre012

创建于 2022年04月07日 15:18

No change after Force refresh.

Yuriy Vinogradov

创建于 2022年04月08日 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.