Informix Sysmaster Table Detailed explanation

Source: Internet
Author: User

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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.