SQL/MX 2.x Installation and Management Guide (H06.04+)

Managing Database Applications
HP NonStop SQL/MX Installation and Management Guide—540436-001
11-24
Removing Modules
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).
Before you remove a module file:
1. Verify that no other applications use modules that you will remove.