DB2 list schemas of a database

11 July,2011 by Jack Vamvas

"How to do a DB2 list schemas ?"

 Step 1 – Connect to the database

db2 connect to my_database

 Step 2 – Execute this query

select schemaname from syscat.schemata

 

If you want to connect to another schema - read DB2 SET CURRENT SCHEMA

The recordset is something like :

 Db2 list schemas

 

Read More

DB2 SET CURRENT SCHEMA - DBA DB2

ADMIN_DROP_SCHEMA to drop a schema - DBA DB2

how to grant select privileges on all tables for DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 list schemas of a database

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright