The db2 tutorial I am watching is: IBM DB2 daily maintenance summary (I). :
1.What are the levels of DB2 products?
Enterprise version of NTERPRISEEDITION
Working Group Edition WORKGROUPEDITION
Enterprise Extended Edition ENTERPRISEEXTENDEDEDITION
Personal version of PERSONALEDITION
Satellite version of SATELLITEEDITION
Miniature version of EVERYPLACE
2. What products can be connected to the DB2 database?
DB2 client
DB2CONNECT
DB2DATAPROPAGATOR
DB2DATAJOINER
DB2RELATIONALCONNECT
WEBSPHERE application server
wait
3.What are the communication protocols supported by DB2?
TCP/IP
NETBIOS
APPG
IPX/SPX
NAMEPIPE
wait
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?
Can
6. From which version can stored procedures be created using SQL statements?
After version 7.1
7.What relational extenders does DB2 provide?
Text Extended
Image Expander IMAGEEXTENDER
Audio Extender AUDIOEXTENDER
Video Expander VIDEOEXTENDER
Spatial Data Extender SPATIALEXTENDER
XML Extender XMLEXTENDER
Web Search Extender
And the DB2 installation directory structure in OS/2 environment?
Used to install
\The root directory of SQLLIB installation, including README files
\SQLLIB\ADSM contains ADSTAR distributed storage manager file
\SQLLIB\BIN contains the executable file of the DB2 tool
\SQLLIB\BND contains the binding file for DB2 tools
\SQLLIB\CC contains the files required to run the Control Center
\SQLLIB\CFG contains the default system configuration file
\SQLLIB\CONV contains code page conversion table file
\SQLLIB\DB2 default instance directory
\SQLLIB\DB2DAS00 Default DB2 Management Server Directory
\SQLLIB\DOC contains DB2 online manual
\SQLLIB\FUNCTION Default user-defined function directory
\SQLLIB\FUNCTION\UNFENCED Default Non-isolated User Custom Correspondence Directory
\SQLLIB\HELP Online Help File
\SQLLIB\JAVA class library required by JAVADB2
JAVA12 includes support programs for JDK1.2
\SQLLIB\MISC contains HTML search server file
\SQLLIB\MSG\PRIME contains information file
\SQLLIB\QP Client file containing QUERYPATROLLER
\SQLLIB\SAMPLES contains sample programs and sample scripts
\SQLLIB\SPMLOG contains DB2 synchronization point manager log file
\SQLLIB\THNSETUP contains thin client installation files
What is the DB2 installation directory structure in the LINUX environment?
Used to install
The following directory will also be created in the root directory of the installation:
The root directory of README installation, including README files
ADM contains system management tool files
ADSM contains ADSTAR distributed storage manager files
BIN contains binary executable files for DB2 tools
BND contains the binding file of DB2 tool
CC contains the files required to run the Control Center
CFG contains the default system configuration file
CONV contains code page conversion table file
DOC contains DB2 online manual
FUNCTION default user-defined function directory
FUNCTION\UNFENCED Default Non-isolated User Custom Correspondence Directory
INSTALL contains the installer
INSTANCE contains instance scripts
JAVA class library required for JAVADB2
LIBDB2 library file
MAP contains the mapping file used by DB2CONNECT
MISC contains HTML search server files
SAMPLES contains sample programs and sample scripts
MSG\$L contains DB2 information file
1.What are the levels of DB2 products?
Enterprise version of NTERPRISEEDITION
Working Group Edition WORKGROUPEDITION
Enterprise Extended Edition ENTERPRISEEXTENDEDEDITION
Personal version of PERSONALEDITION
Satellite version of SATELLITEEDITION
Miniature version of EVERYPLACE
2. What products can be connected to the DB2 database?
DB2 client
DB2CONNECT
DB2DATAPROPAGATOR
DB2DATAJOINER
DB2RELATIONALCONNECT
WEBSPHERE application server
wait
3.What are the communication protocols supported by DB2?
TCP/IP
NETBIOS
APPG
IPX/SPX
NAMEPIPE
wait
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?
Can
6. From which version can stored procedures be created using SQL statements?
After version 7.1
7.What relational extenders does DB2 provide?
Text Extended
Image Expander IMAGEEXTENDER
Audio Extender AUDIOEXTENDER
Video Expander VIDEOEXTENDER
Spatial Data Extender SPATIALEXTENDER
XML Extender XMLEXTENDER
Web Search Extender
And the DB2 installation directory structure in OS/2 environment?
Used to install
\The root directory of SQLLIB installation, including README files
\SQLLIB\ADSM contains ADSTAR distributed storage manager file
\SQLLIB\BIN contains the executable file of the DB2 tool
\SQLLIB\BND contains the binding file for DB2 tools
\SQLLIB\CC contains the files required to run the Control Center
\SQLLIB\CFG contains the default system configuration file
\SQLLIB\CONV contains code page conversion table file
\SQLLIB\DB2 default instance directory
\SQLLIB\DB2DAS00 Default DB2 Management Server Directory
\SQLLIB\DOC contains DB2 online manual
\SQLLIB\FUNCTION Default user-defined function directory
\SQLLIB\FUNCTION\UNFENCED Default Non-isolated User Custom Correspondence Directory
\SQLLIB\HELP Online Help File
\SQLLIB\JAVA class library required by JAVADB2
JAVA12 includes support programs for JDK1.2
\SQLLIB\MISC contains HTML search server file
\SQLLIB\MSG\PRIME contains information file
\SQLLIB\QP Client file containing QUERYPATROLLER
\SQLLIB\SAMPLES contains sample programs and sample scripts
\SQLLIB\SPMLOG contains DB2 synchronization point manager log file
\SQLLIB\THNSETUP contains thin client installation files
What is the DB2 installation directory structure in the LINUX environment?
Used to install
The following directory will also be created in the root directory of the installation:
The root directory of README installation, including README files
ADM contains system management tool files
ADSM contains ADSTAR distributed storage manager files
BIN contains binary executable files for DB2 tools
BND contains the binding file of DB2 tool
CC contains the files required to run the Control Center
CFG contains the default system configuration file
CONV contains code page conversion table file
DOC contains DB2 online manual
FUNCTION default user-defined function directory
FUNCTION\UNFENCED Default Non-isolated User Custom Correspondence Directory
INSTALL contains the installer
INSTANCE contains instance scripts
JAVA class library required for JAVADB2
LIBDB2 library file
MAP contains the mapping file used by DB2CONNECT
MISC contains HTML search server files
SAMPLES contains sample programs and sample scripts
MSG\$L contains DB2 information file