The db2 tutorial we are watching is: IBM DB2 daily maintenance summary (IV). 46. How to quickly clear a large table?
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINITALLYWITHEMPTYTABLE
ALTER TABLETABLE_NAME ACTIVE NOT LOGGED INITALLY WITH EMPTYTABLE
The delete action between two commits does not record the log.
commit
alter table ab activate not logged intially
delete ab where id >1000
commit
(The created table ab does not log: create table ab (id int) not logged initially)
47. How to view the database package?
select*
48. How to view the stored procedures of the database?
SELECT*
49. How to view the constraints of tables?
SELECT*='AAAA'
50.How to view the complete constraints for references of a table?
SELECT*='AAAA'
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
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINITALLYWITHEMPTYTABLE
ALTER TABLETABLE_NAME ACTIVE NOT LOGGED INITALLY WITH EMPTYTABLE
The delete action between two commits does not record the log.
commit
alter table ab activate not logged intially
delete ab where id >1000
commit
(The created table ab does not log: create table ab (id int) not logged initially)
47. How to view the database package?
select*
48. How to view the stored procedures of the database?
SELECT*
49. How to view the constraints of tables?
SELECT*='AAAA'
50.How to view the complete constraints for references of a table?
SELECT*='AAAA'
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