What are the similarities and differences in terminology between Tivoli Storage Manager V6 and DB2?
Terminology may be different or have different meanings.
- 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
Configuration files (dsmserv.opt, volume history, etc.)
Storage pool volumes
TSM ADSM ITSM
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.