db2 connect to dbmon user inst1 using inst1

   Database Connection Information

 Database server        = DB2/6000 8.2.7
 SQL authorization ID   = INST1
 Local database alias   = DBMON


2.  current schema 조회 - connect 한 계정

db2 "select current schema from sysibm.sysdummy1"

1                                                                                                                              
--------------------------------------------------------------------------------------------------------------------------------
INST1                                   


3. 테이블 생성시 current schema(INST1)가  테이블 스키마(owner) 가 됨 
   
db2 "create table t1 (c1 int)"

db2 list tables for all | grep T1
T1                              INST1           T     2008-04-08-15.13.10.335290

   INST1.T1, INST2.T1, INST3.T1 이라는 테이블이 있을때 select * from t1 으로 조회를 한다면 
   current schmea 가 INST1 이므로 3개의 테이블 중 INST1.T1 테이블을 조회 함 


4. 더미 테이블인 sysibm.sysdummy1에는 한건의 데이터가 들어있습니다.

db2 "select * from sysibm.sysdummy1"

IBMREQD
-------
Y  

5. SQL0551N   -  does not have the privilege to perform operation "SELECT"  
   - 말 그대로 mins 계정이 sysibm.sysdummy1테이블에 대해 select 권한이 없는 경우 입니다. 
     테이블에 select 권한을 주려면 
     db2 "grant select on sysibm.sysdummy1 to mins" 


6. current schema 변경 방법 
   - db2 "grant select on sysibm.sysdummy1 to db2inst2"
   - db2 "select current schema from sysibm.sysdummy1"

1                                                                                                                              
--------------------------------------------------------------------------------------------------------------------------------
INST2