VERY SLOW DROP PROCEDURE IN *SYSBAS OS 7.4
-
- Posts: 1
- Joined: Tue Jul 26, 2022 1:26 pm
VERY SLOW DROP PROCEDURE IN *SYSBAS OS 7.4
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.