SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Managing Database Applications
HP NonStop SQL/MX Installation and Management Guide—640325-001
11-26
Removing Modules
10. Perform Step 9 for the remainder of the applications:
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t02.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t03.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t11.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t12.exe
11. Verify how the local modules are generated:
/user/smith/tmp/tmp/DUO: ls -l *.*.INVENTORYAPP^*^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
/user/smith/tmp/tmp/DUO: ls -l *.*.SHIPMENTAPP^*^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:02
T01CAT.T01SCH.SHIPMENTAPP^T11MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:02
T01CAT.T01SCH.SHIPMENTAPP^T12MOD^^
12. Use DISPLAY USE OF to search for the local modules:
>>display use of module_dir '/user/smith/tmp/tmp/DUO' module
'*.*.INVENTORYAPP^*^^';
Module: T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
Table: T01CAT.T01SCH.T01TBL
Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
Table: T01CAT.T01SCH.T01TBL
Module: T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
Table: T01CAT.T01SCH.T01TBL
13. You can also display the modules in local directories that use the specified SQL
object:
>>display use of module_dir '/user/smith/tmp/tmp/DUO' object
'T01CAT.T01SCH.T01TBL';
Object: T01CAT.T01SCH.T01TBL
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
14. You can further limit the modules that can be searched:
>>display use of module_dir '/user/ychang/tmp/tmp/DUO' module
'T01CAT.T01SCH.INVENTORYAPP^T02MOD^^' object 'T01CAT.T01SCH.T01TBL';
Object: T01CAT.T01SCH.T01TBL
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
Removing Modules
You should prepare carefully before you remove module files. At best, removing a
module file can free up disk space. At worst, it can cause some of their applications to
return run-time errors (8809, unable to open module file).