SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)
Using Guardian Names With TMF, RDF, and
Measure
HP NonStop SQL/MX Installation and Management Guide—523723-004
B-9
MXGNAMES Examples
Assuming the local node is called \PNODE, the output of the command would be:
LOCATION
(
\pnode.$vol1.zsd0126a.bxnl1r00 TO
\bnode.$vol1.zsd0126a.bxnl1r00,
\pnode.$vol2.zsd0126a.bxnl2r00 TO
\bnode.$vol2.zsd0126a.bxnl2r00,
\pnode.$vol3.zsd0126a.bxnl3r00 TO
\bnode.$vol3.zsd0126a.bxnl3r00,
\pnode.$vol4.zsd0126a.bxnl4r00 TO
\bnode.$vol4.zsd0126a.bxnl4r00,
\pnode.$vol5.zsd0126a.bxnl5r00 TO
\bnode.$vol5.zsd0126a.bxnl5r00,
\pnode.$vol6.zsd0126a.bxnl6r00 TO
\bnode.$vol6.zsd0126a.bxnl6r00,
\pnode.$vol1.zsd0126a.qdxwg100 TO
\bnode.$vol1.zsd0126a.qdxwg100,
\pnode.$vol2.zsd0126a.qdxwg200 TO
\bnode.$vol2.zsd0126a.qdxwg200,
\pnode.$vol3.zsd0126a.qdxwg300 TO
\bnode.$vol3.zsd0126a.qdxwg300,
\pnode.$vol4.zsd0126a.qdxwg400 TO
\bnode.$vol4.zsd0126a.qdxwg400,
\pnode.$vol1.zsd0126a.bxnw1r00 TO
\bnode.$vol1.zsd0126a.bxnw1r00,
\pnode.$vol2.zsd0126a.bxnw2r00 TO
\bnode.$vol2.zsd0126a.bxnw2r00,
\pnode.$vol3.zsd0126a.bxnw3r00 TO
\bnode.$vol3.zsd0126a.bxnw3r00,
\pnode.$vol4.zsd0126a.bxnw4r00 TO
\bnode.$vol4.zsd0126a.bxnw4r00,
\pnode.$vol1.zsd0126a.qdx1g100 TO
\bnode.$vol1.zsd0126a.qdx1g100,
\pnode.$vol2.zsd0126a.qdx1g200 TO
\bnode.$vol2.zsd0126a.qdx1g200,
\pnode.$vol3.zsd0126a.qdx1g300 TO
\bnode.$vol3.zsd0126a.qdx1g300,
\pnode.$vol4.zsd0126a.qdx1g400 TO
\bnode.$vol4.zsd0126a.qdx1g400,
\pnode.$vol5.zsd0126a.qdx1g500 TO
\bnode.$vol5.zsd0126a.qdx1g500)
Restore Example 2: Input Is SHOWDDL Text
MXGNAMES -Showddl=$VOL1.SQLSTUFF.SHOWD123 -output=NAMELST2 -BR2
–node=\bnode