IBM DB2 Daily Maintenance Summary

Source: Internet
Author: User
Tags db2 db2 client db2 installation ibm db2 websphere application server
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.