Dear Firends,

I know that all the catalog tables available in SYSIBM.*

What is catalog tables? SYSIBM is the catalog database. Is it true?

Now is it possible to create/catalog user defined tables in SYSIBM database.

Is yes, pelase explain how? thans in advance. Sorry for my english. i am a new bie.

SYSIBM is a schema - every (DB2 LUW) database has its own set of catalog tables. (In DB2 zOS its one set of catalog tables per instance - "database" has a very different meaning.) These tables are used to store a variety of system related information, including definitions of items created by users. Apart from some specialised information, no information in them is stored by INSERT or UPDATE statements.

Why would you want to create your own catalog tables? What do you intend to store in them?

James Campbell

No, that's an interview question.

They have asked me:

"Is it possible to create/catalog your own table in SYSIBM database."

In that case the correct answer is "I don't know".

James Campbell