The db2 tutorial I am looking at is: 1000 common fool questions for DB2 (two). When applying DB2, you may encounter some seemingly simple problems. Especially for novices, I will briefly summarize it here and post it to you. I hope it will be helpful to you. At the same time, you are welcome to discuss together, develop together and make progress together!
The following are mainly based on the characters. The following characters are lowercase.
This article is not necessary for DB2 experts.
All characters are lowercase.
51. What is the default case name for installing DB2?
The default is DB2 in WINDOWS or OS/2
In LINUX or UNIX environment, the default is DB2INST1
52. What is the default account after installation?
The default is DB2ADMIN in WINDOWS or OS/2
In LINUX or UNIX environment, the default is DB2AS
53. What are the types of cases?
CLIENT (customer)
STANDALONE (independent)
SATELLITE (Satellite)
EEDB2
EEE
54. How to create an example?
DB2ICRTINSTNAME<...PARAMETERS>
55. How to list all available examples on the system?
DB2ILIST
56. How to know which example is used in the current conversation?
GETINSTANCE
57. How to update the configuration of the case?
DB2IUPDT
58. How to delete examples?
DB2IDROPINSTANCE_NAME
The specific steps are as follows:
Stop all applications on the case
Execute DB2TERMINATE on all open command lines
Run DB2STOP
Backup the example directory pointed out by the DB2INSTPROF registration variable
Logout case All loginers
Using DB2IDROP
You can also delete the ID
59. How to 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 license for a product?
DB2LICM-RPRODUCTPASSWORD
62. How to update the number of licenses purchased?
DB2LICM-U
63. How to force only the purchased quantity to be used?
DB2LICM-EHARD
64. How to update the type of license policy used on the system?
DB2LICM-PREGISTEREDCONCURRENT
65. How to update the number of processors on the system?
DB2LICM-N
66. How to query the version information of the license file record?
DB2LICM-V
67. How to query DB2LICM help information?
DB2LICM-H
68. What tablespaces does a database include at least?
A directory table space
One or more user tablespaces
One or more temporary tablespaces
The following are mainly based on the characters. The following characters are lowercase.
This article is not necessary for DB2 experts.
All characters are lowercase.
51. What is the default case name for installing DB2?
The default is DB2 in WINDOWS or OS/2
In LINUX or UNIX environment, the default is DB2INST1
52. What is the default account after installation?
The default is DB2ADMIN in WINDOWS or OS/2
In LINUX or UNIX environment, the default is DB2AS
53. What are the types of cases?
CLIENT (customer)
STANDALONE (independent)
SATELLITE (Satellite)
EEDB2
EEE
54. How to create an example?
DB2ICRTINSTNAME<...PARAMETERS>
55. How to list all available examples on the system?
DB2ILIST
56. How to know which example is used in the current conversation?
GETINSTANCE
57. How to update the configuration of the case?
DB2IUPDT
58. How to delete examples?
DB2IDROPINSTANCE_NAME
The specific steps are as follows:
Stop all applications on the case
Execute DB2TERMINATE on all open command lines
Run DB2STOP
Backup the example directory pointed out by the DB2INSTPROF registration variable
Logout case All loginers
Using DB2IDROP
You can also delete the ID
59. How to 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 license for a product?
DB2LICM-RPRODUCTPASSWORD
62. How to update the number of licenses purchased?
DB2LICM-U
63. How to force only the purchased quantity to be used?
DB2LICM-EHARD
64. How to update the type of license policy used on the system?
DB2LICM-P
65. How to update the number of processors on the system?
DB2LICM-N
66. How to query the version information of the license file record?
DB2LICM-V
67. How to query DB2LICM help information?
DB2LICM-H
68. What tablespaces does a database include at least?
A directory table space
One or more user tablespaces
One or more temporary tablespaces
12Next pageRead the full text