IBM Books

Input Database Alias


Snapshot Information Level
Database
Application
Table Space
 
Table
Lock

API Structure(s)
sqlm_dbase
sqlm_appl_id_info
sqlm_tablespace_header
sqlm_bufferpool
sqlm_table_header
sqlm_dbase_lock

Monitor Group
Basic
Basic
Buffer Pool
Buffer Pool
Table
Basic

Resettable

No

 
API Element Name
Element Type

input_db_alias
information

 

Description:  The alias of the database provided when calling the snapshot function.

Usage:  This element can be used to identify the specific database to which the monitor data applies. It contains blanks unless you requested monitor information related to a specific database.

The value of this field may be different than the value of the "Database Alias Used by Application" monitor element since a database can have many different aliases. Different applications and users can use different aliases to connect to the same database.

If you are using the database system monitor APIs, note that the API constant sqlm_ident_sz is used to define the length of this element. Only the first 8 characters are currently used.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]