DB2 common dummies 1000 questions (one)

When applying DB2, you may encounter some seemingly simple problems, especially for beginners.
To sum up, I will release it to you. I hope it will be helpful to you. At the same time, you are welcome to discuss, develop, 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.

1. What are the levels of DB2 products?
Enterprise Edition NTERPRISEEDITION
WORKGROUPEDITION
Extended Enterprise version: iseextendedition
Personal Edition
Satellite version of SATELLITEEDITION
Micro version EVERYPLACE
　　
2. What products can be connected to the DB2 database?
DB2 Client
DB2CONNECT
DB2DATAPROPAGATOR
DB2NET. DATA
DB2DATAJOINER
DB2RELATIONALCONNECT
WEBSPHERE Application Server
And so on
　　
3. What communication protocols does DB2 support?
TCP/IP
NETBIOS
APPG
IPX/SPX
NAMEPIPE
And so on
　　
4. What are the DB2 client products?
DB2 runtime client DB2RUNTIMECLIENT
DB2 management client DB2ADMINISTRATIONCLIENT
DB2 Application Development client DB2APPLICATIONDEVELOPMENTCLIENT
DB2 thin client DB2THINCLIENT
　　
5. Can a database be installed on multiple database servers?
Yes
　　
6. Which version of the stored procedure can be created using SQL statements?
After version 7.1
　　
7. What relational extenders does DB2 provide?
TEXTEXTENDER
Image extensioner IMAGEEXTENDER
Audio extensioner AUDIOEXTENDER
VIDEOEXTENDER
Space Data extender spatialex.pdf
XML extender XMLEXTENDER
NET. SEARCHEXTENDER
　　
8. What is the DB2 installation directory structure in WINDOWS and OS/2 environments?
Use SETUP. EXE for Installation
　　
\ SQLLIB installation root directory, including README file
\ SQLLIB \ ADSM contains the ADSTAR Distributed Storage Manager File
\ SQLLIB \ BIN contains the executable file of the DB2 Tool
\ SQLLIB \ BND: bind file containing DB2 Tool
\ SQLLIB \ CC contains the files required by the Operation Control Center
\ SQLLIB \ CFG contains the default system configuration file
\ SQLLIB \ CONV contains the code page conversion table File
\ SQLLIB \ DB2 default instance directory
\ SQLLIB \ DB2DAS00 default DB2 Management Server Directory
\ SQLLIB \ DOC contains the DB2 online manual
\ SQLLIB \ FUNCTION Default User-Defined FUNCTION directory
\ SQLLIB \ FUNCTION \ UNFENCED default non-isolated user-defined correspondence directory
\ SQLLIB \ HELP Online HELP File
JAVA class library required by \ SQLLIB \ JAVADB2
Java 12 supports JDK1.2
\ SQLLIB \ MISC contains HTML search server files
\ SQLLIB \ MSG \ PRIME contains information files
\ SQLLIB \ QP client file containing QUERYPATROLLER
\ SQLLIB \ SAMPLES contains sample programs and sample scripts
\ SQLLIB \ SPMLOG contains the DB2 synchronization point Manager Log File
\ SQLLIB \ THNSETUP contains the thin client Installation File
9. What is the DB2 installation directory structure in UNIX and LINUX environments?
Use DB2SETUP. EXE for Installation
The following directories will also be created under the installed root directory:
　　
The root directory for README installation, including the README file
ADM contains system management tool files
ADSM contains the ADSTAR Distributed Storage Manager File
BIN contains binary executable files of the DB2 Tool
BND contains the BIND file of the DB2 Tool
CC contains the files required by the Operation Control Center
CFG contains the default system configuration file
CONV contains the code page conversion table File
DOC contains the DB2 online manual
FUNCTION Default User-Defined FUNCTION directory
FUNCTION \ UNFENCED default non-isolated user-defined correspondence directory
INSTALL contains the installer
INSTANCE contains INSTANCE scripts
JAVA class library required by JAVADB2
LIBDB2 Library File
MAP contains the db2ing file used by DB2CONNECT
MISC contains HTML search server files
SAMPLES contains sample programs and sample scripts
MSG \ $ L contains DB2 information files

