Question on OWNER in DB2



IBM's flagship relational database management system

Question on OWNER in DB2

Postby fornanthakumar » Thu Jan 24, 2013 10:08 am

Hi,

Good Day.

1. We have owner IBIS for our database IBIS. Mostly we refer the table as IBIS.TABLE_NAME. Hence what is mean by OWNER , is it called SCHEMA ? What is the difference between OWNER and SCHEMA ?

2. In my BIND Parameter, if i mention OWNER(IBIS) then is it necessary i should refer the table as IBIS.TABLE_NAME in the program or is it enough to mention only the table name. ?

3. What is SYSIBM means if i refer table SYSIBM.SYSTABLESPACE ?
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post