DB2 database schema introspection does not work on some schemas

Answered

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
Avatar
Yuriy Vinogradov
Comment actions Permalink

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.

0
Comment actions Permalink

Thanks Yuriy. Upload ID is 2022_04_07_hJEHcFiRMWuG6RpC 

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

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

0
Comment actions Permalink

No change after Force refresh.

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

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.

0
Comment actions Permalink

Exported the result of the query to CSV and uploaded it. Upload ID 2022_04_08_5BL4nr7Y5JEKehBu

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

Unfortunately we do not support nicknames yet. Please follow and vote for the issue.

0
Comment actions Permalink

Thanks for looking into it.

0
Comment actions Permalink

Hi,

 

Do you think you will support nicknames for a while ?

 

Thank you in advance...

 

Hervé.

0
Comment actions Permalink

I mean, soon !

 

Thanks...

Hervé.

0

Please sign in to leave a comment.