01. Click Start on the Windows Toolbar
02. Click Run...
03. Type db2cw on the Open combo box and click OK button
=== please wait until DOS Prompt appears
04. On the DB2 Command Window, type the following commands and press Enter key for each line of command:
db2icrt DEV
db2 CATALOG LOCAL NODE DEV INSTANCE DEV SYSTEM
=== Substitute
=== You can see the full computer name by: right-click My Computer, Select Properties and Click Network Identification
05. Start DB2 - DEV instance on Services
=== make it automatic
=== Select This account on Log On tab
=== User name .\db2admin
=== Password password
=== Confirm password password
06. Start DB2 Governor on Services
=== make it automatic
07. On the DB2 Command Window, type the following commands and press Enter key for each line of command:
db2 ATTACH TO DEV
db2 CREATE DATABASE OIS ON C: WITH 'Database for OIS'
=== please wait until DOS Prompt appears
exit
08. Click Start on the Windows Toolbar
09. Click Run...
10. Type db2ca on the Open combo box and click OK button
=== please wait until Configuration Assitant appears
11. On the pane, right-click OIS and click Change Database...
=== please wait until Change Database Wizard appears
12. Click Database
13. Type S_OIS on Database alias text box and click Next button
14. Enter the following parameters:
Register this database for ODBC checked
As system data source selected
As user data source unselected
As file data source unselected
Data source name S_OIS
Optimize for application None
15. Click Finish button
16. Close the Configuration Assistant.
17. Open Data Sources (ODBC) on Administrative Tools
18. On System DSN tab, select S_OIS and click Configure button
19. Enter the following parameters:
Data source anme S_OIS
Description
User ID db2admin
Password password
Save Password checked (click OK button on the DB2 Message)
20. Click Connect button
=== DB2 Message must be "Connection tested successfully"
(click OK button on the DB2 Message)
21. Click Bind CLI/ODBC support utilities button
=== There must be result and click OK button
22. Click OK button
23. Click OK button
24. Click Start on the Windows Toolbar
25. Click Run...
26. Type db2cc on the Open combo box and click OK button
=== please wait until Control Center appears
27. On the Object View pane, click nodes of All Systems,
28. Richt-click DEV instance and click Setup communications
29. Enter the following parameters:
NetBIOS unchecked
TCP/IP checked
NPIPE unchecked
30. Click Properties(2) button
31. Enter the following parameters:
Host name
Service name applctn
Port number 50001
32. Click OK button
=== message will appear
33. Click Close button
33. Click OK button
=== message will appear
34. Click Close button
35. Richt-click DEV instance and click Stop
36. Click OK button
=== message will appear
37. Click Close button
38. Richt-click DEV instance and click Start
=== message will appear
39. Click Close button
40. Close the Control Center.
Steps In Creating Instance and Database in IBM DB2
Monday, July 13, 2009 |
Posted by
Brienne
|
Subscribe to:
Post Comments (Atom)
My Sponsors
My Premature Baby
It's all about the progress of our premature baby
The Cooking Shows
Its all about cooking television show, television cooking show
Programmer's Choice
Programming tutorials, free controls, programming source codes
Flash Gamer's Hub
Flash games, online games, dress up games, arcade games
Our Gadget
Gadget reviews, gadget news, latest gadgets, cool electronics
Walang Pasok
Legal holidays, special holidays, special and important events
Labels
Button
(3)
Windows XP
(3)
Control
(2)
Change
(1)
DB2
(1)
Database
(1)
Drives
(1)
Hidden Application
(1)
IBM
(1)
Identity
(1)
Image
(1)
Installing
(1)
Registry
(1)
Reseed
(1)
SQL
(1)
Start Button
(1)
Students
(1)
Thesis
(1)
Visual Basic
(1)
XP
(1)
Followers
My Blog List
-
-
I Want More1 year ago
-
-
-
-
My Long Haired #Dachshund: A Rescue Dog7 years ago
-
-
Tahun Baruan Lagi yuk..!8 years ago
-
-
-
-
OB9 years ago
-
-
Pemeran The Heirs9 years ago
-
Blood Father (2015)9 years ago
-
How To Make Palitaw9 years ago
-
-
-
The Master Cleanse (2015)10 years ago
-
happy thursday10 years ago
-
Athletic Bags10 years ago
-
-
Canterbury film trailer11 years ago
-
Jasa Cetak Id Card Yogyakarta11 years ago
-
Happy Hearts!11 years ago
-
-
-
Aishwarya Rai Baby Photos12 years ago
-
Sejarah Dewa Utama Jepang (part 1)12 years ago
-
-
Links for 2012-04-16 [Digg]13 years ago
-
Maxus Dragonoid13 years ago
-
Looking Around13 years ago
-
Sambal Politik... ala Indonesia13 years ago
-
What is Nano Medicine ?13 years ago
-
-
-
Spartacus Gods of the Arena Episode 2: Missio14 years ago
-
-
This Side Up14 years ago
-
-
-
Some new updates to We Pay Guide15 years ago
-
Arabella Vitanc Canceled Concert15 years ago
-
Earn Cash from JillsClickCorner15 years ago
-
Bleach PSP15 years ago
-
Where To Find Refurbished Ipods15 years ago
-
-
Lovely Mouse Gadget15 years ago
-
-
-
scholarship opportunities16 years ago
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0 comments:
Post a Comment