The DB2 tutorial you are looking at 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 is not logged
Commit
ALTER TABLE AB activate not logged intially
Delete ab where ID >1000
Commit
(created table AB does not log: CREATE TABLE AB (ID int) not logged initially)
47. How do I view the package for a database?
Select*fromsyscat.packages
48. How do I view the stored procedures of a database?
Select*fromsyscat. Procedures
49. How do I see the constraints on a table?
Select*fromsyscat. Checkswheretabname= ' AAAA '
50. How do I see the reference complete constraint for a table?
Select*fromsyscat. Referenceswheretabname= ' AAAA '
51. Install DB2 The default case name is?
The default in Windows or OS/2 is DB2
In Linux or UNIX environments, the default is Db2inst1
52. What is the default account after installation?
The default in Windows or OS/2 is Db2admin
In Linux or UNIX environments, the default is Db2as
53. What are the types of cases?
Client (Customer)
STANDALONE (Independent)
Satellite (satellite)
EEDB2
EEE
54. How do I create a case?
Db2icrtinstname< Parameters>
55. How do I list all the available cases on the system?
Db2ilist
56. How do I know which case is used for the current dialogue?
GetInstance
57. How do I update the configuration of the case?
Db2iupdt
58. How do I delete a case?
Db2idropinstance_name
The specific steps are as follows:
Stop all applications on the case
Perform db2terminate on all open command lines
Run Db2stop
Backup Db2instprof The case directory indicated by the registration variable
Exit Case All Landers
Using Db2idrop
You can also delete IDs
59. How do I list all the products with license information on the local system?
Db2licm-l
60. How to add a product license?
Db2licm-afilename
61. How do I remove a license for a product?
Db2licm-rproductpassword
62. How do I update the number of licenses that have been purchased?
Db2licm-u
63. How to enforce the use of the quantity already purchased?
Db2licm-ehard
<
