MIRO transaction very slow

[Former Member]

Dear Sir,

In our Production System , MIRO trabsaction is running very slow .

Kindly guide us as what steps need to be followed to trace/analyze the reason for slow MIRO transaction .

As the reason of the problem can be that some of the SQL might be running very slow or some Index related issue .

We need to undersatnd the steps to be followed to know the cause of the problem .

Pl help us .

Rgds

Sonia

[former_member181995]

you need to search for OSS.

surly there would be OSS for same.

Amit.

[valter_oliveira]

As Ámit said, you should look in OSS. However, also check if you are running optimizer statistics.

Regards,

Valter Oliveira.

[Former Member]

>

> Dear Sir,
> 
> In our Production System , MIRO trabsaction is running very slow . 
> Kindly guide us as what steps need to be followed to trace/analyze the reason for slow MIRO transaction . 
> 
> As the reason of the problem can be that some of the SQL might be running very slow or some Index related issue . 
> 
> We need to undersatnd the steps to be followed to know the cause of the problem .
> 
> Pl help us .
> 
> 
> Rgds
> 
> Sonia

Hello Sonia,

Check the following link:

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/68e8e4d2d16e721...

Regards,

Prashant