Clearing SQL Packages from QRECOVERY
You may have one or more packages (Rnnnnn) in QRECOVERY if you are upgrading from JD Edwards ERP 8.9 onwards, and you were running with this setting:
[DB SYSTEM SETTINGS] SQL Package Library=1
If these packages exist in QRECOVERY, you could experience problems after the upgrade.
However, the problem will not be apparent during the upgrade, because the upgrade
installer uses a jde.ini
with SQL Package
Library=2
.
Note: With the setting
SQL Package
Library=2
, the system assigns each job its own unique package (for
example, T123456), which is not based on the UBE name.You should delete any old UBE SQL packages in QRECOVERY.
Note: No UBEs can be running on the server
while you are deleting these packages.
To delete the packages, use this command:
DLTSQLPKG QRECOVERY\R*