Overview
of
the
DB2
technical
information
DB2 technicalinformationisavailable throughthefollowingtoolsandmethods: v DB2InformationCenter
– Topics
– HelpforDB2 tools – Sampleprograms – Tutorials
v DB2books
– PDFfiles(downloadable)
– PDFfiles(fromtheDB2PDFCD) – printedbooks
v Commandlinehelp – Commandhelp – Messagehelp v Sampleprograms
IBM periodicallymakesdocumentationupdatesavailable.Ifyouaccesstheonline version ontheDB2InformationCenterat ibm.com®,youdonotneedtoinstall documentationupdatesbecausethisversioniskeptup-to-datebyIBM.Ifyouhave installedtheDB2InformationCenter,itisrecommendedthatyouinstallthe documentationupdates.Documentationupdatesallowyoutoupdatethe
informationthatyouinstalledfromtheDB2 InformationCenterCDordownloaded fromPassportAdvantageasnewinformationbecomesavailable.
Note: TheDB2InformationCentertopics areupdatedmorefrequentlythaneither thePDForthehard-copybooks.Toget themostcurrentinformation,install thedocumentationupdatesastheybecomeavailable,orrefertotheDB2 InformationCenteratibm.com.
YoucanaccessadditionalDB2technicalinformationsuchastechnotes, white papers,andRedbooks™online atibm.com.AccesstheDB2Information
Management softwarelibrarysiteat http://www.ibm.com/software/data/sw- library/.
Documentation
feedback
Wevalue yourfeedbackontheDB2documentation.Ifyouhavesuggestionsfor how wecanimprovetheDB2documentation,send ane-mailto
[email protected] yourfeedback,but cannotrespondtoyoudirectly.Providespecific exampleswhereverpossibleso thatwecanbetterunderstandyourconcerns.Ifyouareprovidingfeedbackona specific topicorhelpfile,includethetopictitleandURL.
Donotusethis e-mailaddress tocontactDB2CustomerSupport.Ifyouhavea DB2 technicalissuethatthedocumentationdoesnotresolve,contactyourlocal IBM servicecenterforassistance.
Related concepts:
v “FeaturesoftheDB2InformationCenter”inOnlineDB2Information Center v “Samplefiles”inSamplesTopics
Related tasks:
v “Invokingcommandhelpfromthecommandlineprocessor”inCommand Reference
v “Invokingmessagehelpfromthecommandlineprocessor”inCommand Reference
v “UpdatingtheDB2 InformationCenter installedonyour computerorintranet server”onpage83
Related reference:
v “DB2technicallibraryinhardcopyorPDFformat”onpage78
DB2
technical
library
in
hardcopy
or
format
The followingtablesdescribetheDB2libraryavailable fromtheIBMPublications Center atwww.ibm.com/shop/publications/order.DB2 Version9 manualsinPDF formatcanbedownloadedfromwww.ibm.com/software/data/db2/udb/support/ manualsv9.html.
Althoughthetablesidentifybooks availableinprint,thebooks mightnotbe available inyourcountryorregion.
The informationinthese booksisfundamentaltoallDB2users;youwillfindthis informationusefulwhetheryouarea programmer,a databaseadministrator,or someonewho workswithDB2 Connector otherDB2 products.
Table12.DB2technicalinformation
Name FormNumber Availableinprint
AdministrationGuide: Implementation
SC10-4221 Yes
AdministrationGuide:Planning SC10-4223 Yes
AdministrativeAPIReference SC10-4231 Yes
AdministrativeSQLRoutinesand Views
SC10-4293 No
CallLevelInterfaceGuideand Reference,Volume1
SC10-4224 Yes
CallLevelInterfaceGuideand Reference,Volume2
SC10-4225 Yes
CommandReference SC10-4226 No
DataMovementUtilitiesGuide andReference
SC10-4227 Yes
DataRecoveryandHigh AvailabilityGuideandReference
SC10-4228 Yes
DevelopingADO.NETandOLE DBApplications
SC10-4230 Yes
DevelopingEmbeddedSQL Applications
Table12.DB2technicalinformation (continued)
Name FormNumber Availableinprint
DevelopingSQLandExternal Routines
SC10-4373 No
DevelopingJavaApplications SC10-4233 Yes
DevelopingPerlandPHP Applications
SC10-4234 No
GettingStartedwithDatabase ApplicationDevelopment
SC10-4252 Yes
GettingstartedwithDB2 installationandadministrationon LinuxandWindows
GC10-4247 Yes
MessageReferenceVolume1 SC10-4238 No
MessageReferenceVolume2 SC10-4239 No
MigrationGuide GC10-4237 Yes
NetSearchExtender
AdministrationandUser’sGuide
Note: HTMLforthis
documentisnotinstalledfrom theHTMLdocumentationCD.
SH12-6842 Yes
PerformanceGuide SC10-4222 Yes
QueryPatrollerAdministration andUser’sGuide
GC10-4241 Yes
QuickBeginningsforDB2 Clients
GC10-4242 No
QuickBeginningsforDB2 Servers
GC10-4246 Yes
SpatialExtenderandGeodetic DataManagementFeatureUser’s GuideandReference
SC18-9749 Yes
SQLGuide SC10-4248 Yes
SQLReference,Volume1 SC10-4249 Yes
SQLReference,Volume2 SC10-4250 Yes
SystemMonitorGuideand Reference
SC10-4251 Yes
TroubleshootingGuide GC10-4240 No
VisualExplainTutorial SC10-4319 No
What’sNew SC10-4253 Yes
XMLExtenderAdministration andProgramming
SC18-9750 Yes
XMLGuide SC10-4254 Yes
XQueryReference SC18-9796 Yes
Table13.DB2Connect-specifictechnicalinformation
Name FormNumber Availableinprint
Table13.DB2Connect-specifictechnicalinformation (continued)
Name FormNumber Availableinprint
QuickBeginningsforDB2 ConnectPersonalEdition
GC10-4244 Yes
QuickBeginningsforDB2 ConnectServers
GC10-4243 Yes
Table14.WebSphere®InformationIntegrationtechnicalinformation
Name FormNumber Availableinprint
WebSphereInformation
Integration:AdministrationGuide forFederatedSystems
SC19-1020 Yes
WebSphereInformation Integration:ASNCLPProgram ReferenceforReplicationand EventPublishing
SC19-1018 Yes
WebSphereInformation
Integration:ConfigurationGuide forFederatedDataSources
SC19-1034 No
WebSphereInformation Integration:SQLReplication GuideandReference
SC19-1030 Yes
Note: TheDB2ReleaseNotesprovideadditionalinformationspecifictoyour product’sreleaseand fixpacklevel.For moreinformation,seetherelated links.
Related concepts:
v “OverviewoftheDB2technicalinformation”onpage77 v “AbouttheReleaseNotes”inReleasenotes
Related tasks:
v “OrderingprintedDB2books”onpage80
Ordering
printed
DB2
books
IfyourequireprintedDB2 books,youcanbuythemonlineinmanybutnotall countries orregions.YoucanalwaysorderprintedDB2books fromyourlocalIBM representative.Keepinmind thatsomesoftcopybooksontheDB2PDF
Documentation CDareunavailableinprint.Forexample,neithervolumeof theDB2
MessageReferenceisavailableasa printedbook.
Printed versionsofmanyoftheDB2booksavailable ontheDB2PDF
DocumentationCD canbe orderedforafee fromIBM.Dependingonwhereyou are placingyourorderfrom,youmaybe abletoorderbooksonline,fromtheIBM PublicationsCenter.Ifonline orderingisnotavailable inyourcountryorregion, youcanalwaysorderprintedDB2 booksfromyourlocalIBM representative.Note thatnotallbooks ontheDB2PDFDocumentationCDare availableinprint.
Note: Themostup-to-dateand completeDB2documentationismaintainedinthe DB2InformationCenterathttp://publib.boulder.ibm.com/infocenter/ db2help/.
Procedure:
Toorderprinted DB2books:
v TofindoutwhetheryoucanorderprintedDB2 booksonlineinyour countryor region,checktheIBMPublicationsCenterat http://www.ibm.com/shop/ publications/order.Youmust selecta country,region,orlanguagetoaccess publicationorderinginformationand thenfollowtheordering instructionsfor yourlocation.
v ToorderprintedDB2booksfromyour localIBMrepresentative:
– Locate thecontactinformationforyourlocalrepresentativefromoneof the followingWebsites:
- TheIBMdirectoryofworldwidecontactsat www.ibm.com/planetwide - TheIBMPublicationsWebsiteat http://www.ibm.com/shop/
publications/order.Youwillneedtoselectyourcountry,region,or languagetotheaccessappropriatepublicationshome pageforyour location.Fromthis page,followthe″Aboutthissite″link.
– Whenyoucall,specifythatyouwanttoorderaDB2publication.
– Provideyour representativewiththetitlesandformnumbersofthebooks thatyouwanttoorder.
Related concepts:
v “OverviewoftheDB2technicalinformation”onpage77 Related reference:
v “DB2technicallibraryinhardcopyorPDFformat”onpage78
Displaying
SQL
state
help
from
the
command
line
processor
DB2 returnsanSQLSTATEvaluefor conditionsthatcouldbe theresult ofanSQL statement. SQLSTATEhelp explainsthemeanings ofSQLstatesand SQLstateclass codes.
Procedure:
Toinvoke SQLstatehelp,openthecommandlineprocessor andenter: ? sqlstate or ? class code
where sqlstaterepresentsavalidfive-digitSQLstateandclasscoderepresentsthe first twodigits oftheSQLstate.
For example,? 08003 displayshelp forthe08003 SQLstate, and? 08displays help forthe08classcode.
Related tasks:
v “Invokingcommandhelpfromthecommandlineprocessor”inCommand Reference
v “Invokingmessagehelpfromthecommandlineprocessor”inCommand Reference