10. Which command is used to install DB2 under AIX?
INSTALLP command
　　
11. How many DB2 databases can be installed in the same operating system?
Yes
　　
12. How do I stop an instance?
DB2STOP
　　
13. How do I start an instance?
DB2START
[Page]
14. How do I modify the value of the registration item?
DB2SET can be modified
For example:
Sets a parameter for the current instance.
DB2SETPARAMETER = VALUE
　　
Set a global Parameter
DB2SETPARAMETER = VALUE-G (lower case)
　　
View the list of all variables that can be set in the configuration file Registry
DB2SET-LR (lower case)
　　
15. How to execute operating system commands in CLP?
Add "! "As prefix
DB2 =>! DIRC :\
　　
16. What should I do if the command in CLP is too long?
Use "\" as the continuation symbol
　　
17. How to obtain the syntax information of DB2 commands?
DB2? Show all DB2 commands
DB2? COMMAND: displays COMMAND information.
DB2? SQLnnnn displays the explanation of this SQLCODE
DB2? DB2nnnn displays the explanation of this DB2 Error
　　
18. How do I view the current CLP settings?
DB2 => LISTCOMANDOPTIONS
　　
19. How to update the specific settings of the current CLP session?
DB2UPDATECOMMANDOPTIONSUSINGOPTIONS...
　　
20. Which command can be used to call COMMANDWINDOWS?
DB2CMD command
　　
21. What is the default name of the management server?
DB2AS in UNIX
DB2DAS00 in WINDOWS
　　
22. Commonly Used commands for managing DB2 server instances?
DB2ADMINSTART start the DB2 management server instance
DB2ADMINSTOP stop the DB2 management server instance
Create a DB2 management server instance in DASICRTUNIX
Delete A DB2 management server instance under DASIDROPUNIX
Create a DB2 management server instance under DB2ADMINCREATEWINDOWSOROS/2
Delete A DB2 management server instance under DB2ADMINDROPWINDOWSOROS/2
DB2GETADMINCFG displays the configuration parameters of the DB2 Management Server
DB2UPDATEADMINCFG modify the configuration parameters of the DB2 Management Server
DB2RESETADMINCFG sets the configuration parameters of the DB2 Management Server to the default value.
　　
23. What types of DB2 directories are divided?
System database directory
Local Database directory
Node directory
DCS directory
Manage node Directories
　　
24. How do I view the system database directory?
LISTDBDIRECTORY
　　
25. How to view the database server directory?
LISTNODEDIRECTORY
　　
26. What is the default port of the DB2 instance server?
50000
The server name is DB2CDB2.
　　
27. What are the authentication types on the DB2UDB server?
SERVER
SERVER_ENCRYPT
CLIENT
DCE
DCE_SERVER_ENCRYPT
KERBEROS
KRB_SERVER_ENCRYPT
　　
28. What are the authentication types of the DB2 client?
SERVER
SERVER_ENCRYPT
DCS
DCS_ENCRYPT
CLIENT
DCE
　　
29. What types of permissions does DB2 have?
SYSADM System Management permission
SYSCTRL system control permission
SYSMAINT system maintenance permission
DBADM database management permission
Permission to LOAD a table
　　
30. Which of the following permissions cannot be granted through GRANT?
SYSAM
SYSCTRL
SYSMAINT
To modify the preceding permissions, you must modify the Database Manager configuration parameters.
　　
31. What types of tables are there?
Permanent Table (base table)
Temporary table (description table)
Temporary table (derived table)
　　
32. How many tables does a user have?
SELECT * FROMSYSIBM. SYSTABLESWHERECREATOR = 'user'
　　
33. How do I know the functions under a user?
Select * fromIWH. USERFUNCTION
Select * fromsysibm. SYSFUNCTIONS
　
34. How do I know the number of views under a user?
Select * fromsysibm. sysviewsWHERECREATOR = 'user'
　　
35. How do I know the current DB2 version?
Select * fromsysibm. sysvERSIONS
　　
36. How do I know the number of triggers under a user?
Select * fromsysibm. SYSTRIGGERSWHERESCHEMA = 'user'
　　
37. How do I know the status of TABLESPACE?
Select * fromsysibm. SYSTABLESPACES
　　
38. How do I know the SEQUENCE status?
Select * fromsysibm. SYSSEQUENCES
　　
39. How do I know the SCHEMA status?
Select * fromsysibm. SYSSCHEMATA
　　
40. How do I know the INDEX status?
Select * fromsysibm. SYSINDEXES
　　
41. How do I know the status of table fields?
Select * fromsysibm. SYSCOLUMNSWHERETBNAME = 'aaa'
　　
42. How do I know the DB2 data type?
Select * fromsysibm. SYSDATATYPES
　　
43. How do I know the BUFFERPOOLS status?
Select * fromsysibm. SYSBUFFERPOOLS
　　
44. Restrictions on modifying fields in the DB2 table?
Only the VARCHAR2 type can be modified and can be increased or not decreased.
　　
45. How to view the table structure?
DESCRIBLETABLETABLE_NAME
OR
DESCRIBLESELECT * FROMSCHEMA. TABLE_NAME
　　
46. How to quickly clear a large table?
ALTERTABLETABLE_NAMEACTIVENOTLOGGEDINITALLYWITHEMPTYTABLE
　　
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'