Under certain conditions you might need to delete the sql packages.
1]Before doing that all the applications or services using them should be brought down.For example for an E1 Enterprise Server running on IBM iseries, use ENDNET command to bring down the services.
2]Figure out the sql packages that need to be deleted using WRKOBJ *ALL/*ALL *SQLPKG.
now use the key 4 to selectively delete the packages.please make sure that the packages beginning with 'Q' are system packages and should never be deleted.
Related
SQL Packages
1]Before doing that all the applications or services using them should be brought down.For example for an E1 Enterprise Server running on IBM iseries, use ENDNET command to bring down the services.
2]Figure out the sql packages that need to be deleted using WRKOBJ *ALL/*ALL *SQLPKG.
now use the key 4 to selectively delete the packages.please make sure that the packages beginning with 'Q' are system packages and should never be deleted.
Related
SQL Packages
No comments:
Post a Comment