Expensive SQL Statements

[Former Member]

Hi All,

We have solution manager 4.0 and the problem is that there are two sql statements which are triggering off by user DDIC. These statements when executed are triggering other SQL statements and there on a chain of SQL statements are getting triggered. This is giving a beating on the performance where the system is slow.

I have checked in SM37 and do not see any jobs running.

Can anyone help me by letting me know where i can these statements and where i can cancel the statements from running, or what else can be done regarding this.

All inputs are appreciated.

Thank you in advance..

-SACHIN.

[former_member209604 · Accepted solution]

Hi Sachin,

Could you post the statements into the forum?

Regards, Ruediger

[Former Member · Accepted solution]

Hi Ruediger,

Thanks for replying

Following are two SQL statements-:

1> SELECT COUNT(*) FROM "BC_SLD_INST" WHERE "APPL" = ? AND "NA_KEY" = ? AND

"INST_HASH" = ?

2> SELECT "INST_HANDLE","INSTNAME_BYTES" FROM "BC_SLD_INST" WHERE "APPL" =

? AND "NA_KEY" = ? AND "INST_HASH" = ?

INSERT INTO "BC_SLD_ASSINST" ("APPL","NA_KEY","ASSINST_HASH","ASSINST_HA

NDLE","INST_HASH","INST_HANDLE","ROLE_HASH","ROLE_HANDLE") VALUES (?,?,?

,?,?,?,?,?)

Regards

Sachin