Beginer questions

[Craig87]

Hi,

I am a newbie to DB2. I am looking for help with the following:

1) Can you recomend a good book? I have read Chamberlin's "DB2 Universal Database" but I found it highly lacking in the basics of operation.

2) This may sound stupid, but how do you create a database? In the manual and the book it never actually tell you how to do this. Online the only thing I can find is to exapand the tree in the Control center and right click and select "create". However I cannot expand the tree and therefor right clicking does not yield a "create" option. What am I doing wrong? In Oracle I can just create a database....



THANKS !!

 

[micjohnson]

Hi!

Its better to purchase "A Guide to DB2" by C.J.Date and White

mic

 

[2742]

Hi there
The most useful book i have found for SQL Statements and DB2 configuration help is the IBM SQL Reference guilds and Administration Guide. These are avaliable online under
DB2 folder -> information -> DB2 online books choose administrations. Under there there is the Admin Guide, SQK Reference, Command Reference, Message Reference(Very helpful sometimes !! ) And other Guilds. You can Bye these books as well. But these books have all the information you should need to get started! I hope this Helps.

P.S Create Database Command is:

>>-CREATE----+-DATABASE-+--database-name------------------------>
'-DB-------'

>-----+------------------------------+-------------------------><
+-AT NODE----------------------+
'-| Create Database options |--'

Create Database options

|---+----------------+---+------------------------+------------->
'-ON--+-path--+--' '-ALIAS--database-alias--'
'-drive-'

>-----+-----------------------------------------------+--------->
'-USING CODESET--codeset--TERRITORY--territory--'

>-----+-----------------------------------+--------------------->
| .-SYSTEM--------. |
'-COLLATE USING--+-COMPATIBILITY-+--'
'-IDENTITY------'

>-----+-------------------+------------------------------------->
'-NUMSEGS--numsegs--'

>-----+--------------------------------+------------------------>
'-DFT_EXTENT_SZ--dft_extentsize--'

>-----+----------------------------------------+---------------->
'-CATALOG TABLESPACE--| tblspace-defn |--'

>-----+-------------------------------------+------------------->
'-USER TABLESPACE--| tblspace-defn |--'

>-----+------------------------------------------+-------------->
'-TEMPORARY TABLESPACE--| tblspace-defn |--'

>-----+-------------------------+-------------------------------|
'-WITH--&quot;comment-string&quot;--'

tblspace-defn

|---MANAGED BY-------------------------------------------------->

.-,--------------------.
V |
>-----+-SYSTEM USING--(-----'container-string'--+---)-------------------------------------+>
| .-,-----------------------------------------------------. |
| V | |
'-DATABASE USING--(------+-FILE---+---'container-string'---number-of-pages---+---)--'
'-DEVICE-'

>-----+------------------------------+-------------------------->
'-EXTENTSIZE--number-of-pages--'

>-----+--------------------------------+------------------------>
'-PREFETCHSIZE--number-of-pages--'

>-----+-----------------------------------+--------------------->
'-OVERHEAD--number-of-milliseconds--'

>-----+---------------------------------------+-----------------|
'-TRANSFERRATE--number-of-milliseconds--'