Win a copy of Head First Android this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Creating Cloudscape database and data sources in Web Sphere

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

Can someone please tell me how to create a database in Cloudscape. From what i know, a Cloudscape database is a dir of same name with several files in it. I want some help in following:

1. How to create a Cloudscape database? Does Cloudscape have an editor or something to run sql commands?

2. I guess Cloudscape doesnt have a Database Administrator,etc to create databases like Oracle does, am I right?

3. Could someone also elaborate on what "service.properties" file mean w.r.t. a Cloudscape database.

Regards.
 
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are two versions of Cloudscape: an embedded version and a network server version. I don't know, but I assume you need to use the embedded version. Execute the cview.bat in %WAS_HOME%/cloudscape/bin/embedded. This will display the database admin GUI, the use of which, is intuitively obvious.

service.properties is a text file with internal database configuration information. When you create a database, a directory structure gets created, with a number of files, of which service.properties is one. Following is an example:

SysschemasIndex2Identifier=225
db2j.serviceProtocol=com.ibm.db2j.database.Database
SyscolumnsIdentifier=144
SysconglomeratesIndex1Identifier=49
SysconglomeratesIdentifier=32
db2j.serviceLocale=en_US
SyscolumnsIndex2Identifier=177
SysschemasIndex1Identifier=209
SysconglomeratesIndex3Identifier=81
SystablesIndex2Identifier=129
SyscolumnsIndex1Identifier=161
SysschemasIdentifier=192
db2j.storage.propertiesId=16
SysconglomeratesIndex2Identifier=65
SystablesIdentifier=96
SystablesIndex1Identifier=113

Bill Lasley
Versant Corp.
http://www.versant.com
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic