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
　　
\ 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