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*