因为工作的原因，开始学习DB2的基础知识，为可能拿到的Project做点准备。<br />希望能在这里和大家互相交流，共同进步。<br /><br />我学习的资料来源是IBM网站上的free的课程，地址如下：<br /><a href="http://www-306.ibm.com/software/data/education/selfstudy.html#1" target="_blank" style="text-decoration: underline" style="color:blue">http://www-306.ibm.com/software/data/educa...elfstudy.html#1</a><br />大家可能需要注册一下才可以登陆，下载。<br /><br /><br />因为目前处在搜集资料，入门学习的阶段，我将在这个帖子里逐步贴出自己的学习笔记和找到的一些资料链接地址，还请各位朋友不吝指正，谢谢。

谢谢：）

支持。原来有阵子时间由于工作关系，匆忙学习了一阵子，呵呵。。。<br />最近狂想研究db2的分区模式，可惜没机器了。。。

一。DB2 Planning<br /><br />1.DB2 Products<br /><br />The different editions of DB2<br /><br />DB2 Everyplace<br />A mobile computing infrastructure;<br />A tiny engine, about 180KB<br />Triggers are not part of the DB2 Everyplace engine.<br /><br />DB2 Personal Edition (DB2 PE)<br />A single-user RDBMS;<br />Remote clients cannot connect to databases that are running this edition DB2;<br />However, workstations with the Control Center can connect to these databases to perform remote administration;<br /><br />DB2 Workgroup Server Edition (DB2 WSE)<br />Web–enabled client / server RDBMS; <br />Intended primarily for small business and departmental computing;<br />No integrated mainframe connectivity via the DB2 Connect component;<br />Does not support 64-bit computing or DB2 Data Links File Manager;<br />Can be installed on SMP machines with up to four processors;<br />Don’t allow for external Web-based usage,  should consider DB2 Workgroup Unlimited Server Edition (DB2 WSUE);<br />In DB2 Version7, this product was called DB2 Workgroup Edition.<br /><br />DB2 Workgroup Server Unlimited Edition<br />Essentially DB2 WSE with different licensing terms;<br />Eliminates the need to count users accessing the database;<br />Can not create 64-bit instances;<br />Does not come with the connection concentrator;<br />Does not include the integrated DB2 Connect component found in DB2 ESE<br />In DB2 Version7, this product was called DB2 Workgroup Unlimited Edition.<br /><br />DB2 Enterprise Server Edition (DB2 ESE)<br />Does not run on Windows XP for production purposes, but can be licensed for user acceptance testing, test and application development on that OS;<br />Microsoft limits the number of concurrent connections that can be handled by the single-user version of their Windows server products, like DB2 WSE or DB2 WSUE in a four-way SMP box;<br />DB2 ESE is meant for large and mid-sized departmental servers;<br />Includes the DB2 Connect component, which enables you to connect to iSeries and zSeries-based DB2 databases, as well as non-database hot resources like CICS, VSAM and IMS;<br />Each server running DB2 ESE is licensed for 5 registered users when connecting to host-based data sources, need more, purchase a separate DB2 Connect server license and user entitlements;<br />DB2 ESE is licensed per processor and can be installed on any number of processors on a single SMP box;<br />Has the ability to partition data within a single server, across multiple database servers (all of which have to be running on the same operating system), DPF;<br />DPF allows multiple SMP machines to be clustered together under a single database image for very large-scale transaction volumes;<br />In DB2 Version 7, this product was called DB2 Enterprise Edition.<br /><br />DB2 Universal Developer’s and DB2 Personal Developer’s Edition<br /><br />DB2 clients:<br />DB2 Runtime Client;<br />DB2 Administration Client;<br />DB2 Application Development<br /><br />DB2 Extenders:<br />The DB2 Extenders can take your database applications beyond traditional numeric and character data to images, XML, videos, voice, spatial objects, complex documents and more.<br /><br />XML Extender:<br />You can store entire XML documents in DB2 or store them as external files managed by the database. This method is known is XML Columns;<br />You can also decompose an XML document into relational tables and then recompose that information to XML on the way out of the dataset. This method is known as XML Collections.<br /><br />DB2 Net Search Extender:<br />You need a high-speed in-memory search, this is the extender for you;<br />For internet applications;<br />Eg. A license for up to five concurrent users comes with DB2 WSE with this product, if you want to support more than five users, DB2 WSUE or DB2 ESE.<br /><br />DB2 Spatial Extender:<br />It allows you to store, manage and analyze spatial data, that is, information about the location of geographic features;<br />Eg. A license for up to five concurrent users comes with DB2 WSE with this product, if you want to support more than five users, DB2 WSUE or DB2 ESE.<br /><br />Text, Audio, Image, and Video (TAIV) Extenders:<br />It allows you to extend the relational database to use nontraditional forms of data like text, songs, pictures and movies.<br /><br />DB2 Data Links File Manager<br />It allows you to manage files that reside outside the database as though they were logically.<br /><br />DB2 Connect<br />This product is an add-on product to DB2 that can be purchased separately, although some complimentary user licenses are provided in DB2 ESE.<br /><br />DB2 add-on tools<br />The free tools come as part of a DB2 installation and can be launched from the Control Center, the Configuration Assistant or on their own.<br />DB2 Recovery Expert;<br />DB2 Performance Expert;<br />DB2 High Performance Unload;<br />        Quickly and efficiently unloads and extracts data from DB2 for movement across enterprise systems.<br />DB2 Web Query Tool;<br />DB2 Table Eidtor<br />

2.DB2 Tools<br /><br />DB2 Tools is not add-on DB2 tools;<br />DB2 Tools are divided into two camps: the Control Center (CC) and the Configuration Assistant (CA);<br />There are special kinds of wizards that are new to DB2 Version 8, called advisors;<br />Another type of wizard is a notebook, eliminating the need to memorize syntax;<br /><br />The DB2 processors: An introduction<br />We got two different processors in DB2: the DB2 Command Line Processor (DB2 CLP) and the DB2 Command Window (DB2 CW);<br />The DB2 CLP allows you to enter DB2 commands interactively, without using the db2 prefix to tell the OS that you are planning to enter a DB2 command. However if you want to enter an OS command, you have to prefix it with the “&#33;” key;<br />For all OSs other than Windows, the DB2 CW is built into the OS’s native CLP. In a Windows environment you have to start a DB2 CW from a Windows command prompt by selecting the appropriate option from the Start menu. And you have to type in the keyword “db2” to get this DB2 command to run.<br />