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 More7 months ago
-
UHAW - DILAW8 months ago
-
-
2 years ago
-
A Guide to Moving With Pets3 years ago
-
I want to blog... blog... and blog4 years ago
-
-
Lama juga, Apa Kabar Teman?6 years ago
-
Links for 2017-03-30 [del.icio.us]7 years ago
-
-
-
-
Did You Know ? a dalily tips..7 years ago
-
-
-
OB8 years ago
-
Pemeran BBF8 years ago
-
Blood Father (2015)8 years ago
-
-
The Master Cleanse (2015)8 years ago
-
happy thursday9 years ago
-
Athletic Bags9 years ago
-
-
Canterbury film trailer9 years ago
-
Jasa Cetak Id Card Yogyakarta10 years ago
-
Happy Hearts!10 years ago
-
-
-
Aishwarya Rai Baby Photos11 years ago
-
Sejarah Dewa Utama Jepang (part 1)11 years ago
-
-
Links for 2012-04-16 [Digg]12 years ago
-
Maxus Dragonoid12 years ago
-
Looking Around12 years ago
-
What is Nano Medicine ?12 years ago
-
-
-
Spartacus Gods of the Arena Episode 2: Missio13 years ago
-
-
This Side Up13 years ago
-
-
-
Some new updates to We Pay Guide14 years ago
-
Arabella Vitanc Canceled Concert14 years ago
-
Earn Cash from JillsClickCorner14 years ago
-
Bleach PSP14 years ago
-
-
Lovely Mouse Gadget14 years ago
-
-
-
scholarship opportunities15 years ago
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0 comments:
Post a Comment