#DBSCHEMA FLAGS AS VIRUS HOW TO#

> scb sqscb optofc pdqpriority sqlstats optcompind directives > name class addr totalsize freesize #allocfrag #freefrag > id user tty pid hostname threads memory memory explain > IBM Informix Dynamic Server Version 9.40.UC6 - On-Line (Prim) - Up 2 > for pid 2788 which consumes the biggest mem. > To Andrea, onstat -g ses pid|grep user|sort -n -k 9,shows these are the > 'ping hostname', the latency is quite high '160 average'. > a big part? on the user who is testing the application, when he tried to > changes are the network configuration and the hardware. > version, OS version are the same, the application is the same. > all are working normally, until it was migrated to a new box. > complaining is locked on a per row basis. > 'extent size 256000 next size 32000 lock mode row', the table they are

> The thing i noticed on the table they are complaining is this > experiencing too much slowness when performing a select, even just it is a > The real problem actually is the user is complaining that they are > First let me thank all of you guys for the nice inputs, really

#DBSCHEMA FLAGS AS VIRUS HOW TO#

> An: Betreff: Re: How to check informix DB bottlenecks We trust that you appreciate our position. If, in spite of our using Antivirus protection software, a virus may have penetrated your system through the sending of this e-mail, we do not accept liability for any damage that may possibly arise as a result of this. The contents of the e-mail are only legally binding if they have been confirmed and signed by us in writing. We therefore do not accept legal liability for the information contained in this communication. In the event that the e-mail may have been sent to you in error, we would ask you to kindly delete this communication from your system and to contact us.Į-mails sent via the Internet can be easily manipulated or sent out under someone else's name. The information in this e-mail is made available exclusively for use by the addressee. Important notice: The contents of this e-mail may contain confidential and legally protected information that is in particular related to operational and trade secrets, which the recipient is obliged to treat as confidential. Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die Zusendung von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht für evtl. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich bestätigt und gezeichnet wird. Daher schließen wir die rechtliche Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Über das Internet versandte E-Mails können leicht manipuliert oder unter fremdem Namen erstellt werden. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung zu setzen.

Die Informationen in dieser E-Mail sind ausschließlich für den Adressaten bestimmt. Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und rechtlich geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse, enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. You already did a onstat -g ses (or onstat -g sql) - look at the SQL statement if you see an obviously missing index or something like that. If nothing obvious is found, you can run the SQL in dbaccess with set explain on - to get the execution plan.įor the last rows of the onstat -u | sort : Onstat -g sql 0 (if you could not get the session id in advance).Īfterwards compare the where-clause of the SQL and theĭbschema -d -t, look for missing indices. Then you can ask the user to run the SQL and do a few If the SQL the user is complaining about takes a few seconds, you could try to find the specific SQL statement:ĭepending on the kind of application you could try to identify the sessions belonging to that user (onstat -g ses will give you client addresses and process IDs ). To follow my suggestions (with focus on single SQL statements): They are all worth to check and implement. You got a lof of help from other people, too. In Response To: Re: How to check informix DB bottlenecks (JACK PAPA)

Dbschema flags as virus