Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

what is the importance of tables in "USERSPACE1" tablespace of CLM application databases? Can they be removed?

What is the importance of the tables created in tablespace "USERSPACE1" in DB2 dB tables for CLM applications?

* Can they be removed?
* A quick test disabling database user access to this tablespace has no negetive impact on RQM application?
Does it mean the application has no issues with this tablespace & tables removed/ deleted?
* What is the use of the tables under "USERSPACE1" tablespace?

Best Regards
Sunil

-------------------------------------- database tablespace / tables ---------------------------------------------------
-------------------------------------- database tablespace / tables ---------------------------------------------------

0 votes

Comments

These tables exist since the RTC 1.0 days.
https://jazz.net/forum/questions/18425/weird-behaviour-during-db2-reorg-for-some-jazz-tables

As the names suggests, they are for "deadlocks", although I don't know the details of how they are used.



One answer

Permanent link
I would not place a big concern on tables in this tablespace in the context of CLM applications.  All other tables are created in other tablespaces and the size of userspace1 containers is likely miniscule relative to the CONTENTTS.

e.g. on an almost tera-byte size CCM database USERSPACE is using

 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 1024
 Useable pages                        = 992
 Used pages                           = 544
 Free pages                           = 448
 High water mark (pages)              = 608
 Page size (bytes)                    = 32768

Which is ~17Mb ( 544 * 32768 )

You can get the information above for your database using:

db2 connect to db
db2 list tablespaces show detail

My recommendation:  do nothing.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495

Question asked: Feb 29 '16, 1:02 p.m.

Question was seen: 5,175 times

Last updated: Feb 29 '16, 6:32 p.m.

Confirmation Cancel Confirm