SQL PROBLEM

[gionata]

HI all.
I've a problem on P43214.

When i'm tryng to "delete" a receipt the program call "f43121 end doc".
This function execute the following SQL(this is an example):
update PRODDTA/F43121T set prmatc = '4' ,
PRDOCO = 6001832 ,
PRDCTO = 'A3' ,
PRKCOO = '00350',
PRSFXO = '000',
PRLNID = 1000 ,
PRNLIN = 1



WHERE PRMATC = '1' AND
PRDOCO = 6001832
AND PRDCTO = 'A3'
AND PRKCOO = '00350'
AND PRSFXO = '000'
AND PRLNID = 1000
AND PRNLIN = 1

this statement on AS/400 take 1 second. but in oneworld it takes sometimes 1 minute or more, is slower.

evrything seems ok , index are ok .
i don't know...

please let me know.



application server: IBM Intel(4 processor) XEON,
database server : db2(as400,V5R1M0)
Peoplesoft version: - B7333

 

[Gargamel]

Did you try to submit this SQL query directly to your database using dedicated tools such as sqlplus/osql... ??

 

[Sebastien Leclerc]

I suggest you search for SQLPKG in the forum or on the Oracle knowledge base. Sometimes, purging them helps solving these issues.

Good luck.

 

[gionata]

I'm sorry,
the sql string is incorrect.
The sql string update also the "PRDOC".
The SQL update the "pincipal key"(unique key).
The PRDOC is the "last" field of the key.
If i add in the selection of the sql string the field PRDOC the SQL is very faster , so i modified the business function and i' have added PRDOC in the "sql selection" .
(But i don't know why is so slower).
?
now it's ok.


application server: IBM Intel(4 processor) XEON,
database server : db2(as400,V5R1M0)
Peoplesoft version: - B7333