IBM DB2 routine maintenance Summary

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

　　

The root directory of SQLLIB installation, including the README file

SQLLIBADSM contains the ADSTAR Distributed Storage Manager File

SQLLIBBIN contains the executable file of the DB2 Tool

SQLLIBBND contains the BIND file of the DB2 Tool

SQLLIBCC contains the files required by the Operation Control Center

SQLLIBCFG contains the default system configuration file

SQLLIBCONV contains the code page conversion table File

Default instance directory of SQLLIBDB2

SQLLIBDB2DAS00 default DB2 Management Server Directory

SQLLIBDOC contains the DB2 online manual

SQLLIBFUNCTION Default User-Defined Function directory

SQLLIBFUNCTIONUNFENCED default non-isolated user-defined correspondence directory

SQLLIBHELP Online Help File

JAVA class library required by SQLLIBJAVADB2

Java 12 supports JDK1.2

SQLLIBMISC contains HTML search server files

SQLLIBMSGPRIME contains information files

SQLLIBQP client file containing QUERYPATROLLER

SQLLIBSAMPLES contains sample programs and sample scripts

SQLLIBSPMLOG contains the DB2 synchronization point Manager Log File

SQLLIBTHNSETUP 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

FUNCTIONUNFENCED 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

　　

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 this permission, 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 = AAAA

　　

42. How do I know the DB2 data type?

Select * fromsysibm. SYSDATATYPES

　　

43. How do I know the BUFFERPOOLS status?

Select * fromsysibm. SYSBUFFERPOOLS

　　

44.