Difference between SYSCAT and SYSIBM



IBM's flagship relational database management system

Difference between SYSCAT and SYSIBM

Postby nikesh_rai » Tue Sep 24, 2013 10:58 pm

Hi Guys,

What is the difference b/w SYSCAT and SYSIBM. I have access to see SYSIBM but don't have access for SYSCAT. Where we generally use this SYSCAT. I saw the manual where I found some tables which are common to SYSIBM and SYSCAT both e.g., TABLES, VIEWS, COLUMNS, INDEXES. So do they contain anything different from SYSIBM
Thanks
Nikesh Rai
nikesh_rai
 
Posts: 205
Joined: Tue Oct 18, 2011 1:27 am
Has thanked: 17 times
Been thanked: 0 time

Re: Difference between SYSCAT and SYSIBM

Postby Akatsukami » Tue Sep 24, 2013 11:29 pm

I believe that the SYSIBM schema contains the actual tables, whilst SYSCAT contains read-only views.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Difference between SYSCAT and SYSIBM

Postby nikesh_rai » Wed Sep 25, 2013 7:04 pm

thanks Akatsukami.. :)
Thanks
Nikesh Rai
nikesh_rai
 
Posts: 205
Joined: Tue Oct 18, 2011 1:27 am
Has thanked: 17 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post