Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

kc_db_info_str - Output database information

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

-

char db_id[2];

-

char db_type[8];

-

char db_entry_name[8];

-

char db_lib_info[54];

-

char db_xaswitch[54];

x(GPD)

char db_userid[30];

x(GPD)

char db_password[30];

-

char db_new_userid[30]; 

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.