Ingres 12.0 | Example: Table of SCF Sessions

System Administrator Guide > System Administrator Guide > Understanding Ingres Management Architecture > REGISTER TABLE Examples > Example: Table of SCF Sessions

Was this helpful?

Example: Table of SCF Sessions

The ima_server_sessions table below shows information about SCF-level sessions:

server varchar(64) not null not default is

'SERVER',

session_ptr varchar(32) not null not default is

'exp.scf.scs.scb_index',

session_id varchar(32) not null not default is

'exp.scf.scs.scb_self',

effective_user varchar(32) not null not default is

'exp.scf.scs.scb_euser',

real_user varchar(32) not null not default is

'exp.scf.scs.scb_ruser',

db_name varchar(32) not null not default is

'exp.scf.scs.scb_database',

db_owner varchar(32) not null not default is

'exp.scf.scs.scb_dbowner',

db_lock varchar(9) not null not default is

'exp.scf.scs.scb_dblockmode',

server_facility varchar(10) not null not default is

'exp.scf.scs.scb_facility_name',

session_activity varchar(80) not null not default is

'exp.scf.scs.scb_activity',

activity_detail varchar(80) not null not default is

'exp.scf.scs.scb_act_detail',

session_query varchar(4096) not null not default is

'exp.scf.scs.scb_query',

session_terminal varchar(12) not null not default is

'exp.scf.scs.scb_terminal',

session_group varchar(8) not null not default is

'exp.scf.scs.scb_group',

session_role varchar(8) not null not default is

'exp.scf.scs.scb_role',

client_host varchar(20) not null not default

is 'exp.scf.scs.scb_client_host',

client_pid varchar(20) not null not default

is 'exp.scf.scs.scb_client_pid',

client_terminal varchar(20) not null not default

is 'exp.scf.scs.scb_client_tty',

client_user varchar(32) not null not default

is 'exp.scf.scs.scb_client_user',

client_connect_string varchar(64) not null not default

is 'exp.scf.scs.scb_client_connect',

client_info varchar(200) not null not default

is 'exp.scf.scs.scb_client_info',

application_code integer4 not null not default

is 'exp.scf.scs.scb_appl_code',

session_name varchar(32) not null not default

is 'exp.scf.scs.scb_s_name',

server_pid integer4 not null not default is

'exp.scf.scs.scb_pid',

query_start_secs integer4 not null not default is

'exp.scf.scs.scb_query_start_secs'

)

as import from 'tables'

with dbms = IMA, structure = unique sortkeyed,

key = (server, session_id)

Last modified date: 08/29/2024