Results 1 to 5 of 5
  1. #1
    Newcomer
    Join Date
    Aug 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Does anyone in the group know where the TSM Server database schema is documented. I understand that I can query the system catalog tables but this does not show or describe the table relationships etc. I'm looking for some type of Entity Relationship Diagram (ERD) for the TSM Server database.



    Thx

  2. #2
    Member
    Join Date
    Nov 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    you can query tables named tables and columns to get the information you need.

  3. #3
    Member
    Join Date
    Jun 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I believe you can find a info about the DB schema in the following tables. It talks about SQL and the DB in chapter 19 of the Admin guide.



    SYSCAT.TABLES

    Contains information about all tables that can be queried with the SELECT

    command.

    SYSCAT.COLUMNS

    Describes the columns in each table.

    SYSCAT.ENUMTYPES

    Defines the valid values for each enumerated type and the order of the

    values for each type.

  4. #4
    Newcomer
    Join Date
    Dec 2012
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    With a "select tabname from syscat.tables where tabschema='TSMDB1' and type 'V'" you can get the names of tables.

    With a "select colname from syscat.columns where tabschema='TSMDB1' and tabname='XXX'" you can get the names of the columns of the table XXX.

    Anybody have already done a schema to have a graphical representation of the structure of TSM database ?

  5. #5
    Newcomer
    Join Date
    Dec 2012
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I join an excel document with TSM 6.3.3 dbstruct table.
    Attached Files Attached Files

Similar Threads

  1. TDP for SQL Server - restoring Database to another server
    By director_den in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 09-30-2011, 06:44 AM
  2. Vol problem
    By MLiam in forum Tape / Media Library
    Replies: 5
    Last Post: 12-04-2006, 05:22 PM
  3. Replies: 0
    Last Post: 09-13-2006, 09:29 AM
  4. Unable to Restore-No Errors at All
    By khurana5 in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 05-04-2006, 07:02 AM
  5. TSM Server Upgrade Flash
    By samg in forum TSM Server
    Replies: 0
    Last Post: 05-23-2003, 01:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •