Content Manager — DB structure & guides

http://publib.boulder.ibm.com/infocenter/cmgmt/v8r4m0/index.jsp?topic=/com.ibm.systemtables.doc/rmobjects.htmAs for a new Archiv-project I had to go deeper into Content Manager and its components.

The complexity of the content manager by IBM is really impressive and took me some hours/days to get through it a bit at least.
We are using only TSM (diskpool/wormtapes) and a temporary space on the CM system for the archived files.

One of the best howtos I found on the net was this one: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0605tham/index.html

It is more or less focused on TSM integration within CM, but it has some nice pictures of the new CM8.4 and its functions.
The DB structure itself is not that complex to be honest.

You have following important tables in the XXRMT database:

RMCOLLECTIONS
RMMGTCLASS
RMMGTTRANSITION
RMSTGGRPCLASS
RMSTGGRPVOLUME
RMSTORAGECLASS
RMSTORAGEGROUP
RMVOLUMES

For more information on the tables check this page:
http://publib.boulder.ibm.com/infocenter/cmgmt/v8r4m0/index.jsp?topic=/com.ibm.systemtables.doc/rmobjects.htm

It explains every table, and a DB diagramm is a real mess to draw, so I will skip that one 🙂

Most important is the dtable rmobjects, as within this table every item that was archived with the CM is placed in this table with all information on where to find the files (stgclassid from rmstorageclass), which managementclass it is placed in (mgtclassid from rmtmgtclass) and so on.

With CM8.3 all Logfiles are saved in ~/ibmadm/log/rm/. You can change the level waht will be logged in the files placed in the folder ~/was/installedApps/<servername>/icmrm.ear/icmrm.war/*.xml
The files are selfexplaining by their names. Be aware that with the DEBUG level, some system might crash 🙂

Advertisements
This entry was posted in Content Manager, DB2, TSM and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s