Tivoli Storage Manager V6/DB2 Terminology

Technote (FAQ)


Question

What are the similarities and differences in terminology between Tivoli Storage Manager V6 and DB2?

Cause

Terminology may be different or have different meanings.

Answer

- Both Tivoli Storage Manager and DB2 use the terms of “active logs”, “archive logs” , and “failover archive logs”. Tivoli Storage Manager collectively refers to these 3 log types as the “recovery log”. DB2 refers to these just as “transaction logs”.

- Tivoli Storage Manager uses the term “directory” for where these logs are to be written. DB2 administrators use the term “container”.

- Tivoli Storage Manager refers to “transactions” while DB2 refers to “units of work” (UOW). There is a 1:1 correlation between the two, and some of the command outputs from DB2 will refer to UOW.

- DDL - The schema for a database is written using what is called DDL, which stands for Data Definition Language. This is not a DB2 term, but it is a language used to define the data structures (such as records, fields, and data) in the database.

- Tivoli Storage Manager uses select statements where DB2 uses SQL and are also sometimes referred to as DML, or data manipulation language statements.

- An Instance is everything required to run a server and is used by both Tivoli Storage Manager and DB2

    Database files
    Log files
    Configuration files (dsmserv.opt, volume history, etc.)
    Storage pool volumes

Product Alias/Synonym

TSM ADSM ITSM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2, 6.3

Operating system(s):

Linux, UNIX, Windows

Software edition:

Edition Independent

Reference #:

1617500

Modified date:

2013-10-17

Translate my page

Machine Translation

Content navigation