Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, make progress together!
The following mainly based on DB27.x. The following characters are lowercase. This article is not to see on the DB2 master. 1.DB2 products have those levels? Enterprise Edition NTERPRISEEDITION Working Group Edition Workgrouped Business Extension EnterpriseExtendededed Personal Edition the PERSONALEDITION satellite version of SATELLITEEDITION miniature version of EVERYPLACE 2. can connect to the DB2 database product What? DB2 client DB2CONNECT DB2DATAPROPAGATOR DB2NET.DATA DB2DATAJOINER DB2RELATIONALCONNECT WEBSPHERE application server supports communication protocols such as 3.DB2 What? TCP / IP NETBIOS APPG IPX / SPX NamePipe, etc. 4.DB2 client products What are the DB2 Run Time Client DB2RuntimeClient DB2 Management Client DB2AdministrationClient DB2 Application Development Client DB2ApplicationDevelopmentClient DB2 Thin Client DB2THINCLIENT 5. Can a database can be installed in multiple database servers ? Can 6. Which version of the stored procedure can be created with a SQL statement? 7.1 After 7.db2 provides which relational expansion? Text extension TextExtender Image Extender ImageExtender Audio AudioExtender Video Expander VideoExtender Space Data Extension SpatialeExtender XML extender XMLExtender network search expander NET.SEARCHEXTENDER 8.Windows and OS / 2 Environment DB2 installation directory structure? Use setup.exe to install the root directory installed / SQLLIB installation, including Readme file / SQLLIB / ADSM contains Adstar Distributed Storage Manager file / SQLLIB / BIN contains executable file / SQLLIB / BND containing the DB2 tool / SQLLIB / CC / SQLLIB / CC contains file / SQLLIB / CFG required to Run the control center contains the default system configuration file / SQLLIB / CONV contains code page conversion Table File / SQLLIB / DB2 Default Directory / SQLLIB / DB2DAS00 Default DB2 Management Server Directory / SQLLIB / DOC Contains DB2 Online Manual / SQLLIB / Function Default User Custom Function Directory / SQLLIB / Function / Unfenced Default Non Isolated User Custom Correspondence Directory / SQLLIB / HELP online help file / SQLLIB / JAVADB2 required Java class library Java12 contains JDK1.2 support program / SQLLIB / MISC contains HTML search server file / SQLLIB / MSG / Prime contains information file / SQLLIB / QP contains QueryPatroller client file / SQLLIB / Samples contains sample programs and sample scripts / SQLLIB / SPMLOG contains DB2 Synchronous Point Manager log files / SQLLIB / THNSETUP contains thin client installation files 9.Unix and Linux environments DB2 installation directory structure?
Use DB2Setup.exe to install the installed root directory, you will also create the following directory: The root directory of the Readme installation, including the ReadMe file ADM contains the system management tool file ADSM contains the Adstar distributed storage manager file BIN contains a binary executable of DB2 tools BND contains the bind file of the DB2 tool CC contains the file CFG required for the Running Control Center. CFG contains the default system profile. CONV includes code page conversion table file DOC contains DB2 online manual Function default user-defined function directory Function / Unfenced default Isolation User Custom Correspondence Directory Install Containing Instance Instance Contains Instance Script JavaDB2 Required Java Class Libdb2 Library File Map Contains MSPLES MISC contains HTML Search Server files Samples containing sample programs and sample scripts MSG / $ L Which command contains DB2 information file 10.Aix to install DB2? Installp command 11. Multiple DB2 databases can be installed under the same operating system? Can you stop instance? DB2Stop 13. How to start instance? DB2Start [Page] 14 How do I modify the value of the registration item? DB2SET can modify, such as: Set a parameter of the current instance DB2SetParameter = Value Set a global level parameter db2setParameter = value-g (lowercase) View all variables set in the configuration file registry List DB2SET-LR (lowercase) 15. How to execute an operating system in the CLP? In the command, "!" As the prefix db2 =>! DIRC: / 16. How long does the command in the CLP? Use "/" As the symbol 17. How to get the syntax related information of the DB2 command? DB2? Display all DB2 commands DB2? Command Display Command Information DB2? SQLNNNNNNNNNNNNNNNNNNNNNNNN DB2? Db2nnnn displays this DB2 error interpretation information 18. How to View the current CLP settings? DB2 =>
ListcomandOptions 19. How to update the specific item settings for the current CLP session? DB2UPDATECOMMANDOPTIONSUSINGOTIONS ... 20.COMMANDWINDOWS can pass which command call? DB2CMD Command 21. The default name of the management server is DB2DAS Windows under DB2DAS Windows, DB2DAS00 22. Common Management DB2 command server instance? DB2ADMINSTART start the DB2 Administration server instance DB2ADMINSTOP stopped DB2 Administration server instance DASICRTUNIX create drop the DB2 Administration server instance DB2ADMINCREATEWINDOWSOROS under the DB2 Administration server instance DASIDROPUNIX create DB2 Administration server instance DB2ADMINDROPWINDOWSOROS under / 2 instance delete DB2 Administration server under / 2 DB2GETADMINCFG Display DB2 Management Server DB2UPDATEADMINCFG Modifying DB2 Management Server DB2RESETMINCFG Setting DB2 Management Server The configuration parameters of DB2 management servers are divided into defaults 23. What are the specifics of the DC Directory Directory Directory DCS Directory Directory Directory Directory Directory 24. how to view the system database directory? how LISTDBDIRECTORY 25. Check the database server directory? 26.DB2 default port LISTNODEDIRECTORY server instances is? 50000 server name as an authentication type DB2CDB2 27.DB2UDB server have? sERVER SERVER_ENCRYPT CLIENT DCE DCE_SERVER_ENCRYPT KERBEROS KRB_SERVER_ENCRYPT 28.DB2 client authentication type Is there any type of permissions in Server Server_Encrypt DCS DCS_ENCRYPT Client DCE 29.DB2? Sysadm System Administration Permissions SYSCTRL System Control Permissions SYSMAINT System Maintenance DBADM Database Administration Permissions LOAD Table LOAD Operation Permissions 30. What is the permissions authorized by GRANT? Sysam sysctrl sysmaint To change the above permissions must modify the database manager configuration parameter 31. What are the types of tables? Permanent Table (Base Table) Temporary Table (Description Table) 32. How many tables do you know? SELECT * FROMSYSIBM.SYSTABLESWHERECREATOR = 'uSER' 33. how do I know the function at the user? select * fromIWH.USERFUNCTION select * fromsysibm.SYSFUNCTIONS 34. how do I know the number of users under VIEW? select * fromsysibm.sysviewsWHERECREATOR = 'uSER' 35. how do I know the current DB2 version? select * fromsysibm.sysvERSIONS 36. how do I know the number of users under TRIGGER? select * fromsysibm.SYSTRIGGERSWHERESCHEMA = 'uSER' 37. how do I know the situation TABLESPACE? select * fromsysibm.SYSTABLESPACES 38. how do I know the status of SEQUENCE? select * fromsysibm.SYSSEQUENCES 39. how do I know the status of SCHEMA? select * fromsysibm.SYSSCHEMATA 40. how do I know the status of INDEX? select * fromsysibm.SYSINDEXES 41. how do I know the status table fields? select * fromsysibm.SYSCOLUMNSWHERETBNAME = 'AAAA'