Creating Cloudscape database and data sources in Web Sphere

[Sunil Aggarwal]

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.

[Bill Lasley]

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