Appendix
A.
DB2
Database
technical
information
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”onpage65
Related reference:
v “DB2technicallibraryinhardcopyorPDFformat”onpage60
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.
Table16.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
Table16.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
Table17.DB2Connect-specifictechnicalinformation
Name FormNumber Availableinprint
Table17.DB2Connect-specifictechnicalinformation (continued)
Name FormNumber Availableinprint
QuickBeginningsforDB2 ConnectPersonalEdition
GC10-4244 Yes
QuickBeginningsforDB2 ConnectServers
GC10-4243 Yes
Table18.WebSphereInformationIntegrationtechnicalinformation
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”onpage59
v “AbouttheReleaseNotes”inReleasenotes Related tasks:
v “OrderingprintedDB2books”onpage62
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”onpage59 Related reference:
v “DB2technicallibraryinhardcopyorPDFformat”onpage60
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
Accessing
different
versions
of
the
DB2
Information
Center
For DB2Version9topics,theDB2InformationCenterURLishttp:// publib.boulder.ibm.com/infocenter/db2luw/v9/.
For DB2Version8topics,go totheVersion8 InformationCenterURLat: http://publib.boulder.ibm.com/infocenter/db2luw/v8/.
Related tasks:
v “UpdatingtheDB2 InformationCenter installedonyour computerorintranet
server”onpage65
Displaying
topics
in
your
preferred
language
in
the
DB2
Information
Center
The DB2InformationCenter attemptstodisplaytopicsinthelanguagespecifiedin your browserpreferences.Ifa topichasnotbeentranslated intoyourpreferred language,theDB2InformationCenterdisplaysthetopicinEnglish.
Procedure:
Todisplaytopics inyourpreferredlanguageintheInternetExplorerbrowser: 1. InInternetExplorer,clicktheTools—>InternetOptions—>Languages...
button.TheLanguagePreferenceswindow opens.
2. Ensureyour preferredlanguageisspecifiedasthefirstentryinthelistof
languages.
v Toadda newlanguagetothelist,clicktheAdd...button.
Note: Addinga languagedoesnotguaranteethatthecomputerhasthefonts
requiredtodisplaythetopicsin thepreferredlanguage.
v Tomovea languagetothetopof thelist,selectthelanguageandclick the MoveUpbuttonuntilthelanguageisfirstinthelistoflanguages.
3. Clearthebrowsercacheandthen refreshthepagetodisplaytheDB2
InformationCenterinyour preferredlanguage.
Todisplaytopics inyourpreferredlanguageinaFirefox orMozillabrowser: 1. SelecttheTools—>Options—>Languagesbutton.TheLanguagespanelis
displayedin thePreferenceswindow.
2. Ensureyour preferredlanguageisspecifiedasthefirstentryinthelistof
languages.
v Toadda newlanguagetothelist,clicktheAdd...buttontoselectalanguage
fromtheAddLanguageswindow.
v Tomovea languagetothetopof thelist,selectthelanguageandclick the MoveUpbuttonuntilthelanguageisfirstinthelistoflanguages.
3. Clearthebrowsercacheandthen refreshthepagetodisplaytheDB2
InformationCenterinyour preferredlanguage.
On somebrowserandoperatingsystemcombinations,youmighthavetoalso changetheregionalsettingsof youroperatingsystemtothelocaleandlanguageof your choice.
Related concepts:
v “OverviewoftheDB2technicalinformation”onpage59
Updating
the
DB2
Information
Center
installed
on
your
computer
or
intranet
server
Ifyouhavealocally-installed DB2InformationCenter, updatedtopics canbe available fordownload.The'Lastupdated'value foundatthebottomofmost topics indicatesthecurrentlevelforthattopic.
Todetermineifthereisanupdateavailable fortheentireDB2InformationCenter, lookforthe'Lastupdated'value ontheInformationCenterhomepage.Compare thevalue inyourlocallyinstalledhomepagetothedateofthemostrecent downloadableupdateathttp://www.ibm.com/software/data/db2/udb/support/ icupdate.html.Youcanthen updateyour locally-installedInformationCenterifa more recentdownloadableupdateisavailable.
Updatingyourlocally-installed DB2InformationCenterrequiresthatyou:
1. StoptheDB2InformationCenteronyourcomputer,andrestart theInformation
Center instand-alonemode.RunningtheInformationCenterinstand-alone modepreventsotherusersonyournetworkfromaccessingtheInformation Center,and allowsyoutodownloadandapplyupdates.
2. UsetheUpdatefeature todetermineif updatepackagesareavailable from
IBM.
Note: Updatesare alsoavailableonCD.Fordetailsonhowtoconfigureyour
InformationCenter toinstallupdatesfromCD,seetherelatedlinks. Ifupdatepackagesareavailable,usetheUpdate featuretodownloadthe packages.(TheUpdatefeatureisonlyavailable instand-alonemode.) 3. Stopthestand-aloneInformationCenter,andrestarttheDB2Information
Center serviceonyour computer.
Procedure:
ToupdatetheDB2InformationCenterinstalledonyourcomputerorintranet server:
1. StoptheDB2InformationCenterservice.
v On Windows,clickStart →ControlPanel →AdministrativeTools→Services.
Thenright-click onDB2InformationCenterserviceand selectStop. v On Linux,enterthefollowingcommand:
/etc/init.d/db2icdv9 stop
2. StarttheInformationCenter instand-alonemode.
v On Windows:
a. Openacommandwindow.
b. Navigatetothepathwhere theInformationCenterisinstalled.By
default,theDB2InformationCenter isinstalledintheC:\Program Files\IBM\DB2 Information Center\Version 9 directory.
c. Runthehelp_start.batfileusingthefullyqualifiedpathfortheDB2
InformationCenter:
<DB2 Information Center dir>\doc\bin\help_start.bat
a. Navigatetothepathwhere theInformationCenterisinstalled.By
default,theDB2InformationCenter isinstalledinthe/opt/ibm/db2ic/V9 directory.
b. Runthehelp_startscriptusingthefullyqualifiedpathfortheDB2
InformationCenter:
<DB2 Information Center dir>/doc/bin/help_start
ThesystemsdefaultWebbrowserlaunchestodisplaythestand-alone InformationCenter.
3. ClicktheUpdatebutton(
).On theright handpaneloftheInformation Center,click FindUpdates.Alistofupdatesforexistingdocumentation displays.
4. Toinitiatethedownloadprocess,checktheselectionsyouwanttodownload,
then clickInstallUpdates.
5. Afterthedownloadandinstallation processhascompleted, clickFinish.
6. Stopthestand-aloneInformationCenter.
v On Windows,runthehelp_end.batfileusingthefullyqualified pathforthe
DB2 InformationCenter:
<DB2 Information Center dir>\doc\bin\help_end.bat
Note: Thehelp_endbatchfilecontains thecommandsrequiredtosafely
terminatetheprocessesthatwere startedwith thehelp_start batchfile. DonotuseCtrl-Coranyothermethodtoterminatehelp_start.bat. v On Linux,runthehelp_endscriptusingthefullyqualifiedpath fortheDB2
InformationCenter:
<DB2 Information Center dir>/doc/bin/help_end
Note: Thehelp_endscriptcontainsthecommandsrequiredtosafely
terminatetheprocessesthatwere startedwith thehelp_start script.Do notuseanyothermethod toterminatethehelp_startscript.
7. RestarttheDB2InformationCenter service.
v On Windows,clickStart →ControlPanel →AdministrativeTools→Services.
Thenright-click onDB2InformationCenterserviceand selectStart. v On Linux,enterthefollowingcommand:
/etc/init.d/db2icdv9 start
The updatedDB2 InformationCenter displaysthenewandupdatedtopics.
Related concepts:
v “DB2InformationCenterinstallationoptions” inQuickBeginningsforDB2Servers Related tasks:
v “InstallingtheDB2 InformationCenter usingtheDB2Setupwizard(Linux)”in
QuickBeginningsforDB2Servers
v “InstallingtheDB2 InformationCenter usingtheDB2Setupwizard(Windows)”
DB2
tutorials
TheDB2 tutorialshelpyoulearnaboutvariousaspectsofDB2products.Lessons providestep-by-step instructions.
Beforeyoubegin:
YoucanviewtheXHTMLversionofthetutorialfromtheInformationCenterat http://publib.boulder.ibm.com/infocenter/db2help/.
Some lessonsusesampledataorcode.Seethetutorialfora descriptionofany prerequisites foritsspecific tasks.
DB2tutorials:
Toview thetutorial,click onthetitle.
NativeXMLdatastore
Setupa DB2databasetostoreXMLdataandtoperform basicoperations with thenativeXMLdatastore.
VisualExplain Tutorial
Analyze,optimize, andtuneSQLstatementsforbetterperformance using VisualExplain.
Related concepts:
v “VisualExplainoverview”inAdministrationGuide:Implementation
DB2
troubleshooting
information
Awidevarietyoftroubleshootingand problemdeterminationinformationis available toassistyouinusingDB2products.
DB2documentation
Troubleshootinginformationcanbe foundintheDB2 Troubleshooting GuideortheSupportandTroubleshootingsection oftheDB2Information Center.Thereyouwillfindinformationonhow toisolateand identify problemsusingDB2diagnostic toolsandutilities,solutions tosomeofthe mostcommonproblems,andotheradviceonhow tosolveproblemsyou might encounterwith yourDB2products.
DB2TechnicalSupportWebsite
Refer totheDB2TechnicalSupportWebsiteifyouareexperiencing problemsand wanthelp findingpossiblecausesandsolutions.The TechnicalSupportsitehaslinkstothelatestDB2publications, TechNotes, Authorized ProgramAnalysisReports(APARsorbugfixes),fixpacks,and otherresources.Youcansearchthrough thisknowledgebasetofind possiblesolutions toyourproblems.
AccesstheDB2TechnicalSupportWebsiteat http://www.ibm.com/ software/data/db2/udb/support.html
Related concepts:
v “Introductiontoproblemdetermination”inTroubleshootingGuide
Terms
and
Conditions
Permissionsfortheuseofthesepublicationsisgrantedsubjecttothefollowing termsandconditions.
Personaluse:YoumayreproducethesePublicationsforyourpersonal,non commercialuseprovidedthatallproprietarynoticesarepreserved.Youmaynot distribute, displayormakederivativeworkofthesePublications, oranyportion thereof, withouttheexpress consentofIBM.
Commercial use:Youmayreproduce, distributeanddisplaythese Publications solelywithin yourenterpriseprovidedthatallproprietarynoticesarepreserved. Youmaynotmakederivative worksofthesePublications, orreproduce,distribute or displaythesePublicationsoranyportionthereofoutsideyourenterprise, withouttheexpressconsentofIBM.
Exceptasexpresslygrantedin thispermission,nootherpermissions,licensesor rightsaregranted, eitherexpressorimplied, tothePublicationsorany
information,data,softwareorotherintellectualpropertycontained therein.
IBM reservestherighttowithdrawthepermissionsgrantedhereinwhenever, inits discretion, theuseofthePublicationsisdetrimentaltoitsinterestor,as
determinedbyIBM,theaboveinstructionsare notbeingproperlyfollowed. Youmaynotdownload,exportorre-exportthisinformationexceptinfull compliancewith allapplicablelawsandregulations,includingallUnitedStates exportlawsandregulations.
IBM MAKESNO GUARANTEEABOUT THECONTENTOFTHESE
PUBLICATIONS. THEPUBLICATIONSAREPROVIDED″AS-IS″ANDWITHOUT
WARRANTY OFANYKIND,EITHEREXPRESSEDORIMPLIED,INCLUDING
BUTNOT LIMITEDTOIMPLIEDWARRANTIESOFMERCHANTABILITY,