DB2 common dummies 1000 questions (2) page 1/2

Source: Internet
Author: User

The db2 Tutorial we are reading is: DB2 common dummies: 1000 (2 ). When applying DB2, you may encounter some seemingly simple problems. For Beginners, I would like to briefly summarize them and publish them to you, hoping to help you, we also welcome everyone to discuss, develop together, and make progress together!
The characters below are mainly in lower case based on DB27.X.


This article does not need to be viewed by DB2 experts.
All characters are in lowercase.

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
64. How to update the license policy types used on the system?
DB2LICM-P REGISTEREDCONCURRENT
  
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.