Re: Onstat question
Michel Auger wrote:
}
} When we use the Onstat -u , sometimes we get this display:
}
} onstat -u
}
} INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes
}
} Userthreads
} address flags sessid user tty wait tout locks nreads nwrites
} 332c020 ---P--D 0 informix - 0 0 0 2100 1585
} 332c6a8 ---P--F 0 informix - 0 0 0 0 0
} 332cd30 ---P--F 0 informix - 0 0 0 0 0
} 332d3b8 ---P--F 0 informix - 0 0 0 0 0
} 332da40 ---P--F 0 informix - 0 0 0 0 0
} 332e0c8 ---P--B 8 informix - 0 0 0 1868 10682
} 332e750 ---P--D 0 informix - 0 0 0 0 0
} 3330170 Y--P--- 11899 G4SLUS03 - 5fae4e0 0 1 44 109
} 3330e80 Y--P--- 11837 intdba ttyq1 603cef8 0 1 1 0
} 3331b90 Y--P--- 11812 sylvainL ttypc 4437548 0 1 2 0
} Changing data structure forced command termination.
}
} Does anyone know why we are getting the message "Changing data structure ..." ?
}
} How can we prevent this from happening ? We found that, by bringing Online
} down and then up, it solves this problem. Is there a better alternative ?
}
} Thank you
}
} Michel
I have had this a couple of times, but issuing the command again displays the information
correctly, ie, it is not a recurring problem. I assume that the onstat code detects that
the snapshots it is taking of shared memory to obtain the display output no longer
tie-up. THe code therefore bombs out to avoid displaying inconsistent data. I would be
grateful if anyone could tell me how far from the truth I am (in miles please !!!)
--
Rick Ward
Senior DBA
Great Universal Stores Home Shopping
MANCHESTER, UK
All views and comments in this e-mail are expressed by myself only, and
are not necessarily representative of my employer, Great Universal Stores.