1. How to describe the definition of table from DB2 database?
ie. equal to "desc <table_name>" in Oracle env.
2. How can i found the owner information of a table?
3. Any good reference for studying "sysibm" and "syscat" schemas?
The two schemas contain many database internal information, such as the name of tablspaces, auit setting, schema setting, etc. How can we check it and What actually information can be found by using sysibm and syscat schemas?
Thanks, just a little bit followup of the second question.
do you mean, schema name = owner of the tables?
If yes, I would like to clarify that who will be the owner of tables if the table is under a schema which is not the same as the username.
(eg. a "schema.tablename" table was create by db2_inst1 user while there is no user which is called "schema".)
Then how can we check the owner of the table if we dont know such table was created by db2_inst1 user.