The db2 Tutorial we are reading is: DB2 common dummies: 1000 (2 ). When applying DB2, you may encounter some seemingly simple problems. For Beginners, I would like to briefly summarize them and publish them to you, hoping to help you, we also welcome everyone to discuss, develop together, and make progress together!
The characters below are mainly in lower case based on DB27.X.
This article does not need to be viewed by DB2 experts.
All characters are in lowercase.
51. What is the default case name for installing DB2?
In WINDOWS or OS/2, DB2 is used by default.
In LINUX or UNIX, the default value is DB2INST1.
52. What is the default account after installation?
In WINDOWS or OS/2, the default value is DB2ADMIN.
In LINUX or UNIX, the default value is DB2AS.
53. What types of cases are there?
CLIENT (customer)
STANDALONE (independent)
SATELLITE (SATELLITE)
EEDB2
EEE
54. How to create an example?
DB2ICRTINSTNAME <... PARAMETERS>
55. How do I list all the available cases on the system?
DB2ILIST
56. How do I know which example of the current conversation is used?
GETINSTANCE
57. How to update the instance configuration?
DB2IUPDT
58. How to delete an example?
DB2IDROPINSTANCE_NAME
The procedure is as follows:
Stop all applications in the case
Execute DB2TERMINATE on all open command lines
Run DB2STOP
Back up the example directory pointed out by the DB2INSTPROF registration variable
All logged-on users in the exit case
Use DB2IDROP
You can also delete the ID.
59. How do I list all products with license information on the local system?
DB2LICM-L
60. How to add a product license?
DB2LICM-AFILENAME
61. How to delete a product license?
DB2LICM-RPRODUCTPASSWORD
62. How to update the number of purchased licenses?
DB2LICM-U
63. How to force only the purchased quantity to be used?
DB2LICM-EHARD
64. How to update the license policy types used on the system?
DB2LICM-P REGISTEREDCONCURRENT
65. How to update the number of processors on the system?
DB2LICM-N
66. How do I query the version information recorded in the license file?
DB2LICM-V
67. How can I query the help information of DB2LICM?
DB2LICM-H
68. What table spaces does a database contain?
One directory tablespace
One or more user tablespaces
One or more temporary tablespace