Appendix
A.
Overview
of
the
DB2
technical
information
DB2 technicalinformationisavailable throughthefollowingtoolsandmethods: v DB2InformationCenter
– Topics (Task,conceptand referencetopics)
– HelpforDB2 tools
– Sampleprograms
– Tutorials
v DB2books
– PDFfiles(downloadable)
– PDFfiles(fromtheDB2PDFDVD)
– printedbooks
v Commandlinehelp
– Commandhelp
– Messagehelp
Note: TheDB2InformationCentertopics areupdatedmorefrequentlythaneither thePDForthehardcopybooks.Togetthemostcurrentinformation,install the documentationupdatesastheybecomeavailable,orrefertotheDB2 Information Center atibm.com.
YoucanaccessadditionalDB2technicalinformationsuchastechnotes, white papers,andIBM Redbooks® publicationsonline atibm.com.AccesstheDB2 InformationManagementsoftwarelibrarysiteathttp://www.ibm.com/software/ data/sw-library/.
Documentation
feedback
Wevalue yourfeedbackontheDB2documentation.Ifyouhavesuggestionsfor how toimprovetheDB2documentation,sendan [email protected]. TheDB2 documentationteamreadsallofyourfeedback,but cannotrespondto youdirectly.Providespecific exampleswhereverpossiblesothatwecanbetter understandyourconcerns.Ifyouareprovidingfeedback ona specifictopicor help file,include thetopictitleandURL.
Donotusethis e-mailaddress tocontactDB2CustomerSupport.Ifyouhavea DB2 technicalissuethatthedocumentationdoesnotresolve,contactyourlocal IBM servicecenterforassistance.
DB2
technical
library
in
hardcopy
or
format
ThefollowingtablesdescribetheDB2libraryavailable fromtheIBMPublications Center atwww.ibm.com/shop/publications/order.Englishand translatedDB2 Version9.7manualsinPDFformatcanbedownloadedfromwww.ibm.com/ support/docview.wss?rs=71&uid=swg2700947.
Althoughthetablesidentifybooks availableinprint,thebooks mightnotbe available inyourcountryorregion.
The formnumberincreaseseachtimeamanualisupdated.Ensure thatyouare readingthemostrecentversionofthemanuals,aslistedbelow.
Note: TheDB2Information Centerisupdatedmorefrequentlythaneither thePDF or thehard-copybooks.
Table13.DB2technicalinformation
Name FormNumber Availableinprint Lastupdated
AdministrativeAPI Reference SC27-2435-00 Yes August,2009 AdministrativeRoutines andViews SC27-2436-00 No August,2009
CallLevelInterface GuideandReference, Volume1
SC27-2437-00 Yes August,2009
CallLevelInterface GuideandReference, Volume2
SC27-2438-00 Yes August,2009
CommandReference SC27-2439-00 Yes August,2009
DataMovementUtilities GuideandReference
SC27-2440-00 Yes August,2009
DataRecoveryandHigh AvailabilityGuideand Reference SC27-2441-00 Yes August,2009 DatabaseAdministration Conceptsand ConfigurationReference SC27-2442-00 Yes August,2009 DatabaseMonitoring GuideandReference
SC27-2458-00 Yes August,2009
DatabaseSecurityGuide SC27-2443-00 Yes August,2009
DB2TextSearchGuide SC27-2459-00 Yes August,2009
DevelopingADO.NET andOLEDB Applications SC27-2444-00 Yes August,2009 DevelopingEmbedded SQLApplications SC27-2445-00 Yes August,2009 DevelopingJava Applications SC27-2446-00 Yes August,2009 DevelopingPerl,PHP, Python,andRubyon RailsApplications SC27-2447-00 No August,2009 DevelopingUser-defined Routines(SQLand External) SC27-2448-00 Yes August,2009
GettingStartedwith DatabaseApplication Development
GI11-9410-00 Yes August,2009
GettingStartedwith DB2Installationand AdministrationonLinux andWindows
Table13.DB2technicalinformation (continued)
Name FormNumber Availableinprint Lastupdated
GlobalizationGuide SC27-2449-00 Yes August,2009
InstallingDB2Servers GC27-2455-00 Yes August,2009
InstallingIBMData ServerClients GC27-2454-00 No August,2009 MessageReference Volume1 SC27-2450-00 No August,2009 MessageReference Volume2 SC27-2451-00 No August,2009
NetSearchExtender Administrationand User’sGuide SC27-2469-00 No August,2009 Partitioningand ClusteringGuide SC27-2453-00 Yes August,2009
pureXMLGuide SC27-2465-00 Yes August,2009
QueryPatroller Administrationand User’sGuide
SC27-2467-00 No August,2009
SpatialExtenderand GeodeticData ManagementFeature User’sGuideand Reference
SC27-2468-00 No August,2009
SQLProcedural Languages:Application EnablementandSupport
SC27-2470-00 Yes August,2009
SQLReference,Volume1 SC27-2456-00 Yes August,2009
SQLReference,Volume2 SC27-2457-00 Yes August,2009
Troubleshootingand TuningDatabase Performance SC27-2461-00 Yes August,2009 UpgradingtoDB2 Version9.7 SC27-2452-00 Yes August,2009
VisualExplainTutorial SC27-2462-00 No August,2009
What’sNewforDB2 Version9.7
SC27-2463-00 Yes August,2009
WorkloadManager GuideandReference
SC27-2464-00 Yes August,2009
XQueryReference SC27-2466-00 No August,2009
Table14.DB2Connect-specifictechnicalinformation
Name FormNumber Availableinprint Lastupdated
Installingand ConfiguringDB2 ConnectPersonalEdition
SC27-2432-00 Yes August,2009
Installingand ConfiguringDB2 ConnectServers
SC27-2433-00 Yes August,2009
Table14.DB2Connect-specifictechnicalinformation (continued)
Name FormNumber Availableinprint Lastupdated
DB2ConnectUser’s Guide
SC27-2434-00 Yes August,2009
Table15.InformationIntegrationtechnicalinformation
Name FormNumber Availableinprint Lastupdated
InformationIntegration: AdministrationGuidefor FederatedSystems
SC19-1020-02 Yes August,2009
InformationIntegration: ASNCLPProgram ReferenceforReplication andEventPublishing
SC19-1018-04 Yes August,2009
InformationIntegration: ConfigurationGuidefor FederatedDataSources
SC19-1034-02 No August,2009 InformationIntegration: SQLReplicationGuide andReference SC19-1030-02 Yes August,2009 InformationIntegration: Introductionto
ReplicationandEvent Publishing
GC19-1028-02 Yes August,2009
Ordering
printed
DB2
books
Ifyourequireprinted DB2books,youcanbuythemonlineinmanybutnotall countries orregions.YoucanalwaysorderprintedDB2books fromyourlocalIBM representative.Keepinmind thatsomesoftcopybooks ontheDB2PDF
Documentation DVDareunavailableinprint.Forexample,neithervolumeofthe
DB2 MessageReference isavailable asaprintedbook.
Printed versionsofmanyoftheDB2booksavailable ontheDB2 PDF
DocumentationDVDcanbe orderedforafee fromIBM.Dependingonwhereyou are placingyourorderfrom,youmaybe abletoorderbooksonline, fromtheIBM PublicationsCenter.Ifonline orderingisnotavailable inyourcountryorregion, youcanalwaysorderprintedDB2 booksfromyourlocalIBM representative.Note thatnotallbooks ontheDB2PDFDocumentationDVDare availableinprint. Note: Themostup-to-dateand completeDB2documentationismaintainedinthe DB2 InformationCenter athttp://publib.boulder.ibm.com/infocenter/db2luw/ v9r7.
Toorderprinted DB2books:
v TofindoutwhetheryoucanorderprintedDB2 booksonlineinyour countryor
region,checktheIBMPublicationsCenterat http://www.ibm.com/shop/ publications/order.Youmustselectacountry,region,orlanguagetoaccess publicationorderinginformationand thenfollowtheordering instructionsfor yourlocation.
1. Locate thecontactinformationforyourlocalrepresentativefromoneof the
followingWebsites:
– TheIBMdirectory ofworldwidecontactsatwww.ibm.com/planetwide
– TheIBMPublicationsWebsiteathttp://www.ibm.com/shop/
publications/order.Youwillneed toselectyour country,region,or languagetotheaccessappropriatepublicationshomepageforyour location.Fromthispage,followthe″Aboutthissite″link.
2. Whenyoucall,specifythatyouwanttoorderaDB2publication.
3. Provideyour representativewiththetitlesandformnumbersofthebooks
thatyouwanttoorder.Fortitlesand formnumbers,see“DB2technical libraryinhardcopyorPDFformat”onpage101.
Displaying
SQL
state
help
from
the
command
line
processor
DB2 productsreturn anSQLSTATEvalue forconditions thatcanbe theresult ofan SQLstatement.SQLSTATEhelpexplainsthemeaningsofSQLstatesand SQLstate class codes.
Tostart SQLstatehelp,openthecommandlineprocessorandenter:
? sqlstate or ? class code
where sqlstaterepresentsavalidfive-digitSQLstateandclasscoderepresentsthe first twodigits oftheSQLstate.
For example,? 08003 displays helpforthe 08003SQLstate, and? 08displays help forthe08classcode.
Accessing
different
versions
of
the
DB2
Information
Center
For DB2Version9.7topics,theDB2 InformationCenter URLis http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/ For DB2Version9.5topics,theDB2 InformationCenter URLis http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/
For DB2Version9topics,theDB2InformationCenterURLishttp:// publib.boulder.ibm.com/infocenter/db2luw/v9/
For DB2Version8topics,go totheVersion8 InformationCenterURLat: http://publib.boulder.ibm.com/infocenter/db2luw/v8/
Displaying
topics
in
your
preferred
language
in
the
DB2
Information
Center
TheDB2 InformationCenter attemptstodisplaytopicsinthelanguagespecifiedin your browserpreferences.Ifa topichasnotbeentranslated intoyourpreferred language,theDB2InformationCenterdisplaysthetopicinEnglish.
v TodisplaytopicsinyourpreferredlanguageintheInternetExplorerbrowser:
1. InInternet Explorer,click theTools—>InternetOptions—>Languages...
button.TheLanguagePreferenceswindow opens.
2. Ensureyour preferredlanguageisspecifiedasthefirstentryinthelistof
languages.
– Toaddanew languagetothelist,clicktheAdd...button.
Note: Addingalanguagedoesnotguaranteethatthecomputerhasthe fontsrequiredtodisplaythetopics inthepreferredlanguage.
– Tomovealanguagetothetopofthelist,selectthelanguageandclickthe
MoveUpbuttonuntilthelanguageisfirst inthelistoflanguages. 3. Clearthebrowsercacheand thenrefreshthepagetodisplaytheDB2
InformationCenterinyour preferredlanguage.
v Todisplaytopicsinyourpreferredlanguageina FirefoxorMozillabrowser:
1. SelectthebuttonintheLanguagessectionoftheTools—>Options—>
Advanceddialog.TheLanguagespanelisdisplayed inthePreferences window.
2. Ensureyour preferredlanguageisspecifiedasthefirstentryinthelistof
languages.
– Toaddanew languagetothelist,clicktheAdd...buttontoselecta
languagefromtheAddLanguageswindow.
– Tomovealanguagetothetopofthelist,selectthelanguageandclickthe
MoveUpbuttonuntilthelanguageisfirst inthelistoflanguages. 3. Clearthebrowsercacheand thenrefreshthepagetodisplaytheDB2
InformationCenterinyour preferredlanguage.
On somebrowserandoperatingsystemcombinations,youmustalso changethe regional settingsofyouroperatingsystemtothelocaleand languageofyour choice.
Updating
the
DB2
Information
Center
installed
on
your
computer
or
intranet
server
AlocallyinstalledDB2InformationCentermustbe updatedperiodically. Beforeyoubegin
ADB2Version9.7InformationCentermustalreadybeinstalled.Fordetails, see the“InstallingtheDB2InformationCenterusingtheDB2Setupwizard”topicin
InstallingDB2 Servers.Allprerequisites andrestrictionsthatapplied toinstalling
theInformationCenteralso applytoupdatingtheInformationCenter. About thistask
An existingDB2InformationCenter canbeupdatedautomaticallyormanually: v Automaticupdates-updatesexistingInformationCenter featuresand
languages.AnadditionalbenefitofautomaticupdatesisthattheInformation Centerisunavailableforaminimalperiodoftimeduringtheupdate.In
addition,automaticupdatescanbesettorunaspartofotherbatchjobsthatrun periodically.
v Manualupdates-shouldbeusedwhenyouwanttoaddfeaturesorlanguages
duringtheupdateprocess.Forexample,alocalInformationCenterwas
originallyinstalledwithbothEnglishandFrench languages,andnowyouwant toalsoinstall theGermanlanguage;amanualupdatewillinstallGerman,as wellas,updatetheexistingInformationCenter featuresandlanguages. However,a manualupdaterequiresyoutomanuallystop,update,and restart theInformationCenter.TheInformationCenterisunavailableduringtheentire updateprocess.
Thistopicdetailstheprocess forautomaticupdates.Formanualupdate
instructions,seethe“ManuallyupdatingtheDB2InformationCenterinstalledon your computerorintranetserver”topic.
ToautomaticallyupdatetheDB2 InformationCenter installedonyour computeror intranet server:
1. On Linuxoperatingsystems,
a. NavigatetothepathwheretheInformationCenterisinstalled.By default,
theDB2InformationCenter isinstalledinthe/opt/ibm/db2ic/V9.7 directory.
b. Navigatefromtheinstallationdirectorytothedoc/bin directory.
c. Runtheic-updatescript:
ic-update
2. On Windowsoperatingsystems,
a. Opena commandwindow.
b. NavigatetothepathwheretheInformationCenterisinstalled.By default,
theDB2InformationCenter isinstalledinthe<ProgramFiles>\IBM\DB2 InformationCenter\Version9.7 directory,where <ProgramFiles>represents thelocationoftheProgramFilesdirectory.
c. Navigatefromtheinstallationdirectory tothedoc\bin directory.
d. Runtheic-update.batfile:
ic-update.bat Results
TheDB2 InformationCenter restartsautomatically.Ifupdateswere available,the InformationCenterdisplays thenewandupdatedtopics.IfInformationCenter updateswere notavailable,amessageisaddedtothelog.Thelogfileislocatedin doc\eclipse\configurationdirectory. Thelogfilenameisarandomlygenerated number.For example,1239053440785.log.
Manually
updating
the
DB2
Information
Center
installed
on
your
computer
or
intranet
server
IfyouhaveinstalledtheDB2InformationCenter locally,youcanobtainand install documentationupdatesfromIBM.
Updatingyourlocally-installed DB2InformationCentermanuallyrequiresthat you:
1. StoptheDB2InformationCenteronyourcomputer,andrestart theInformation
Center instand-alonemode.RunningtheInformationCenterinstand-alone modepreventsotherusersonyournetworkfromaccessingtheInformation Center,and allowsyoutoapplyupdates.TheWorkstationversionoftheDB2 InformationCenteralways runsinstand-alonemode..
2. UsetheUpdatefeature toseewhatupdatesareavailable.Ifthereareupdates
thatyoumustinstall,youcanusetheUpdatefeaturetoobtainand installthem Note: IfyourenvironmentrequiresinstallingtheDB2InformationCenter updatesonamachine thatisnotconnectedtotheinternet,mirrortheupdate sitetoalocalfilesystemusinga machinethatisconnectedtotheinternetand hastheDB2 InformationCenter installed.Ifmanyusersonyournetworkwill be installingthedocumentationupdates,youcanreducethetimerequiredfor
individualstoperformtheupdatesbyalsomirroringtheupdatesitelocally andcreating aproxyfortheupdatesite.
Ifupdatepackagesareavailable,usetheUpdate featuretogetthepackages. However, theUpdate featureisonlyavailable instand-alonemode.
3. Stopthestand-aloneInformationCenter,andrestart theDB2Information
Center onyour computer.
Note: OnWindows 2008,Windows Vista(andhigher),thecommandslistedlater in thissectionmust berunasanadministrator. Toopenacommandpromptor graphical toolwith fulladministratorprivileges,right-click theshortcutandthen selectRunasadministrator.
ToupdatetheDB2InformationCenterinstalledonyourcomputerorintranet server:
1. StoptheDB2InformationCenter.
v On Windows,clickStart →ControlPanel →AdministrativeTools→Services.
Thenright-click DB2Information Centerserviceand selectStop. v On Linux,enterthefollowingcommand:
/etc/init.d/db2icdv97 stop
2. StarttheInformationCenterinstand-alonemode.
v On Windows:
a. Openacommandwindow.
b. Navigatetothepathwhere theInformationCenterisinstalled.By
default,theDB2InformationCenter isinstalledinthe<Program Files>\IBM\DB2InformationCenter\Version9.7directory,where <ProgramFiles>represents thelocationoftheProgramFilesdirectory. c. Navigatefromtheinstallationdirectorytothedoc\bindirectory.
d. Runthehelp_start.batfile:
help_start.bat v On Linux:
a. Navigatetothepathwhere theInformationCenterisinstalled.By
default,theDB2InformationCenter isinstalledinthe /opt/ibm/db2ic/V9.7directory.
b. Navigatefromtheinstallationdirectory tothedoc/bin directory.
c. Runthehelp_startscript:
help_start
ThesystemsdefaultWebbrowseropenstodisplaythestand-aloneInformation Center.
3. ClicktheUpdatebutton(
).(JavaScript™must beenabled inyourbrowser.) On theright paneloftheInformationCenter,clickFindUpdates.Alistof updatesforexistingdocumentationdisplays.
4. Toinitiatetheinstallationprocess,check theselections youwanttoinstall,then
clickInstall Updates.
5. Aftertheinstallation processhascompleted, clickFinish.
6. Stopthestand-aloneInformationCenter:
v On Windows,navigatetotheinstallationdirectory’sdoc\bin directory,and
runthehelp_end.batfile: help_end.bat
Note: Thehelp_endbatchfilecontains thecommandsrequiredtosafelystop theprocessesthatwerestartedwiththehelp_startbatchfile.Donotuse Ctrl-Coranyothermethodtostophelp_start.bat.
v On Linux,navigatetotheinstallationdirectory’sdoc/bindirectory, andrun
thehelp_endscript: help_end
Note: Thehelp_endscriptcontainsthecommandsrequiredtosafelystopthe processesthatwere startedwith thehelp_start script.Donotuseanyother method tostopthehelp_startscript.
7. RestarttheDB2InformationCenter.
v On Windows,clickStart →ControlPanel →AdministrativeTools→Services.
Thenright-click DB2Information Centerserviceand selectStart. v On Linux,enterthefollowingcommand:
/etc/init.d/db2icdv97 start
TheupdatedDB2InformationCenter displaysthenewandupdatedtopics.
DB2
tutorials
TheDB2 tutorialshelpyoulearnaboutvariousaspectsofDB2products.Lessons providestep-by-step instructions.
Before
you
begin
YoucanviewtheXHTMLversionofthetutorialfromtheInformationCenterat http://publib.boulder.ibm.com/infocenter/db2help/.
Some lessonsusesampledataorcode.Seethetutorialfora descriptionof any prerequisites foritsspecifictasks.
DB2
tutorials
Toview thetutorial,click thetitle. “pureXML®”inpureXML Guide
Setupa DB2databasetostoreXMLdataandtoperform basicoperations with thenative XMLdatastore.
“VisualExplain”inVisualExplainTutorial
Analyze,optimize, andtuneSQLstatementsforbetterperformance using VisualExplain.
DB2
troubleshooting
information
Awidevarietyoftroubleshootingand problemdetermination informationis available toassistyouinusingDB2databaseproducts.
DB2documentation
Troubleshootinginformationcanbe foundintheDB2 TroubleshootingGuide ortheDatabasefundamentalssection oftheDB2 InformationCenter. There youwillfind informationabouthow toisolateand identifyproblemsusing DB2 diagnostictoolsandutilities, solutionstosomeofthemostcommon