python informix 日期,Informix sysmaster表详解

数据库*systabnames ————>表*sysextents ————>表区域*sysptprof ————>表I/O

create table "sysmaster".sysdatabase {实例中所有的数据库信息}

(

name char(1, {数据库名}

partnum integer, {systables表ID }

owner char(, {生成者用户名}

created integer, {生成日期}

is_logging integer, {无缓冲日志，1=YES，0=NO }

is_buff_log integer, {缓冲日志，1=YES，0=NO }

is_ansi integer, {ANSI方式数据库1=YES，0=NO }

is_nls integer, {NLS支持，1=YES，0=NO }

flags smallint {指示日志的标志}

);

grant select on sysdatabase to public;

create table "sysmaster".systabnames {实例中的所有表}

(

partnum integer, { table id for table表号}

dbsname char(1, { database name数据库名}

owner char(, { table owner表拥有者}

tabname char(1, { table name表名}

collate char(32) { collation assoc with database与GLS的相关性}

);

create unique index systabs_pnix on systabnames(partnum);

revoke all on systabnames from public;

grant select on systabnames to public;

create table "sysmaster".sysextents {实例中的表和每个区域}

(

dbsname char(1, {数据库名}

tabname char(1, {表名}

start integer, {这个区域的物理地址}

size integer {这个区域的长度(页数) }

);

grant select on sysextents to public;

create table "sysmaster".sysptnext {区域的信息}

(

pe_partnum integer, { partnum for this partition这个区域的编号}

pe_extnum smallint, { extent number区域号}

pe_phys integer, { physical addr for this extent这个区域的物理地址}

pe_size integer, { size of this extent这个区域的长度(页数) }

pe_log integer { logical page for start开始逻辑页}

);

create unique index sysptnextidx on sysptnext (pe_partnum, pe_extnum);

revoke all on sysptnext from public;

grant select on sysptnext to public;

create table "sysmaster".sysptprof {表I/O概貌}

(

dbsname char(1, {数据库名}

tabname char(1, {表名}

partnum integer, {表编号}

lockreqs integer, {锁请求 }

lockwts integer, {锁等待}

deadlks integer, {死锁}

lktouts integer, {锁超时}

isreads integer, {读}

iswrites integer, {写入}

isrewrites integer, {改写}

isdeletes integer, {删除}

bufreads integerinteger, {缓冲区读}

bufwrites integer, {行冲区写}

seqscans integer, {顺序扫描}

pagreads integer, {磁盘读}

pagwrites integer {磁盘写}

);

grant select on sysptprof to public;