IBM Books

Database Alias Used by Application


Snapshot Information Level
Application
Lock
DCS Application

API Structure(s)
sqlm_appl_id_info
sqlm_appl_lock
sqlm_dcs_applinfo

Monitor Group
Basic
Basic
Basic

Resettable

No

 

Event Information Level
Connection

API Structure(s)
sqlm_connheader_event

 

API Element Name
Element Type

client_db_alias
information

 

Description:  The alias of the database provided by the application to connect to the database.

Usage:  This element can be used to identify the actual database that the application is accessing. The mapping between this name and "Database Name" could be done by using the database directories at the client node and the database manager server node.

This is the alias defined within the database manager where the database connection request originated.

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.

This element can also be used to help you determine the authentication type, since different database aliases can have different authentication types.

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

[ DB2 List of Books | Search the DB2 Books ]