The data structure kc_db_info_str is defined for the object type KC_DB_INFO. If KC_GET_OBJECT is specified then UTM returns information on the generated database connections in kc_db_info_str.
With KC_MODIFY_OBJECT, you can modify the database password and/or the database user.
Database connections are generated with the KDCDEF control statement DATABASE (BS2000 systems) or RMXA (Unix, Linux and Windows systems).
mod1 | Data structure kc_db_info_str |
- |
|
- |
|
- |
|
- |
|
- |
|
x(GPD) |
|
x(GPD) |
|
- |
|
1 Field content can be modified with KC_MODIFY_OBJECT, see "obj_type=KC_DB_INFO"
The fields in the data structure have the following meanings:
db_id
Specifies the ID of the database. The ID is a digit which represents the databases in the order in which they were generated. The ID is assigned internally by openUTM.
db_type
Specifies the type of database system:
'XA'
'UDS' (only on BS2000 systems)
'LEASY' (only on BS2000 systems)
'SESAM' (only on BS2000 systems)
'CIS' (only on BS2000 systems)
'DB' (only on BS2000 systems)
db_entry_name
In the case of a BS2000 database, the entry name of the BS2000 database is output. In the case of a BS2000 database with db_type=XA, the name of the XA switch generated with the ENTRY operand of the DATABASE statement is returned in db_entry_name. In a BS2000 system, this XA switch name is also returned in the db_xaswitch field.
In the case of Unix, Linux and Windows systems, db_entry_name does not contain any relevant information.
db_lib_info
The meaning of this field is platform-specific.
On BS2000 systems, this field corresponds exactly to the LIB field in the KDCDEF statement DATABASE, i.e. it outputs information on the library from which the connection module to the database system was dynamically loaded. The field contains either the name of an object module library itself or a LOGICAL-ID as used during IMON installation in the format "LOGICAL-ID(logical-id)".
On Unix, Linux and Windows systems, this field contains the internal name of the loaded XA switch, e.g. "Oracle_XA".
db_xaswitch
The meaning of this field is platform-specific.
On BS2000 systems, the content of db_entry_name is returned in db_xaswitch.
On Unix, Linux and Windows systems, this field contains the name of the Resource Manager’s XA switch. This name is defined in the XASWITCH parameter of the KDCDEF statement RMXA.
db_userid
For XA databases, with KC_GET_OBJECT UTM returns the user name generated for this database system in the db_userid field.
For an XA database, the database user name in this field can also be changed using KC_MODIFY_OBJECT. The change always takes effect the next time the application is started.
db_password
In the db_password field, a new database password for an XA database can be assigned using KC_MODIFY_OBJECT.
For KC_GET_OBJECT, UTM always supplies blanks to this field.
db_new_userid
For XA databases, UTM returns the modified but not yet activated user name for this database system in the field db_new_userid for KC_GET_OBJECT. The user name returned here is activated the next time the application is started and transferred to the database system.