Skip to Content
0
Feb 26, 2007 at 11:33 AM

Schema-Concept issues

29 Views

Dear all,

playing around with the implmentation of the schema concept in MaxDB 7.6.01 Build 10 I came acrosse some oddities.

1. There are still tables without a schemaname assigned in the catalog while many of the catalog-tables do have a schemaname.

This looks inconsistent to me.

select owner, schemaname, tablename from tables where owner='SUPERDBA'

OWNER;SCHEMANAME;TABLENAME
[...]
SUPERDBA;SUPERDBA;DBAN_NUM_HISTORY_PAGES
SUPERDBA;SUPERDBA;DBAN_NUM_REGION_WAITERS
SUPERDBA;SUPERDBA;DBAN_NUM_RUNNABLE_USERTASKS
SUPERDBA;SUPERDBA;DBAN_NUM_RUNNABLE_US_P_UKT
SUPERDBA;SUPERDBA;DBAN_NUM_RUNNING_USERTASKS
SUPERDBA;SUPERDBA;DBAN_NUM_TABS_FEW_SAMPLE_ROWS
SUPERDBA;SUPERDBA;DBAN_NUM_TRACES_ACTIVATED
SUPERDBA;SUPERDBA;DBAN_NUM_VBEGEXCL_USERTASKS
SUPERDBA;SUPERDBA;DBAN_NUM_VWAIT_USERTASKS
SUPERDBA;SUPERDBA;DBAN_REGION_BLOCKERS_AR
[...]
SUPERDBA;;ACTIVECONFIGURATION
SUPERDBA;;ALLOCATORSTATISTIC
SUPERDBA;;ALL_CATALOG
SUPERDBA;;ALL_COL_COMMENTS
SUPERDBA;;ALL_COL_PRIVS
SUPERDBA;;ALL_COL_PRIVS_MADE
[...]

2. It does not seem to be clear to the MaxDB who is the owner of tables that belong to a schema which is NOT names after the user who owns that schema:

select owner, schemaname, tablename from tables where owner='MONA'
  - No result

select owner, schemaname, tablename from tables where schemaname='HOTEL'

OWNER;SCHEMANAME;TABLENAME
MONA;HOTEL;CITY
MONA;HOTEL;CUSTOMER
MONA;HOTEL;CUSTOMER_ADDR
MONA;HOTEL;CUSTOM_HOTEL
MONA;HOTEL;EMPLOYEE
MONA;HOTEL;HOTEL
MONA;HOTEL;HOTEL_ADDR
MONA;HOTEL;RESERVATION
MONA;HOTEL;ROOM

but:

select owner, schemaname from schemas where owner='MONA'
OWNER                            | SCHEMANAME                       |
-------------------------------- | -------------------------------- |
MONA                             | MONA                             |
MONA                             | HOTEL                            |

Please clarify what's wrong here.

Thanks and best regards,

Lars