sexta-feira, 27 de dezembro de 2013

Novo Technote de ER finalmente publicado!!!!

Pessoal,
levou um tempinho pra conseguir concluir, mas com a ajuda de outros colegas da IBM US
finalmente saiu: http://www-01.ibm.com/support/docview.wss?uid=swg21572991

How to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions

Technote (troubleshooting)


This document applies only to the following language version(s):

English

Problem(Abstract)

This document can be used to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions

Symptom

Several occasions when ER/CDR queues become 'flooded' with transactions, it is critical to identify the user(s) triggering Data Manipulation Language (DML) SQL statements which consume a lot of logical log area that can cause the DDR Block situation and hang the Informix instance.

Cause

A user triggered a huge transaction causing several logical logs to be filled and ER sync to hang.

Diagnosing the problem

1. Look at 'onstat -g rqm sendq'

2. Check the progress table and look for the 'group id' with the largest bytes queued;

3. The 'group id' is really the 'replicate id';

4. Look for the replicate id from 'onstat -g cat' to find the table used in that replicate;

5. With the table partnum information, now you can use one of the following options to find the session id or userthread:
- onlog
- onstat -g opn
- sqltrace history


Looking 'onstat -g rcv full" from one of the target servers also lists replicated id's and bytes received.

Resolving the problem

After finding the user/session id, cancell the userthread/session causing the flood.

1 comentários:

Em parceria com a Google e com o Grupo VIP oferecemos telas mosquiteiras SP importadas dos estados unidos aos clientes que querem proteção e bem-estar para sua família, isto porque o produto não propaga chamas, fungos ou mofos, são telas de fácil limpeza e protegem sua família contra picadas de insetos, principalmente os mosquitos da dengue. Telas mosquiteiras em São Paulo, telas mosquiteiras campinas, telas mosquiteiras valinhos, telas mosquiteiras vinhedo, telas mosquiteiras granja vianna, telas mosquiteiras alphaville, telas mosquiteiras tamboré , telas mosquiteiras jundiai.

telas mosquiteiras para idústrias de alimentos , telas mosquiteiras SP, telas mosquiteiras empresas químicas, telas mosquiteiras vinhedo, telas mosquiteiras granja vianna, telas mosquiteiras alphaville, telas mosquiteiras tamboré , telas mosquiteiras SP

Postar um comentário