Example: Table of SCF Sessions
The ima_server_sessions table below shows information about SCF-level sessions:
register table ima_server_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)