NonSys tables in DSNDB06 tablespaces?

cliff boley

NonSys tables in DSNDB06 tablespaces?
Hi all,
I came across something that I'm a little puzzled over.
I found 2987 tables in my the SYSDBAUT tablespace other than the two I
expected to find (SYSDATABASE & SYSDBAUTH).

Did DB2 put them in there? if so what are they there for?
else
Can I drop them? and/or do I need to slap my DBAs around for creating them?
(should I slap myself around for authorizing CREATE in the system catalog)?

cliff:-)



Kirk Hampton

Re: NonSys tables in DSNDB06 tablespaces?
(in response to cliff boley)
Those table entries assigned to SYSDBAUT are probably Aliases
(TYPE column in SYSTABLES = 'A'). If so, yes, DB2 put them there.
If not, then you or one of your DBA's would need to be slapped for putting
user tables in a catalog tablespace.






Cliff Boley <[login to unmask email]>@LISTSERV.YLASSOC.COM> on
12/31/2002 12:42:44 PM

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: NonSys tables in DSNDB06 tablespaces?


Hi all,
I came across something that I'm a little puzzled over.
I found 2987 tables in my the SYSDBAUT tablespace other than the two I
expected to find (SYSDATABASE & SYSDBAUTH).

Did DB2 put them in there? if so what are they there for?
else
Can I drop them? and/or do I need to slap my DBAs around for creating them?
(should I slap myself around for authorizing CREATE in the system catalog)?

cliff:-)



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can





**********************************************************************************
Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.
**********************************************************************************