If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Timing out on onstat -d

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-13-04, 06:18
holtermp holtermp is offline
Registered User
 
Join Date: Dec 2003
Posts: 6
Question Timing out on onstat -d

Hello,
with a customer of ours, that have some quite large blob spaces we get a timeout warning, when starting a "onstat -d" on Informix7.31/HPUX11:
Chunks
address chk/dbs offset size free bpages flags pathname
The server did not respond within 21 seconds. Timing out.
Warning: blob chunk page usage statistics may be inaccurate.
caf57218 1 1 0 750000 748625 PO- /dev/dbspaces/h1rootdbs
caf57620 2 2 0 100000 947 PO- /dev/dbspaces/h1llogs
caf57728 3 3 0 100000 947 PO- /dev/dbspaces/h1plogs
caf57830 4 4 0 1024000 ~20478 20480 POB caf588b0 20 16 0 1024000 523947 PO- /dev/dbspaces/h1ifounter01
caf589b8 21 17 0 1024000 ~0 1024000 POB /dev/dbspaces/h1ifounterblob01
caf58ac0 22 17 0 1024000 ~0 1024000 POB /dev/dbspaces/h1ifounterblob02
caf58bc8 23 17 0 1024000 ~0 1024000 POB /dev/dbspaces/h1ifounterblob03
caf58cd0 24 17 0 1024000 ~627760 1024000 POB /dev/dbspaces/h1ifounterblob04
caf58dd8 25 17 0 1024000 ~1019951 1024000 POB /dev/dbspaces/h1ifounterblob05
caf58ee0 26 17 0 1024000 ~1019951 1024000 POB /dev/dbspaces/h1ifounterblob06

Has anyone experienced that too?
What does it mean? Should we do anything about that?

Thanks, Peter
Reply With Quote
  #2 (permalink)  
Old 07-13-04, 14:44
tmullins tmullins is offline
Registered User
 
Join Date: Aug 2003
Posts: 68
Normally when I get these type of messages with onstat commands:

"The server did not respond within 21 seconds. Timing out."

I have to bounce the engine. Do any of the other onstat commands time out?
Reply With Quote
  #3 (permalink)  
Old 07-13-04, 17:15
ServerMetrics ServerMetrics is offline
Registered User
 
Join Date: May 2004
Posts: 45
I believe this is to do with the onstat commands needing access to critical memory structures that are changing when the command in in play. Similar to the old 'changing memory structure caused command-line termination' errors onstat used to give to busy Solaris systems.
__________________
Keith Brownlow
ServerMetrics DB Monitoring (www.servermetrics.com)
Reply With Quote
  #4 (permalink)  
Old 07-14-04, 07:00
holtermp holtermp is offline
Registered User
 
Join Date: Dec 2003
Posts: 6
Should be no problem

I asked someone I know, who administrates a few larger INFORMIX DBSs, who said:

Should be no problem, occurs alway when there is more than a certain number of blob chunks.
Itīs only a warning. The Server can not measure the exact usage of blob space in time. For exact values use onmonitor.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On