VERY SLOW DROP PROCEDURE IN *SYSBAS OS 7.4

Any IBM i topic that does not fit in another forum
Post Reply
roberto.cattaneo
Posts: 1
Joined: Tue Jul 26, 2022 1:26 pm

VERY SLOW DROP PROCEDURE IN *SYSBAS OS 7.4

Post by roberto.cattaneo »

Hi everyone, after the update from 7.3 to 7.4 a very strange thing happens. My AS400 has two databases. The first * SYSBAS and another GENERAL, created ad hoc and both reside on two different ASPs. If I do the DROP PROCEDURE in GENERAL it is performed in one second, if I do the DROP PROCEDURE in * SYSBAS it also takes 15 minutes and not less than two minutes. I noticed that at each DROP a QDBX033XR2 job is executed which uses a lot of CPU resources. Did the same thing happen to anyone? Thanks for any help.
Post Reply