Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
SangGyu Jeong — source: IBM Community (ConnectedCommunity.org) Informix forum
Hi, All
When I click on table activity in InformixHQ's system reports menu, I only see catalog tables and no user tables.
Below is a screenshot from my test server.
So I looked up a query of table activity with sql tracing function.
When I ran the following query from dbaccess, there was no information about user tables as well.
This seems to be the result of a join with systables in the sysmaster database.
Is this report correct? Or am I misunderstanding the report?
Thanks,
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix
↪ replying to SangGyu Jeong
Alexandre Marini — source: IBM Community (ConnectedCommunity.org) Informix forum
Hello.
Seems you are with tablespace stats turned off.
Try running onstst -g ppf and see if there is some result.
If not, you should enable jt and restart the engine.
HTH
------------------------------
Alexandre Marini
------------------------------
↪ replying to Alexandre Marini
SangGyu Jeong — source: IBM Community (ConnectedCommunity.org) Informix forum
Hi,
Alexandre.
Thank you for your answer.
My test server's TBLSPACE_STATS configuration value is 1 and it hasn't changed.
As shown below, the onstat -g ppf command shows various values.
Running the System Reports' query with the partnum value of the user table (stores_demo: customer, 0x100233) by the onstat -g ppf command did not return any results.
In other words, the query seems to be missing information about user tables.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.