One, instance information
*sysconfig ———— > Onconfig files
*sysprofile ———— > Server Statistics
*syslog ———— > Logic Log
*sysvpprof ———— > virtual processor
CREATE TABLE "Sysmaster". Sysconfig {server configuration parameters}
(
cf_id Integer, {unique numeric identifier}
Cf_name char (1, {onconfig parameter name}
Cf_flags integer, {flag, 0 = in view}
Cf_original char (256), {value in Onconfig at startup}
Cf_effective char (256), {The value actually used}
Cf_default char (256) {The value that is used by default when unspecified in Onconfig file}
);
Grant SELECT on Sysconfig to public;
CREATE TABLE "Sysmaster". Sysprofile {Server overview information}
(
Name Char (13), {overview element name}
Value integer {current value}
);
Grant SELECT on Sysprofile to public;
CREATE TABLE "Sysmaster". syslogs {logical Log information}
(
Number smallint, {log file No.}
Uniqid integer, {log file unique ID}
Size integer, {log File page}
Used integer, {The page used by the log file}
is_used Integer, {1 is used, 0 is unused}
Is_current Integer, {1 is current}
Is_backed_up Integer, {1 for backup}
Is_new Integer, {1 is new}
Is_archived Integer, {1 for archive}
Is_temp Integer, {1 is temporary}
Flags smallint {log file flag}
);
Grant SELECT on syslogs to public;
CREATE TABLE "Sysmaster". Sysvpprof {Virtual processor information and statistics}
(
Vpid Integer, {virtual processor}
Class char (50, {Virtual processor class name (CPU, ADM, Lio, PIO, etc.)}
Usercpu float, {User Time Unix seconds}
SYSCPU Float {System time Unix seconds}
);
Grant SELECT on Sysvpprof to public;