The db2 tutorial we are watching is: IBM DB2 daily maintenance summary (V). 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
69. According to the different control methods of movement between data and storage space, which two table spaces are divided into?
System-managed space (SMS)
Database Management Space (DMS)
70. How to list the contents of the system database directory?
LISTDATABASEDIRECTORY
Is it an SQL command?
No, it's a system command
72. How to view the content of the database ABC configuration file?
GETDATABASECONFIGURATIONFORABC
73. How to set the parameters of database ABC to the default value?
RESETDATABASECONFIGURATIONFORABC
74. How to modify the database ABC configuration parameter value?
UPDATEDATABASECONFIGURATIONFORABC
USING
75. How to restart the database?
RESTARTDATABASEDATABASE_NAME
76. How to activate the database?
ACTIVATEDATABASEDATABASE_NAME
77. How to stop the database?
DEACTIVATEDATABASEDATABASE_NAME
78. How to delete a database?
DROPDATABASEDATABASE_NAME
79.How to establish a model?
CREATESCHEMASCHEMA_NAME
80.How to set the mode?
SETSCHEMA=SCHEMA_NAME
81. What are the types of tables?
Basic Table
Results table
Summary
Type table
Subtype
Sub-table
A temporary table for declaration
System temporary table
82. How to define a sequence?
CREATESEQUENCEORDERSEQSTARTWITH1INCREMENTBY1NOMAXVALUENOCYCLECACHE24
83. How to put the table in the check pending state?
SETINTEGRITYTABLE_NAMEOFF
84. How to obtain the table's repulsive lock?
LOCKTABLETABLE_NAMEINEXCLUSIVEMODE
85. How to adjust the table to an online status without checking data?
SETINTEGRITYFORTABLE_NAMEALLIMMEDIATEUNCHECKED
86. How to unlock tables?
COMMIT
87. How to close the log of a table?
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
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
69. According to the different control methods of movement between data and storage space, which two table spaces are divided into?
System-managed space (SMS)
Database Management Space (DMS)
70. How to list the contents of the system database directory?
LISTDATABASEDIRECTORY
Is it an SQL command?
No, it's a system command
72. How to view the content of the database ABC configuration file?
GETDATABASECONFIGURATIONFORABC
73. How to set the parameters of database ABC to the default value?
RESETDATABASECONFIGURATIONFORABC
74. How to modify the database ABC configuration parameter value?
UPDATEDATABASECONFIGURATIONFORABC
USING
75. How to restart the database?
RESTARTDATABASEDATABASE_NAME
76. How to activate the database?
ACTIVATEDATABASEDATABASE_NAME
77. How to stop the database?
DEACTIVATEDATABASEDATABASE_NAME
78. How to delete a database?
DROPDATABASEDATABASE_NAME
79.How to establish a model?
CREATESCHEMASCHEMA_NAME
80.How to set the mode?
SETSCHEMA=SCHEMA_NAME
81. What are the types of tables?
Basic Table
Results table
Summary
Type table
Subtype
Sub-table
A temporary table for declaration
System temporary table
82. How to define a sequence?
CREATESEQUENCEORDERSEQSTARTWITH1INCREMENTBY1NOMAXVALUENOCYCLECACHE24
83. How to put the table in the check pending state?
SETINTEGRITYTABLE_NAMEOFF
84. How to obtain the table's repulsive lock?
LOCKTABLETABLE_NAMEINEXCLUSIVEMODE
85. How to adjust the table to an online status without checking data?
SETINTEGRITYFORTABLE_NAMEALLIMMEDIATEUNCHECKED
86. How to unlock tables?
COMMIT
87. How to close the log of a table?
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