Looking at the DB2 tutorial is: DB2 common fool question 1000 Q (ii). Everyone in the application of DB2 may encounter some seemingly simple problems, especially for beginners, I briefly summed up in this, released to everyone, hope that we can help, but also welcome everyone to explore together, common development and common progress!
The following are mainly based on db27.x. The following characters are lowercase.
This article for DB2 Master is not to see.
All characters are lowercase.
51. Install DB2 The default case name is?
The default in Windows or OS/2 is DB2
In Linux or UNIX environments, the default is Db2inst1
52. What is the default account after installation?
The default in Windows or OS/2 is Db2admin
In Linux or UNIX environments, the default is Db2as
53. What are the types of cases?
Client (Customer)
STANDALONE (Independent)
Satellite (satellite)
EEDB2
EEE
54. How do I create a case?
Db2icrtinstname< Parameters>
55. How do I list all the available cases on the system?
Db2ilist
56. How do I know which case is used for the current dialogue?
GetInstance
57. How do I update the configuration of the case?
Db2iupdt
58. How do I delete a case?
Db2idropinstance_name
The specific steps are as follows:
Stop all applications on the case
Perform db2terminate on all open command lines
Run Db2stop
Backup Db2instprof The case directory indicated by the registration variable
Exit Case All Landers
Using Db2idrop
You can also delete IDs
59. How do I list all the products with license information on the local system?
Db2licm-l
60. How to add a product license?
Db2licm-afilename
61. How do I remove a license for a product?
Db2licm-rproductpassword
62. How do I update the number of licenses that have been purchased?
Db2licm-u
63. How do I force only the quantity already purchased?
Db2licm-ehard
64. How do I update the license policy type used on the system?
Db2licm-p registeredconcurrent
65. How do I update the number of processors on the system?
Db2licm-n
66. How do I query the version information for the license file record?
Db2licm-v
67. How do I query the Help information for DB2LICM?
Db2licm-h
68. What table space does a database include at least?
One directory table space
One or more user tablespace
One or more temporary tablespace
current 1/2 page
1 2 Next read the full page
