DB2 Common fool question 1000 question (a) 1th/2 page _db2

Looking at the DB2 tutorial is: DB2 common fool question 1000 q (i).

When you apply DB2, you may encounter some seemingly simple problems, especially for beginners, I have a simple
Summed up, released to everyone, I hope that we can help, but also welcome everyone to discuss together, common development and common progress!

The following are mainly based on db27.x. The following characters are lowercase.

This article for DB2 Master is not to see.

What are the levels of 1.DB2 products?
Enterprise version of the Nterpriseedition
Workgroup Edition Workgroupedition
Enterprise Extended Edition Enterpriseextendededition
Personal version of the Personaledition
Satellite version of the Satelliteedition
Miniature version of the Everyplace
　　
2. What are the products that can be connected to the DB2 database?
DB2 Client
DB2Connect
Db2datapropagator
Db2net. DATA
Db2datajoiner
Db2relationalconnect
WebSphere Application Server
Wait
　　
What are the communication protocols supported by 3.DB2?
Tcp / ip
NETBIOS
Appg
Ipx/spx
Namepipe
Wait
　　
What are the 4.DB2 client products?
DB2 Run Time 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?
OK
　　
6. From which version can stored procedures be created with SQL statements?
After version 7.1
　　
What relational Extender does 7.DB2 provide?
Text Extender Textextender
Image Extender Imageextender
Audio Extender Audioextender
Video Extender Videoextender
Spatial Data Extender Spatialextender
XML Extender Xmlextender
Network Search Extender Net.searchextender
　　
DB2 installation directory structure in 8.WINDOWS and OS/2 environments?
Use SETUP.EXE to install
　　
\sqllib installed root directory, including readme file
\SQLLIB\ADSM contains Adstar distributed Storage Manager files
\sqllib\bin executable file containing the DB2 tool
\sqllib\bnd the binding file containing the DB2 tool
\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 files
\SQLLIB\DB2 the default instance directory
\SQLLIB\DB2DAS00 default DB2 Management Server directory
\sqllib\doc contains DB2 online manuals
\sqllib\function Default user-defined function directory
\sqllib\function\unfenced default non-quarantined user custom correspondence directory
\sqllib\help online Help file
Java class libraries required by \SQLLIB\JAVADB2
JAVA12 contains JDK1.2 support programs
\sqllib\misc contains HTML search server files
\sqllib\msg\prime contains information files
\SQLLIB\QP contains Querypatroller client files
\sqllib\samples contains sample programs and sample scripts
\sqllib\spmlog contains DB2 Sync point manager log file
\sqllib\thnsetup contains thin client installation files
9.UNIX and Linux Environment DB2 installation directory structure?
Use DB2SETUP.EXE to install
The following directories are also created under the root directory of the installation:
　　
The root directory of the readme installation, including the Readme file
ADM contains system administration tool files
ADSM contains Adstar distributed Storage Manager files
Bin contains binary executables for the DB2 tool
BND the binding file containing the DB2 tool
CC contains files required to run the control center
The CFG contains the default system configuration file
Conv contains code page conversion table files
Doc contains DB2 online manuals
Function Default user-defined function directory
function\unfenced default non-quarantined user custom correspondence directory
Install contains setup programs
Instance contains instance scripts
Java class libraries required by JAVADB2
LIBDB2 Library files
Map contains map files used by DB2Connect
Misc contains HTML Search server files
Samples contain sample programs and sample scripts
Msg\ $L contains DB2 information file

Which command does the 10.AIX use to install the DB2?
INSTALLP command
　　
11. Can you install multiple DB2 databases under the same operating system?
OK
　　
12. How do I stop an instance?
Db2stop
　　
13. How do I start the instance?
Db2start
　　

Current 1/2 page 12 Next read the full text