Routine maintenance Summary of IBM DB2 (5)

The DB2 tutorial is: Daily maintenance Summary of IBM DB2 (5 ). 64. How to update the license policy types used on the system?
DB2LICM-PREGISTEREDCONCURRENT

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

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 to 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 obtain the current time?
selectcurrenttimestampfromsysibm. sysdummy1