× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tomconrad reported 2021-08-23T14:27:27Z  · last modified 2021-08-23T14:27:27Z

Case #00904989 - SYSPROC schema not available in ADS


Priority Minor
Complexity Unknown
Component DB - DB2 zOS
Version Future

User is reporting that Aqua Data Studio doesn’t show SYSPROC under schemas, so they are missing access to all the stored procs in that schema. 

 

We ran the SQL log in the schema tree and this is the query that resulted:

 

select
distinct schema as schema
from
sysibm.sysdatatypes
union
select
distinct OWNER
from
sysibm.SYSPACKAGE
union
select
distinct CREATOR
from
sysibm.SYSPLAN
union
select
distinct SCHEMA
from
sysibm.SYSSEQUENCES
union
select
distinct creator
from
sysibm.SYSSTOGROUP
union
select
distinct CREATOR
from
sysibm.SYSTABLESPACE
union
select
distinct creator as schema
from
sysibm.systables
union
select
distinct creator as schema
from
sysibm.sysviews
union
select
distinct creator as schema
from
sysibm.sysindexes
union
select
distinct owner as schema
from
sysibm.systriggers
union
select
distinct owner as schema
from
sysibm.sysroutines
order by 1

User also recommended using the following query:

SELECT DISTINCT SCHEMA FROM SYSIBM.SYSROUTINES

 

Issue #15868

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017