Create new query

In this task, we'll illustrate how to create a new query to get all ddtsu and ddtvr information from ceqcom2.

Follow these steps:

  1. Start MUT and select an ECP in the ECP List Box.
  2. Open the Mass Update Wizard , using one of these 3 methods: (1) click New Query on the vertical toolbar, (2) select File > New Query , or (3) type Ctrl + N.
  3. In Query Name , type ceqcom2_ddtsu_ddtvr.
  4. Click Next>.
  5. From the Table Name list, select ceqcom2, Rel. 20 -the ECP Release box auto fills to 20.
  6. Click Next>.
  7. First, select ddtsu from Field Name , then select NE (not equal) as Condition, and finally, type 0 (zero) as Value. ( Condition not equal  0).
  8. Click Next>.
  9. Accept the default selection No, last criterion.
  10. Click Next>.
  11. Note: MUT has moved *csno (Cell Site) key field to Dump Fields. All key fields (marked with *) should be left in Dump Fields as they serve to identify the record.

  12. Scroll down Available Fields , hold down the Ctrl key, select ddtsu and ddtvr , and then click Add Fields>> -they are added to Dump Fields.
  13. Hold down the Shift key and select the first 3 Available Fields and click Add Fields>> -they are added to Dump Fields.
  14. Click Next> for the 6 th Mass Update Wizard screen.
  15. The query generated should be: DB: ceqcom2 MATCH: ddtsu NE 0 OUTPUT: csno ddtsu ddtvr (+ your 3 choices) ENDDB
  16. If the DBsurvey query does not match the query above, use the <Back button to make changes.

  17. When the query matches, click Next>.
  18. Open a Telnet (OMP) session ( Virtual Terminal window) for the selected ECP, using one of these 3 methods: (1) press OMP on the horizontal toolbar, (2) select OMP > Connect to OMP , or (3) type Ctrl + P
  19. Enter your login and password. You should be at the OMP shell prompt $ -if the OMP prompts you with a menu, select Miscellaneous... and at the sub-menu select OMP Shell.
  20. Click anywhere on Mass Update Wizard to bring it to the front.
  21. Click Next> -MUT executes the DBsurvey and displays the result in the box.
  22. The following steps are the result of executing DBsurvey on the next Mass Update Wizard screen.

  23. Verify results of the query. If the query is successful click Transfer Dump (if not, make corrections using the <Back button).
  24. MUT automatically brings up the Edit Query Output window, including the query name- ceqcom2_ddtsu_ddtvr -in the header of the window, and displays the dumped fields in it.
  25. Click Finish on the final wizard screen to close it.
  26. Click Done on the Virtual Terminal window to close it.
  27. On the Edit Query Output window, use the Menu button to sort, edit and print the output. Then (if needed), use the Script button to create and execute an apxrcv script to update the switch with your modifications.
  28. Click Done on the Edit Query Output window to close it.

© 3D Cellular. All rights reserved.