DB2 common dummies question 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 [page]
　　
69. Which two types of tablespaces can be used to control the movement between data and buckets?
System Management space (SMS)
Database Management space (DMS)
　　
70. How to list the contents of the system database directory?
LISTDATABASEDIRECTORY
　　
71. Is CREATEDATABASE an SQL command?
No, it's a system command
　　
72. How can I view the configuration file content of database ABC?
GETDATABASECONFIGURATIONFORABC
　　
73. How do I set the ABC parameter of the database to the default value?
RESETDATABASECONFIGURATIONFORABC
　　
74. How to modify the value of the ABC configuration parameter in the database?
UPDATEDATABASECONFIGURATIONFORABC
USING
　　
75. How to restart the database?
RESTARTDATABASEDATABASE_NAME
　　
76. How to activate the database?
ACTIVATEDATABASEDATABASE_NAME
　　
77. How do I stop a database?
DEACTIVATEDATABASEDATABASE_NAME
　　

78. How to delete a database?
DROPDATABASEDATABASE_NAME
　　
79. How to Establish a mode?
CREATESCHEMASCHEMA_NAME
　　
80. How do I set the mode?
SETSCHEMA = SCHEMA_NAME
　　
81. What types of tables are there?
Basic table
Result table
Summary table
Type table
Child type
Sub-table
Declared temporary table
System temporary table

82. How to define a sequence?
CREATESEQUENCEORDERSEQSTARTWITH1INCREMENTBY1NOMAXVALUENOCYCLECACHE24

83. How to put the table in the check pending status?
SETINTEGRITYTABLE_NAMEOFF
　　
84. How to obtain the table exclusion lock?
LOCKTABLETABLE_NAMEINEXCLUSIVEMODE
　　
85. How can I adjust the table to the online status without checking the data?
SETINTEGRITYFORTABLE_NAMEALLIMMEDIATEUNCHECKED

86. How can I unlock a table?
COMMIT
　　
87. How do I disable table logs?
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINIALLY
　　
88. How to delete a table?
DROPSCHEMA. TABLE_NAME
　　　　
89. How to rename a table?
RENAMETABLE_OLDTOTABLE_NEW
　　
90. How to get the current time?
SELECTCURRENTTIMESTAMPFROMSYSIBM. SYSDUMMY1