IBM Support What's New?

C&DS 5.0 Config Tool errors with Create Schema permission

Technote (troubleshooting)


Problem(Abstract)

Collaboration and Deployment Services Configuration fails with this error:

The input user does not have the following required permission: create schema

Engine.log:
Prerequisite Check: Database Permission Check: FAIL: The input user
does not have the following required permission:create schema

Cause

DB2 user does not have required permission.
See Installation Guide: IBM SPSS Collaboration and Deployment Services Repository 5 Installation and Configuration Guide; Planning your installation; Database permissions

Environment

Windows Server 2008 64b R2
C&DS 5.0; Websphere; Db2

Resolving the problem

Permission to "Create Schema" is a requirement for the DB2 profile being used for the C&DS repository. For more information see C&DS Installation Guide: IBM SPSS Collaboration and Deployment Services Repository 5 Installation and Configuration Guide; Planning your installation; Database permissions.

Document information

More support for: SPSS Collaboration and Deployment Services

Software version: 5.0

Operating system(s): Platform Independent

Reference #: 1609322

Modified date: 2012-12-28