SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-11
Examples of DISPLAY USE OF
Parallel Execution of DISPLAY USE OF
Suppose your system has many modules. When you run DISPLAY USE OF against all
modules on the system, it might take 30 minutes or more.
If you name the modules with a distinguishing prefix, such as an indication of what
application the module belongs to, you can use wild cards to run multiple instances of
DISPLAY USE OF that each target a different set of modules, in different CPUS. Each
of these instances will complete much more quickly. See the SQL/MX Installation and
Management Guide for a detailed example of this.
Examples of DISPLAY USE OF
•
Display all modules and dependent objects:
>>display use of;
Module: CAT.SCH.CONSTRAINTM
Index: \NODE1.$DATA08.ORDERS.TI(CAT.SCH.T)
Object: CAT.SCH.T
Module: CAT.SCH.CURSOMEM
Object: \NODE1.$DATA08.ORDERS.T071CH
Object: \NODE1.$DATA08.ORDERS.T071M
Object: \NODE1.$DATA08.ORDERS.T071S
Object: \NODE1.$DATA08.ORDERS.T071T
Object: \NODE1.$DATA08.ORDERS.T071U
Module: CAT.SCH.TESTE001M
Table: \NODE1.$DATA08.ORDERS.RSWORKS
...
(and so on for all modules).
•
Display objects for all modules matching wild card “c*M”:
>>display use of module 'CAT.*.c*M';
Module: CAT.SCH.constraintM
Index: \NODE1.$DATA08.ORDERS.TI(CAT.SCH.T)
Table: CAT.SCH.T
Module: CAT.SCH.cursomeM
Table: \NODE1.$DATA08.ORDERS.T071CH
Table: \NODE1.$DATA08.ORDERS.T071M
Table: \NODE1.$DATA08.ORDERS.T071S
Table: \NODE1.$DATA08.ORDERS.T071T
Table: \NODE1.$DATA08.ORDERS.T071U
•
Display use of a specified Guardian object in all modules:
>>display use of object '\NODE1.$DATA08.ORDERS.T1';
Object: \NODE1.$DATA08.ORDERS.T1
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.INS1M
Object: \NODE1.$DATA08.ORDERS.T1 Module: