Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

Try this against sysmaster.  It's will show when the internal stats were last cleared (onstat -z) or when Informix was last started.  Full disclosure, I think that Art shared this originally!

You can replace sh_boottime with sh_pfclrtime to get the time that onstat -z was run to clear the internal stats.

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

select dbinfo("UTC_TO_DATETIME", sh_boottime) from sysmaster:sysshmvals;

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

Jacob: It is in sysmaster.sysshmvals.sh_boottime along with the last time that stays were zeroed out. That column is a Unix epoch. You Cadbury get it as a dztetim by using dbinfo:

Select dbinfo( 'utc_to_datetime', sh_boottime)

From sysmaster.sysshmvals;

Art

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.

Jacob: It is in sysmaster.sysshmvals.sh_boottime along with the last time that stays were zeroed out. That column is a Unix epoch. You Cadbury get it as a dztetim by using dbinfo:

Select dbinfo( 'utc_to_datetime', sh_boottime)

From sysmaster.sysshmvals;

Art

Hi family.

I SOOO want this one to be a quickie question & answer.

Bottom line: How do I get the complete date/time of when the current server instance started up?

Currently, the best I can do is:

grep 'IBM Informix Dynamic Server Started' <message log> | tail -1|awk '{print $1}' 

In my case I got 03:35:54.  Now while this is a start (ahem) it is obviously missing the date. If it started up last week, this time stamp is less than helpful. Most (all?) other messages in the online log start with a full date-time stamp like 06/13/25 10:09:04.

I was so sure there is a DBINFO parameter that would would hand this to me but I don't see that in the DBINFO documentation.

I also recall there is a table in sysmaster that keeps a gazzilion little items about the current server and one row may contain the start date/time. But I don't recall the name of that table. A peruse of sysmaster.sql was an example of searching for the needle in the haystack.  (Aside: Author Kurt Vonnegut has advised aspiring authors to "avoid cliches like the plague." :-)

(The up time in every onstat heading would involve datetime and interval arithmetic that crosses the month<->day boundary.)

So how do find this?

Thank y'all for advice.