New answers tagged


Per @mustachhio's comment, the tool I was looking for was VisualExplain in the System i Navigator.


In Db2 for z/OS this information is in the DEFAULT column of the SYSIBM.SYSCOLUMNS catalog table. In your case the value you'll be looking for is 'E'.


Select privileges on all SYSCAT objects are granted by default to the PUBLIC pseudo-group (unless the database is created as "restrictive"), so you shouldn't have ended up with users not being able to access syscat.schemata unless you or someone before you chose to actively prevent that. What could go "wrong"? Users will be able to ...

Top 50 recent answers are included