Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, common progress! The following mainly based on DB27.x. The following characters are lowercase.
This article is not read for DB2 masters. All characters are lowercase. 51. Installing DB2 default example names? Devils in Windows or OS / 2 is DB2 in Linux or UNIX environment is DB2Inst1 52. Installation The default account is that the default is DB2Admin in the Linux or UNIX environment in Windows or OS / 2. What are the types of DB2AS 53? CLIENT (Customer) Standalone "Satellite (Satellite) EEDB2 EEE 54. How to create an example? DB2ICRTINSTNAME <... Parameters> 55. How to list all available cases on your system? DB2IList 56. How do you know which example of the current dialogue? GetInstance 57. How to update the configuration of the example? DB2IUPDT
58. How to delete the case? DB2IDropinstance_name The specific steps are as follows: Stopping Examples All applications perform DB2TERMINATE Run on all open command lines DB2STOP backup DB2Instprof registration variable pointed by directory Exit Current Example All Landers use DB2IDROP to delete ID 59. 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 licenses that have been purchased? DB2LICM- U
63. How to force only the number of purchased numbers? DB2LICM-Ehard64. How to update the licensing policy type used on the system? DB2LICM-P
RegisteredConcurrent 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 is at least which tablespaces? One or more user table spaces one or more Temporary table space [PAGE] 69. Different of the control mode between the data and the storage space, where is the space (SMS) database management space (SMS) 70. How to list system databases Directory content? ListDatabaseDirectory 71.createDatabase is a SQL command? Not ABC configuration parameter value? UpdatedatabaseConfigurationForAbc Using
