SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-29
Example of Moving a Database
>> VERIFY $DATA1.PERSNL.*;
... <-- omitted miscellaneous tables
--- Verifying $DATA1.PERSNL.DEPT
--- $DATA1.PERSNL.DEPT verified.
--- Verifying $DATA1.PERSNL.EMPLIST
--- $DATA1.PERSNL.EMPLIST verified.
--- Verifying $DATA1.PERSNL.EMPLOYEE
--- $DATA1.PERSNL.EMPLOYEE verified.
--- Verifying $DATA1.PERSNL.JOB
--- $DATA1.PERSNL.JOB verified.
--- Verifying $DATA1.PERSNL.MGRLIST
--- $DATA1.PERSNL.MGRLIST verified.
--- Verifying $DATA1.PERSNL.XDEPTMGR
--- $DATA1.PERSNL.XDEPTMGR verified.
--- Verifying $DATA1.PERSNL.XDEPTRPT
--- $DATA1.PERSNL.XDEPTRPT verified.
--- Verifying $DATA1.PERSNL.XEMPDEPT
--- $DATA1.PERSNL.XEMPDEPT verified.
--- Verifying $DATA1.PERSNL.XEMPNAME
--- $DATA1.PERSNL.XEMPNAME verified.
--- SQL operation complete.
>> VERIFY $DATA1.SALES.*;
... <-- omitted miscellaneous tables
--- Verifying $DATA1.SALES.CUSTLIST
--- $DATA1.SALES.CUSTLIST verified.
--- Verifying $DATA1.SALES.CUSTOMER
--- $DATA1.SALES.CUSTOMER verified.
--- Verifying $DATA1.SALES.ODETAIL
--- $DATA1.SALES.ODETAIL verified.
--- Verifying $DATA1.SALES.ORDERS
--- $DATA1.SALES.ORDERS verified.
--- Verifying $DATA1.SALES.ORDREP
--- $DATA1.SALES.ORDREP verified.
--- Verifying $DATA1.SALES.PARTS
--- $DATA1.SALES.PARTS verified.
--- Verifying $DATA1.SALES.XCUSTNAM
--- $DATA1.SALES.XCUSTNAM verified.
--- Verifying $DATA1.SALES.XORDCUS
--- $DATA1.SALES.XORDCUS verified.
--- Verifying $DATA1.SALES.XORDREP
--- $DATA1.SALES.XORDREP verified.
--- Verifying $DATA1.SALES.XPARTDES
--- $DATA1.SALES.XPARTDES verified.
--- SQL operation complete.
>> EXIT
End of SQLCI Session
Example 9-1. Example of Moving the Sample Database (page 4 of 5)