Qsys2.systables

0 views

Skip to first unread message

Muriel Trettin

unread,

Aug 5, 2024, 2:04:34 AM8/5/24

to garosige

Ihave exactly the same situation with DB2 (version V5R4M0) in AS400. Database includes more than 100 schemas, but Toad Data Point 4.0 Trial shows only 12 of them. Filters are applied only to displayed schemas. Could you please advice any possible solution of this issue?

Here is screenshot with query counting schemas quantity (query to display them - select distinct table_schema from qsys2.systables). In Object explorer only 12 of them are available, but query returns 189 schemas. I thought it could be a profile issue, but in iSeries Navigator all schemas are available to my user profile.