DB2 common dummies 1000 question (1) page 1/2

Source: Internet
Author: User
Tags db2 client db2 installation websphere application server

The db2 Tutorial we are reading is: DB2 common dummies 1000 (1 ).

When applying DB2, you may encounter some seemingly simple problems, especially for beginners.
To sum up, I will release it to you. I hope it will be helpful to you. At the same time, you are welcome to discuss, develop, and make progress together!

The characters below are mainly in lower case based on DB27.X.

This article does not need to be viewed by DB2 experts.

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

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
  

Related Article

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.