Using command prompts
Related topics
When you create a Db2 command, Catalog Manager provides a user-friendly interface with predefined input fields. These input fields correspond to the keywords for a Db2 command. The interface also provides an optional field in which you can specify additional keywords for the command.
To use the command prompt interface
In the Action field on the Primary Menu panel, select DB2 Commands and press Enter.Catalog Manager displays the DB2 Command Prompts panel.
DEEG-R --------------------- DB2 Command Prompts ---------------------------
Command ===>
Select command model==> Notice the order has recently changed
1. ACCESS DATABASE 16. DISPLAY LOCATION 31. SET SYSPARM
2. ALTER BUFFERPOOL * 17. DISPLAY LOG 32. START DATABASE
3. ALTER GROUPBUFFERPOOL 18. DISPLAY PROCEDURE 33. START DDF
4. ALTER UTILITY * 19. DISPLAY RLIMIT 34. START FUNCTION SPEC
5. ARCHIVE LOG 20. DISPLAY THREAD 35. START PROCEDURE
6. CANCEL THREAD 21. DISPLAY TRACE 36. START RLIMIT
* 7. DISPLAY ARCHIVE 22. DISPLAY UTILITY 37. START TRACE
8. DISPLAY BLOCKERS 23. MODIFY TRACE 38. STOP DATABASE
9. DISPLAY BUFFERPOOL 24. RECOVER BSDS 39. STOP DDF
10. DISPLAY DATABASE 25. RECOVER INDOUBT 40. STOP FUNCTION SPEC
11. DISPLAY DDF 26. RECOVER POSTPONED 41. STOP PROCEDURE
12. DISPLAY FUNCTION SPEC 27. RESET GENERICLU 42. STOP RLIMIT
13. DISPLAY GROUP 28. RESET INDOUBT 43. STOP TRACE
14. DISPLAY GROUPBUFFERPOOL 29. SET ARCHIVE 44. TERM UTILITY
15. DISPLAY INDEXMEMORYUSAGE 30. SET LOG
* Note - These commands have no variable parameters and will be executed when
they are selected from this panel.In the Select command model field, type the number of the Db2 command that you want to create and press Enter.Catalog Manager displays the command prompt panel for the selected command. For example, if you selected the START DATABASE command, Catalog Manager displays the following panel:
AUBDYN Start Database 1 to 9 of 9
Command ===>
Scroll ===> PAGE
Process type . . . . . N G-Generate only, E-Generate and Execute
Database name. . . . . Name of the database
Tablespace name. . . . Name of the tablespace
Part list/range. . . .
Clones . . . . . . . . N Process CLONE objects
Access . . . . . . . . <blank> RW, RO, UT, FORCE
Additional options . .- Specify the values for the Db2 command:
In the Process type field, type N, G, or E to specify the method of processing the command, as shown in the following table:
Value
Description
N
Take no action
G
Generate the syntax, but do not execute it.
The syntax that Catalog Manager generates is commented out.
E
Generate the syntax and execute it.
- Specify values for the keywords for the command.
- To specify additional keywords that are not displayed on the panel, enter the keyword and value in the Additional options field.
To save the command values in a profile, on the Command line, type PROFILE SAVEAS profileName.Catalog Manager displays a message that specifies the location of your profile. Press Enter to clear the message.
For more information about Db2 command profiles, see Db2 command profiles.
Press Enter.Catalog Manager displays the DB2 Commands panel in the following figure. The command that you generated is displayed in the Current Command line. The Command Results section displays the result of processing:
- If you selected G in Step 3, Catalog Manager displays the message, 'NO COMMAND EXECUTED YET.'
To execute the command, on the Current Command line, change the asterisk (*) to a dash (-) and press Enter.
- If you selected E in Step 3, Catalog Manager displays the result of the executed command.
ACTPKOUB ---------------------- DB2 Commands --------------- Row 1 to 1 of 1
Command ===> Scroll ===> PAGE
01
Model Commands 1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Current Command . . *START DATABASE(PBXJ2310)
------------------------------- Command Results -------------------------------
NO COMMAND EXECUTED YET
******************************* Bottom of data ********************************