[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2134
  • Last Modified:

Can i get IBM tivoli Database Schema with data definition?

Need IBM tivoli Database Schema with data definition
0
Senz79
Asked:
Senz79
  • 3
1 Solution
 
woolmilkporcCommented:
Hi,
yes, you can.
There are the tables SYSCAT.TABLES and SYSCAT.COLUMNS (and SYSCAT.ENUMTYPES for valid enumerations).
Their Layout is as shown in the attachment.

Use select  TABNAME from SYSCAT.TABLES    to get a listing of all tables,
Use select * from SYSCAT.COLUMNS where TABNAME='[tablename]'  to get the column layout of a given table [tabname].
HTH
Cheers
wmp


SYSCAT.TABLES
 
COLNAME                TYPENAME                    LENGTH
------------------     ------------------     -----------
TABSCHEMA              VARCHAR                          8
TABNAME                VARCHAR                         18
CREATE_TIME            TIMESTAMP                        0
COLCOUNT               SMALLINT                         0
INDEX_COLCOUNT         SMALLINT                         0
UNIQUE_INDEX           BOOLEAN                          0
REMARKS                VARCHAR                        250 
 
SYSCAT.COLUMNS
 
COLNAME                TYPENAME                    LENGTH
------------------     ------------------     -----------
TABSCHEMA              VARCHAR                          8
TABNAME                VARCHAR                         18
COLNAME                VARCHAR                         18
COLNO                  SMALLINT                         0
INDEX_KEYSEQ           SMALLINT                         0
INDEX_ORDER            CHAR                             1
TYPENAME               VARCHAR                         40
LENGTH                 INTEGER                          0
SCALE                  SMALLINT                         0
NULLS                  BOOLEAN                          0
REMARKS                VARCHAR                        250

Open in new window

0
 
Senz79Author Commented:
Thanks for the quick reply. I dont have the access to the same, but can i get any document where the overall database schema of Tivoli has been discussed.
0
 
woolmilkporcCommented:
Unfortunately, I'm not aware of such a document, as far as Tivoli Storage Manager is concerned.
There are some database layouts around for e.g. Tivoli Configuration Manager, however.
I'll append the content of SYSCAT.TABLES and SYSCAT.COLUMNS (slightly less detailed than the original) as .txt files for your reference.
 I'll search some material elsewhere, but I can't promise that I'll find any.
wmp
 
 

tsm-tables.txt
tsm-columns.txt
0
 
woolmilkporcCommented:
Got this jpeg for you. But that's all, I fear.
TSM-Table-Schema.jpg
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now