IBM DB2 routine maintenance Summary (4)

The db2 tutorial is: Daily maintenance Summary of IBM DB2 (4 ). 46. How to quickly clear a large table?
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINITALLYWITHEMPTYTABLE
ALTER TABLETABLE_NAME ACTIVE NOT LOGGED INITALLY WITH EMPTYTABLE
The delete action between two commit does not record logs.
Commit
Alter table AB activate not logged intially
Delete AB where id> 1000
Commit
(The created table AB does not record the log: create table AB (id int) not logged initially)
　　
47. How to view database packages?
Select * fromsysCAT. PACKAGES
　　
48. How to view the stored procedure of the database?
SELECT * FROMSYSCAT. PROCEDURES
　　
49. How to view table constraints?
SELECT * FROMSYSCAT. CHECKSWHERETABNAME = 'aaa'
　　
50. How can I view the complete reference constraints of a table?
SELECT * FROMSYSCAT. REFERENCESWHERETABNAME = 'aaa'

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


<