WebSphere Application Server Version 6.1 Feature Pack for Web Services
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

Creating Microsoft SQL Server databases for schedulers

This topic describes how to create Microsoft SQL Server databases for schedulers, using data definition language (DDL) or structured query language (SQL) files.

About this task

To create Microsoft SQL Server databases for schedulers, using data definition language (DDL) or structured query language (SQL) files, use these steps.

Procedure

  1. Make sure that you are using a user ID that has administrator rights for the database system.
  2. In the Enterprise Manager, expand a server group, then expand a server. A Microsoft SQL Server database named scheddb is created.
  3. Right-click Databases, then click New Database.
  4. Verify that the database supports Unicode (UTF-8). Otherwise, the database does not store all characters that can be handled in the Java code, which results in code page conversion problems, when a client uses an incompatible codepage.
  5. Type the name scheddb.
  6. Modify any default values, and save your changes. The Microsoft SQL Server database, scheddb, is created.

Results

The Microsoft SQL Server database for scheduler exists.



In this information ...


IBM Redbooks, demos, education, and more


Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Nov 25, 2008 2:35:59 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.wsfep.multiplatform.doc/info/ae/scheduler/tasks/tsch_codbsql.html