DB2 Instructions

  1. Open IBM Data Studio
  2. Create a new database named clinic
  3. Click on the Task Launcher tab; if it's not shown, select Task Launcher from the Task Navigator menu dropdown
  4. Click on the Develop tab (within the Task Launcher)
  5. Click on Create and run SQL or XQuery statements
  6. Select a Project
  7. Enter "Build" for the Name
  8. Ensure Edit using is set to SQL and XQuery editor
  9. Click on Finish
  10. Select the appropriate connection profile for the clinic database
  11. Click on Finish
  12. Click on Import (tray icon with arrow pointing down and to the right)
  13. Select the clinic.sql file from this folder
  14. Ensure the statement terminator is ";"
  15. Click on OK
  16. Click on Run SQL (green round icon with play symbol, near the tray icon from step 12)
  17. Open the clinicDB2.cfg file in this folder
  18. Replace the orange text in the following line with valid credentials:

    connectionString = "Server=localhost:50000;Database=clinic;UID=db2admin;PWD=password"

  19. Move the clinicDB2.cfg file from this folder to the dbiScript\data folder
  20. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicDB2.cfg"

  21. Navigate to http://localhost/dbiScript/apps/clinic/